mysql x

15 Jun 13

PDO utf-8 character issue (stackoverflow.com) permalink

2 Jun 13

MySQL in the cloud at Airbnb (nerds.airbnb.com) permalink

25 May 13

Mysql slave server-id selection (www.semicomplete.com) permalink

Two slaves with the same server id will replicate successfully, but when they reach the end of the master's binary log, something freaks out and forces them to disconnect. This causes both slaves to reconnect, sync (no data needed), and have the connection die off quickly again. The result of this is rapid connection/disconnection by both slaves driving the load to 1+ on both slaves, and to around .3 on the master even in a completely idle system. This is bad. Therefore, server id collisions are bad.

databases mysql replication

10 Feb 13

Converting MySQL to PostgreSQL (en.wikibooks.org) permalink

convert database mysql postgres tips tutorial

Taps for Easy Database Transfers (adam.heroku.com) permalink

database mysql postgres sqlite taps tools utilities

5 Jun 12

Loading half a billion rows into MySQL (derwiki.tumblr.com) permalink

db mysql performance scaling tips

16 May 12

(My)SQL mistakes. Do you use GROUP BY correctly? (www.dbasquare.com) permalink

db mysql sql

10 May 12

Goodbye, CouchDB (saucelabs.com) permalink hackernews

Here at Sauce Labs, we recently celebrated the completion of a significant project to improve our service uptime and reliability, as we transitioned the last of our CouchDB databases to MySQL.

couchdb hackernews mysql

16 Mar 12

Using MySQL as a NoSQL – A story for exceeding 750,000 qps on a commodity server (yoshinorimatsunobu.blogspot.com) permalink

mysql nosql scaling

20 Feb 12

MySQL/Galera is synchronous multi-master cluster for MySQL/InnoDB database (codership.com) permalink

database multi-master mysql replication

30 Sep 11

Introducing Additional Slaves to an Existing Replication Environment (dev.mysql.com) permalink

mysql replication

17 Sep 11

Troubleshooting Memory and Networking Issues (library.linode.com) permalink

apache linode memory mysql optimizing troubleshooting

18 Aug 11

19 Jun 11

MySQL Explain Output (dev.mysql.com) permalink

mysql optimization

Joins are fast (stackoverflow.com) permalink

Joins are fast. Joins should be considered standard practice with a properly normalized database schema. Don't fear the join.

It's true that join performance degrades non-linearly as the size of the data set increases. Therefore, it doesn't scale as nicely as single table queries, but it still does scale.

It's also true that a bird flies faster without any wings, but only straight down.

databases JOIN mysql scaling