Install MySQL 5.7.22 Community edition: #yum install mysql-community-server #yum install perl-DBD-MySQL-4.023-6.el7.x86_64.rpm #yum install percona-release-0.1-4.noarch.rpm Configure multiple instances instance1 and instance2 on the same machine: 01. Backup existing my.cnf file to my.cnf.bkup 02. Edit my.cnf with following [root@server_name]# cat /etc/my.cnf [mysqld@instance1] datadir = /mysql/instance1/data socket = /mysql/instance1/data/instance1.sock port = 3777 server-id = 3777 log-error = /mysql/instance1/data/instance1.err [mysqld@instance2] datadir = /mysql/instance2/data socket = /mysql/instance2/data/instance2.sock port = 3999 server-id = 3999 log-error = /mysql/instance2/data/instance2.err Start mysql instance using system: #systemctl start mysqld@instance1 #systemctl start mysqld@instance2 It will create database files at /mysql/instance1/data/ and /mysql/instance2/data/ Check status: [root@mysqlhost system]# systemctl status mysql...
Welcome to explore technology about Kubernetes, MySQL, Machine Learning | Deep Learning - Shrenik Parekh