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.

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.

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

A quick, step-by-step guide to setting up, configuring, and managing a MySQL database server on Windows, Linux, and macOS.

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. Inside the /etc/sysconfig ...

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

Verifying the data is as simple as this: mysql -u root -p -t < test_employees_sha.sql With the test database servers set up, I then created a fourth virtual machine with a base Ubuntu Server install ...