test mysql replication

High-Performance MySql evolution (14th): Replication (Replication) bitsCN.com Overview The built-in replication function of Mysql is the basis for building large and high-performance applications. This distribution mechanism replicates data from a

There are 3 main steps to the MySQL replication function The primary server logs changes to the binary log (these are called Binary log events)Copy the primary server's binary log events from the server to its trunk logRedo the events in the relay log from the server.The first part of the process is that the primary server records the binary logs, and before each transaction updates the data is completed,Ma

| +-----------------------------+-------+ | Rpl_semi_sync_master_yes_tx | 1 | --to indicate that this thing was successful. Return a confirmation signal from slave +-----------------------------+-------+ 1 row in Set (0.04 sec) Impersonation error, stop the IO thread on the slave-back to Maste R on test mysql> create database btbcs2; Query OK, 1 row affected (10.34 sec)--this time inserting a value req

, execute on B Because, this replication error is our artificial simulation, is sure, so we can skip. Any uncertain replication errors are not easily skipped. 8. After all the final recovery, take a test to test whether the new architecture is up or down. Conditional re-validation of the data. Here, we have completed

-- Read-only # // Set slave database as read-only, which can only be executed by the slave server thread or user with SUPER permission -- Relay-log = mysqld-relay-bin # // use a fixed relay log file -- Report-host = server205 # // host name or IP address reported to the master server -- Slave_compressed_protocol = 1 # // enable compression during the replication process. if this option is enabled, both the master and slave servers should be added. --

1. Replication overview1.1, Replication solution of the problem data replication technology has the following features: (1) data distribution (2) load balancing (load Balancing) (3) Backup (4) High availability (Hi availability) and fault tolerance1.2. How replication works from a high level,

| | Rpl_semi_sync_master_yes_TX | 7472 |+--------------------------------------------+-----------+14 rows in Set (0.00 sec)　　You can see the automatic shutdown, it is important to note that when the slave turn on the semi-synchronous, or when the network delay between the master and slave back to normal, the semi-synchronous replication automatically from the asynchronous replication to semi-synchronous

Originally the MySQL binlog and show processlist commands belonged to the two transactions of unrelated, but in the most recent troubleshooting, there was a significant replication delay found in the main library and from the library, but the Slave_behind_master value from the library was shown as 0, The replication SQL thread is blocking each other from the back

, and the others are exceptions. mysql> show grants for 'replication'@'%';+--------------------------------------------------------------------------------------------------------------------------------------+| Grants for replication@% |+------------------------------------------------------------------------------------------------------------------------------