Quote:
Originally Posted by Army
Can you run mysql on more than one server?
I didn't think it was capable of doing Oracle-like tricks...
|
You can replicate your datasets amongst several slave MySQL servers to spread out load for a read-heavy application. In theory, all your data writes should go to the master, all your reads should go to the slave, and backups/mysqldumps should come from yet another slave.
This is actually one half of my favourite pair of interview questions when talking to potential employees.