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

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

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

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

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