top-image

Archives for February, 2009

Drupal Scaling, not so much

25
Feb
 posted by Clay vanSchalkwijk                filed under Framework, PHP
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 once we were able to really pick apart the infrastructure. Couple this with our own internal testing and ...more»
Comments (0)

SQL script to grab the worst performing indexes

11
Feb
 posted by Clay vanSchalkwijk                filed under SQL
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 see what changes we can do on the code and database side of things to help bring the site ...more»
Comments (0)

MySQL Proxy Quick Start

10
Feb
 posted by Clay vanSchalkwijk                filed under Linux, SQL
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 0.60 for low overhead, ease of setup, and ease of maintenance. I installed the proxy on ...more»
Comments (0)
bottom-img