I am building a standart infrastructure, where writes are going to master db, and reads are going to slave dbs. The idea is that when I need more read power - I just spawn more MySQL slave servers.
Now I am aware of standart procedures of how to create a new slave. And they are a little to slow ... What I am looking for is to create an server image that I could spawn when I need more read power and that image would automatically sync to master and become its slave for reads.
At the moment I think of doing it like this.
- Have a database backups every 4 hours or so/
- Write a script that would run first time server is started.
- The script would download the latest backup and import it in a regular way ... and bla bla bla ...
Maybe someone has done something similar and could share some resources ?