Jump to content
Main menu
Main menu
move to sidebar
hide
Navigation
Main page
Recent changes
Random page
Help about MediaWiki
TetraWiki
Search
Search
Appearance
Create account
Log in
Personal tools
Create account
Log in
Pages for logged out editors
learn more
Contributions
Talk
Editing
Radico-Sitapur-Master-Slave Replication
(section)
Page
Discussion
English
Read
Edit
View history
Tools
Tools
move to sidebar
hide
Actions
Read
Edit
View history
General
What links here
Related changes
Special pages
Page information
Appearance
move to sidebar
hide
Warning:
You are not logged in. Your IP address will be publicly visible if you make any edits. If you
log in
or
create an account
, your edits will be attributed to your username, along with other benefits.
Anti-spam check. Do
not
fill this in!
==Configuration on slave server== vi /etc/my.cnf #slave server bind-address = 172.18.40.212 server-id = 2 log_bin = mysql-bin binlog_format = row gtid-mode=ON enforce-gtid-consistency log-slave-updates default_authentication_plugin=mysql_native_password Save the file :wq! ##login into mysql and run the below commands Stop slave; mysql -> CHANGE MASTER TO -> MASTER_HOST='172.18.40.211' , -> MASTER_USER='repl_user' , -> MASTER_PASSWORD='Pass@1234' , -> MASTER_LOG_FILE='mysql-bin.000012' , -> MASTER_LOG_POS=418; start slave; mysql> show slave status\G Slave_IO_State: Waiting for source to send event Master_Host: 172.18.40.211 Master_User: repl_user Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000012 Read_Master_Log_Pos: 418 Relay_Log_File: TNTSERVER2-relay-bin.000040 Relay_Log_Pos: 587 Relay_Master_Log_File: mysql-bin.000012 Slave_IO_Running: Yes Slave_SQL_Running: Yes '''Note:Slave_IO_Running and Slave_SQL_Running should show Yes Status '''
Summary:
Please note that all contributions to TetraWiki may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see
TetraWiki:Copyrights
for details).
Do not submit copyrighted work without permission!
Cancel
Editing help
(opens in new window)