#INSTALL MONGODB CENTOS 6.4 HOW TO#
#INSTALL MONGODB CENTOS 6.4 INSTALL#

=> Replace 192.168.56.121 with your Master MySQL ip address. Mysql -u root -p database-name From Step 7 in Master Server, you will get the details of MASTER_LOG_FILE, MASTER_LOG_POS Step 13: Now restore the dump file in database Step 12: Login to MySQL and create database and exit Step 11: Restart the mysql service in Slave server Step 10: Now edit the my.cnf file and paste below given contents in section Step 9: Login in Slave MySQL server and take the backup of my.cnf file Scp database-name-backup.sql steps in MySQL Slave Server

Scp database-name-backup.sql our scenario: Step 8: Now move you database backup dump file to slave server CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000002', ~]# ~]# head -100 database-name-backup.sql | grep 'MASTER_LOG_POS' Note: You can also get information of MASTER_LOG_FILE,MASTER_LOG_POS from MySQL dump file.Įg. | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Step 7: Now login to Master MySQL server again and run below given commandsīelow Given is my Master Server reference:īy ‘ show master status‘ command we got two values Mysqldump -skip-lock-tables -single-transaction -hex-blob -flush-logs -master-data=2 -u root -p database-name > database-name-backup.sql Mysql > CREATE USER > GRANT REPLICATION SLAVE ON *.* TO IDENTIFIED BY 'password' ĬREATE USER REPLICATION SLAVE ON *.* TO IDENTIFIED BY 'password' Here we are selecting the name replication as MySQL user. Step 5: Login to MySQL Master Server as a root. (Do not write this line,find this section and write below given contents) Replace 192.168.56.121 with your Master Server IP address Note: /var/lib/mysql is bydefault path of MySQL data directory if in your case it is different, give correct path in datadir value (find it in below given contents) In section paste the given below contents. Step 3: Now edit the my.cnf with your favorite editor. Step 2: Take the backup of my.cnf file (If any problem happen while editing you can restore)Ĭp -p /etc/my.cnf /etc/my.cnf.orig.`date +%F` Step 1: Login into your Master Server with user root.

#INSTALL MONGODB CENTOS 6.4 INSTALL#

Yum install mysql mysql-server mysql-develĬonfiguration steps in Master MySQL Server Install the prerequisites in both Master and Slave server by given below command Iptables service was stopped (/etc/init.d/iptables stop) The Slave server is not required to be connected always with Master Server, once slave server is up and when you start the slave thread(START SLAVE command) it will again take all the replicated updates automatically.įirst of all lets see the given below details which is important.

#INSTALL MONGODB CENTOS 6.4 HOW TO#

In this tutorial we will learn about how to setup MySQL Master Slave replication in CentOS 6.4.In Master-Slave replication one database server (Master) can replicate the databases to one or more MySQL database Server(slave).

Install mongodb centos 6.4