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?
I'm looking for a good MySQL database replication guide
-
- New to forums
- Posts: 2
- https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
- Joined: Thu Feb 14, 2019 1:46 am