Skip to content

Supportex.NET blog

Server and network management company

  • supportex.net home
  • MySQL Health Test
Menu

All posts tagged percona

MySQL: checking replication with mk-table-checksum

Posted on September 26, 2011May 10, 2019Author Oleksii TykhonovPosted in mysqlLeave a Reply

Here is a simple way to check if your database on master and slave server have the same data. We will use mk-table-checksum from maatkit tools for this purpose. Note! Never do it on the production server! Or use it on your own risk! As stated: mk-table-checksum executes queries that cause the MySQL server to…

Read

Three ways to make MySQL database dump

Posted on November 25, 2010November 20, 2019Author Oleksii TykhonovPosted in UncategorizedLeave a Reply

Everybody knows – backups are very important. Today a lot of web projects use MySQL to keep data. So you need to know how to set up reliable but simple backup of all your databases. And even if you are only developing you might probably need some tools to make quick dumps and to restore…

Read
Quick MySQL Health Audit

Tags

amqp ansible Apache apt-get awk bash bind CentOS cluster Corosync Debian DNS drbd elasticsearch exclude Fedora firewall go golang innobackupex ipset iptables IPv6 ldap linux logs lsi lspci Lua MaxMind mdadm monitoring Munin mysql mysqldump nagios named ncat nginx niginx openvpn otrs Pacemaker percona perl php phpMyAdmin pika pyenv python python rabbitmq raid redis remote install RRD rrdtool rsync sec Selenium sentry slapd slowlog snmp squid SSH svn swap tips Ubuntu vb-accelerator vBulletin windows Xtrabackup yum

©2025 Supportex.NET blog | Theme by SuperbThemes.Com