http://palominodb.com/blog Sun, 08 Nov 2009 16:35:29 +0000 http://backend.userland.com/rss092 en You might notice that I haven't blogged in oh, 2 years.  How remiss of me.  The only defense I have is that we've been non-stop busy!  Since then we've built our client portfolio, brought in two new team members, presented at MySQL Conference and still managed to get into any ... http://palominodb.com/blog/2009/11/08/where-weve-been/ I've been setting up partitioning for various customers lately. The goals primarily have been easy purging of large growth tables and keeping indexes small enough to stay in memory and manageable. These have all been range partitions on dates, which is a rather common requirement. As you've ... http://palominodb.com/blog/2008/03/04/mysql-partitioning/ This is another tool in the same toolkit as archiver. I just saw a great blog post on it at http://blog.arabx.com.au/?p=883. Documentation can be found at http://mysqltoolkit.sourceforge.net/doc/mysql-checksum-filter.html. This is an invaluable tool for ensuring your replicated tables are staying in sync, something that MySQL replication does not ... http://palominodb.com/blog/2007/11/12/mysql-checksum/ Everyone puts lip service to the concept of keeping versions consistent between servers but it is consistently one of the most broken best practices I see amongst my clients. The problems with such inconsistency are legion, and I'll point out a few here. Mismatch between production and development: Development ... http://palominodb.com/blog/2007/11/11/version-consistency/ The MySQL Toolkit can be found at http://mysqltoolkit.sourceforge.net/. It is coded and maintained by Baron Schwartz (www.xaprb.com). I've been using the archiver tool he wrote lately, and wanted to share this tool. In every web environment I've worked in, there is data that is collected for analysis ... http://palominodb.com/blog/2007/10/23/mysql-toolkit-archiver/ The first start-up stage I've worked within is the prototype phase. Within this phase traffic is not an issue for performance or scale, it's about functionality. Low traffic and small datasets can hide atrocious code quite easily. The nice thing about this stage is that you should ... http://palominodb.com/blog/2007/10/15/the-prototype/ My first senior production database role was at an established start-up, Preview Travel, that had just been purchased by a similarly established, but better positioned start-up, Travelocity. Since then, I've worked with start-ups in all stages of growth and I've seen definite patterns in how database infrastructures are designed, ... http://palominodb.com/blog/2007/10/06/the-start-up-and-the-database-pt-1/ I've been considering starting a blog of my own for quite some time, but I must admit to some hesitancy, primarily due to the quality of technical content already posted online. Finally, I've decided to take the plunge, and to focus on the quality I truly bring to my ... http://palominodb.com/blog/2007/10/06/preamble/