MySQL 10
How To Check And Repair MyISAM Tables In MySQL
MySQL tables can become corrupt for a variety for reasons such as incomplete writes, running out of space, the MySQL daemon being killed or crashing, power failures. If MySQL detects a crashed or corrupt table it will need to be repaired before it can be used again. This guide will walk you through detecting crashed […]
How To Reset A MySQL Root Password
MySQL contains it own ‘root’ password independent of the system root password, this is a guide on how to reset the MySQL root password. To reset it you will need root access on the server that has the MySQL instance. The same process applies to percona and mariadb servers as well, the only differences will […]
How To Use Percona Xtrabackup To Create A MySQL Slave
Percona Xtrabackup can be used to create “hot backups” of MySQL servers fairly quickly and can avoid some of the pitfalls of mysqldump. Xtrabackup can be setup to use backup locks instead of read locks which is much less invasive, this is available on innodb tables. MyISAM and other tables will still need to be […]
Galera Cluster MariaDB Configuration On CentOS 7
Galera cluster is a true multi-master MySQL cluster using synchronous replication. It allows for any of the nodes to be used as a master or all of them as well as providing automatic node joining and node removal. The multi-master configuration is very different from the typical master-slave configuration done with MySQL servers and […]
MariaDB 10 Upgrade From MySQL 5.1 on CentOS 6
MariaDB is a fork of MySQL that was created from some of the original developers of mysql after MySQL was purchased by Oracle. Upgrading to MariaDB offers a range of benefits and is a relatively simple upgrade. It has more active development then MySQL currently and is just developed by Oracle support as MySQL is. […]
MySQL Replication Master Slave Setup
MySQL Replication allows you to synchronize slave copies of a MySQL server. You can then use the slave to perform backups and a recovery option if the master should go offline for any reason. MySQL needs to be installed on both servers. Install MySQL on both servers: yum install -y mysql-server mysql-client mysql-devel Edit /etc/my.cnf […]
Disable WordPress Crontab and Run it Manually
By default WordPress runs wp-cron.php every time someone visits your site. This causes increased load on the server each time a page is requested. On low traffic sites this really isnt noticeable but on higher traffic sites this can become problematic and cause increased load and resource consumption on the server. Turn off the WordPress […]
Most Commented