Users Guide

MySQL Replication | Database Management

156 OMNM 6.5.3 Installation Guide

still on master mysql server, grand privileges for created user:

mysql>GRANT ALL PRIVILEGES ON *.* TO 'repluser'@'10.35.35.170';

mysql>GRANT ALL PRIVILEGES ON *.* TO 'repluser'@'10.35.35.174';

on master mysql server (10.35.35.170) grant user permissions for replication:

mysql> GRANT REPLICATION SLAVE ON *.* TO 'repluser'@'10.35.35.170';

stop adding more information into master database by executing following on master database:

mysql>FLUSH TABLES WITH READ LOCK;

Copy databases to slave

backup databases in oware prompt on master (10.35.35.170)

mysqldump -a -u root --password=dorado --routines owbusdb > owbusdb.mysql

mysqldump -a -u root --password=dorado owmetadb > owmetadb.mysql

mysqldump -a -u root --password=dorado lportal > lportal.mysql

move *.mysql files to slave

on slave (10.35.35.174) in oware prompt execute following commands

mysqladmin -u root --password=dorado drop owmetadb

mysqladmin -u root --password=dorado drop owbusdb

mysqladmin -u root --password=dorado drop lportal

mysqladmin -u root --password=dorado create owmetadb

mysqladmin -u root --password=dorado create owbusdb

mysqladmin -u root --password=dorado create lportal

mysql -u root --password=dorado owmetadb < owmetadb.mysql

mysql -u root --password=dorado owbusdb < owbusdb.mysql

mysql -u root --password=dorado lportal < lportal.mysql

To obtain master file position which is required to know, execute following command on master

mysql, (in this example it is 73):

mysql>show master status;

+----------------------+------------+-------------------+-----------------------+

+-----------------------+-----------+-------------------+-----------------------+

| mysql-bin.000001 | 73 | | |

+-----------------------+-----------+-------------------+-----------------------+