2 Locate the directory my.cnf file resides:
\nMySQL –help | grep my.cnf
\ngeneral my.cnf are located in \/etc\/directory;<\/p>\n
3 with vim open MySQL configuration file my.cnf:
\nvim \/etc\/my.cnf<\/p>\n
4 Locate the [mysqld] and subsequently add the following configuration:
\n# uniquely identifies this MySQL server, the default value is 1, the general IP terminal belongs value
\nserver-id=1
\n# binary log file name, MySQL master server must enable this configuration
\nlog-bin=master-bin-log
\n# master server in the MySQL database name involved in master-slave replication; if there are multiple databases, this parameter can have multiple, one per line, divisions corresponding to different database
\nbinlog-do-db=db_master_slave
\n# master the MySQL server binary log file name in the index of
\nlog-bin-index=master-bin-log.index<\/p>\n
Also open from 5 in the MySQL server using vim my.cnf file, locate the [mysqld], and add the following configuration at the rear:
\n# uniquely identifies this MySQL server, the default value is 1, the general IP terminal belongs value
\nserver-id=2
\n# log index file name from the MySQL server the above mentioned id
\nrelay-log-index=slave-relay-log.index
\n# log file name from the MySQL server
\nrelay-log=slave-relay-log<\/p>\n
6, respectively, to create a database db_master_slave on MySQL master and slave servers:
\nthe Create Database db_master_slave;
\ncreate database db_master_slave;<\/p>\n
7 Create user user_master on MySQL master server, and set a password Password_Master_123456: the Create the User ‘user_master’ @ ‘%’ IDENTIFIED by ‘Password_Master_123456’;
\ncreate user ‘user_master’@’%’ identified by ‘Password_Master_123456’;<\/p>\n
8 on MySQL master server for users user_master Empowering all rights db_master_slave database:
\ngrant all on db_master_slave.* to ‘user_master’@’%’;<\/p>\n
9 On the MySQL master server for the local user access privileges assigned user_master:
\ngrant all privileges on db_master_slave.* to ‘user_master’@’localhost’ identified by ‘Password_Master_123456’;<\/p>\n
10 Authorized MySQL slave servers on a MySQL master server can access the host server by user_master User:
\ngrant replication slave on *.* to ‘user_master’@’%’ identified by ‘Password_Master_123456′ with grant option;<\/p>\n
11 On the MySQL master and slave servers are restarted MySQL service:
\nclosed MySQL service:
\nservice mysqld stop
\nopen MySQL service:
\nservice mysqld start
\nrestart the MySQL service:
\nservice mysql restart<\/p>\n
12 On the MySQL master and slave servers are entered into the database db_master_slave:
\nuse db_master_slave;
\ncreate table t_user(id int(3), name varchar(128));<\/p>\n
13 See MySQL master server status:
\nshow master status;
\nthe value of its properties and master_log_pos master_log_file property and records;<\/p>\n
14 executed on a MySQL slave service as follows:
\nChange to Master MASTER_HOST =’192.168.1.10′, \/\/ the MySQL Master server the IP
\nMASTER_PORT=3306,
\nMASTER_USER=’user_master’,
\nmaster_password=’Password_Master_123456′,
\nMASTER_LOG_FILE=’Master-bin-log.000004 ‘, \/\/ MySQL master server master_log_file value
\nmaster_log_pos=654; \/\/ value of MySQL master server master_log_pos<\/p>\n
15 db_master_slave library MySQL master server to add data to the user name T_USER:
\nmysql> insert into t_user(id, name) values(1, ‘idea1’);
\nmysql> select * from t_user;<\/p>\n
16 db_master_slave library MySQL slave server to add data to the user name T_USER:
\nmysql> insert into t_user(id, name) values(1, ‘idea1’);
\nmysql> select * from t_user;<\/p>\n
17 MySQL slave servers how to discover:
\nslave_IO_running = NO
\nthen execute the following command:
\nmysql> stop slave;
\nmysql> start slave;<\/p>\n
18 See MySQL runtime server_id values:
\nshow variables like ‘server_id’;<\/p>\n","protected":false},"excerpt":{"rendered":"
Deploy MySQL master-slave on CentOS7 <\/p>\n
2 Locate the directory my.cnf file resides: MySQL –help | grep my.cnf general my.cnf are located in \/etc\/directory;<\/p>\n
3 with vim open MySQL configuration file my.cnf: vim \/etc\/my.cnf<\/p>\n
4 Locate the [mysqld] and subsequently add the following configuration: # uniquely identifies this MySQL server, the default value is 1, the […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[73],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6185"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6185"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6185\/revisions"}],"predecessor-version":[{"id":6186,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6185\/revisions\/6186"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6185"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6185"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}