My box is pegging out. I'm trying to setup a MySQL box running for:
- 3000 connections (3 workers for 1000 boxes) (box maxes out at 700 connections, already)
- Heavy Writes
- AWS High-CPU Extra Large Instance (c1.xlarge)
- Ubuntu 10.04
- MySQL 5.5.19
- InnoDB Tables
The config is:
my-innodb-heavy-4G.cnf. Specific modifications are:
- max_connections = 65000
- innodb_buffer_pool_size = 5G
Otherwise everything is default. What recommendations do you guys have for a different MySQL setup?
- MySQL Cluster
- Master/Slave replication (I don't know if there will be many gains here.)
We're already using the most powerful box AWS has available, so realistically it's looking like a distributed system is possibly the way we should go. Dedicated hardware might be a possibility but it's a very long shot.
What do you recommend/think how we should proceed? Is there a magic configuration I'm missing?
Thanks in advanced, Justin