Simple setup of master-slave MySQL

Source: Internet
Author: User
Simple setup of MySQL master-slave architecture 192.168.190.128 192.168.190.129master ---- slaveslave ---- master1. Configure on master128

Simple construction of MySQL master-slave for mutual master: 192.168.190.128 "===" 192.168.190.129 master ----" slave "---- master 1. Configure on master 128

Simple setup of master-slave MySQL

192.168.190.128 "====" 192.168.190.129
Master ---- slave
Slave ---- master

1. Configure the my. cnf file on the master 128 and add the following parameters:
Server-id = 1
Log-bin = mysql-bin
Log-salve-updates
Sync_binlog = 1
Auto_increment_increment = 2
Auto_increment_offset = 1

Restart mysql
[Root @ calvin1 ~] #/Etc/init. d/mysqld start
Starting MySQL: [OK]
[Root @ calvin1 ~] # Mysql-u root-p123456
Welcome to the MySQL monitor. Commands end with; or \ g.
Your MySQL connection id is 6
Server version: 5.0.77-log Source distribution

Type 'help; 'or' \ H' for help. Type '\ C' to clear the buffer.

Mysql> show databases;
+ -------------------- +
| Database |
+ -------------------- +
| Information_schema |
| Calvin |
| Calvin2 |
| Mysql |
| Sampdb |
| Test |
| Testdb |
+ -------------------- +
7 rows in set (0.00 sec)

2. Configure the my. cnf file on the master 129 and add the following parameters:
Server-id = 2
Log-bin = mysql-bin
Log-salve-updates
Sync_binlog = 1
Auto_increment_increment = 2
Auto_increment_offset = 2

Restart mysql
[Root @ calvin2 ~] #/Etc/init. d/mysqld start
Starting MySQL: [OK]
[Root @ calvin2 ~] # Mysql-u root-p123456
Welcome to the MySQL monitor. Commands end with; or \ g.
Your MySQL connection id is 7
Server version: 5.0.77-log Source distribution

Type 'help; 'or' \ H' for help. Type '\ C' to clear the buffer.

Mysql> show databases;
+ -------------------- +
| Database |
+ -------------------- +
| Information_schema |
| Calvin |
| Calvin2 |
| Mysql |
| Sampdb |
| Test |
| Testdb |
+ -------------------- +
7 rows in set (0.00 sec)

3. Create a replication account on master 128:
Mysql> grant replication slave, file on *. * to mysync @ '192. 168.190.129 'identified by '123 ';
Query OK, 0 rows affected (0.00 sec)

Mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

Add read-only locks to all tables:
Mysql> flush tables with read lock;
Query OK, 0 rows affected (0.00 sec)

View the binary file of the master, pos Number:
Mysql> show master status \ G;
* *************************** 1. row ***************************
File: mysql-bin.000004
Position: 906
Binlog_Do_DB:
Binlog_Ignore_DB:
1 row in set (0.00 sec)

ERROR:
No query specified

Mysql> unlock tables;
Query OK, 0 rows affected (0.00 sec)

Mysql> stop slave;
Query OK, 0 rows affected, 1 warning (0.00 sec)

4. Create a replication account on master 129:
Mysql> grant replication slave, file on *. * to mysync @ '192. 168.190.128 'identified by '123 ';
Query OK, 0 rows affected (0.00 sec)

Mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

Add read-only locks to all tables:
Mysql> flush tables with read lock;
Query OK, 0 rows affected (0.00 sec)

View the binary file of the master, pos Number:
Mysql> show master status \ G;
* *************************** 1. row ***************************
File: mysql-bin.000001
Position: 318
Binlog_Do_DB:
Binlog_Ignore_DB:
1 row in set (0.00 sec)

ERROR:
No query specified

Mysql> unlock tables;
Query OK, 0 rows affected (0.00 sec)

Mysql> stop slave;
Query OK, 0 rows affected (0.00 sec)



5. Modify synchronization parameters:
Configure the synchronization parameters of master 3rd Based on the binary file and pos number read in Step 1:
Mysql> change master
-> Master_host = '192. 168.190.129 ',
-> Master_user = 'mysync ',
-> Master_password = '123 ',
-> Master_log_file = 'mysql-bin.000001 ',
-> Master_log_pos = 318;
Query OK, 0 rows affected (0.01 sec)

Mysql> start slave;
Query OK, 0 rows affected (0.00 sec)

Configure the synchronization parameters of master 4th Based on the binary file and pos number read in Step 1:
Mysql> change master
-> Master_host = '192. 168.190.128 ',
-> Master_user = 'mysync ',
-> Master_password = '123 ',
-> Master_log_file = 'mysql-bin.000004 ',
-> Master_log_pos = 906;
Query OK, 0 rows affected (0.01 sec)

Mysql> start slave;
Query OK, 0 rows affected (0.01 sec)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.