Репликация master-master

Опубликовано | Автор: mora | 140 комментариев

MASTER1

/etc/mysql/my.cnf

[mysqld] server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
binlog_do_db = master_master
bind-address = 192.168.11.10

/etc/mysql/mariadb.conf.d/50-server.cnf

адрес поставить норм

mysql

create database master_master;

create user ‘replicator’@’%’ identified by ‘password’;

grant replication slave on *.* to ‘replicator’@’%’;

show master status ; отсюда брать данные для второго сервера

после полной настройки master2

CHANGE MASTER TO MASTER_HOST = ‘192.168.11.20’, MASTER_USER = ‘replicator’, MASTER_PASSWORD = ‘password’, MASTER_LOG_FILE = ‘mysql-bin.000002’, MASTER_LOG_POS = 2658;

start slave;

show slave status ;

MASTER2

/etc/mysql/my.cnf

[mysqld] server-id = 2
log_bin = /var/log/mysql/mysql-bin.log
binlog_do_db = master_master
bind-address = 192.168.11.20

/etc/mysql/mariadb.conf.d/50-server.cnf

адрес поставить норм

mysql

create database master_master;

create user ‘replicator’@’%’ identified by ‘password’;

grant replication slave on *.* to ‘replicator’@’%’;

теперь надо вгрузить дамп базы

CHANGE MASTER TO MASTER_HOST = ‘192.168.11.20’, MASTER_USER = ‘replicator’, MASTER_PASSWORD = ‘password’, MASTER_LOG_FILE = ‘mysql-bin.000002’, MASTER_LOG_POS = 2658;

start slave ;

show master status ; отсюда брать данные для первого сервера

show slave status ;

в принципе при настройке репликации не нужно указывать конкретную базу ( ты ведь собираешься синхронизировать все базы верно?) и проверить работу реплики можно просто создав ещё базу, но если нужно посоздавать таблицы и записи то вот примеры

create table yo (name varchar(20), age int);

insert into yo values(‘mora’,14);

select * from yo;

Рубрика: Useful tricks, Work

140 комментариев на Репликация master-master

  13. One thing I’ve noticed is the fact that there are plenty of myths regarding the lenders intentions whenever talking about foreclosed. One fable in particular is always that the bank desires your house. The bank wants your hard earned dollars, not the house. They want the amount of money they gave you together with interest. Staying away from the bank will simply draw a new foreclosed summary. Thanks for your article.

    Ответить

  14. I have taken notice that in video cameras, exceptional receptors help to {focus|concentrate|maintain focus|target|a**** automatically. Those kind of sensors connected with some cams change in contrast, while others utilize a beam with infra-red (IR) light, especially in low lumination. Higher standards cameras occasionally use a mix of both programs and might have Face Priority AF where the dslr camera can ‘See’ a face as you concentrate only upon that. Many thanks for sharing your opinions on this site.

    Ответить

  16. I’m in awe of the author’s talent to make intricate concepts understandable to readers of all backgrounds. This article is a testament to his expertise and passion to providing useful insights. Thank you, author, for creating such an engaging and illuminating piece. It has been an absolute pleasure to read!

    Ответить

  19. Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point. You obviously know what youre talking about, why throw away your intelligence on just posting videos to your site when you could be giving us something enlightening to read?

    Ответить

  22. affordablecanvaspaintings.com.au is Australia Popular Online 100 percent Handmade Art Store. We deliver Budget Handmade Canvas Paintings, Abstract Art, Oil Paintings, Artwork Sale, Acrylic Wall Art Paintings, Custom Art, Oil Portraits, Pet Paintings, Building Paintings etc. 1000+ Designs To Choose From, Highly Experienced Artists team, Up-to 50 percent OFF SALE and FREE Delivery Australia, Sydney, Melbourne, Brisbane, Adelaide, Hobart and all regional areas. We ship worldwide international locations. Order Online Your Handmade Art Today.

    Ответить

  23. I do agree with all of the ideas you’ve presented in your post. They’re very convincing and will certainly work. Still, the posts are too short for novices. Could you please extend them a little from next time? Thanks for the post.

    Ответить

  28. This is undoubtedly one of the finest articles I’ve read on this topic! The author’s thorough knowledge and zeal for the subject shine through in every paragraph. I’m so appreciative for coming across this piece as it has deepened my knowledge and sparked my curiosity even further. Thank you, author, for investing the time to craft such a remarkable article!

    Ответить

  30. Hey There. I found your blog using msn. This is an extremely well written article. I?ll make sure to bookmark it and come back to read more of your useful information. Thanks for the post. I?ll definitely return.

    Ответить

  51. UpvoteRocket delivers anonymous automated votes to 25+ game server toplists XtremeTop100, GTop100, TopG, MMtop200, RagnaTOP, MuTop100 and more. Undetectable, no bans, no risk. Pay only per successful vote delivered. Launch a campaign in seconds and rank higher today.

    Ответить

  55. Just wish to say your article is as astonishing. The clarity in your post is simply cool and i could assume you are an expert on this subject. Fine with your permission allow me to grab your RSS feed to keep updated with forthcoming post. Thanks a million and please keep up the rewarding work.

    Ответить

  58. Good ? I should certainly pronounce, impressed with your website. I had no trouble navigating through all the tabs as well as related information ended up being truly easy to do to access. I recently found what I hoped for before you know it in the least. Quite unusual. Is likely to appreciate it for those who add forums or something, web site theme . a tones way for your customer to communicate. Excellent task..

    Ответить

  63. Thanks for the several tips contributed on this weblog. I have noticed that many insurance providers offer prospects generous deals if they opt to insure more and more cars with them. A significant number of households own several motor vehicles these days, especially those with mature teenage children still living at home, plus the savings for policies could soon begin. So it pays to look for a bargain.

    Ответить

  64. Thanks for your write-up. One other thing is that if you are advertising your property all on your own, one of the challenges you need to be cognizant of upfront is when to deal with household inspection accounts. As a FSBO seller, the key about successfully transferring your property and also saving money in real estate agent income is knowledge. The more you understand, the better your home sales effort will probably be. One area exactly where this is particularly crucial is inspection reports.

    Ответить

  66. Just want to say your article is as astounding. The clarity on your post is just nice and that i could suppose you’re a professional in this subject. Fine together with your permission let me to grasp your RSS feed to keep updated with approaching post. Thank you a million and please keep up the gratifying work.

    Ответить

  68. Appreciating the hard work you put into your blog and in depth information you offer. It’s nice to come across a blog every once in a while that isn’t the same outdated rehashed information. Great read! I’ve bookmarked your site and I’m adding your RSS feeds to my Google account.

    Ответить

  69. Along with everything which seems to be building within this specific subject matter, many of your opinions are actually quite stimulating. However, I appologize, because I can not subscribe to your entire idea, all be it stimulating none the less. It appears to me that your opinions are actually not entirely validated and in reality you are your self not really fully certain of the assertion. In any case I did enjoy examining it.

    Ответить

  75. Hmm it appears like your site ate my first comment (it was super long) so I guess I’ll just sum it up what I had written and say, I’m thoroughly enjoying your blog. I too am an aspiring blog writer but I’m still new to the whole thing. Do you have any tips and hints for beginner blog writers? I’d certainly appreciate it.

    Ответить

  77. One thing I want to say is car insurance cancellations is a terrifying experience so if you’re doing the proper things as a driver you may not get one. A number of people do obtain the notice that they’ve been officially dropped by their own insurance company they then have to scramble to get added insurance after the cancellation. Low cost auto insurance rates are frequently hard to get from cancellation. Knowing the main reasons pertaining to auto insurance cancellations can help car owners prevent burning off one of the most essential privileges readily available. Thanks for the suggestions shared via your blog.

    Ответить

  79. hey there and thank you for your information ? I have certainly picked up something new from proper here. I did then again expertise a few technical issues the usage of this website, as I skilled to reload the site lots of times prior to I could get it to load correctly. I had been wondering if your web host is OK? Now not that I am complaining, but sluggish loading circumstances times will very frequently impact your placement in google and can damage your high-quality ranking if ads and ***********|advertising|advertising|advertising and *********** with Adwords. Well I?m including this RSS to my email and can glance out for much more of your respective fascinating content. Ensure that you replace this once more soon..

    Ответить

  81. Thanks for your article. Another thing is that being photographer involves not only difficulty in catching award-winning photographs but hardships in acquiring the best video camera suited to your needs and most especially issues in maintaining the quality of your camera. This can be very genuine and apparent for those photography fans that are into capturing the actual nature’s exciting scenes : the mountains, the particular forests, the actual wild or the seas. Visiting these amazing places absolutely requires a digital camera that can live up to the wild’s hard areas.

    Ответить

  85. hello there and thank you for your information ? I?ve definitely picked up anything new from right here. I did however expertise some technical points using this website, since I experienced to reload the web site lots of times previous to I could get it to load properly. I had been wondering if your web hosting is OK? Not that I am complaining, but sluggish loading instances times will very frequently affect your placement in google and can damage your high quality score if advertising and marketing with Adwords. Well I am adding this RSS to my e-mail and could look out for a lot more of your respective fascinating content. Ensure that you update this again soon..

    Ответить

  86. Thanks for revealing your ideas here. The other factor is that every time a problem develops with a personal computer motherboard, individuals should not have some risk associated with repairing the item themselves for if it is not done right it can lead to permanent damage to all the laptop. It is usually safe just to approach the dealer of your laptop for the repair of its motherboard. They’ve technicians who definitely have an expertise in dealing with laptop computer motherboard problems and can make the right diagnosis and perform repairs.

    Ответить

  87. Thanks for your post. I would like to say that the health insurance brokerage also works best for the benefit of the particular coordinators of any group insurance policy. The health agent is given a list of benefits sought by a person or a group coordinator. Such a broker does indeed is try to find individuals or perhaps coordinators that best go with those desires. Then he offers his tips and if the two of you agree, this broker formulates an agreement between the 2 parties.

    Ответить

  88. Hi! I know this is somewhat off topic but I was wondering if you knew where I could locate a captcha plugin for my comment form? I’m using the same blog platform as yours and I’m having trouble finding one? Thanks a lot!

    Ответить

  96. What an informative and meticulously-researched article! The author’s attention to detail and capability to present intricate ideas in a digestible manner is truly admirable. I’m thoroughly captivated by the scope of knowledge showcased in this piece. Thank you, author, for sharing your knowledge with us. This article has been a real game-changer!

    Ответить

  98. This article is a refreshing change! The author’s distinctive perspective and insightful analysis have made this a truly fascinating read. I’m appreciative for the effort she has put into crafting such an enlightening and thought-provoking piece. Thank you, author, for offering your expertise and igniting meaningful discussions through your brilliant writing!

    Ответить

  101. I feel this is among the such a lot vital info for me. And i’m satisfied reading your article. However want to remark on some general issues, The website style is wonderful, the articles is actually great : D. Just right job, cheers

    Ответить

  104. I have realized some important things through your blog post post. One other point I would like to convey is that there are numerous games on the market designed in particular for preschool age kids. They incorporate pattern acceptance, colors, animals, and forms. These generally focus on familiarization in lieu of memorization. This keeps children engaged without feeling like they are learning. Thanks

    Ответить

  105. One thing I’d like to say is that before acquiring more laptop memory, check out the machine within which it is installed. When the machine can be running Windows XP, for instance, the memory threshold is 3.25GB. Applying more than this would easily constitute just a waste. Be sure that one’s mother board can handle an upgrade amount, as well. Good blog post.

    Ответить

  107. Thanks for your handy post. In recent times, I have been able to understand that the particular symptoms of mesothelioma are caused by your build up associated fluid between your lining on the lung and the chest muscles cavity. The sickness may start in the chest region and spread to other body parts. Other symptoms of pleural mesothelioma cancer include weight-loss, severe breathing in trouble, vomiting, difficulty ingesting, and bloating of the face and neck areas. It really should be noted that some people with the disease never experience virtually any serious signs or symptoms at all.

    Ответить

  109. hello there and thanks in your information ? I have certainly picked up something new from proper here. I did alternatively experience several technical issues the use of this website, since I experienced to reload the web site many instances prior to I may get it to load properly. I had been brooding about in case your hosting is OK? No longer that I’m complaining, however slow loading cases instances will very frequently affect your placement in google and could injury your high quality ranking if ads and ***********|advertising|advertising|advertising and *********** with Adwords. Well I am adding this RSS to my email and can look out for much extra of your respective interesting content. Ensure that you update this once more soon..

    Ответить

  111. I have noticed that repairing credit activity should be conducted with techniques. If not, you might find yourself causing harm to your rank. In order to be successful in fixing your credit rating you have to ascertain that from this instant you pay all of your monthly costs promptly in advance of their timetabled date. It is really significant for the reason that by not really accomplishing this, all other actions that you will decide to use to improve your credit position will not be efficient. Thanks for discussing your concepts.

    Ответить

  113. Thanks for your interesting article. One other problem is that mesothelioma is generally attributable to the inhalation of fibres from mesothelioma, which is a extremely dangerous material. It can be commonly found among employees in the construction industry who may have long contact with asbestos. It could be caused by moving into asbestos protected buildings for years of time, Inherited genes plays an important role, and some persons are more vulnerable towards the risk as compared to others.

    Ответить

  115. Appreciating the commitment you put into your site and detailed information you provide. It’s awesome to come across a blog every once in a while that isn’t the same outdated rehashed information. Fantastic read! I’ve bookmarked your site and I’m adding your RSS feeds to my Google account.

    Ответить

  118. Thank you sharing these kinds of wonderful posts. In addition, an excellent travel in addition to medical insurance system can often relieve those issues that come with traveling abroad. Some sort of medical crisis can in the near future become very costly and that’s guaranteed to quickly impose a financial burden on the family finances. Setting up in place the ideal travel insurance package prior to leaving is definitely worth the time and effort. Cheers

    Ответить

  119. Holy cow! I’m in awe of the author’s writing skills and talent to convey complicated concepts in a concise and concise manner. This article is a true gem that merits all the applause it can get. Thank you so much, author, for providing your wisdom and giving us with such a priceless resource. I’m truly thankful!

    Ответить

  120. It’s appropriate time to make a few plans for the future and it is time to be happy. I’ve learn this put up and if I may I desire to counsel you few interesting things or suggestions. Maybe you could write subsequent articles relating to this article. I desire to read more issues approximately it!

    Ответить

  122. I have seen many useful things on your web site about desktops. However, I have got the viewpoint that notebooks are still not nearly powerful sufficiently to be a wise decision if you frequently do projects that require loads of power, like video modifying. But for world wide web surfing, word processing, and many other frequent computer functions they are just great, provided you do not mind the tiny screen size. Thanks for sharing your opinions.

    Ответить

  123. I additionally believe that mesothelioma cancer is a scarce form of cancer that is often found in those people previously subjected to asbestos. Cancerous cellular material form within the mesothelium, which is a shielding lining that covers most of the body’s internal organs. These cells usually form in the lining of the lungs, belly, or the sac which actually encircles one’s heart. Thanks for sharing your ideas.

    Ответить

  128. I have observed that online degree is getting popular because obtaining your degree online has changed into a popular choice for many people. Numerous people have definitely not had an opportunity to attend a regular college or university nevertheless seek the increased earning potential and a better job that a Bachelors Degree affords. Still other folks might have a qualification in one field but would wish to pursue a thing they now have an interest in.

    Ответить

  131. After research a couple of of the weblog posts in your website now, and I really like your method of blogging. I bookmarked it to my bookmark website list and can be checking again soon. Pls try my web site as properly and let me know what you think.

    Ответить

  132. One more thing I would like to express is that rather than trying to match all your online degree programs on days that you finish work (since the majority people are fatigued when they return), try to arrange most of your classes on the weekends and only one or two courses in weekdays, even if it means a little time off your weekend break. This is really good because on the weekends, you will be far more rested along with concentrated with school work. Thx for the different tips I have acquired from your website.

    Ответить

  136. Thanks for your post on this blog site. From my own personal experience, there are occassions when softening way up a photograph may provide the wedding photographer with a little bit of an creative flare. Oftentimes however, this soft clouds isn’t what precisely you had at heart and can frequently spoil an otherwise good picture, especially if you anticipate enlarging it.

    Ответить

  137. What an eye-opening and thoroughly-researched article! The author’s thoroughness and aptitude to present complicated ideas in a comprehensible manner is truly praiseworthy. I’m totally enthralled by the depth of knowledge showcased in this piece. Thank you, author, for providing your expertise with us. This article has been a real game-changer!

    Ответить

  139. Howdy just wanted to give you a quick heads up. The text in your content seem to be running off the screen in Ie. I’m not sure if this is a formatting issue or something to do with internet browser compatibility but I figured I’d post to let you know. The layout look great though! Hope you get the issue resolved soon. Cheers

    Ответить

  140. Greetings from California! I’m bored to tears at work so I decided to browse your blog on my iphone during lunch break. I enjoy the information you provide here and can’t wait to take a look when I get home. I’m surprised at how fast your blog loaded on my cell phone .. I’m not even using WIFI, just 3G .. Anyhow, excellent blog!

    Ответить

Добавить комментарий

Ваш адрес email не будет опубликован. Обязательные поля помечены *