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

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

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

62 комментария на Репликация 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..

    Ответить

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

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