MySQL user tools

1: interface tools

Interface tools can help you run queries, create tables and users, and execute other daily tasks.

MySQL Workbench

MySQL Workbench is an all-in-one tool for managing servers, writing queries, developing stored procedures, and Schema design drawings. You can use a plug-in interface to compile your own tools and integrate them into this work platform. Some Python scripts and libraries use this plug-in interface. MySQL Workbench has two editions: Community edition and commercial edition. Commercial edition only adds some other advanced features. The free version is sufficient for most scenarios. Reference: http://www.mysql.com/products/workbench/

SQLyog

SQLyog is one of the most popular MySQL visualization tools and has many good features. It is similar to MySQL Workbench, but both tools have features that are not available to each other. SQLyog can only be used in Windows, and the version with all features is charged. Reference: https://www.webyog.com/

PhpMyAdmin

PhpMyAdmin is a popular management tool that runs on Web servers and provides browser-based MySQL server access interfaces. Although browser-based access is sometimes good, phpMyAdmin is a big and complex tool and has been accused of many security issues. Be especially careful about this. We recommend that you do not install it in any place that can be accessed from the Internet. Reference: http://sourceforge.net/projects/phpmyadmin/

Adminer

Adminer is a lightweight browser-based security management tool, similar to phpMyAdmin. Its developers have positioned it as a better alternative to phpMyAdmin. Although it looks safer, we recommend that you install it wherever it is publicly accessible. Reference: http://www.adminer.org/

2: command line tool set

MySQL contains some command line tool sets, such as mysqladmin and mysqlcheck. These are mentioned and documented in the MySQL manual. The MySQL Community has also created a large number of high-quality toolkit, and there are good documentation to support these utility sets.

Percona Toolkit

Percona Toolkit is a required tool kit for MySQL administrators. It includes many tools for similar log analysis, replication integrity, data synchronization, mode and index analysis, query recommendations, and data archiving purposes. If you are new to MySQL, we recommend that you first learn these key tools: pt-mysql-summary, pt-table-checksum, pt-table-sync, and pt-query-digest. Reference: http://www.percona.com/software/

The openark kit

Shlomi Noach's openark kithttp: // code.openark.org/forge/openark-kit) contains Python scripts that can be used for a series of management tasks.

Innotop

It shows the real-time update view of what is happening on the server. Displays the transaction list, running queries, the current lock and lock wait list, server status and variable summary, and so on. Highly configurable and scalable.

3: SQL utility set

The server itself also has a series of free additional components and utility sets that can be used. Some of them are indeed quite powerful.

Common_schema

Shlomi Noach's common_schema Project (http://code.openark.org/forge/common_schema) is a powerful set of code and views for server scripting and management. Common_schema for MySQL is like jQuery for JavaScript.

Mysql-sr-lib

Giuseppe Maxia creates a stored procedure code library for MySQL. Reference: http://www.nongnu.org/mysql-sr-lib/

MySQL UDF Repository

Roland Bouman creates a MySQL user-defined function library. Reference: http://www.mysqludf.org

MySQL Forge

On MySQL Forge (http://forge.mysql.com), you can find programs, scripts, code snippets, practical sets and tips and traps contributed by hundreds of communities.

4: monitoring tools

Two types of monitoring tools: 1): alarm when the health monitoring tool detects exceptions)

2): It is a tool that records indicators, such as trends, diagnostics, troubleshooting, and capacity planning.

Most systems only do well in one of these tasks, rather than both.

4.1: open-source monitoring tools

Nagios

Nagios (http://www.nagios.org) is perhaps the most popular problem detection and alarm system in the Open Source world.

Zabbix

Zabbix is a complete system that supports both monitoring and indicator collection. For example, it stores all configurations and other data in the database instead of the configuration file. It stores more data types than Nagios, so it can get better trend and historical reports. Its network drawing and visualization capabilities are also stronger than those of Nagios, simpler, more flexible, and more scalable. Reference: http://www.zabbix.com

Zenoss

Zenoss is written in Python and has a browser-based user interface using Ajax, which makes it faster and more efficient. It can automatically discover resources on the network and integrate monitoring, alarms, trends, plotting, and history data into a unified tool. Zenoss Uses SNMP by default to collect data from remote servers, but SSH can also be used, and the Nagios plug-in is supported. Reference: http://www.zenoss.com

Hyperic HQ

Hyperic HQ is a java-based monitoring system. Compared with most other systems at the same level, Hyperic HQ is also known as listed enterprise-level monitoring. Reference: http://www.hyperic.com

OpenNMS

OpenNMS is also a java Development and has an active development community. It has common features, such as monitoring and alarms, but also adds plotting and trending features. Its goals are high performance, scalability, automation, and flexibility. Reference: http://www.opennms.org

Groundwork Open Source

Groundwork Open Source integrates Nagios with several other tools into a system using a portable interface. Refer:

Http://www.gwos.com

Compared to a system that combines all functions, a series of software focuses on collecting metrics, drawing, and visualization, rather than performing performance monitoring checks. Many of them are built on RRDTool (http://www.rrdtool.org) to store time series data to poll database (RRD) files. The RRD file automatically aggregates input data, interpolation the input values that are not expected to be transmitted, and a powerful drawing tool can generate beautiful and distinctive graphs.

MRTG

MRTG is a typical RRDTool-based system. Originally designed to record network traffic, but can also be expanded to record and plot other metrics. Reference: http://oss.oetiker.ch/mrtg/

Cacti

Cacti may be the most popular RRDTool-based system. It uses PHP Web pages to interact with RRDTool, and uses MySQL databases to define servers, plug-ins, images, and so on. Because it is template-driven, you can define a template and apply it to the system. Baron has written a set of very popular templates for MySQL and other systems. For more information, see http://code.google.com/p/mysql-cacti-templates /. These methods have been used until OpenNMS, Zabbix, and Munin.

Munin

Munin collects data and stores it in RRDTool. Then, it generates data graphs at several different levels. Reference: http://munin.projects.linpro.no

4.2: Commercial Monitoring System

MySQL Enterprise Monitor

It integrates features such as monitoring, metrics and drawing, consulting services, and query analysis into a tool. Status counters are detected by using the agent on the server. See http://www.mysql.com/products/enterprise/monitor.html.

MoNyog

Is a browser-based and agent-less monitoring system running on the desktop. It starts an HTTP server and then uses this tool in a browser. Reference: http://www.webyog.com.

Splunk

It is a log collector and search engine that can help obtain data produced by all machines in the environment and perform operation analysis. Refer:

Http://www.splunk.com.

Pingdom

It monitors the availability and performance of websites from multiple locations in the world. In fact, there are many services like Pingdom. We do not need to recommend such services, but we do recommend using some external monitoring services, so that you can be notified in time when the website is unavailable. Reference: http://www.pingdom.com.

And so on.

This article is from the Focus on the database Blog, please be sure to keep this source http://lgdvsehome.blog.51cto.com/3360656/1229459