Category Archives: Database

I had it coming…

Just to recap - various stuff that runs Ravelry and my opinion on each:

Ruby on Rails 2: Love it. Moving to 2.1 for the named scopes (and because I’m on Edge somewhere between 2 and 2.1) Thin : stable. A little nicer than Mongrel. nginx : rocks. (ie. fast, stable, does what I […]

New Database Server

Well, I installed our new database server last night and so far things are looking good. The new box has way faster disks (4 SAS disks that are RAID10′d) and 32 GB of memory. You can’t scale up a database forever, but now I’ll actually be able to see through the smoke and tune […]

MySQL 5.1 (finally?)

After years of development, it appears that MySQL 5.1 is going to be released at the MySQL conference next week.

The timing is perfect. Our new database server is arriving on Monday and there hasn’t been a release candidate release since January.

5.1 is supposed to be faster. I’m sure that the web will be awash […]

Sphinx for search

In November or December, I started looking into other full text search options that would be suitable for searching forums (1.1 million posts) and projects (430,000 and lots of important associations). At the time, I was using Ferret (a port of Apache Lucene) and acts_as_ferret for all of our search needs and I […]