I'm looking for a good MySQL database replication guide

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.
Post Reply
mmc
New to forums
New to forums
Posts: 2
Joined: Thu Feb 14, 2019 1:46 am

I'm looking for a good MySQL database replication guide

Post by mmc » Thu Feb 14, 2019 1:53 am

Hi,

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?

Post Reply