Original: http://www.cnblogs.com/ilifeilong/category/1014799.htmlMySQL5.6 Replication technology (4)-mysql master-slave Replication filtering parameters
Summary: There are 2 main ways to filter replication: Replication can only extend the read, cannot extend the write, and partition the data for extended writes. Replication optimization: In MySQL replication environment, there are 8 parameters that let us control, need to copy or need to ignore the DB or table that does not replicate: The following two items need to be set on master: binlog_do_db: Set which databases need to record B read the full text posted @ 2017-07-18 20:26 A-ze ripple reading (12) | Comments (0) Edit MySQL5.6 replication Technology (3)-mysql master-slave replication Thread state transition
Summary: Primary library thread status (state) Values The following list shows the most common states (show processlist) that may be seen in the State column of the Binlog dump thread of the primary server in master-slave replication. If the Binlog dump thread is not visible on the primary server, this means that replication is not running, that is, no slave hosts are currently connected. Sending read full posted @ 2017-07-18 17:44 A-ze ripple reading (54) | Comments (0) Edit MySQL5.6 replication Technology (2)-master-slave deployment and semi-synchronous configuration detailed process
Summary: Current environmental planning one. mysql database installation 1. Create MySQL users and Groups 2. Configure the MySQL user environment variable 3. Download the MySQL binary package and install 4. Configure MySQL Database (primary and standby operation) 4.1 create MySQL profile/etc/my.cnf 4.2 initialize MySQL database 4.3 start MySQL database and read full text posted @ 2017-07-12 16:51 A-ze ripple reading (16) | Comments (0) Editing MySQL5.6 replication Technology (1)-A detailed explanation of the principle
Summary: The SQL replication feature describes MySQL built-in replication capabilities as the foundation for building large, high-performance applications. This type of application uses the so-called "horizontal scaling" architecture. We can synchronize data by configuring one or more repositories for the server to distribute MySQL data across multiple systems. A primary library (master) server can synchronize data to multiple slave libraries during the replication process. Read the full text from the library server posted @ 2017-07-12 00:19 A-ze ripple reading (9) | Comments (0) Edit
Go MySQL5.6 Master-slave replication technology
