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