![]() ![]() One of the most common scenarios involving Master-Master replication is when you have a 2 VPS (or hosting servers) environment/farm, each one providing an http web server (such as IIS or Apache) containing one or more web sites connected to a local MySQL server instance on the same machine. A more robust, fail-proof and scalable environment, as long as you'll connect different web sites/services/apps to each of your DB and install a software or hardware http load balancer to distribute clients between them.A 1:1 mirror your entire database pool (or a selection of your choice), ensuring you won't lose anything due to an hardware (or software/OS) crash. ![]() In order to do that you'll need a second machine/server, meaning you'll have to sustain more costs: don't make this stop you - an investment like that is hardly worthless: conversely, it will most likely be a substantial improvement for your system. If you don't know what it is, just imagine two MySQL server instances continuosly updating each other in real-time while fullfilling their job. Master-Master replication, also known as mirror, is by far the simplest technique you can use to increase the performance and the reliability of your MySQL server installation. Configure replication from Server B to Server A Configure replication from Server A to Server B ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |