3 ms·
Replace MySQL with Percona XtraDB, and leverage aggressive "permacaching" for a start. Then it's more about splitting up your infrastructure and having mechanis
by antihero 14y ago
Replace MySQL with Percona XtraDB, and leverage aggressive "permacaching" for a start. Then it's more about splitting up your infrastructure and having mechanisms for dealing with increased load on different parts of it (ie high db load = spin up more DB machines)
- astrodust 14y agoYou have no idea what the problem is and you're already advocating a change of platform? This is not how you scale. This is how you hit up a client for thousands of hours of "consulting" fees. This performance problem could be because of missing indexes, grossly inefficient queries, or a whole host of other elementary problems that can be fixed with a keystroke.
- antihero 14y agoNot advocating a change of platform at all - Percona is a drop-in replacement for MySQL, and XtraDB is backwards compatible with InnoDB which gets much more performance out of multicore systems. Unless your server has one core, it's a no-brainer.