Recently developed in the system using MySQL as a database, because the data related to money, so have to be cautious. At the same time, the user to the maximum number of visits also put forward requirements. To prevent MySQL from becoming a performance bottleneck with good fault tolerance, master-slave and read-write separation is hereby achieved. Make a summary here for future use! First, the configuration master-slave condition: Two pc,ip are 192.168.168.253,192.168.168.251 respectively. The MySQL version on both PCs is 5.0. MySQL on 253 is master,251 on MySQL for slave. 1, the primary database server configuration into the primary database server installation directory, open My.ini, add the following configuration at the end of the file: #数据库ID号, 1, as Master, where master_id must be 1 to 232–1 a positive integer value; Server-id = # enable binary log; log-bin=mysql-bin# need to synchronize binary database name;
1. Introduction to code examples for mysql-master multi-slave and read-write separation configuration
Summary: Recently developed systems using MySQL as a database, because the data related to money, so have to be cautious. At the same time, the user to the maximum number of visits also put forward requirements. To prevent MySQL from becoming a performance bottleneck with good fault tolerance, master-slave and read-write separation is hereby achieved. Make a summary here for future use! First, the configuration master-slave condition: Two pc,ip are 192.168.168.253,192.168.168.251 respectively. The MySQL version on both PCs is 5.0. MySQL on 253 is MA
2. mysql-a master-slave read-Write separation configuration method based on amoeba
Summary: Recently developed systems using MySQL as a database, because the data related to money, so have to be cautious. At the same time, the user to the maximum number of visits also put forward requirements. To prevent MySQL from becoming a performance bottleneck with good fault tolerance, master-slave and read-write separation is hereby achieved. Make a summary here for future use! First, the configuration master-slave condition: Two pc,ip are 192.168.168.253,192.168.168.251 respectively. The MySQL version on both PCs is 5.0. MySQL on 253 is MA
3. Yii2 database read/write Detach configuration Example
Introduction: This article mainly introduces the YII2 database read and write separation configuration example, the database read and write separation is the site encountered performance bottlenecks when the first consideration of optimization steps, interested can understand.
4. mysql proxy read-write separation configuration and PHP MySQL read-Write separation class
Description: MySQL proxy read-write separation configuration and PHP MySQL read-Write separation class
5. Yii2 database Read-write separation configuration, YII2 database read-write _php tutorial
Introduction: YII2 Database read-write separation configuration, YII2 database read and write. YII2 database read/write separation configuration, YII2 database read and write Source link: Yii Chinese network (yii-china.com)-YII2 database read-Write separation configuration Introduction database read-write separation is encountered in the Web site
6. Yii2 database read/write separation configuration, YII2 database read/write
Introduction: YII2 Database read-write separation configuration, YII2 database read and write. YII2 database read/write separation configuration, YII2 database read and write Source link: Yii Chinese network (yii-china.com)-YII2 database read-Write separation configuration Introduction database read-write separation is encountered in the Web site
7. mysql master-slave synchronization, read and write separation configuration steps
Description: Configure MySQL master-slave backup, read/write separation according to requirements, combined with the online documentation, the steps of the building and the problems and the process of solving the following notes
8. mysql master-slave copy and read/write separation implementation
Introduction: Mysql5.6 Based on Gtid master-slave replication and the use of amoeba configuration read-write separation one, introduction two, MySQL master configuration three, read and write separation configuration one, Amoeba introduction Amoeba (Amoeba) project, the Open source framework launched in 2008
9. CentOS System AMOEBA+MYSL Master-Slave read/write separation configuration Tutorial
Introduction: CentOS system Amoeba+mysql Master-Slave read/write separation configuration suitable for beginners fool-style tutorial! -----for reference only!
Thinksns error after read-write separation configuration
Introduction: We are THINKSNS on the development of two times, because thinkphp can configure read and write separation, so I found a lot of related articles on the internet, are said to be the following configuration, such as: My configuration (below) {code ...} Why, Error: Php_network_ Getaddresses:getaddrinfo failed ...
"Related question and answer recommendation":
Php-thinksns error after reading and writing separation configuration