mysql配置主从复制基于GTIDs
用最简单的例子，教你配置基于GTIDs全局事物id的主从配置。mysql从5.7之后，增加了基于全局事务的主从复制，能够省去，log-bin主从复制找坐标的工作。
环境说明
mysql 8.0.12
过程说明
下面是两台新装的mysql启用全局事务id主从复制的过程
1) 启用log-bin,mysql默认是启动的不需要配置
2) master上创建复制用的帐号
3) master/slave启用gtid
4) slave配置master信息
5) slave启动复制
6) 检查配置是否成功
7) 测试效果
master上创建帐号用于复制
create user 'repl'@'%' identified by 'password'; grant replication slave on *.* to 'repl'@'%';
master启用gtid
#/etc/mysql/my.conf server-id=1 gtid_mode=ON enforce-gtid-consistency=true
slave启用gtid
server-id=2 #id不能重复 gtid_mode=ON enforce-gtid-consistency=true
slave配置master信息
change master TO master_host='192.168.50.111', master_port=3307, master_user='repl', master_password='password', master_auto_position=1;
启动slave
start slave
查看slave状态
#Slave_IO_Running/Slave_SQL_Running两个都是yes表示配置成功 show slave status;
测试
在master创建数据库，slave很快同步过来
2023年12月09日 16:31
This is a good influencing take on this specific thought. I am glad you shared your thoughts as well as ideas and I find that i am in agreement. I certainly like the straightforward writing additionally , the work you’ve you spend working on this post. A great many thanks yous for that great work and great luck with your web site, I will be looking forward to new subjects in the future. 玫瑰花
===============
As I web-site possessor I believe the content material here is rattling fantastic , appreciate it for your efforts. You should keep it up forever! Good Luck. rent a car kosovo 開張花籃花牌
================
Hello. i like the way you post on your blog” 訂花推介
================
Very well-done blog. I especially appreciate content that has to do with beauty and fitness, so it’s important to me to see what you have here. Keep it up! facial exercises 網上訂花
2023年12月10日 14:10
Ill come back to check it again, thanks for your post. amazon
2023年12月27日 02:34
As I website possessor I believe the content matter here is rattling wonderful , appreciate it for your efforts. You should keep it up forever! Best of luck. universitas medan
2024年1月11日 18:30
There are various posts out there near this, I do believe taking there reference could experience made this spot or article really informative. That’s not me expression this information is poor quality. Simply I need to pronounce the fact that info provided here was unique, merely rebuild more near complete, supporting to former information will receive been actually good. The points you have touched listed below are really important, thus I’ll spot many of the information here to make this actually best for entirely the newbie’s here. Thank you this info. Actually helpful! Agencja Reklamowa Gdańsk
==============
Nice blog entre. I really have to say, good work. 網上訂花
==============
you employ a excellent weblog here! do you wish to develop invite posts on my weblog? 訂花推介
==============
When I visit this site there’s new things and improved will be able to study from. Haha I’ve experienced your source code too many times to master how you’re doing things so we could wear them my site. Thanks! I can teach you about methods to easy. 開張花籃花牌
==============
An interesting discussion may be worth comment. I do believe that you ought to write much more about this topic, it might certainly be a taboo subject but usually folks are too few to communicate on such topics. Yet another. Cheers 玫瑰花
==============
This is actually interesting, You’re a particularly proficient article author. I’ve registered with your feed additionally expect finding the fabulous write-ups. Furthermore, I’ve shared your internet-site with our social networks. seiko prospex
==============
oh cool, this information is really useful and definately is comment worthy! hehe. I’ll see if I can try to use some of this information for my own blog. Thanks! seiko watch bands
==============
I’m curious to find out what blog platform you are utilizing? I’m experiencing some small security issues with my latest blog and I would like to find something more safe. Do you have any solutions? seiko skx
==============
I just could not leave your web site before suggesting that I actually enjoyed the standard info an individual provide on your visitors? Is gonna be back regularly in order to check up on new posts. seiko 5 sports gmt
==============
The color of your blog is quite great. i would love to have those colors too on my blog.,*:~- 二手電腦
2024年1月30日 00:09
The platform focus is solely on cryptocurrency transactions. This means you have a variety of digital currencies to choose from when it comes to banking. Instead of traditional deposits, the site rewards you with Gold Coins and Stake Cash to enhance your gaming journey. dublinbet
2024年2月16日 06:55
Your blog has the same post as another author but i like your better.*’”,: UAE
=============
When do you think this Real Estate market will go back up? Or is it still too early to tell? We are seeing a lot of housing foreclosures in Winter Springs Florida. What about you? I would love to get your feedback on this. 開張花籃花牌
=============
When visiting blogs, i always look for a very nice content like yours “ 玫瑰花
=============
I am really impressed with your writing abilities neatly as with the layout on your blog. Is that this a paid subject matter or did you modify it your self? Anyway stay up the excellent high quality writing, it is uncommon to see a nice blog like this one today. 訂花
=============
Do you have a spam issue on this website; I also am a blogger, and I was wanting to know your situation; we have created some nice practices and we are looking to trade methods with others, please shoot me an email if interested. 法式花藝
=============
Terrific write-up! Thought about savored the actual scanning. I’m hoping you just read additional by you. There’s no doubt you could have wonderful awareness in addition to ability to see. My corporation is really prompted keeping this particulars. 手機回收
=============
produce,Whitened froth, rather same interest to find area, mild white over a chin, there’s magnificence that the rhythm, and then make a shout might be kinda hot. seiko prospex
=============
Wow, fantastic weblog layout! How lengthy have you been blogging for? you made blogging glance easy. The full glance of your website is excellent, neatly as the content material! seiko watch bands
=============
An impressive share, I just with all this onto a colleague who has been doing little analysis on this. And the man in reality bought me breakfast since I found it for him.. smile. So let me reword that: Thnx for the treat! But yeah Thnkx for spending enough time to debate this, I feel strongly regarding it and really like reading on this topic. If you can, as you become expertise, could you mind updating your blog post with more details? It is highly ideal for me. Huge thumb up in this article! seiko skx
=============
Have you ever considered adding more videos to your blog posts to keep the readers more entertained? I mean I just read through the entire article of yours and it was quite good but since I’m more of a visual learner,I found that to be more helpful well let me know how it turns out! I love what you guys are always up too. Such clever work and reporting! Keep up the great works guys I’ve added you guys to my blogroll. This is a great article thanks for sharing this informative information.. I will visit your blog regularly for some latest post. seiko 5 sports gmt
2024年2月18日 22:22
There is noticeably a lot of money to understand this. I assume you have made particular nice points in functions also. WASTEWATER TREATMENT PLANT MANUFACTURER
=================
Nice post. I find out some thing much harder on distinct blogs everyday. Most commonly it is stimulating to learn content off their writers and practice a specific thing from their store. I’d opt to apply certain together with the content in my weblog whether or not you don’t mind. Natually I’ll provide link with your web blog. Thank you sharing. WATER TREATMENT PLANT MANUFACTURER
2024年3月12日 21:19
Transactions using cryptocurrencies are the only emphasis of the platform. This implies that when it comes to banking, you have a range of digital currencies to select from.
captain salary in merchant navy2024年3月20日 19:20
There are a couple of fascinating points soon enough here but I don’t know if these people center to heart. There’s some validity but I am going to take hold opinion until I consider it further. Very good write-up , thanks and now we want more! Added onto FeedBurner too Download WordPress
2024年3月22日 02:04
This is really interesting, You are a very skilled blogger. I’ve joined your rss feed and look forward to seeking more of your magnificent post. Also, I’ve shared your site in my social networks! 開張花籃花牌
======================
This web-site is often a walk-through its the data you wanted concerning this and didn’t know who to inquire about. Glimpse here, and you’ll undoubtedly discover it. 玫瑰花
======================
Your blog never ceases to amaze me, it is very well written and organized.”\"*”- 訂花
======================
It’s always good to see it from a different perspective My experience confirms that. I have to think about it some more. Can you expand on this? 法式花藝
======================
Thanks for another informative blog. The place else may I get that type of information written in such an ideal approach? I’ve a project that I’m simply now running on, and I’ve been on the look out for such info. iphone trade in
======================
Your understanding definitely fills a necessity. I’ve been wanting to locate this type of article and you truly came through. Can you believe that that which you have written just about accurately duplicates my own experience. seiko prospex
======================
This is the fitting weblog for anybody who desires to seek out out about this topic. You notice a lot its virtually arduous to argue with you (not that I really would want…HaHa). You undoubtedly put a new spin on a subject thats been written about for years. Nice stuff, just great! seiko watch bands
======================
The the next occasion Someone said a blog, I hope who’s doesnt disappoint me approximately this place. After all, It was my substitute for read, but I just thought youd have some thing interesting to convey. All I hear can be a handful of whining about something that you could fix when you werent too busy searching for attention. seiko skx
======================
There are a couple of interesting points soon enough in this post but I don’t know if I see these people center to heart. You can find some validity but I’ll take hold opinion until I consider it further. Good post , thanks and we want much more! Combined with FeedBurner also seiko 5 sports gmt
2024年3月28日 19:54
I am thankful that I discovered this web blog , just the right information that I was searching for! .Typically, Apple announces a press event about a week in advance, and products tend to ship within a couple days to a couple weeks of that event. Tech
==================
Can I simply say what a relief to seek out somebody who actually knows what theyre speaking about on the internet. You definitely know tips on how to deliver a problem to gentle and make it important. Extra people must learn this and understand this facet of the story. I cant consider youre no more in style since you undoubtedly have the gift. Tech
2024年3月31日 04:30
Hello! I could have sworn I’ve been to this blog before but after checking through some of the post I realized it’s new to me. Anyways, I’m definitely delighted I found it and I’ll be bookmarking and checking back often! Black dollar cleaning chemical in UAE and all over the world
====================
Simply to follow up on the up-date of this topic on your web site and would really want to let you know how much I loved the time you took to write this beneficial post. Within the post, you actually spoke regarding how to actually handle this issue with all convenience. It would be my personal pleasure to collect some more concepts from your web-site and come as much as offer other folks what I learned from you. Many thanks for your usual terrific effort. najlepszy klub piłkarski
2024年4月12日 23:58
Did you publish this particular report by yourself? ? ? Yep Marketing Agency
2024年4月27日 05:39
Thanks a large amount just for this particular information. I clearly cherished reading it and have to share it with my local freinds. 法式花藝
===============
Wow, suprisingly I never knew this. I have been reading your blog alot over the past few days and it has earned a place in my bookmarks. 訂花
===============
I am not really good with English but I find this rattling easygoing to read . 玫瑰花
===============
I cant wait to read far more from you. This is really a tremendous web site. 開張花籃花牌
2024年5月06日 18:33
Nice post. I find out some thing tougher on various blogs everyday. Most commonly it is stimulating to learn to read content from other writers and exercise a specific thing at their store. I’d would prefer to apply certain while using the content on my own blog whether or not you don’t mind. Natually I’ll supply you with a link on your own internet blog. Thank you for sharing. Najlpeszy ośrodek terapii
===================
I just wanted to thank you again for this amazing site you have built here. Its full of useful tips for those who are definitely interested in this subject, especially this very post. Your all so sweet and also thoughtful of others and reading the blog posts is a good delight to me. And thats a generous surprise! Jeff and I are going to have excitement making use of your points in what we must do in the near future. Our listing is a distance long and tips is going to be put to fine use. Prishtina Reisen Pozyczki dla Polaków w Norwegii
===================
Enjoyed reading this, very good stuff, thankyou . Lechia Gdańsk
2024年5月09日 02:23
Thank you, I’ve just been searching for information about this topic for a while and yours is the greatest I’ve discovered till now. But, what in regards to the conclusion? Are you sure concerning the supply? AVデータベース
2024年5月15日 20:36
Bloghopping is really my forte and i like to visit blogs. 슬롯커뮤니티
2024年5月17日 15:49
I agree with your thoughts here and I really love your blog! I’ve bookmarked it so that I can come back & read more in the future. 魔術課程
===============
hey there i stumbled upon your site searching around the web. I wanted to tell you I enjoy the look of things around here. Keep it up will bookmark for sure. 魔術
===============
I definitely did not understand that. Learnt one thing new today! Thanks for that. 魔術教學
===============
There are some fascinating points in time in this posting but I don’t determine if them all center to heart. There is certainly some validity but I’m going to take hold opinion until I look into it further. Very good post , thanks and now we want far more! Included with FeedBurner at the same time 魔術表演
===============
I’m keen on this post, enjoyed this one thank you posting . iphone回收
===============
Good day very cool web site!! Man .. Excellent .. Superb .. I’ll bookmark your web site and take the feeds additionally…I am glad to find a lot of useful information right here in the put up, we want develop more strategies in this regard, thanks for sharing. . . . . . iphone回收價
===============
I just now learned your site a couple weeks ago so i are looking at it also on a daily basis. There is a massive amount information at this site and i relish your personal style belonging to the world-wide-web site very. Continue the high quality hard work! 二手電腦回收
==============
i haven’t been on the silicon valley but i would really love to visit that place. i bet that it is a very exciting place to visit. seiko prospex
==============
being an entrepreneur opened up lots of business leads on my line of work, i like to make money both online and offline,, rubber strap
==============
It’s excellent page, I was looking for something like this seiko 5 sports gmt
==============
Superb post but I was wanting to know if you could write a litte more on this subject? I’d be very thankful if you could elaborate a little bit further. Many thanks! 62mas
2024年5月21日 03:53
This web page is usually a walk-through you discover the information it suited you relating to this and didn’t know who to ask. Glimpse here, and you’ll undoubtedly discover it. エロ動画保存
=============
you have a very wonderful weblog here! do you wish to make some invite posts on my blog? AV監督データベース
=============
I am always thought about this, thankyou for putting up. AVメーカー一覧
2024年5月25日 00:59
Aw, this has been quite a good post. In idea I must put in writing such as this additionally – spending time and actual effort to manufacture a excellent article… but exactly what can I say… I procrastinate alot by no indicates manage to get something carried out. 바카라 사이트
2024年5月26日 09:39
I think you have remarked some very interesting points , regards for the post. 訂花
=============
There is noticeably big money to learn about this. I assume you have made certain nice points in functions also. 線上花店
=============
The tips you provided here are very valuable. It absolutely was such an exciting surprise to get that waiting for me immediately i woke up this very day. They are often to the point and straightforward to understand. Warm regards for the clever ideas you have shared above. 開張花籃花牌
=============
Thanks for any other informative blog. Where else may I am getting that kind of info written in such an ideal method? I have a project that I am simply now running on, and I’ve been on the glance out for such information. rentacarkosova 情人節
2024年6月03日 00:49
Presently the grade of our very own bordering is now a vital condition. The complete community human population shall be rising hence swiftly the planet is now also congested. Tip de redactie
2024年6月13日 23:48
I like the way you conduct your posts. Brabant Vandaag
2024年6月17日 21:02
Only a few blogger would discuss this topic the way you do. Tilburg
2024年6月19日 13:29
It’s difficult to acquire knowledgeable folks during this topic, but the truth is could be seen as guess what happens you are referring to! Thanks 訂花
==============
Hi there, Might I export your own photograph and use it on my own webpage? 線上花店
==============
Thank you for the good writeup. It in fact was a amusement account it. Look advanced to more added agreeable from you! However, how can we communicate? 開張花籃花牌
==============
evening dresses should always be classy, simple but elegant. you don’t need to invest several hundred bucks on a classy evening dress:: 情人節
2024年6月25日 12:34
It’s in point of fact a nice and helpful piece of information. I am satisfied that you shared this useful info with us. Please stay us informed like this. Thanks for sharing. av4dex
2024年6月26日 03:18
Real informative and excellent anatomical structure of content material , now that’s user pleasant (:. AV女優一覧
===============
This web page does not show up appropriately on my blackberry – you may want to try and repair that AV単体作品一覧
===============
what i can say is that abortion is a sin and it should be deemed illegal by all means’ 熟女動画一覧
===============
I simply could not go away your web site prior to suggesting that I really enjoyed the standard information a person supply on your guests? Is going to be back steadily to inspect new posts Rent a car kosova 魔術課程
===============
Thanks for the great post on your blog, it really gives me an insight on this topic.~.;-; 魔術
===============
Several years of in depth study along with advancement triggered by far the most outstanding headset loudspeaker actually developed. Bests capabilities extremely superior supplies in addition to building to supply a new higher level of audio reliability as well as quality. Combining extra-large audio motorists plus a high-power digital camera amp, Is better than gives a good unprecedented combination of super heavy bass sounds, easy undistorted highs, and really clear vocals in no way noticed just before from headset. 魔術教學
===============
This is a great website, would you be involved in doing an interview about just how you created it? If so e-mail me! 魔術表演
2024年7月01日 03:35
Have you consider starting an monthly news letter. It would take your site to its potential. Weer Vandaag
=============
When I originally commented I clicked the -Notify me when new surveys are added- checkbox and after this whenever a comment is added I purchase four emails with the exact same comment. Could there be in whatever way you possibly can remove me from that service? Thanks! 62mas
=============
It¡¦s in reality a great and useful piece of information. I¡¦m glad that you simply shared this useful info with us. Please stay us up to date like this. Thank you for sharing. rent a car pristina seiko 5 sports
=============
I discovered your blog web site on google and appearance a couple of your early posts. Always keep in the very good operate. I recently extra up your Feed to my MSN News Reader. Looking for toward reading a lot more by you at a later date!… rubber strap
=============
Hello! I would want to offer a enormous thumbs up to the great info you might have here with this post. We are returning to your site for additional soon. seiko prospex
=============
Oh my goodness! a great post dude. Thanks a ton Nevertheless I’m experiencing trouble with ur rss . Do not know why Struggle to enroll in it. Could there be any person obtaining identical rss dilemma? Anybody who knows kindly respond. Thnkx ipad回收
=============
I truly wanted to develop a brief note to thank you for some of the lovely instructions you are writing here. My rather long internet investigation has finally been recognized with reputable concept to exchange with my companions. I ‘d mention that most of us site visitors are extremely fortunate to dwell in a very good place with so many outstanding individuals with good plans. I feel really grateful to have seen your web site and look forward to tons of more amazing times reading here. Thanks once more for a lot of things. iphone trade in
=============
Comfortabl y, the post is actually the freshest on this precious topic. I concur with your conclusions and also definitely will eagerly look forward to your future updates. Saying thanks definitely will not simply just be acceptable, for the fantastic lucidity in your writing. I definitely will instantly grab your rss feed to stay abreast of any updates. Fabulous work and also much success in your business endeavors! iphone回收
2024年7月15日 00:07
When Apple didn’t make computers as well as Local cafe did not help make coffee, how arrive acquired they will become thus prospering? The journey to offer the state-of-the-art and most interesting goods, even though intoxicating, is often a fairly packed location. If possible, Apple and Starbucks built their own niche. shoes
2024年7月18日 01:55
I love blogging and i can say that you also love blogging.’,\':* john spencer ellis pictures
================
How long does xanax stay in your system, LOFZVRd. john spencer ellis news
2024年7月23日 22:14
Many thanks for this specific info I had been exploring all Bing to discover it! エロ同人漫画一覧
===============
Just be sure you analyze this great article that relates to your hard work; plus remember that while you are thinking about that it’s many cost-free with the spending. 中出し動画一覧
===============
After study a few of the weblog posts on your web site now, and I actually like your approach of blogging. I bookmarked it to my bookmark web site record and shall be checking back soon. Pls take a look at my web page as nicely and let me know what you think. 巨乳動画一覧
===============
Excellent commentary on that subject. We appreciate your knowledge that you really to leave out with us! 素人動画一覧
===============
This could be considered a time when you find yourself led to new inspiration, or permit all by yourself to sink into religious confusion! 人妻動画一覧
===============
Quite right! It is good idea. It is ready to support you. マニアエロ動画
2024年7月25日 20:14
Some times its a pain in the ass to read what people wrote but this site is really user friendly! 花束課程
=============
The post is absolutely fantastic! Lots of great information and inspiration, both of which we all need! Also like to admire the time and effort you put into your site and detailed info you offer! I will bookmark your blog! 花藝證書
=============
It’s difficult to find knowledgeable folks about this topic, however, you be understood as guess what happens you are referring to! Thanks 插花課程
=============
One Tree Hill should be the best TV series for me, the characters are great~ 插花技巧
2024年7月29日 04:19
Sweet website , super design , very clean and utilise pleasant. drzwi premium
2024年8月02日 02:10
My dear goodness! an amazing article guy. Many thanks Nevertheless I’m going through problem with third really simply syndication . Have no idea exactly why Unable to subscribe to that. Will there be anybody acquiring comparable rss or atom downside? Anyone who knows generously reply. Thnkx African FollTales
2024年10月30日 04:01
I also think thus, perfectly written post! . binary options signals
2024年11月28日 21:56
I have been looking around for an article like this. Took some time but finally found it… Really good read thanks. It’s been difficult to find the information I needed. I use this website for a good deal. Cutting-Edge Tech Innovations
2024年11月28日 21:56
I together with my buddies were found to be analyzing the great key points from your website while suddenly got a horrible suspicion I had not thanked the blog owner for those secrets. These boys were definitely consequently happy to read through all of them and have in effect extremely been using these things. Appreciate your really being well accommodating and then for obtaining such terrific useful guides most people are really wanting to learn about. Our own sincere regret for not saying thanks to you sooner. binary options trading
2024年12月15日 22:55
guess what? I like what you wrote, added you to my FeeBurner. binary options signals
2024年12月16日 20:15
I got too much interesting stuff on your blog. I guess I am not the only one having all the enjoyment here! Keep up the good work. affiliate program
2024年12月18日 15:47
I have been meaning to read this and just never obtained a chance. It’s an issue that I’m really interested in, I just started reading and I’m glad I did. You’re a fantastic blogger, one of the best that I’ve seen. This weblog undoubtedly has some facts on topic that I just wasn’t aware of. Thanks for bringing this stuff to light. trading bots
2024年12月31日 21:29
I do not even know the way I stopped up right here, however I thought this put up was good. I don’t understand who you’re but certainly you are going to a famous blogger when you are not already Cheers! trade cryptocurrencies
2025年1月08日 21:04
Strong blog. I acquired several nice info. I?ve been keeping a watch on this technology for a few time. It?utes attention-grabbing the method it retains totally different, however many of the primary components remain a similar. have you observed a lot change since Search engines created their own latest purchase in the field? technical analysis
2025年1月13日 19:33
Thanks for the blog post buddy! Keep them coming... ruby woo mac
2025年1月18日 16:13
usually, the best sounding ringtones are coming from paid ringtone donwload sites“ vfxAlert PRO activation