Row cannot be located for updating mysql server

I have 2 websites, 2 databases (same name) on 2 different web servers, S1 & S2. I want both the user data on both the websites to be the same.

You might also want to keep out other databases such as mysql or other ones: if that’s the case, just add those you want to exclude by adding a binlog-ignore-db and replicate-ignore-db command for each one of them.

, is by far the simplest technique you can use to increase the performance and the reliability of your My SQL server installation.

If you don’t know what it is, just imagine two My SQL server instances continuosly updating each other in real-time while fullfilling their job.

If you already have a My SQL instance up and running on one of them, just upgrade it to the latest version you feel confident to use and then install that same identical version to the other one.

As soon as you’re finished, edit the main config file – server-id=1 log-bin="mysql-bin" binlog-ignore-db=test binlog-ignore-db=information_schema replicate-ignore-db=test replicate-ignore-db=information_schema relay-log="mysql-relay-log" auto-increment-increment = 2 auto-increment-offset = 1 server-id=2 log-bin="mysql-bin" binlog-ignore-db=test binlog-ignore-db=information_schema replicate-ignore-db=test replicate-ignore-db=information_schema relay-log="mysql-relay-log" auto-increment-increment = 2 auto-increment-offset = 2 values.

Leave a Reply