Drupal Scaling, not so much
by Clay vanSchalkwijk on February 25, 2009
After working on the migration this week and moving CitySquares.com over to a new environment we ended the week with a load test from Soasta. Starting at several hundred concurrent users to a cap of 2500 simulated users on at (…)
SQL script to grab the worst performing indexes
by Clay vanSchalkwijk on February 11, 2009
I have been doing a lot of auditing and clean up of database performance the last few days. We are currently in the middle of a migration and with hardware infrastructure in place it is time to go back and (…)
MySQL Proxy Quick Start
by Clay vanSchalkwijk on February 10, 2009
There isn’t too much out there for easy reliable mysql load balancing. I recently built a master/master mysqld setup and needed automatic roll over on the software side. After going through the options I ended up going with MySQL Proxy (…)
There and Back Again, an EC2 MySQL Cluster
by Clay vanSchalkwijk on January 26, 2009
Limitations of EC2 as a web platform: Price- An m1.xlarge instance will run you ~$600 with data transfer costs. Managed hosting solutions run cheaper especially if you plan on purchasing in bulk. The grid is designed for on-demand computation and (…)