Radico-Sitapur-Master-Slave Replication - Revision history

Alok: /* Configuration on slave server */

2022-12-02T12:11:31Z

Configuration on slave server

← Older revision		Revision as of 12:11, 2 December 2022
Line 102:		Line 102:
	Slave_IO_Running: Yes		Slave_IO_Running: Yes
	Slave_SQL_Running: Yes		Slave_SQL_Running: Yes
	'''Note: Slave_IO_Running and Slave_SQL_Running should show Yes Status		'''Note:Slave_IO_Running and Slave_SQL_Running should show Yes Status
	'''		'''

Alok: /* Configuration on slave server */

2022-12-02T12:11:10Z

Configuration on slave server

← Older revision		Revision as of 12:11, 2 December 2022
Line 78:		Line 78:
	enforce-gtid-consistency		enforce-gtid-consistency
	log-slave-updates		log-slave-updates
			default_authentication_plugin=mysql_native_password
			Save the file :wq!
	##login into mysql and run the below commands		##login into mysql and run the below commands
	Stop slave;		Stop slave;

Alok: /* Configuration on master server */

2022-12-02T12:10:32Z

Configuration on master server

← Older revision		Revision as of 12:10, 2 December 2022
Line 48:		Line 48:

	==Configuration on master server==		==Configuration on master server==
			vi /etc/my.cnf
	server-id = 1		server-id = 1
	log_bin = mysql-bin		log_bin = mysql-bin
Line 54:		Line 55:
	enforce-gtid-consistency		enforce-gtid-consistency
	log-slave-updates		log-slave-updates
			default_authentication_plugin=mysql_native_password
			Save the file :wq!
	#Again login into mysql:		#Again login into mysql:
	mysql -u root -pPAss@12345		mysql -u root -pPAss@12345

Alok at 12:05, 2 December 2022

2022-12-02T12:05:35Z

← Older revision		Revision as of 12:05, 2 December 2022
Line 1:		Line 1:
	[[Category:Radico-Master-Slave-Replication ]]		[[Category:Radico-MySQL-Master-Slave-Replication ]]

	==Installation of MySQL community server on both the server==		==Installation of MySQL community server on both the server==

Alok: /* Configuration on master server */

2022-12-02T12:04:45Z

Configuration on master server

← Older revision		Revision as of 12:04, 2 December 2022
Line 58:		Line 58:
	##Check master status:		##Check master status:
	mysql> SHOW MASTER STATUS \G		mysql> SHOW MASTER STATUS \G
	~~******************************************************~~		File: mysql-bin.000012
	File: mysql-bin.000012		Position: 418
	Position: 418
	Binlog_Do_DB:		Binlog_Do_DB:
	Binlog_Ignore_DB:		Binlog_Ignore_DB:
	Executed_Gtid_Set: 380ce9d3-6ee0-11ed-a63d-d4f5ef651a4c:1-16		Executed_Gtid_Set: 380ce9d3-6ee0-11ed-a63d-d4f5ef651a4c:1-16
	1 row in set (0.00 sec)		1 row in set (0.00 sec)

	==Configuration on slave server==		==Configuration on slave server==

Alok: /* Installation of MySQL community server on both the server */

2022-12-02T12:02:06Z

Installation of MySQL community server on both the server

← Older revision		Revision as of 12:02, 2 December 2022
Line 5:		Line 5:
	VPN details		VPN details
	Login URL : https://125.21.90.50:6443/userportal/webpages/myaccount/login.jsp#51349		Login URL : https://125.21.90.50:6443/userportal/webpages/myaccount/login.jsp#51349

	User : tetra		User : tetra
	Pass : Tetra@2211		Pass : Tetra@2211

Alok: /* Installation of MySQL community server on both the server */

2022-12-02T12:01:18Z

Installation of MySQL community server on both the server

← Older revision		Revision as of 12:01, 2 December 2022
Line 2:		Line 2:

	==Installation of MySQL community server on both the server==		==Installation of MySQL community server on both the server==

			VPN details
			Login URL : https://125.21.90.50:6443/userportal/webpages/myaccount/login.jsp#51349

			User : tetra
			Pass : Tetra@2211

			Server DetailsS
			TNT Server1 : 172.18.40.211 (Master Server)
			TNT Server2 : 172.18.40.212 (Slave Server)
			Username:root
			Pass:R@D!C)@a

			Mysql login Details
			username:root
			Pass:Pass@12345

	'''Note: Run this commands as a Root User'''		'''Note: Run this commands as a Root User'''

Alok: /* Configuration on master server */

2022-12-02T11:59:25Z

Configuration on master server

← Older revision		Revision as of 11:59, 2 December 2022
Line 43:		Line 43:
	##Check master status:		##Check master status:
	mysql> SHOW MASTER STATUS \G		mysql> SHOW MASTER STATUS \G
			******************************************************
	************************* ~~1. row~~ *************************
	File: mysql-bin.000012		File: mysql-bin.000012
	Position: 418		Position: 418
Line 52:		Line 51:
	1 row in set (0.00 sec)		1 row in set (0.00 sec)

	~~'''configuration~~ on slave server~~'''~~		==Configuration on slave server==

	vi /etc/my.cnf		vi /etc/my.cnf
	#slave server		#slave server
Line 63:		Line 61:
	enforce-gtid-consistency		enforce-gtid-consistency
	log-slave-updates		log-slave-updates

	##login into mysql and run the below commands		##login into mysql and run the below commands

	Stop slave;		Stop slave;

	mysql -> CHANGE MASTER TO		mysql -> CHANGE MASTER TO
	-> MASTER_HOST='172.18.40.211' ,		-> MASTER_HOST='172.18.40.211' ,
Line 74:		Line 69:
	-> MASTER_LOG_FILE='mysql-bin.000012' ,		-> MASTER_LOG_FILE='mysql-bin.000012' ,
	-> MASTER_LOG_POS=418;		-> MASTER_LOG_POS=418;

	start slave;		start slave;

	mysql> show slave status\G		mysql> show slave status\G
	Slave_IO_State: Waiting for source to send event		Slave_IO_State: Waiting for source to send event
Line 90:		Line 83:
	Slave_IO_Running: Yes		Slave_IO_Running: Yes
	Slave_SQL_Running: Yes		Slave_SQL_Running: Yes


	'''Note: Slave_IO_Running and Slave_SQL_Running should show Yes Status		'''Note: Slave_IO_Running and Slave_SQL_Running should show Yes Status
	'''		'''

			==Not able to login into mysql using mysql -pPass@1234 on both server ('''Error access denied root@loaclhost : (password using: YES))''' so to solve this we followed the method of skip- grant-tables==
			vi /etc/my.cnf
			[mysqld]
			skip-grant-tables
			systemctl restart mysqld
			mysql -u root -p
			##Flush the privileges, which tells the server to refresh the grant tables and apply your changes, with this command:
			FLUSH PRIVILEGES;
			##Set a new password for the account:
			ALTER USER 'root'@'localhost' IDENTIFIED BY 'Pass@12345';
			##Open the my.cnf file you opened in step 1, and remove the line about skip-grant-tables, and save the file.
			##Restart the MySQL server again.
			##Log in to the root account again:
			mysql -u root -pPAss@12345

Alok: /* Installation of MySQL community server on both the server */

2022-12-02T11:57:30Z

Installation of MySQL community server on both the server

@@ Line 29: / Line 29: @@
   ##To check the permission of the user run the below command
    show grants for replica;
-**********************************************************************************
 **************************************************************************************************

Alok: /* Installation of MySQL community server on both the server */

2022-12-02T11:56:42Z

Installation of MySQL community server on both the server

← Older revision		Revision as of 11:56, 2 December 2022
Line 28:		Line 28:
	ALTER USER 'repl_user'@'%' IDENTIFIED WITH mysql_native_password BY 'Pass@1234';		ALTER USER 'repl_user'@'%' IDENTIFIED WITH mysql_native_password BY 'Pass@1234';
	##To check the permission of the user run the below command		##To check the permission of the user run the below command
	show grants for replica; \		show grants for replica;
	**********************************************************************************		**********************************************************************************
	'''Not able to login into mysql using mysql -pPass@1234 on both server (error access denied root@loaclhost : (password using: YES)) so to solve this we followed the method of skip- grant-tables.'''		'''Not able to login into mysql using mysql -pPass@1234 on both server (error access denied root@loaclhost : (password using: YES)) so to solve this we followed the method of skip- grant-tables.'''
Line 46:		Line 46:
	**************************************************************************************************		**************************************************************************************************

	~~'''~~Configuration on master server~~'''~~		==Configuration on master server==

	~~vi /etc/my.cnf~~
	~~##master server~~
	~~bind-address~~ = ~~172.18.40.211~~
	server-id = 1		server-id = 1
	log_bin = mysql-bin		log_bin = mysql-bin
Line 57:		Line 53:
	enforce-gtid-consistency		enforce-gtid-consistency
	log-slave-updates		log-slave-updates

	#Again login into mysql:		#Again login into mysql:
	mysql -u root -pPAss@12345		mysql -u root -pPAss@12345
	##Check master status:		##Check master status:
	mysql> SHOW MASTER STATUS \G		mysql> SHOW MASTER STATUS \G

	************************* 1. row *************************		************************* 1. row *************************
	File: mysql-bin.000012		File: mysql-bin.000012
Line 96:		Line 92:

	mysql> show slave status\G		mysql> show slave status\G
	~~************************* 1. row *************************~~
	Slave_IO_State: Waiting for source to send event		Slave_IO_State: Waiting for source to send event
	Master_Host: 172.18.40.211		Master_Host: 172.18.40.211
Line 111:		Line 106:


	#Note: Slave_IO_Running and Slave_SQL_Running should show Yes Status		'''Note: Slave_IO_Running and Slave_SQL_Running should show Yes Status
			'''