Setting up MySQL master - master replication

Question

I currently have one master server and want to add another master server for fail over. On the primary server I've added the following to "my.ini" ``` server-id = 1 replicate-same-server-id = 0 auto-increment-increment = 2 auto-increment-offset = 1 log_bin=mysql-bin log_error=mysql-bin.err binlog_do_db=1 binlog_do_db=2 binlog_do_db=3 binlog_do_db=4 ``` Once adding: ``` master-host = [IP] master-user = [usernameslaveuser] master-password = [password] master-connect-retry = 30 ``` The mysql server no longer starts up... So I decided to first get the secondary server to work properly. Problem 2: On the new server I've copied over my user files from the "data"/mysql dir of the primary. I've also imported all databases with MySQL work bench. Then I added this to "my.ini": ``` server-id=2 replicate-same-server-id = 0 auto-increment-increment = 2 auto-increment-offset = 2 master-host = [IP] master-user = [usernameslaveuser] master-password = [password] master-connect-retry = 30 log_bin=mysql…

Accepted Answer

Specifying as below in my.cnf(linux) or my.ini(windows) file is no longer supported in latest versions of MySQL

```
master-host = [IP]
master-user = [usernameslaveuser]
master-password = [password]
master-connect-retry = 30  
```

You should execute this query instead:

```
CHANGE MASTER TO MASTER_HOST='host name/ip',MASTER_USER='user',MASTER_PASSWORD='pwd',              MASTER_PORT=3306, MASTER_CONNECT_RETRY=30; 
```

Setting up MySQL master - master replication

Solution

Problem