Join 1M+ other developers and:
- Get help and share knowledge in Q&A
- Subscribe to topics of interest
- Get courses & tools that help you grow as a developer or small business owner
SQL replication and manage
I would like to have 2 separate droplets with same operating system (CentOS 7) and MySQL. I would like to create a Master-Master replication for the SQL, so (for example) I want to copy the changes from ServerA to ServerB every day, if ServerA crashes, then ServerB takes control and is used by the website. My question is, how can we do this and is there a graphical interface to manage the replication (set schedules, select replicated tables, change IP of the replicated server, etc.) that you could recommend?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×