{"id":2179,"date":"2013-07-07T14:15:25","date_gmt":"2013-07-07T06:15:25","guid":{"rendered":"http:\/\/rmohan.com\/?p=2179"},"modified":"2013-07-07T14:15:25","modified_gmt":"2013-07-07T06:15:25","slug":"setup-mysql-replication-between-linuxmaster-windows-xpslave","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=2179","title":{"rendered":"Setup Mysql Replication Between Linux(master) & Windows XP(Slave)"},"content":{"rendered":"

Step 1 \u2013 Configure the Master Server<\/strong><\/p>\n

First we have to edit\u00a0\/etc\/mysql\/my.cnf. We have to enable networking for MySQL, and MySQL should listen on all IP addresses, therefore we comment out these lines (if existant):<\/p>\n

#skip-networking<\/p>\n

#bind-address\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0= 127.0.0.1<\/p>\n

Furthermore we have to tell MySQL for which database it should write logs (these logs are used by the slave to see what has changed on the master),<\/p>\n

which log file it should use, and we have to specify that this MySQL server is the master. We want to replicate the database\u00a0exampledb, so<\/p>\n

we put the following lines into\/etc\/mysql\/my.cnf:<\/p>\n

server-id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0= 1<\/p>\n

log_bin\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0= \/var\/log\/mysql\/mysql-bin.log<\/p>\n

binlog_do_db\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0= exampledb<\/p>\n

 <\/p>\n

Then we restart MySQL:<\/p>\n

\/etc\/init.d\/mysql restart<\/p>\n

Then we log into the MySQL database as\u00a0root\u00a0and create a user with replication privileges:<\/p>\n

 <\/p>\n

mysql -u root -p<\/p>\n

Enter password:<\/p>\n

 <\/p>\n

Now we are on the MySQL shell.<\/p>\n

mysql>GRANT REPLICATION SLAVE ON *.* TO \u2019slave_user\u2019@\u2019%\u2019 IDENTIFIED BY \u2018<some_password>\u2019;\u00a0(Replace<some_password>\u00a0with a real password!)<\/p>\n

mysql>FLUSH PRIVILEGES;<\/p>\n

 <\/p>\n

Next (still on the MySQL shell) do this:<\/p>\n

mysql>USE exampledb;<\/p>\n

mysql>FLUSH TABLES WITH READ LOCK;<\/p>\n

mysql>SHOW MASTER STATUS;<\/p>\n

 <\/p>\n

The last command will show something like this:<\/p>\n

+\u2014\u2014\u2014\u2014\u2014+\u2014\u2014\u2014-+\u2014\u2014\u2014\u2014\u2013+\u2014\u2014\u2014\u2014\u2014\u2014+<\/p>\n

| File\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| Position | Binlog_do_db | Binlog_ignore_db |<\/p>\n

+\u2014\u2014\u2014\u2014\u2014+\u2014\u2014\u2014-+\u2014\u2014\u2014\u2014\u2013+\u2014\u2014\u2014\u2014\u2014\u2014+<\/p>\n

| mysql-bin.006 | 183\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| exampledb\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|<\/p>\n

+\u2014\u2014\u2014\u2014\u2014+\u2014\u2014\u2014-+\u2014\u2014\u2014\u2014\u2013+\u2014\u2014\u2014\u2014\u2014\u2014+<\/p>\n

1 row in set (0.00 sec)<\/p>\n

 <\/p>\n

Write down this information, we will need it later on the slave!<\/p>\n

Then leave the MySQL shell:<\/p>\n

 <\/p>\n

mysql>quit;<\/p>\n

 <\/p>\n

Step 2 \u2013 Configure the Slave Server(Windows XP)<\/strong><\/p>\n


\n<\/strong><\/p>\n

Edit the\u00a0c:\\program files\\mysql\\mysql server 5.0\\my.ini<\/p>\n

server-id=2<\/p>\n

master-host=db01.yourdomain.net (or IP address)
\nmaster-port=3306
\nmaster-user=slave_user
\nmaster-password=password<\/p>\n

Step 3 \u2013 Restart Mysql Service\u00a0<\/strong><\/p>\n

goto> Control Panel>Administrative Tools>Services>Mysql<\/p>\n

Restart Service<\/p>\n

mysql > Stop slave;<\/p>\n

mysql>CHANGE MASTER TO MASTER_HOST=\u2019192.168.10.175?, MASTER_USER=\u2019slave_user\u2019, MASTER_PASSWORD=\u2019password\u2019,MASTER_LOG_FILE=\u2019mysql-bin.000008?,MASTER_LOG_POS=98;<\/p>\n

mysql > Start slave;<\/p>\n","protected":false},"excerpt":{"rendered":"

Step 1 \u2013 Configure the Master Server<\/p>\n

First we have to edit \/etc\/mysql\/my.cnf. We have to enable networking for MySQL, and MySQL should listen on all IP addresses, therefore we comment out these lines (if existant):<\/p>\n

#skip-networking<\/p>\n

#bind-address = 127.0.0.1<\/p>\n

Furthermore we have to tell MySQL for which database it should write logs (these logs […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2179"}],"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=2179"}],"version-history":[{"count":2,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2179\/revisions"}],"predecessor-version":[{"id":2181,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2179\/revisions\/2181"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2179"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2179"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2179"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}