We have a pretty big MariaDB master-slave setup, which is really under heavy load and suddenly one of our slaves stopped purging relay logs! And…
MySQL
systemd service freezes in activating (start-post) status – mysqld or other services
We’ve experienced this with the MySQL server under CentOS 7, but you can have this state with other services! After updating our MySQL we tried…
mysql slave requested master to start replication from position greater than the file size
If you happen to reset your master mysql server without shutting down the mysql process (probably because of your super collocation cut the power!!!) you…
mariadb mysql slave cannot stop and then crashes on start up with segmentation fault or abort
Let’s show you what means “That’s specifics of InnoDB data storage.” Here is the what this specific case will teach you: basic debug with strace…
Speeding up the receiving of mysql binlog when replication is configured
Have you ever set up a mysql replication between two host with more than 100ms latency between. Let’s say one of your server is in…
mysql slave reset and fixing relay log read failure
Suddenly your slave server reset without a clean shutdown and when it came up again you saw the error of this kind: 2016-02-26 10:41:50 876…