Running Multiple Instances of MySQL in CentOS/Fedora/RedHat Linux
Running Multiple Instances of MySQL in CentOS/Fedora/RedHat Linux 1. Make sure that you have installed mysql-server in your Linux , If not install it with yum install –y mysql-server 2 . After installing MySQL-Server , Open your terminal and paste as mkdir /var/lib/mysql2 chown -R mysql.mysql /var/lib/mysql2 mkdir /var/log/mysql2 chown -R mysql.mysql /var/log/mysql2 Above code stands for creating two directories for MySQL 2 nd instance , There /var/lib/mysql2 for data directory and /var/log/mysql2 is for log directory. After that changing the owner as mysql for both. 3 . Make a dump of mycnf configuration file with cp -R /etc/my.cnf /etc/my2.cnf Then Open it with nano /etc/my2.cnf (or ) vim /etc/my2.cnf Make the changes as mentioned in the below file. # change/add the following options