mysql trigger send email

I. Introduction of RedisRedis is a key-value storage system. Similar to memcached, data is cached in memory in order to ensure efficiency. The difference is that Redis periodically writes the updated data to disk or writes the modified operation to

13th. The extensible design of MySQL ReplicationObjective:MySQL Replication is a very distinctive feature of MySQL, and he is able to copy the data from one MySQL server Instance to the Instance of another MySQL server. Although the replication

This article describes how to use keepalived to build highly available MySQL-HA to ensure data consistency between the two MySQL instances. then, keepalived is used to implement virtual IP addresses and automatic switch during MySQL fault is

Prerequisites: (1) The zabbix server has been successfully installed and run. (2) The zabbix client has been successfully created and runs. 1. Download and install msmtp Software WgetHttp://sourceforge.net/projects/msmtp/files/msmtp/1.4.32/msmtp-1.

DirectoryPrinciple 1Master-Slave Synchronization configuration 2Master server Synchronization User Authorization 2Configuring MY.CNF files for MySQL master server 3Standby configuration: 4Common commands: 5Dual master Configuration my.cnf

Use keepalived to build highly available MySQL-HA   This article describes how to use keepalived to build highly available MySQL-HA to ensure data consistency between the two MySQL instances. Then, keepalived is used to implement virtual IP

A MySQL trigger or a stored procedure can call a PHP function. If there should be write I have a feature user after the AAP send message insert I want to send a message with a trigger reply Because our web site data sources have app-side and

These tools may have been used, especially the system administrator or Linux Server maintenance students may know these gadgets, there will be a little more, in addition to the system monitoring gadgets, including some MySQL tools, and even in-depth

I. Replication architecture derivative historyBefore we talk about this feature, let's take a look at MySQL's replication architecture derivation history.In 2000, the MySQL 3.23.15 version introduced the replication. As a quasi-real-time

The previous content is to use the third-party developed plug-in for MySQL monitoring, there may be some of our concern about the monitoring content is not in it, then a common method is to define our own script and integrate it into the Zabbix, so