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

Let’s say you have your WordPress server set up (running on IP address 192.168.1.100) to access a MySQL database named wordpressdb on the MySQL server with user wpadmin.

A quick, step-by-step guide to setting up, configuring, and managing a MySQL database server on Windows, Linux, and macOS. Long a staple of open source computing, MySQL serves as the database back end ...

HowtoForge – This tutorial describes how to set up database replication in MySQL using an SSL connection for encryption (to make it impossible for hackers to sniff out passwords and data transferred ...

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

Recently, I had a chance to test the community edition of Zmanda Recovery Manager for MySQL. I was partly testing to make sure it worked with MariaDB, Monty Program's drop-in replacement for MySQL, ...

Amazon Web Services offer new challenges and flexibility for database admins -- here's how to avoid the pitfalls and tune for performance For many MySQL database admins, Amazon Web Services represents ...