I want to setup replication for my MySQL database.
Recently I've came to the conclusion that the current backup method I use (SQL dumps) isn't good at all and quite unsafe as various tables in the database can be modified while the dump is running, resulting in a corrupted database.
The only alternative would be to lock the database before making a backup, but since it it needs to be available at all times this is not an option.
I've tried various MySQL db replication guides, but I found them confusing and I don't think I've managed to set it up properly.
The previous time I tried to set it up the replication database didn't work properly. I was receiving duplicate entries query errors etc.
Can someone recommend me a very noob-friendly guide for this?
Ask questions about dedicated servers here and we and other users will do our best to answer them. Please also refer to the self-help section for tutorials and answers to the most commonly asked questions.
1 post • Page 1 of 1