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 ...

Setting up database replication is one of the most reliable means of getting a real-time backup of your MariaDB data. See how easy this is to achieve. If you plan on setting up a database server using ...

Our final sprint to the finish line stretches over replication: its limitations, high availability and the many improvements since the last version. Over our previous three stages you made it through ...

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 ...

We're also in the starting a website migration from our current colo facility to a cloud provider and want SQL replication to help keep data of new host and old host in sync so that as dns propogates ...

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 ...

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 ...

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, ...