Sample Header Ad - 728x90

mysqld-multi with first DB as Slave and second DB as Master

3 votes
1 answer
537 views
Yesterday, I setup mysqld-multi in my.cnf. It works fantastic, but there is still a further Problem. The first DB on socket 1 running as Slave from a other server. The second one from socket 2 should run as Master for a further Slave. The replication for DB 1 running successful. **My question is it possible to setup the master-slave environment for every socket? Is it basically possible to setup more than one master-slave configuration in my.cnf?** I couldn't found helpful hints in google or I doesn't have the correct search words. I'm happy for any helpful hints. My system is Debian 6 with mysql 5 and php. [mysqld1] read-only # comment out only on the productive dbmaster port = 3306 datadir = /var/lib/mysql pid-file = /var/lib/mysql/mysqld.pid socket = /var/lib/mysql/mysql.sock user = mysql log-error=/var/log/mysql1.log innodb_data_home_dir = /var/lib/mysql innodb_log_group_home_dir = /var/lib/mysqlinnolog relay-log = /var/log/mysql/master-relay-bin relay-log-index = /var/log/mysql/master-relay-bin.index log-bin = /var/log/mysql/relaylog/master-bin [mysqld2] port = 3307 datadir = /var/lib/mysql-data2/mysqld2 pid-file = /var/lib/mysql-data2/mysqld2/mysql.pid socket = /var/lib/mysql-data2/mysqld2/mysql.sock user = mysql log-error=/var/log/mysqld2.log log-bin = /var/log/data2/mysql-bin Both instance have a specific port and a separate Datadir. Is it possible to give each section in the snippet a unique ID? Can I put the Slave ID in section [mysqld1] and the master ID in [mysqld2]?
Asked by Holger Jensen (31 rep)
May 29, 2012, 10:56 AM
Last activity: Jul 23, 2017, 05:54 PM