The site I am working on has a lot of backend/cron activity, so there are between 5 and 15 queries being executed every second of the day. This can slow down page loads by a second or more.
I was thinking the best thing to do would be create two databases and synchronize them daily. However:
- I do not know how to do this
- I am worried synchronization will be slow & block db access. I really don't like the idea of taking the site offline, even for 10 minutes at 3 am.
So I am wondering:
- Is separate databases the best solution for this problem, or would something else be better?
- How would I synchronize the database without interfering too much with the 'user experience'?
Thanks very much!
BTW running PHP/MySQL on 'could' servers.