Performing a MySQL Upgrade
Performing a MySQL Upgrade Performing a MySQL Upgrade Every time you update your version of MySQL it’s necessary to perform a mysql_upgrade. The reason that this is necessary is so…
Read More
Convert MySQL Slave to Master
Convert MySQL Slave to Master Convert MySQL Slave to Master If you ever have some sort of major failure, or you are just testing your fail over capabilities, you have…
Configure MySQL Multi-Master Replication
Configure MySQL Multi-Master Replication Configure MySQL Multi-Master Replication In this scenario we are configuring mysql master-master replication. The idea behing multimaster is to load-balance MySQL. This configuration will allow read/write…
Connect CentOS to MySQL ODBC
Connect CentOS to MySQL ODBC Connect CentOS to MySQL ODBC There are many uses for this, usually reporting, or some other data manipulation. Let’s get started, login and su to root…
MySQL Replication CentOS All Databases
MySQL Replication CentOS All Databases MySQL Replication CentOS All Databases ** THIS BLOG WORKS ONLY WITH MySQL VERSION 5.1 or EARLIER ** If you’re going to do it, do it…
Openfire Standalone Installation
Openfire Standalone Installation Openfire Standalone Installation An Openfire Standalone installation on MySQL can be tricky the first time, but we will do our best to walk you through it. Once…