The right way? Automated Synchronization between 2 mysql DB?

What you're describing is master-master or multi-master replication There are plenty of tutorials on how to set this up across the web. Definitely do your research before putting a solution like this into production as replication in MySQL isn't exactly elegant -- you need to know how to recover if (when? ) something goes wrong.

What you're describing is master-master or multi-master replication. There are plenty of tutorials on how to set this up across the web. Definitely do your research before putting a solution like this into production as replication in MySQL isn't exactly elegant -- you need to know how to recover if (when?) something goes wrong.

1 +1 - I would say don't try to re-invent this wheel. Too much time and effort has been put into MySQL replication to solve its many, many complexities. It effectively does what you describe using the binary logs to store the queries issued so slaves can be updated.

See master-master replication if that is what you need, but master-slave configuration is really not that difficult, just follow their directions step by step. I think ultimately it will resolve many headaches and future problems. – drew010 Sep 30 at 2:54 I'm too stupid to find my way through the Documentation, not my day.

Now hoping I'm allowed to access the remote servers mysql configuration file. Thank you guys! – danontheline Sep 30 at 3:18 Just got told that my hoster doesn't support Replication, unless I take a really expensive package - is this the standard procedure?

Otherwise I propably have to use my solution anyway :/ – danontheline Sep 30 at 3:58 1 When you say they don't "support" replication, that could mean either (1) that your database is on a server shared with other people, or (2) that they don't provide technical support for a replication setup -- I'm going to assume the former. One way around this is to use a (pair of) VPS, but it'll cost more and you'll have to set up and manage the server yourself. Alternatively, you can build logic to read/write to two databases in PHP but it's certainly non-trivial.

– Justin Sep 30 at 14:39.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.