The number of servers in our farm is continuing to grow. It’s becoming more and more difficult to monitor them all as closely as we would like. We decided that it’s time to set up as centralized location for log files to keep a closer eye on everything and allow us to easily develop our own reports and triggers against the logs. For this, we will be using rsyslog with a 3rd party program, LogAnalyzer. For the purposes of this document, we will assume that you already have a MySQL database configured running on a separate server.
We recently began using MySQL replication to handle our database backups. The reason we aren’t able to use mysqldump is because of the sheer size of our database. Our database consists of close to 1 million tables. Percona XtraBackup is able to back this up efficiently, but takes quite a while to run and causes a lot of disk io on the production server. The replicated instance resides on a separate physical server in a separate physical location. Everything works perfectly, except one thing… All the data is being transmitted in plain text! This document will walk you through installing SSL support on your server.
There are many reasons why a server admin may want to run multiple instances of MySQL on the same physical server. These could include consolidating physical servers, increasing uptime per product, or to fully utilize existing hardware. In our case, we want to set up a separate MySQL instance to house Zabbix database. Zabbix is an open source systems monitoring platform. We want this database to remain online as much as possible, even when we are performing maintenance to our main MySQL database. Spinning up a separate MySQL instance isn’t difficult at all.