check mysql health example

Original link http://tengine.taobao.org/document_cn/http_upstream_check_cn.htmlNgx_http_upstream_check_module This module provides proactive back-end server Health check functionality for Tengine. The module is Tengine-1.4. version 0 was not

Welcome to the Linux community forum and interact with 2 million technical staff in the MySQL database. There are hundreds of data tables, and the database administrator cannot have so much time and effort to check the effectiveness of the table in

Article Directory 1. built-in healthindicator monitoring and testing 2. Custom Healthindicator Monitoring detection 3. Source Code The health information is collected from all the healthindicator beans in ApplicationContext,

The first approach: use the MySQL command to viewMySQL built-in directly to see the status can see the system common information, such as the following example: Copy Code code as follows: 1.$ Mysql-u Root-p 2.mysql> s "Threads:2

1. keepAlived + Mysql uses KeepAlived to implement high-availability MYSQL_HA cluster environment. MYSQL is a master-master synchronous replication relationship to ensure data consistency on the MYSQL server. KeepAlived is used to provide virtual IP

At the same time, the amount of online access continues to increase for 1G memory server Obviously feel the difficulty of severe when even every day will panic or occasional server card This problem once bothered me for more than half a month MySQL

One: Connection query:Connection query is to connect two or more tables according to a certain condition, select the required data, the connection query query two or more tables at the same time, when there are fields representing the same meaning

I. Preparation 1. prepare the server to establish the MySQLCLuster system with two nodes, and use six servers to establish Haproxy43; mysqlcluster (MySQL Cluster) system node configuration description the IP address and port of the node Haproxy

I. Architecture II. install Mysqlserver in DB1 (192168010) configuration as an example, DB2 configuration is basically the same, as long as you modify the server_id21 in mycnf install mysql-serverdb1apt-getinsta I. Architecture II. install Mysql

(1) Reduce Database Access Static pages are possible Static parts of a dynamic page Some data can be generated as XML or saved as text files Use data caching technology, such as memcached (2)Optimization Detection Method 1. User Experience