Mariadb Replication Quick Setup using GTID


On Slave

CHANGE MASTER '{replica_connection_name}' TO MASTER_HOST='{10.8.0.2}',MASTER_USER='{replicauser}',MASTER_PASSWORD='{replicauser_pass}',MASTER_USE_GTID=current_pos

On Master

mysqldump -uroot -p --master-data --gtid tablename > tablename.sql


On Slave

mysql -uroot -p tablename < tablename.sql

Mariadb Replication Quick Setup using GTID was originally published on Thwin.Net

Advertisements

About herzcthu

I'm a translator of many cms and blogging software such as WordPress, Joomla. I'm administrator of WordPress Burmese official site. Founder of myanmapress.com

Posted on May 11, 2018, in Uncategorized. Bookmark the permalink. Leave a comment.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: