MySQL databases come in all shapes and sizes, but most often are deployed behind Web sites. As sites grow, the companies behind them often become concerned about uptime and want to move to a ...

Unfortunately, MySQL Proxy and its CentOS package are not well documented. It requires some ingenuity to configure it and get started. Here are some tips to aid you ...

MySQL and PostgreSQL are two of the most used open source SQL databases, and both fulfill the role of a general-purpose database well. How do you choose which one to use for a project? Let's look at ...

For database administrators (DBAs), keeping databases running at peak performance can be a little like spinning plates: It takes agility, concentration, quick reactions, a cool head, and an occasional ...

I'd like to hear some best practices / advice regarding MySQL clustering and replication.<BR><BR>We've looked into the mysql clustering engine and while it seems nice, everything is stored in RAM and, ...

Until recently, I've been a fan of the PostgreSQL database, but Mysql's database replication implementation is very slick. Not to disparage my favorite RDBMS too much, but PostgreSQL's replication ...