mysql compress backup

There are several strategies for backup, snapshot, dump, dump binlog, it all depends on your need and the size of your database. I indicate this tool for databases that have 10G or more than that, the probability that you have problems to restore a backup and long delay, make it unfeasible. I’ll explain a little… Read More »

Reset Your Linux Password In Single Mode

This step will work on especially on CentOS, RedHat, and Fedora. Make sure you didn’t put any password for your GRUB during installation or this tutorial won’t be any help. 1) Turn on the server until the loading screen appears. 2) While on countdown, press any key to cancel the countdown 3) Select your current… Read More »

How to install mytop

Mytop adalah solusi open source yang membantu memantau aktivitas dan kinerja database MySQL. Untuk menginstal Mytop, pastikan bahwa instalasi berada di server yang sama dengan server MySQL. Langkah pertama tambahkan repositori EPEL dengan perintah: yum -y install epel-release Kemudian install mytop dengan perintah: yum -y install mytop Selanjutnya buat file konfigurasi di folder root dengan… Read More »