So I guess they announced this a week or so back, but Joyent is now selling mysql in a somewhat appliance like fashion as their “mysql accelerator”. Pretty cool overall.
Unfortunatly in an attempt to show it off they put out a benchmark blog post that is inconclusive at best: Blog Joyent | On Benchmarking Databases: MySQL on Joyent versus AWS part 1.
Running MySQL on anything more than trivial hardware with the default “my.cnf” means you’re going to run into any of a number of artificial ceelings such that if you benchmark it that way the results don’t really mean anything. If anything, it means that the people selling you a mysql appliance either don’t know that, or are being that level of soft-misleading that kinda undercuts joyents vibe.
However all that is practically sideshow to this little nugget: MySQL Read-Write Splitting with Zeus Accelerators. Thats right, they’re *selling* a service built on using a loadbalancer/app-proxy to split your reads and writes for you. Thats pretty epic. I have yet to see anyone get that working in a proxy/loadbalancer fashion, let alone get it to sellable-service-product status.
Sorry not trying to make this a MySQL blog.
What’s so difficult about splitting up your db tier into read/write VIPs? Anyone not doing that is asking for trouble.
Hi luckyland. Everyplace I’ve seen do it does it via separate handles/vips, but they claim to have gotten the packet inspection down the point where you don’t need to alter code. Raises a lot of spooky questions, but still impressive that they rolled it out.