Percona and Mad Mimi's MySQL Optimizations
Recently, Mad Mimi's email and interface speed has decreased across the board somewhat, and some people have been asking about it.So, here's the skinny on the speed.Mad Mimi in in April, was sending around 1 million emails a day. September, the beginning, we were sending 3 million a day. One month later - as in, today - we're sending over 6 million. This means our database is ballooning quite fast, and although we've substantially scaled all our hardware, we've reached a point at which hardware is limited.We've had Percona (the very best database consultancy in the world) in all week, specifically Piotr Biel and Maciej Dobrzanski, and we are retaining them to scale and optimize our database architecture primarily by implementing replication and sharding which will make our database scalable and fast. We're hoping Percona will complete the optimizations the end of next week, and every day we've been rolling out smaller optimizations, and today we're updating our stored procedures. As of yesterday, we've seen significant enhancements in speed.We expect dramatic improvements by the end of next week, at which time we'll all be sailing. :) Please be assured, we're sparing no expense and no effort in handling this with as much elegance as is possible. We appreciate the support and patience of all our beautiful customers who we love. :-)Gary
Mad Mimi's CEO and Founder
Posted by Mad Mimi
