I want to solve a data replication/data sync problem between two MySQL server instances. Both of them have the same database structure (databases, tables, columns, everyting ...) but each of them has a different priority when it comes to storing data. One receives data from a website, which is the frontend in the solution, the other one gets its data from the backend. This is some sort of load balancing here, because the backend isnt well designed, and its connection dies if it cant write its data within some seconds.
To make it more precise, I have to mention, that backend and frontend does write not into the same tables. Currently the synchronisation between these databases is managed by triggers and stored procedures, and this should be changed into a more stable solution.
I found an article on the web ( http://www.howtoforge.com/mysql_database_replication ) that looks promising, but it threw up a question: Is it possible to make both servers Master and Slave at the same time? It would be perfect if yes. Btw: if yes, i might ask how its done (the settings for master and slave on each servers config?).
Id like to ask if there are other solutions for that kind of replication too.
Thanks