Hi,
I would like to create a mirror server as a backup server, in which anything that happens at the first server, exactly happens on the backup (mirror) server exactly the same and at the same time. So if the first server stopped, the traffic will be automatically transferred to the backup server.
Any help is appreciated.
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.
Take a look at this article on setting up MySQL replication: https://www.digitalocean.com/community/articles/how-to-set-up-master-slave-replication-in-mysql