How to configure MySQL 5.5 Server as Replication Slave:

I had some trouble configuring a MySQL 5.5 Server as Replication Slave.
MySQL did not not start after I wrote master host details in my.cnf of slave node. Got following error.

Goggled and found that Replication Master data cannot be set in slave my.cnf for MySQL 5.5 Server, though the my.cnf sample files still proposes this.
To define the Replication Master connect through a shell to your MySQL server and enter:

This will create a file, where this data and information about the master bin-log and the log position is stored.

Then start the replication:

Confirm your configuration/replication is working or not:

The following two tabs change content below.

Tapas Mishra

Sr. Engineer (DevOps)
Loves to work on Opensource products. Having experience on Linux environment. Knowledge on Public cloud services like AWS, Rackspace, DigitalOcean, Linode. Please don't hesitate to give a comment on the posts. Your comments are my strength.

One thought on “How to configure MySQL 5.5 Server as Replication Slave:

Leave a Reply