I did a master/master replication with MySQL on a Gentoo OVH Release 2, all work fine in my test phase, i put it in production, the replication works fine in 1 or 2 days but this morning, i don't know why, my slave stops running !
So now the log position is bad => i can't just restart slave And my replication did'nt works :/
I want a master/master replication to make a backup server with an IP Fail Over, so only one server is writing/reading in the database at same time.
When i go to MySql and i click on "Show slave status", i see an error like : "Error 'Duplicate entry '411465' for key 1' on query. Default database .... etc"
Did this error stop my replication ? If yes, why do i get this error ? Because the second server does nothing on the database, so normally, there is no problem with the auto increment, right ?
If someone have an idea on how i can fix it, he's welcome :)
PS: Sorry if i made some grammatical mistakes in my question.