MySQL Master-Slave replication with SSL

Published on

To protect data while it is transferred throughout the Internet can be done using SSL. For example if you need to replicate mysql data from one datacenter to another. This is the instruction how to setup MySQL master-slave replication with ssl.

tmpfs

Published on

You can easily prolong the life of your HDD putting small, high access files into RAM. FreeBSD:

to mount tmpfs each time your system boots at scheduled reboots add to /etc/crontab:

Debian:

To have it automatically created at start add to /etc/fstab next:

Percona tools for Mysql

Published on

Percona MySQL Toolkit Percona Toolkit for MySQL is a collection of advanced command-line tools created by Percona to perform a variety of MySQL and system tasks that are too difficult or complex to perform manually. These tools are ideal alternatives to private or “one-off” scripts because they are professionally developed, formally tested, and fully documented. … Continue reading Percona tools for Mysql