MySQL
Notes for MySQL
DB's and Users
Create a DB CREATE DATABASE new_database; Drop a DB DROP DATABASE new_database; Create a new ...
Innodb recovery
What we will need to do for the recovery is to stop mysql and put it in innodb_force_recovery to ...
MySQL Replication
*** TESTED FOR CENTOS 7 *** NEED TO HAVE PORT 3306 OPENED! -- MASTER = 10.1.2.117, SLAVE = 10.1....
DRBD + Pacemaker & Corosync MySQL Cluster Centos7
On Both Nodes Host file vim /etc/hosts 10.1.2.114 db1 db1.localdomain.com10.1.2.115 db2 db...
Reset MySQL root password
Stop MySQL systemctl stop mysqld Set the MySQL environment option systemctl set-environment MY...