Search Results

MySQL Replication over SSL

##Tutorial for MySQL Replication over SSL (one-way)## ##################################################### ##Check that SSL has been compiled in SSL on both the master and the client: SHOW VARIABLES LIKE ‘have_openssl'; or mysql –ssl –help If it says disabled or yes then its fine.  If it says no then an SSL enabled version of MySQL needs to be installed. […]

Veeam as a vSphere backup solution

I’ve recently had the pleasure of implementing Veeam Backup & Replication v8 as a direct replacement for BackupExec 2012/2014 vRay edition.  BackupExec 2012 was a terrible product, which is such a shame considering how good its Veritas predecessor was.  BackupExec 2014 was just as bad; its low reliability and poor usability create a huge support […]

Gluster active/passive cluster

Gluster is a nice distributed file system which offers some management benefits over block level storage systems like DRBD. By design Gluster works in an active/active cluster configuration, however for applications where millisecond precision data replication is essential, an active/passive configuration is preferable. This is how (based on SLES11 with HAE): usual SLES HA cluster […]

Purge MySQL Binary Logs

If you have binary logging enabled in MySQL, for example if you are using replication, there is a good chance that these binary logs will grown pretty big and fill the disk.  It’s a good idea to set some limits in my.cnf expire-logs-days    = 20 max_binlog_size         = 104857600 If you find the need to purge […]