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.
The simplest way to check the size of table is to check it via *nix ‘df’ command. Enter the location of your db, in my case it is ‘/var/db/mysql/admins247’ (‘/var/db/mysql/’ is default for FreeBSD) and perform:
# du -h my_table.ibd
This will show you the ammount of space the table is occupy on your disk. Usually you do … Continue reading Check MySQL table size without shell
Mysql master-slave replication with percona xtrabackup This replication will be seted up with Percona tools and xtrabackup. The replication in MySQL performs via binary logs. Replication is only asynchronous. In version Mysql-5.6 GTID (Global Transaction IDentifier) appeared. In theory replication is the process when master servers sends updates to slave server. Next I’m going to … Continue reading Mysql master-slave replication with percona xtrabackup
OS: FreeBSD Monitoring it the one of the important tools you’d must have running your servers. There are lots of monitoring tools among them zabbix, cacti, munin, etc. I’m going to show you the way you can bootstrap zabbix. The latest version you can find in your ports is 2.0.8. First off all keep your … Continue reading Zabbix 2.0 with zabbix-java-gateway
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