[Chugalug] Percona vs. MySQL

[Ed King]

if time is money and you value your hair...  ditch mysql and go to postgresql





________________________________
From: Eric Wolf <ebwolf at gmail.com>
To: CHUGALUG <chugalug at chugalug.org>
Sent: Sun, November 18, 2012 12:53:15 AM
Subject: [Chugalug] Percona vs. MySQL

Does anyone have experience with Percona versus MySQL?

The application in question has one really big table with a bunch of ENUMs and 
one joined table (with a 4K text field). All reads, minimal writes. Queries on 
the table work great in MySQL (MyISAM engine) with the DB is on an SSD (on a the 
new bad-ass High I/O Quadruple Extra Large EC2 instances) but performance sucks 
when the DB is moved back to EBS (and gets worse with the production m1.large 
instance).

Think Percona will help? Should I bite the bullet and try Postgres?

-Eric


-=--=---=----=----=---=--=-=--=---=----=---=--=-=-
Eric B. Wolf                           720-334-7734
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://chugalug.org/pipermail/chugalug/attachments/20121119/979490e2/attachment.html>