Setting-up second MySQL instance & replication on Linux in 10 steps
Kedar
This is a quick setup guide of 10-steps to install and configure (multiple) MySQL instance on 3307 port, and make it slave from MySQL running on port 3306.
Browsing Tag
step by step second mysql instance configuration on same machine
1 post
3 responses to “Setting-up second MySQL instance & replication on Linux in 10 steps”
I am getting below issue in 3rd step:
Failed to execute /usr/sbin/mysqld –defaults-file=/etc/my3307.cnf –bootstrap –datadir=/var/lib/mysql3307 –lc-messages-dir=/usr/share/mysql –lc-messages=en_US –basedir=/usr
Thanks for this post.
Unless I missed something, there is also a need to change server-id for slave in my.cnf.
That’s right. Corrected above Pavel.