We're currently in the process of moving our hosting services to something which will allow us to scale our infrastructure and requirements.
Essentially we're using MySQL to:
- Run our websites.
- Run our blog
- Store millions of rows which will require some heavy queries, but will be cached afterwards.
Our current idea is to setup two MySQL servers, on a
master replication, with HAProxy on top to load-balance the requests.
As we've never dealt with replication before our main concerns are the following:
- How quickly does replication work?
- What happens if one of the servers go down? Would we change HAProxy to use just the one server?
- How does replication deal with loading and replicating millions of rows each day? This would happen once a day.
Thanks for any help!