4.52 score from hupso.pl for:
dbform.com



HTML Content


Titlechannel [k] | 面朝大海,春暖花开

Length: 23, Words: 2
Description pusty

Length: 0, Words: 0
Keywords pusty
Robots
Charset UTF-8
Og Meta - Title pusty
Og Meta - Description pusty
Og Meta - Site name pusty
Tytuł powinien zawierać pomiędzy 10 a 70 znaków (ze spacjami), a mniej niż 12 słów w długości.
Meta opis powinien zawierać pomiędzy 50 a 160 znaków (łącznie ze spacjami), a mniej niż 24 słów w długości.
Kodowanie znaków powinny być określone , UTF-8 jest chyba najlepszy zestaw znaków, aby przejść z powodu UTF-8 jest bardziej międzynarodowy kodowaniem.
Otwarte obiekty wykresu powinny być obecne w stronie internetowej (więcej informacji na temat protokołu OpenGraph: http://ogp.me/)

SEO Content

Words/Characters 2489
Text/HTML 45.20 %
Headings H1 1
H2 4
H3 6
H4 0
H5 0
H6 0
H1
buy viagra onlineorder levitrachannel [k]
H2
面朝大海,春暖花开
how to set mysql group replication into multi-primary mode
public preview of the next release of sql server for linux
why i returned my purchase of new macbook pro with multi-touch bar
H3
search
tags
enmo tech
links
oracle blogs
meta
H4
H5
H6
strong
b
i
em
Bolds strong 0
b 0
i 0
em 0
Zawartość strony internetowej powinno zawierać więcej niż 250 słów, z stopa tekst / kod jest wyższy niż 20%.
Pozycji używać znaczników (h1, h2, h3, ...), aby określić temat sekcji lub ustępów na stronie, ale zwykle, użyj mniej niż 6 dla każdego tagu pozycje zachować swoją stronę zwięzły.
Styl używać silnych i kursywy znaczniki podkreślić swoje słowa kluczowe swojej stronie, ale nie nadużywać (mniej niż 16 silnych tagi i 16 znaczników kursywy)

Statystyki strony

twitter:title pusty
twitter:description pusty
google+ itemprop=name pusty
Pliki zewnętrzne 20
Pliki CSS 8
Pliki javascript 12
Plik należy zmniejszyć całkowite odwołanie plików (CSS + JavaScript) do 7-8 maksymalnie.

Linki wewnętrzne i zewnętrzne

Linki 173
Linki wewnętrzne 3
Linki zewnętrzne 170
Linki bez atrybutu Title 51
Linki z atrybutem NOFOLLOW 0
Linki - Użyj atrybutu tytuł dla każdego łącza. Nofollow link jest link, który nie pozwala wyszukiwarkom boty zrealizują są odnośniki no follow. Należy zwracać uwagę na ich użytkowania

Linki wewnętrzne

Linki zewnętrzne

buy viagra online http://www.dbform.com/html/tag/macfuse
order levitra http://www.dbform.com/page/58
channel [k] http://www.dbform.com/
generic cialis http://www.dbform.com/page/97
buy cheap levitra http://www.dbform.com/page/90
home http://www.dbform.com/
buy generic viagra http://www.dbform.com/page/59
buy cialis http://www.dbform.com/page/91
database http://www.dbform.com/html/category/oracledb
order viagra online http://www.dbform.com/html/tag/ntpdate
buy cialis http://www.dbform.com/page/117
travel life http://www.dbform.com/html/category/travel
generic cialis http://www.dbform.com/html/tag/browser
buy cialis online http://www.dbform.com/html/tag/pease
about me http://www.dbform.com/about-me
generic cialis http://www.dbform.com/html/tag/pac
generic viagra http://www.dbform.com/page/5
change log http://www.dbform.com/change-log
buy cheap cialis http://www.dbform.com/html/tag/firefox
order viagra http://www.dbform.com/page/20
7zip http://www.dbform.com/html/tag/7zip
order levitra online http://www.dbform.com/page/4
order cialis online http://www.dbform.com/html/tag/asm
acoug http://www.dbform.com/html/tag/acoug
order viagra http://www.dbform.com/html/tag/windowsxp
order viagra online http://www.dbform.com/html/tag/web20
asm http://www.dbform.com/html/tag/asm
buy generic cialis http://www.dbform.com/html/tag/linux
generic cialis http://www.dbform.com/html/tag/rman
bangkok http://www.dbform.com/html/tag/bangkok
order viagra http://www.dbform.com/html/tag/life
buy cialis online http://www.dbform.com/about-me
blog http://www.dbform.com/html/tag/blog
buy cheap levitra http://www.dbform.com/page/30
order cialis online http://www.dbform.com/html/category/db2
dreamhost http://www.dbform.com/html/tag/dreamhost
buy levitra http://www.dbform.com/change-log
buy levitra http://www.dbform.com/page/2
extentions http://www.dbform.com/html/tag/extentions
buy levitra online http://www.dbform.com/html/tag/oracle11gr2
buy cialis online http://www.dbform.com/page/3
firefox http://www.dbform.com/html/tag/firefox
order cialis online http://www.dbform.com/page/10
buy cheap levitra http://www.dbform.com/html/tag/oracle11g
gmail http://www.dbform.com/html/tag/gmail
generic levitra http://www.dbform.com/html/tag/microsoft
buy cheap cialis http://www.dbform.com/html/tag/dul
google http://www.dbform.com/html/tag/google
buy generic cialis http://www.dbform.com/html/tag/oracledb
buy cialis http://www.dbform.com/html/tag/python
life http://www.dbform.com/html/tag/life
buy generic cialis http://www.dbform.com/
linux http://www.dbform.com/html/tag/linux
mac http://www.dbform.com/html/tag/mac
macbook-pro http://www.dbform.com/html/tag/macbook-pro
malaysia http://www.dbform.com/html/tag/malaysia
microsoft http://www.dbform.com/html/tag/microsoft
mv http://www.dbform.com/html/tag/mv
ocm http://www.dbform.com/html/tag/ocm
odi http://www.dbform.com/html/tag/odi
oow http://www.dbform.com/html/tag/oow
oracle-erp http://www.dbform.com/html/tag/oracle-erp
oracle9i http://www.dbform.com/html/tag/oracle9i
oracle10g http://www.dbform.com/html/tag/oracle10g
oracle11g http://www.dbform.com/html/tag/oracle11g
oracle11gr2 http://www.dbform.com/html/tag/oracle11gr2
oracle12c http://www.dbform.com/html/tag/oracle12c
oracle clusterware http://www.dbform.com/html/tag/crs
oracle database http://www.dbform.com/html/tag/oracledb
oracle data integrator http://www.dbform.com/html/tag/oracle-data-integrator
oracle rdbms http://www.dbform.com/html/tag/oracle-rdbms
plugins http://www.dbform.com/html/tag/plugins
rac http://www.dbform.com/html/tag/rac
rman http://www.dbform.com/html/tag/rman
security http://www.dbform.com/html/tag/security
ubuntu http://www.dbform.com/html/tag/ubuntu
us trip http://www.dbform.com/html/tag/us-trip
vmware http://www.dbform.com/html/tag/vmware
web2.0 http://www.dbform.com/html/tag/web20
windowsxp http://www.dbform.com/html/tag/windowsxp
wordpress http://www.dbform.com/html/tag/wordpress
writely http://www.dbform.com/html/tag/writely
招聘 http://www.dbform.com/html/tag/%e6%8b%9b%e8%81%98
紫光拼音 http://www.dbform.com/html/tag/%e7%b4%ab%e5%85%89%e6%8b%bc%e9%9f%b3
青海 http://www.dbform.com/html/tag/%e9%9d%92%e6%b5%b7
魔兽世界 http://www.dbform.com/html/tag/%e9%ad%94%e5%85%bd%e4%b8%96%e7%95%8c
eygle http://www.eygle.com
老熊 http://www.laoxiong.net
老杨 http://yangtingkun.net/
hongyedba http://www/hongyedba.cn
secooler http://www.secooler.me
xiaoyu http://www.dbaxiaoyu.com
youdi http://www.iyoudi.net
我的原创技术文章 http://www.dbform.com/html/2005/7.html
云和恩墨 http://www.enmotech.com/
askmaclean http://askmaclean.com
fenng http://www.dbanotes.net
focus on oracle http://dbsnake.com/
hello dba http://www.hellodba.com/
hellodb http://www.hellodb.net/
love wife & love life – roger http://www.killdb.com/
marshall http://ioracle.org
ningoo http://ningoo.net
paulyibinyi http://blog.itpub.net/7199859/
piner的ixdba http://www.ixdba.com/
sparanoid http://sparanoid.com
vmcd.org http://www.vmcd.org/
xifenfei http://www.xifenfei.com/
小羽 http://www.leonahuang.com
张小事儿的幸福生活 http://www.wisky.org
丰丰 http://zhanglejian.wisky.org
asktom http://asktom.oracle.com/
ixora http://www.ixora.com.au/
julian dyke http://juliandyke.com/
kevin closson http://kevinclosson.wordpress.com/
tanel poder http://blog.tanelpoder.com/
log in http://www.dbform.com/wp-login.php
entries rss http://www.dbform.com/feed
comments rss http://www.dbform.com/comments/feed
wordpress.org https://wordpress.org/
how to set mysql group replication into multi-primary mode http://www.dbform.com/html/2017/3659.html
http://www.dbform.com/html/2017/3659.html
kamus http://www.dbform.com/html/author/kamus-2
deploying group replication in single-primary mode https://dev.mysql.com/doc/refman/5.7/en/group-replication-deploying-in-single-primary-mode.html
http://www.addtoany.com/add_to/sina_weibo?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2017%2f3659.html&linkname=how%20to%20set%20mysql%20group%20replication%20into%20multi-primary%20mode
http://www.addtoany.com/add_to/evernote?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2017%2f3659.html&linkname=how%20to%20set%20mysql%20group%20replication%20into%20multi-primary%20mode
http://www.addtoany.com/add_to/linkedin?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2017%2f3659.html&linkname=how%20to%20set%20mysql%20group%20replication%20into%20multi-primary%20mode
http://www.addtoany.com/add_to/facebook?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2017%2f3659.html&linkname=how%20to%20set%20mysql%20group%20replication%20into%20multi-primary%20mode
http://www.addtoany.com/add_to/twitter?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2017%2f3659.html&linkname=how%20to%20set%20mysql%20group%20replication%20into%20multi-primary%20mode
http://www.addtoany.com/add_to/instapaper?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2017%2f3659.html&linkname=how%20to%20set%20mysql%20group%20replication%20into%20multi-primary%20mode
http://www.addtoany.com/add_to/email?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2017%2f3659.html&linkname=how%20to%20set%20mysql%20group%20replication%20into%20multi-primary%20mode
- https://www.addtoany.com/share
public preview of the next release of sql server for linux http://www.dbform.com/html/2016/3646.html
http://www.dbform.com/html/2016/3646.html
kamus http://www.dbform.com/html/author/kamus-2
- http://www.dbform.com/wp-content/uploads/2016/12/sp161205_205405.png
- http://www.dbform.com/wp-content/uploads/2016/12/sp161205_213646.png
- http://www.dbform.com/wp-content/uploads/2016/12/sp161205_222547.png
http://www.addtoany.com/add_to/sina_weibo?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2016%2f3646.html&linkname=public%20preview%20of%20the%20next%20release%20of%20sql%20server%20for%20linux
http://www.addtoany.com/add_to/evernote?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2016%2f3646.html&linkname=public%20preview%20of%20the%20next%20release%20of%20sql%20server%20for%20linux
http://www.addtoany.com/add_to/linkedin?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2016%2f3646.html&linkname=public%20preview%20of%20the%20next%20release%20of%20sql%20server%20for%20linux
http://www.addtoany.com/add_to/facebook?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2016%2f3646.html&linkname=public%20preview%20of%20the%20next%20release%20of%20sql%20server%20for%20linux
http://www.addtoany.com/add_to/twitter?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2016%2f3646.html&linkname=public%20preview%20of%20the%20next%20release%20of%20sql%20server%20for%20linux
http://www.addtoany.com/add_to/instapaper?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2016%2f3646.html&linkname=public%20preview%20of%20the%20next%20release%20of%20sql%20server%20for%20linux
http://www.addtoany.com/add_to/email?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2016%2f3646.html&linkname=public%20preview%20of%20the%20next%20release%20of%20sql%20server%20for%20linux
- https://www.addtoany.com/share
why i returned my purchase of new macbook pro with multi-touch bar http://www.dbform.com/html/2016/3630.html
http://www.dbform.com/html/2016/3630.html
kamus http://www.dbform.com/html/author/kamus-2
- http://www.dbform.com/wp-content/uploads/2016/11/屏幕快照-2016-11-24-上午10.00.06.png
- http://www.dbform.com/wp-content/uploads/2016/11/屏幕快照-2016-11-24-上午9.22.48.png
- http://www.dbform.com/wp-content/uploads/2016/11/屏幕快照-2016-11-24-上午10.03.34.png
- http://www.dbform.com/wp-content/uploads/2016/11/img_0230-2.jpg
- http://www.dbform.com/wp-content/uploads/2016/11/img_0240-2.jpg
http://www.addtoany.com/add_to/sina_weibo?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2016%2f3630.html&linkname=why%20i%20returned%20my%20purchase%20of%20new%20macbook%20pro%20with%20multi-touch%20bar
http://www.addtoany.com/add_to/evernote?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2016%2f3630.html&linkname=why%20i%20returned%20my%20purchase%20of%20new%20macbook%20pro%20with%20multi-touch%20bar
http://www.addtoany.com/add_to/linkedin?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2016%2f3630.html&linkname=why%20i%20returned%20my%20purchase%20of%20new%20macbook%20pro%20with%20multi-touch%20bar
http://www.addtoany.com/add_to/facebook?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2016%2f3630.html&linkname=why%20i%20returned%20my%20purchase%20of%20new%20macbook%20pro%20with%20multi-touch%20bar
http://www.addtoany.com/add_to/twitter?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2016%2f3630.html&linkname=why%20i%20returned%20my%20purchase%20of%20new%20macbook%20pro%20with%20multi-touch%20bar
http://www.addtoany.com/add_to/instapaper?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2016%2f3630.html&linkname=why%20i%20returned%20my%20purchase%20of%20new%20macbook%20pro%20with%20multi-touch%20bar
http://www.addtoany.com/add_to/email?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2016%2f3630.html&linkname=why%20i%20returned%20my%20purchase%20of%20new%20macbook%20pro%20with%20multi-touch%20bar
- https://www.addtoany.com/share
2 http://www.dbform.com/page/2
3 http://www.dbform.com/page/3
4 http://www.dbform.com/page/4
5 http://www.dbform.com/page/5
240 http://www.dbform.com/page/240
http://www.dbform.com/page/2
proudly powered by wordpress http://wordpress.org/
yoarts http://www.yoarts.com/

Zdjęcia

Zdjęcia 12
Zdjęcia bez atrybutu ALT 0
Zdjęcia bez atrybutu TITLE 12
Korzystanie Obraz ALT i TITLE atrybutu dla każdego obrazu.

Zdjęcia bez atrybutu TITLE

http://www.dbform.com/wp-content/plugins/add-to-any/share_save_120_16.png
http://www.dbform.com/wp-content/uploads/2016/12/sp161205_205405-1024x550.png
https://info.microsoft.com/rs/157-gqe-382/images/gartner-op-dbms-mq-2016.png
http://www.dbform.com/wp-content/uploads/2016/12/sp161205_213646-705x1024.png
http://www.dbform.com/wp-content/uploads/2016/12/sp161205_222547-1024x557.png
http://www.dbform.com/wp-content/plugins/add-to-any/share_save_120_16.png
http://www.dbform.com/wp-content/uploads/2016/11/屏幕快照-2016-11-24-上午10.00.06-1024x682.png
http://www.dbform.com/wp-content/uploads/2016/11/屏幕快照-2016-11-24-上午9.22.48-1024x930.png
http://www.dbform.com/wp-content/uploads/2016/11/屏幕快照-2016-11-24-上午10.03.34-1024x491.png
http://www.dbform.com/wp-content/uploads/2016/11/img_0230-2-768x1024.jpg
http://www.dbform.com/wp-content/uploads/2016/11/img_0240-2-1024x768.jpg
http://www.dbform.com/wp-content/plugins/add-to-any/share_save_120_16.png

Zdjęcia bez atrybutu ALT

empty

Ranking:


Alexa Traffic
Daily Global Rank Trend
Daily Reach (Percent)









Majestic SEO











Text on page:

buy viagra onlineorder levitrachannel [k]面朝大海,春暖花开 generic cialisbuy cheap levitrahome buy generic viagrabuy cialisdatabase order viagra onlinebuy cialistravel life generic cialisbuy cialis onlineabout me generic cialisgeneric viagrachange log search search tagsbuy cheap cialisorder viagra7zip order levitra onlineorder cialis onlineacoug order viagraorder viagra onlineasm buy generic cialisgeneric cialisbangkok order viagrabuy cialis onlineblog buy cheap levitraorder cialis onlinedreamhost buy levitrabuy levitraextentions buy levitra onlinebuy cialis onlinefirefox order cialis onlinebuy cheap levitragmail generic levitrabuy cheap cialisgoogle buy generic cialisbuy cialislife buy generic cialislinux mac macbook-pro malaysia microsoft mv ocm odi oow oracle-erp oracle9i oracle10g oracle11g oracle11gr2 oracle12c oracle clusterware oracle database oracle data integrator oracle rdbms plugins rac rman security ubuntu us trip vmware web2.0 windowsxp wordpress writely 招聘 紫光拼音 青海 魔兽世界 enmo tech eygle 老熊 老杨 hongyedba secooler xiaoyu youdi 我的原创技术文章 云和恩墨 links askmaclean fenng focus on oracle hello dba hellodb love wife & love life – roger marshall ningoo paulyibinyi piner的ixdba sparanoid vmcd.org xifenfei 小羽 张小事儿的幸福生活 丰丰 oracle blogs asktom ixora julian dyke kevin closson tanel poder meta log in entries rss comments rss wordpress.org how to set mysql group replication into multi-primary mode march 19, 2017 by kamus·comments off on how to set mysql group replication into multi-primary mode 在mysql 5.7.17版本中发布的mysql group replication(后文简称为mgr)被很多人称为mysql复制方案的正规军,可以一举取代现在的mysql replication,semisynchronous replication,甚至是可以取代之前最成功的mysql集群方案galera。 mgr有两种模式,一种是single-primary,一种是multi-primary,单主或者多主。 在前一种模式single-primary中,无论集群中有多少个节点,只有一个节点允许写入,其它节点都是只读的,这个允许写入的节点被称为主节点,只有当这个主节点出现问题从集群中被踢出,才会在剩余的节点中选举出另外一个节点成为新的主节点,并且将该节点置为可写模式。 这个过程可以通过log清晰地看到。 2017-03-16t02:04:32.689278z 0 [note] plugin group_replication reported: 'getstart group_id 4317e324' 2017-03-16t02:04:33.081743z 0 [note] plugin group_replication reported: 'unsetting super_read_only.' 2017-03-16t02:04:33.081756z 28 [note] plugin group_replication reported: 'a new primary was elected, enabled conflict detection until the new primary applies all relay logs'2017-03-16t02:04:32.689278z 0 [note] plugin group_replication reported: 'getstart group_id 4317e324' 2017-03-16t02:04:33.081743z 0 [note] plugin group_replication reported: 'unsetting super_read_only.' 2017-03-16t02:04:33.081756z 28 [note] plugin group_replication reported: 'a new primary was elected, enabled conflict detection until the new primary applies all relay logs' 而在后一种模式multi-primary中,所有的节点都是主节点,都可以同时被读写,看上去这似乎更好,但是因为多主的复杂性,在功能上如果设置了多主模式,则会有一些使用的限制,比如不支持foreign keys with cascading constraints。 在多主模式下,集群中的节点退出集群,也不再会出现重新选举的动作,因为本来所有的节点都是primary节点。 前面这些并不是本文的重点,实际上在5.7.17的官方文档中有详细地描述如何设置single-primary mgr的方法。 deploying group replication in single-primary mode 但是不确认是什么原因,却没有单独的章节来描述如何设置集群为multi-primary模式。只是在最后语焉不详地提及了一句:multi-primary mode groups (members all configured with group_replication_single_primary_mode=off) 让读者可以知道跟group_replication_single_primary_mode参数有关。虽然确实也就是跟这个参数有关,但是文档写的这样半半拉拉也确实值得吐槽。 以下为设置multi-primary mgr的方法。假设集群之前已经处于single-primary模式。 --group_replication_single_primary_mode=on,表示启动了single-primary模式,那么修改为off就意味着要启动multi-primary模式。 (root@localhost) [(none)]> show variables like 'group_replication_single_primary_mode'; +----------------------------------------------------+-------------------------------------------------+ | variable_name | value | +----------------------------------------------------+-------------------------------------------------+ | group_replication_single_primary_mode | on | +----------------------------------------------------+-------------------------------------------------+ --如果mgr已经启动,则无法动态修改该参数 (root@localhost) [(none)]> set global group_replication_single_primary_mode=off; error 3093 (hy000): cannot change into or from single primary mode while group replication is running. --停止复制 (root@localhost) [(none)]> stop group_replication; query ok, 0 rows affected (8.67 sec) --设置单主模式参数为off (root@localhost) [(none)]> set global group_replication_single_primary_mode=off; query ok, 0 rows affected (0.00 sec) --该参数设置为on,则禁用了在多主模式下一些可能产生未知数据冲突的操作 (root@localhost) [(none)]> set global group_replication_enforce_update_everywhere_checks=on; query ok, 0 rows affected (0.00 sec) --设置为第一个准备启动mgr(bootstrap)的节点 (root@localhost) [(none)]> set global group_replication_bootstrap_group=on; query ok, 0 rows affected (0.00 sec) --启动复制 (root@localhost) [(none)]> start group_replication; query ok, 0 rows affected (1.29 sec) --为了防止后续由于意外再启动另外一个复制组,关闭bootstrap参数 (root@localhost) [(none)]> set global group_replication_bootstrap_group=off; query ok, 0 rows affected (0.00 sec) --此时可以从视图中看到整个集群只有一个节点是online (root@localhost) [(none)]> select * from performance_schema.replication_group_members; +---------------------------+--------------------------------------+-------------+-------------+--------------+ | channel_name | member_id | member_host | member_port | member_state | +---------------------------+--------------------------------------+-------------+-------------+--------------+ | group_replication_applier | 72ad2062-08a3-11e7-a513-5bfce171938d | bogon | 24801 | online | +---------------------------+--------------------------------------+-------------+-------------+--------------+ 1 row in set (0.00 sec)--group_replication_single_primary_mode=on,表示启动了single-primary模式,那么修改为off就意味着要启动multi-primary模式。 (root@localhost) [(none)]> show variables like 'group_replication_single_primary_mode'; +----------------------------------------------------+-------------------------------------------------+ | variable_name | value | +----------------------------------------------------+-------------------------------------------------+ | group_replication_single_primary_mode | on | +----------------------------------------------------+-------------------------------------------------+ --如果mgr已经启动,则无法动态修改该参数 (root@localhost) [(none)]> set global group_replication_single_primary_mode=off; error 3093 (hy000): cannot change into or from single primary mode while group replication is running. --停止复制 (root@localhost) [(none)]> stop group_replication; query ok, 0 rows affected (8.67 sec) --设置单主模式参数为off (root@localhost) [(none)]> set global group_replication_single_primary_mode=off; query ok, 0 rows affected (0.00 sec) --该参数设置为on,则禁用了在多主模式下一些可能产生未知数据冲突的操作 (root@localhost) [(none)]> set global group_replication_enforce_update_everywhere_checks=on; query ok, 0 rows affected (0.00 sec) --设置为第一个准备启动mgr(bootstrap)的节点 (root@localhost) [(none)]> set global group_replication_bootstrap_group=on; query ok, 0 rows affected (0.00 sec) --启动复制 (root@localhost) [(none)]> start group_replication; query ok, 0 rows affected (1.29 sec) --为了防止后续由于意外再启动另外一个复制组,关闭bootstrap参数 (root@localhost) [(none)]> set global group_replication_bootstrap_group=off; query ok, 0 rows affected (0.00 sec) --此时可以从视图中看到整个集群只有一个节点是online (root@localhost) [(none)]> select * from performance_schema.replication_group_members; +---------------------------+--------------------------------------+-------------+-------------+--------------+ | channel_name | member_id | member_host | member_port | member_state | +---------------------------+--------------------------------------+-------------+-------------+--------------+ | group_replication_applier | 72ad2062-08a3-11e7-a513-5bfce171938d | bogon | 24801 | online | +---------------------------+--------------------------------------+-------------+-------------+--------------+ 1 row in set (0.00 sec) 可以加入第二个节点了。 --同样设置单主模式参数为off (root@localhost) [(none)]> set global group_replication_single_primary_mode=off; query ok, 0 rows affected (0.00 sec) --设置update检查参数为on (root@localhost) [(none)]> set global group_replication_enforce_update_everywhere_checks=on; query ok, 0 rows affected (0.00 sec) --启动复制 (root@localhost) [(none)]> start group_replication; query ok, 0 rows affected (5.42 sec) --此时检查视图,可以发现集群中已经存在两个节点 (root@localhost) [(none)]> select * from performance_schema.replication_group_members; +---------------------------+--------------------------------------+-------------+-------------+--------------+ | channel_name | member_id | member_host | member_port | member_state | +---------------------------+--------------------------------------+-------------+-------------+--------------+ | group_replication_applier | 9003e830-08a3-11e7-8ae3-e62d2f6366d2 | bogon | 24802 | online | | group_replication_applier | 96fe2b5a-08a3-11e7-b383-d7f02f17e847 | localhost | 24803 | online | +---------------------------+--------------------------------------+-------------+-------------+--------------+ 2 rows in set (0.00 sec) --group_replication_primary_member值为空,表示启动的是multi-primary mode,否则该参数显示的是单主模式中的primary节点 (root@localhost) [(none)]> select * from performance_schema.global_status where variable_name='group_replication_primary_member'; +----------------------------------+----------------+ | variable_name | variable_value | +----------------------------------+----------------+ | group_replication_primary_member | | +----------------------------------+----------------+ 1 row in set (0.00 sec)--同样设置单主模式参数为off (root@localhost) [(none)]> set global group_replication_single_primary_mode=off; query ok, 0 rows affected (0.00 sec) --设置update检查参数为on (root@localhost) [(none)]> set global group_replication_enforce_update_everywhere_checks=on; query ok, 0 rows affected (0.00 sec) --启动复制 (root@localhost) [(none)]> start group_replication; query ok, 0 rows affected (5.42 sec) --此时检查视图,可以发现集群中已经存在两个节点 (root@localhost) [(none)]> select * from performance_schema.replication_group_members; +---------------------------+--------------------------------------+-------------+-------------+--------------+ | channel_name | member_id | member_host | member_port | member_state | +---------------------------+--------------------------------------+-------------+-------------+--------------+ | group_replication_applier | 9003e830-08a3-11e7-8ae3-e62d2f6366d2 | bogon | 24802 | online | | group_replication_applier | 96fe2b5a-08a3-11e7-b383-d7f02f17e847 | localhost | 24803 | online | +---------------------------+--------------------------------------+-------------+-------------+--------------+ 2 rows in set (0.00 sec) --group_replication_primary_member值为空,表示启动的是multi-primary mode,否则该参数显示的是单主模式中的primary节点 (root@localhost) [(none)]> select * from performance_schema.global_status where variable_name='group_replication_primary_member'; +----------------------------------+----------------+ | variable_name | variable_value | +----------------------------------+----------------+ | group_replication_primary_member | | +----------------------------------+----------------+ 1 row in set (0.00 sec) 同样的方法可以加入第三个节点,在当前版本中mgr最多支持一个集群中拥有9个节点。 如果需要在mysql重启之后这些参数仍然生效,那么需要将这些参数加入到my.cnf文件中,一个典型的配置了mgr的my.cnf如下所示。 [mysqld] # server configuration datadir=/users/kamus/mysql_data/s2 basedir=/usr/local/cellar/mysql/5.7.17 port=24802 socket=/tmp/s2.sock # # replication configuration parameters # server_id=2 gtid_mode=on enforce_gtid_consistency=on master_info_repository=table relay_log_info_repository=table binlog_checksum=none log_slave_updates=on log_bin=binlog binlog_format=row # # group replication configuration # transaction_write_set_extraction=xxhash64 loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" loose-group_replication_start_on_boot=off loose-group_replication_local_address= "127.0.0.1:24902" loose-group_replication_group_seeds= "127.0.0.1:24901,127.0.0.1:24902,127.0.0.1:24903" loose-group_replication_bootstrap_group= off # ## group replication configuration multi-primary mode ## # loose-group_replication_single_primary_mode=off # loose-group_replication_enforce_update_everywhere_checks=on[mysqld] # server configuration datadir=/users/kamus/mysql_data/s2 basedir=/usr/local/cellar/mysql/5.7.17 port=24802 socket=/tmp/s2.sock # # replication configuration parameters # server_id=2 gtid_mode=on enforce_gtid_consistency=on master_info_repository=table relay_log_info_repository=table binlog_checksum=none log_slave_updates=on log_bin=binlog binlog_format=row # # group replication configuration # transaction_write_set_extraction=xxhash64 loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" loose-group_replication_start_on_boot=off loose-group_replication_local_address= "127.0.0.1:24902" loose-group_replication_group_seeds= "127.0.0.1:24901,127.0.0.1:24902,127.0.0.1:24903" loose-group_replication_bootstrap_group= off # ## group replication configuration multi-primary mode ## # loose-group_replication_single_primary_mode=off # loose-group_replication_enforce_update_everywhere_checks=on public preview of the next release of sql server for linux december 5, 2016 by kamus·comments off on public preview of the next release of sql server for linux 当微软宣布即将发布sql server for linux版本的时候,有些人觉得很兴奋,有些人觉得然并卵,但是既然gartner在2016年的数据库管理系统魔力象限图中将微软列在了第一位,超过了一直以来的霸主oracle,那么无论如何这个sql server for linux版本的发布都是值得关注的,微软将这个版本称为sql server vnext on linux。vnext,好直白的期望。 gartner-op-dbms-mq-2016 微软在2016年11月中旬正式发布了sql server for linux的第一个公众预览版,这条产品线将支持所有的企业级linux平台,在第一个预览版中支持red hat enterprise linux 7.2和ubuntu linux 16.04,并且支持在macos和linux中的docker容器,后续还会支持suse linux enterprise server,另外,微软承诺linux上的sql server绝对不会是“sql server lite”这样的阉割版数据库,而会是一个具备sql server 2016完整功能集的真正的企业级数据库,比如 in-memory oltp,还有always-on encryption和row-level security这样的企业级安全功能。在现在的预览版中以下这些功能还不支持,但是后续会逐渐支持。 本文中会对sql server for linux的安装、配置、使用做简单的测试,说实话,如果oracle数据库的安装使用也能这样简单就太好了。 本文使用的测试环境是aws的一个ec2实例,red hat enterprise linux 7.2,整个安装过程,从开始下载一直到数据库启动结束,不超过20分钟,这其中还包括了下载rpm包的15分钟。 第一步:用root用户下载安装镜像库的repo文件 curl https://packages.microsoft.com/config/rhel/7/mssql-server.repo > /etc/yum.repos.d/mssql-server.repocurl https://packages.microsoft.com/config/rhel/7/mssql-server.repo > /etc/yum.repos.d/mssql-server.repo 第二步:通过yum安装 sudo yum install -y mssql-serversudo yum install -y mssql-server 第三步:设置数据库并启动 [11:24:34:794][ec2-user@ip-172-31-11-228 ~]$ sudo /opt/mssql/bin/sqlservr-setup [11:24:34:876]microsoft(r) sql server(r) setup [11:24:34:876] [11:24:34:876]you can abort setup at anytime by pressing ctrl-c. start this program [11:24:34:876]with the --help option for information about running it in unattended [11:24:34:876]mode. [11:24:34:876] [11:24:34:876]the license terms for this product can be downloaded from [11:24:34:877]http://go.microsoft.com/fwlink/?linkid=746388 and found [11:24:34:877]in /usr/share/doc/mssql-server/license.txt. [11:24:34:880] [11:24:45:937]do you accept the license terms? if so, please type "yes": yes [11:24:45:938] [11:24:55:008]please enter a password for the system administrator (sa) account: [11:24:59:810]please confirm the password for the system administrator (sa) account: [11:24:59:810] [11:24:59:811]setting system administrator (sa) account password... [11:25:03:006] [11:25:07:728]do you wish to start the sql server service now? [y/n]: y [11:25:11:927]do you wish to enable sql server to start on boot? [y/n]: y [11:25:12:022]created symlink from /etc/systemd/system/multi-user.target.wants/mssql-server.service to /usr/lib/systemd/system/mssql-server.service. [11:25:12:058]created symlink from /etc/systemd/system/multi-user.target.wants/mssql-server-telemetry.service to /usr/lib/systemd/system/mssql-server-telemetry.service. [11:25:12:087] [11:25:12:088]setup completed successfully.[11:24:34:794][ec2-user@ip-172-31-11-228 ~]$ sudo /opt/mssql/bin/sqlservr-setup [11:24:34:876]microsoft(r) sql server(r) setup [11:24:34:876] [11:24:34:876]you can abort setup at anytime by pressing ctrl-c. start this program [11:24:34:876]with the --help option for information about running it in unattended [11:24:34:876]mode. [11:24:34:876] [11:24:34:876]the license terms for this product can be downloaded from [11:24:34:877]http://go.microsoft.com/fwlink/?linkid=746388 and found [11:24:34:877]in /usr/share/doc/mssql-server/license.txt. [11:24:34:880] [11:24:45:937]do you accept the license terms? if so, please type "yes": yes [11:24:45:938] [11:24:55:008]please enter a password for the system administrator (sa) account: [11:24:59:810]please confirm the password for the system administrator (sa) account: [11:24:59:810] [11:24:59:811]setting system administrator (sa) account password... [11:25:03:006] [11:25:07:728]do you wish to start the sql server service now? [y/n]: y [11:25:11:927]do you wish to enable sql server to start on boot? [y/n]: y [11:25:12:022]created symlink from /etc/systemd/system/multi-user.target.wants/mssql-server.service to /usr/lib/systemd/system/mssql-server.service. [11:25:12:058]created symlink from /etc/systemd/system/multi-user.target.wants/mssql-server-telemetry.service to /usr/lib/systemd/system/mssql-server-telemetry.service. [11:25:12:087] [11:25:12:088]setup completed successfully. that’s it! sql server for linux数据库就安装完毕并正常启动了。 可以通过systemctl来检查mssql-server的服务的启动状态。 [ec2-user@ip-172-31-11-228 ~]$ systemctl status mssql-server ● mssql-server.service - microsoft(r) sql server(r) database engine loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; vendor preset: disabled) active: active (running) since sun 2016-12-04 22:25:08 est; 1min 59s ago main pid: 16558 (sqlservr) cgroup: /system.slice/mssql-server.service ├─16558 /opt/mssql/bin/sqlservr └─16571 /opt/mssql/bin/sqlservr[ec2-user@ip-172-31-11-228 ~]$ systemctl status mssql-server ● mssql-server.service - microsoft(r) sql server(r) database engine loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; vendor preset: disabled) active: active (running) since sun 2016-12-04 22:25:08 est; 1min 59s ago main pid: 16558 (sqlservr) cgroup: /system.slice/mssql-server.service ├─16558 /opt/mssql/bin/sqlservr └─16571 /opt/mssql/bin/sqlservr 安装完毕以后可以通过自带的mssql-conf命令进行一些简单的配置,可配置项不多,主要是监听端口,默认的数据文件所在目录,日志所在目录,备份所在目录等。 [ec2-user@ip-172-31-11-228 ~]$ sudo /opt/mssql/bin/mssql-conf list supported settings using the 'set' option: tcpport defaultbackupdir defaultdumpdir defaultlogdir defaultdatadir for all command line options use -h or --help[ec2-user@ip-172-31-11-228 ~]$ sudo /opt/mssql/bin/mssql-conf list supported settings using the 'set' option: tcpport defaultbackupdir defaultdumpdir defaultlogdir defaultdatadir for all command line options use -h or --help 如果希望在服务器上直接通过sqlcmd命令行登入数据库,还需要额外安装一个mssql-tools的rpm包,这个安装包里包括sqlcmd和bcp(bulk import-export utility)。 第一步:用root用户下载安装mssql-tools的repo文件 curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/msprod.repocurl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/msprod.repo 第二步:通过yum安装 sudo yum install -y mssql-toolssudo yum install -y mssql-tools 然后就可以通过sqlcmd来登入数据库,并使用transact-sql (t-sql)语言来进行各种操作和管理了。我并非专业的sql server dba,只是浅尝辄止而已。登录以后,创建了一个新数据库testdb,然后进入testdb,创建了一张新表inventory,然后在inventory表中插入了2条记录。 [ec2-user@ip-172-31-11-228 ~]$ sqlcmd -s localhost -u sa -p 'password of sa' 1> select name from sys.databases; 2> go name -------------------------------------------------------------------------------------------------------------------------------- master tempdb model msdb (4 rows affected) 1> create database testdb; 2> go 1> select name from sys.databases; 2> go name -------------------------------------------------------------------------------------------------------------------------------- master tempdb model msdb testdb (5 rows affected) 1> use testdb 2> go changed database context to 'testdb'. 1> create table inventory (id int, name nvarchar(50), quantity int); 2> go 1> insert into inventory values (1, 'banana', 150); 2> insert into inventory values (2, 'orange', 154); 3> go (1 rows affected) (1 rows affected) 1> select * from inventory where quantity > 152; 2> go id name quantity ----------- -------------------------------------------------- ----------- 2 orange 154 (1 rows affected)[ec2-user@ip-172-31-11-228 ~]$ sqlcmd -s localhost -u sa -p 'password of sa' 1> select name from sys.databases; 2> go name -------------------------------------------------------------------------------------------------------------------------------- master tempdb model msdb (4 rows affected) 1> create database testdb; 2> go 1> select name from sys.databases; 2> go name -------------------------------------------------------------------------------------------------------------------------------- master tempdb model msdb testdb (5 rows affected) 1> use testdb 2> go changed database context to 'testdb'. 1> create table inventory (id int, name nvarchar(50), quantity int); 2> go 1> insert into inventory values (1, 'banana', 150); 2> insert into inventory values (2, 'orange', 154); 3> go (1 rows affected) (1 rows affected) 1> select * from inventory where quantity > 152; 2> go id name quantity ----------- -------------------------------------------------- ----------- 2 orange 154 (1 rows affected) 除了sqlcmd命令行之外,在windows操作系统下有全套的sql server management studio (ssms) ,可以直接使用这个具有丰富功能的图形化管理工具来直接管理sql server vnext on linux。多说一句,由于是使用1433端口连接服务器上的数据库,因此需要在aws ec2中将该服务器实例所属的security group中的inbound策略中开放tcp 1433端口。 【结论】sql server vnext on linux预览版在安装、操作过程中非常顺畅,在后续有更多功能加入以后,应该是企业级数据库非常优秀的选择。先不说是否会有oracle用户迁移到sql server上,这至少给了现在正在使用sql server的客户们更广阔的选择空间,现在他们运行在windows server上的sql server数据库也可以移植到linux中了,无论如何,这是一个很大的进步,微软这步要是能早一些迈出可能就更好了。 why i returned my purchase of new macbook pro with multi-touch bar november 24, 2016 by kamus·comments off on why i returned my purchase of new macbook pro with multi-touch bar 是的,我把刚刚收到不到一周的新macbook pro退货了,听上去挺不可思议的。同时,我还退掉了刚刚收到的仍未拆封的两根接口线,一根是usb-c转thunderbolt2,一根是usb-c转lightning。实际上为了这台新macbook pro,我还早早地就购买了4个usb-c转usb3.0的转接头,他们由于收到货太久了,没法儿退货。 我拥有苹果刚刚开始使用intel x86芯片做macbook处理器时的第一代macbook,那是2005年时候的事情,然后一直到今年,在10年多的时间里,几乎每一代macbook pro的新品我都拥有,从13寸到15寸,从普通显示屏到retina显示屏,从普通机械硬盘到ssd,从megasafe到megasafe ii,我甚至为家人购买了新的只有一个usb-c接口的macbook,对于其上饱受很多程序员诟病的一代蝶式键盘,我也同样很喜欢。另外我还拥有从iphone4开始的每一代iphone,从第一代ipad开始的每一代ipad(嗯,不包括ipad pro,因为实在找不到购买的理由)。在购买最新的macbook pro with multi-touch bar之前,我在工作和生活中使用的是2015年年初出的那一批13寸顶配macbook pro。 你们一定要说这是在炫耀,实际上我只是想说,我是一个经验丰富的苹果产品使用者,还是一个彻头彻尾纯正的果粉,然而,在收到新macbook pro不到一周后的今天,我退货了。下面是退货的理由,总得给自己一个交代不是吗?在你阅读下面这些牵强附会的理由之前,如果你还在使用macbook air(像我的一个朋友那样),或者你在使用任何一款windows笔记本,那么我仍然强烈建议你购买这一代macbook pro,但是如果你像我一样已经在使用上一款macbook pro,那么建议你可以体会一下。 1. multi-touch bar。 multi-touch bar是这一代macbook pro的最大卖点,也是看发布会时最让人惊艳的功能。 虽然,这一段窄窄的触摸屏,苹果实现的非常不错,它拥有特别合适的位置和形状,显示在其上的各种图标也很优雅。然而除了最右侧的touch id让我们在解锁笔记本的时候感觉到很爽之外,在我使用这台本子的一周内,这条触摸屏仍然很少场景会被使用到。大部分时间,touch bar上都在不停地变换着用苹果内置的中文输入法时出现的备选字,然而谁会不用数字键去选择备选字,而是用手指戳那个触摸屏呢?连盲打都实现不了。不过值得一提的是,聊天时候输入emoji用触控条真的很方便。 找不到能够频繁使用multi-touch bar的场景倒也罢了,由于取代了原本最上面一条的实体按键,还有一些不太方便的场景。 在很多情况下,调节声音和亮度的按钮是龟缩在整个touch bar的右侧的,需要调小音量,ok,你需要点一下音量按钮,然后在变幻出来的进度条上去拖动,这样的拖动让我非常抓狂,因为完全丧失了一下一下按音量键来确认到底哪个音量更合适的控制感。想一下,在只想快进和后退几格的时候,你是会用按键还是会去拖进度条? 在最开始让程序员抓狂的esc键,现在还在,但是变成了虚拟键,虽然这部分是可以盲打的,在这个虚拟esc键的周边敲击都有效,然而对于一个频繁会被使用到的按键,在大多数按键都有实体键反馈的时候,忽然小指触到一个平平的地方,这种需要迅速转换的体验,总让人疑惑是不是点击到了esc。这是一种让人烦躁的感觉。 2. 超大的触控板。 macbook pro原本的触控板已经很大了,还需要更大吗?问题是大了以后会很容易误触啊。因为实际上在你打字的时候,你的两个大拇指甚至是手掌的半坨肉都是很容易会碰到触控板的,这个误触的频率已经到了有时候会让人心里暗骂“我靠”的地步,有些严重。 3. 四个usb-c接口。 即使拥有可以左右开工,找任意舒服的方位充电的好处,忽然间全部变成了usb-c仍然让人有些头痛。megasafe这么优雅的电源接口就这样被丢弃了,着实让人心痛。特别是当我想到以前的各种线缆在很长一段时间里都又要再接一个转接口,这样的处理方案让我很纠结。一点儿也不优雅!也许再等几年,当所有的外接设备(u盘,移动硬盘,鼠标,演讲遥控器,网银u盾)都有了天生usb-c接口,这个问题就不存在了。 4. 电源绕线。 这是最让我沮丧的地方,完全不能理解为什么从新macbook开始,苹果就取消了那么贴心的设计。以后再也不能像下面这样电源和线缆融为一体了。 我甚至能想像出来,不出几周,线缆就会变成这样,这太让人忧伤了。 【结论】新macbook pro仍然是笔记本电脑中最值得购买的机型(没有之一),但是如果你的手头上已经有一款运行状况良好的上一代macbook pro,就像我现在这样,那么值得更新换代的动机则不会那么强烈。 1 2 3 4 5 … 240 proudly powered by wordpress. theme: flat by yoarts.


Here you find all texts from your page as Google (googlebot) and others search engines seen it.

Words density analysis:

Numbers of all words: 1819

One word

Two words phrases

Three words phrases

----------- - 12.31% (224)
sql - 5.28% (96)
group - 4.95% (90)
replication - 4.29% (78)
group_replication - 3.3% (60)
server - 3.13% (57)
primary - 2.8% (51)
set - 2.31% (42)
row - 2.03% (37)
for - 1.98% (36)
mode - 1.87% (34)
localhost - 1.76% (32)
system - 1.7% (31)
rows - 1.65% (30)
[(none)]> - 1.54% (28)
(root@localhost) - 1.54% (28)
affected - 1.54% (28)
single - 1.37% (25)
pro - 1.37% (25)
mssql-server - 1.37% (25)
sec) - 1.32% (24)
off - 1.32% (24)
name - 1.32% (24)
mac - 1.26% (23)
line - 1.15% (21)
log - 1.15% (21)
the - 1.15% (21)
from - 1.1% (20)
rac - 1.1% (20)
macbook - 1.1% (20)
linux - 1.04% (19)
use - 1.04% (19)
data - 1.04% (19)
online - 1.04% (19)
buy - 1.04% (19)
query - 0.99% (18)
(0.00 - 0.99% (18)
cialis - 0.99% (18)
ok, - 0.99% (18)
-------------------------------------------------- - 0.88% (16)
global - 0.88% (16)
service - 0.88% (16)
group_replication_single_primary_mode - 0.88% (16)
oracle - 0.82% (15)
[11:24:34:876] - 0.77% (14)
mysql - 0.77% (14)
start - 0.77% (14)
multi-primary - 0.71% (13)
+---------------------------+--------------------------------------+-------------+-------------+--------------+ - 0.66% (12)
select - 0.66% (12)
database - 0.66% (12)
microsoft - 0.6% (11)
mssql-server.service - 0.55% (10)
yum - 0.55% (10)
all - 0.55% (10)
where - 0.55% (10)
generic - 0.55% (10)
order - 0.55% (10)
inventory - 0.55% (10)
affected) - 0.55% (10)
testdb - 0.55% (10)
you - 0.49% (9)
levitra - 0.49% (9)
[ec2-user@ip-172-31-11-228 - 0.44% (8)
setup - 0.44% (8)
2016 - 0.44% (8)
create - 0.44% (8)
configuration - 0.44% (8)
into - 0.44% (8)
value - 0.44% (8)
password - 0.44% (8)
bar - 0.44% (8)
sudo - 0.44% (8)
viagra - 0.44% (8)
~]$ - 0.44% (8)
2017 - 0.38% (7)
single-primary - 0.38% (7)
rman - 0.38% (7)
with - 0.38% (7)
plugin - 0.38% (7)
group_replication_applier - 0.33% (6)
(sa) - 0.33% (6)
group_replication; - 0.33% (6)
table - 0.33% (6)
administrator - 0.33% (6)
quantity - 0.33% (6)
option - 0.33% (6)
please - 0.33% (6)
multi-touch - 0.33% (6)
running - 0.33% (6)
license - 0.33% (6)
can - 0.33% (6)
master - 0.33% (6)
next - 0.33% (6)
+----------------------------------------------------+-------------------------------------------------+ - 0.33% (6)
group_replication_primary_member - 0.33% (6)
[note] - 0.33% (6)
loaded - 0.33% (6)
reported: - 0.33% (6)
variable_name - 0.33% (6)
enable - 0.33% (6)
+----------------------------------+----------------+ - 0.33% (6)
sqlcmd - 0.33% (6)
/opt/mssql/bin/sqlservr - 0.33% (6)
account - 0.33% (6)
group_replication_single_primary_mode=off; - 0.33% (6)
new - 0.33% (6)
cheap - 0.27% (5)
enter - 0.27% (5)
change - 0.27% (5)
--help - 0.22% (4)
this - 0.22% (4)
member_state - 0.22% (4)
member_port - 0.22% (4)
member_host - 0.22% (4)
install - 0.22% (4)
curl - 0.22% (4)
24802 - 0.22% (4)
bogon - 0.22% (4)
server(r) - 0.22% (4)
vnext - 0.22% (4)
symlink - 0.22% (4)
-------------------------------------------------------------------------------------------------------------------------------- - 0.22% (4)
tempdb - 0.22% (4)
model - 0.22% (4)
sys.databases; - 0.22% (4)
mssql-tools - 0.22% (4)
16558 - 0.22% (4)
enabled - 0.22% (4)
msdb - 0.22% (4)
how - 0.22% (4)
orange - 0.22% (4)
154 - 0.22% (4)
values - 0.22% (4)
insert - 0.22% (4)
comments - 0.22% (4)
dba - 0.22% (4)
member_id - 0.22% (4)
active - 0.22% (4)
--启动复制 - 0.22% (4)
yes - 0.22% (4)
group_replication_enforce_update_everywhere_checks=on; - 0.22% (4)
and - 0.22% (4)
terms - 0.22% (4)
channel_name - 0.22% (4)
performance_schema.replication_group_members; - 0.22% (4)
relay - 0.22% (4)
account: - 0.22% (4)
[11:24:59:810] - 0.22% (4)
[y/n]: - 0.22% (4)
microsoft(r) - 0.22% (4)
status - 0.22% (4)
wish - 0.22% (4)
list - 0.16% (3)
about - 0.16% (3)
enterprise - 0.16% (3)
systemctl - 0.16% (3)
hat - 0.16% (3)
life - 0.16% (3)
security - 0.16% (3)
kamus·comments - 0.16% (3)
onlinebuy - 0.16% (3)
wordpress - 0.16% (3)
cialisbuy - 0.16% (3)
pid: - 0.11% (2)
main - 0.11% (2)
until - 0.11% (2)
cgroup: - 0.11% (2)
(sqlservr) - 0.11% (2)
ago - 0.11% (2)
59s - 0.11% (2)
22:25:08 - 0.11% (2)
est; - 0.11% (2)
1min - 0.11% (2)
/etc/systemd/system/multi-user.target.wants/mssql-server-telemetry.service - 0.11% (2)
/system.slice/mssql-server.service - 0.11% (2)
├─16558 - 0.11% (2)
using - 0.11% (2)
'set' - 0.11% (2)
option: - 0.11% (2)
tcpport - 0.11% (2)
settings - 0.11% (2)
supported - 0.11% (2)
detection - 0.11% (2)
└─16571 - 0.11% (2)
/opt/mssql/bin/mssql-conf - 0.11% (2)
conflict - 0.11% (2)
2016-12-04 - 0.11% (2)
since - 0.11% (2)
--group_replication_single_primary_mode=on,表示启动了single-primary模式,那么修改为off就意味着要启动multi-primary模式。 - 0.11% (2)
- 0.11% (2)
mgr的方法。 - 0.11% (2)
engine - 0.11% (2)
loaded: - 0.11% (2)
show - 0.11% (2)
variables - 0.11% (2)
[11:25:12:088]setup - 0.11% (2)
completed - 0.11% (2)
successfully. - 0.11% (2)
like - 0.11% (2)
logs' - 0.11% (2)
(/usr/lib/systemd/system/mssql-server.service; - 0.11% (2)
applies - 0.11% (2)
defaultbackupdir - 0.11% (2)
(running) - 0.11% (2)
[11:25:12:087] - 0.11% (2)
active: - 0.11% (2)
disabled) - 0.11% (2)
enabled; - 0.11% (2)
/usr/lib/systemd/system/mssql-server-telemetry.service. - 0.11% (2)
vendor - 0.11% (2)
preset: - 0.11% (2)
sun - 0.11% (2)
command - 0.11% (2)
(1, - 0.11% (2)
oracle11g - 0.11% (2)
'banana', - 0.11% (2)
150); - 0.11% (2)
(2, - 0.11% (2)
int); - 0.11% (2)
ubuntu - 0.11% (2)
hello - 0.11% (2)
(id - 0.11% (2)
int, - 0.11% (2)
nvarchar(50), - 0.11% (2)
'orange', - 0.11% (2)
154); - 0.11% (2)
purchase - 0.11% (2)
viagrabuy - 0.11% (2)
onlineorder - 0.11% (2)
wordpress. - 0.11% (2)
returned - 0.11% (2)
why - 0.11% (2)
152; - 0.11% (2)
levitrabuy - 0.11% (2)
search - 0.11% (2)
cialisgeneric - 0.11% (2)
'testdb'. - 0.11% (2)
context - 0.11% (2)
/etc/yum.repos.d/msprod.repo - 0.11% (2)
https://packages.microsoft.com/config/rhel/7/prod.repo - 0.11% (2)
2017-03-16t02:04:33.081756z - 0.11% (2)
super_read_only.' - 0.11% (2)
'password - 0.11% (2)
was - 0.11% (2)
options - 0.11% (2)
defaultlogdir - 0.11% (2)
defaultdatadir - 0.11% (2)
[11:25:12:058]created - 0.11% (2)
elected, - 0.11% (2)
sa' - 0.11% (2)
'unsetting - 0.11% (2)
rss - 0.11% (2)
testdb; - 0.11% (2)
love - 0.11% (2)
changed - 0.11% (2)
在mysql - 0.11% (2)
2017-03-16t02:04:32.689278z - 0.11% (2)
2017-03-16t02:04:33.081743z - 0.11% (2)
4317e324' - 0.11% (2)
group_id - 0.11% (2)
'getstart - 0.11% (2)
defaultdumpdir - 0.11% (2)
/usr/lib/systemd/system/mssql-server.service. - 0.11% (2)
[11:24:34:794][ec2-user@ip-172-31-11-228 - 0.11% (2)
mode,否则该参数显示的是单主模式中的primary节点 - 0.11% (2)
--group_replication_primary_member值为空,表示启动的是multi-primary - 0.11% (2)
/opt/mssql/bin/sqlservr-setup - 0.11% (2)
[11:24:34:876]microsoft(r) - 0.11% (2)
performance_schema.global_status - 0.11% (2)
variable_name='group_replication_primary_member'; - 0.11% (2)
https://packages.microsoft.com/config/rhel/7/mssql-server.repo - 0.11% (2)
[mysqld] - 0.11% (2)
/etc/yum.repos.d/mssql-server.repo - 0.11% (2)
第二步:通过yum安装 - 0.11% (2)
variable_value - 0.11% (2)
24803 - 0.11% (2)
96fe2b5a-08a3-11e7-b383-d7f02f17e847 - 0.11% (2)
(5.42 - 0.11% (2)
ctrl-c. - 0.11% (2)
program - 0.11% (2)
[11:24:34:876]with - 0.11% (2)
--设置update检查参数为on - 0.11% (2)
pressing - 0.11% (2)
anytime - 0.11% (2)
9003e830-08a3-11e7-8ae3-e62d2f6366d2 - 0.11% (2)
[11:24:34:876]you - 0.11% (2)
--此时检查视图,可以发现集群中已经存在两个节点 - 0.11% (2)
abort - 0.11% (2)
datadir=/users/kamus/mysql_data/s2 - 0.11% (2)
basedir=/usr/local/cellar/mysql/5.7.17 - 0.11% (2)
loose-group_replication_start_on_boot=off - 0.11% (2)
loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" - 0.11% (2)
loose-group_replication_local_address= - 0.11% (2)
"127.0.0.1:24902" - 0.11% (2)
loose-group_replication_group_seeds= - 0.11% (2)
transaction_write_set_extraction=xxhash64 - 0.11% (2)
binlog_format=row - 0.11% (2)
relay_log_info_repository=table - 0.11% (2)
binlog_checksum=none - 0.11% (2)
log_slave_updates=on - 0.11% (2)
log_bin=binlog - 0.11% (2)
"127.0.0.1:24901,127.0.0.1:24902,127.0.0.1:24903" - 0.11% (2)
loose-group_replication_bootstrap_group= - 0.11% (2)
server_id=2 - 0.11% (2)
gtid_mode=on - 0.11% (2)
parameters - 0.11% (2)
socket=/tmp/s2.sock - 0.11% (2)
port=24802 - 0.11% (2)
release - 0.11% (2)
enforce_gtid_consistency=on - 0.11% (2)
loose-group_replication_single_primary_mode=off - 0.11% (2)
loose-group_replication_enforce_update_everywhere_checks=on - 0.11% (2)
public - 0.11% (2)
preview - 0.11% (2)
--同样设置单主模式参数为off - 0.11% (2)
information - 0.11% (2)
confirm - 0.11% (2)
[11:24:59:810]please - 0.11% (2)
while - 0.11% (2)
[11:24:59:811]setting - 0.11% (2)
cannot - 0.11% (2)
running. - 0.11% (2)
--停止复制 - 0.11% (2)
--该参数设置为on,则禁用了在多主模式下一些可能产生未知数据冲突的操作 - 0.11% (2)
--设置单主模式参数为off - 0.11% (2)
(8.67 - 0.11% (2)
stop - 0.11% (2)
password... - 0.11% (2)
[11:25:03:006] - 0.11% (2)
boot? - 0.11% (2)
--如果mgr已经启动,则无法动态修改该参数 - 0.11% (2)
[11:25:12:022]created - 0.11% (2)
'group_replication_single_primary_mode'; - 0.11% (2)
/etc/systemd/system/multi-user.target.wants/mssql-server.service - 0.11% (2)
[11:25:11:927]do - 0.11% (2)
error - 0.11% (2)
[11:25:07:728]do - 0.11% (2)
(hy000): - 0.11% (2)
3093 - 0.11% (2)
now? - 0.11% (2)
[11:24:55:008]please - 0.11% (2)
[11:24:45:938] - 0.11% (2)
product - 0.11% (2)
group_replication_bootstrap_group=off; - 0.11% (2)
downloaded - 0.11% (2)
[11:24:34:877]http://go.microsoft.com/fwlink/?linkid=746388 - 0.11% (2)
--为了防止后续由于意外再启动另外一个复制组,关闭bootstrap参数 - 0.11% (2)
--此时可以从视图中看到整个集群只有一个节点是online - 0.11% (2)
[11:24:34:876]the - 0.11% (2)
24801 - 0.11% (2)
72ad2062-08a3-11e7-a513-5bfce171938d - 0.11% (2)
unattended - 0.11% (2)
[11:24:34:876]mode. - 0.11% (2)
found - 0.11% (2)
[11:24:34:877]in - 0.11% (2)
group_replication_bootstrap_group=on; - 0.11% (2)
so, - 0.11% (2)
type - 0.11% (2)
"yes": - 0.11% (2)
--设置为第一个准备启动mgr(bootstrap)的节点 - 0.11% (2)
terms? - 0.11% (2)
accept - 0.11% (2)
/usr/share/doc/mssql-server/license.txt. - 0.11% (2)
[11:24:34:880] - 0.11% (2)
[11:24:45:937]do - 0.11% (2)
(1.29 - 0.11% (2)
master_info_repository=table - 0.11% (2)
rows affected - 1.54% (28)
(root@localhost) [(none)]> - 1.54% (28)
sql server - 1.43% (26)
(0.00 sec) - 0.99% (18)
query ok, - 0.99% (18)
0 rows - 0.99% (18)
set global - 0.77% (14)
macbook pro - 0.77% (14)
[(none)]> set - 0.77% (14)
affected (0.00 - 0.66% (12)
rows affected) - 0.55% (10)
group replication - 0.55% (10)
primary mode - 0.55% (10)
+---------------------------+--------------------------------------+-------------+-------------+--------------+ | - 0.44% (8)
| +---------------------------+--------------------------------------+-------------+-------------+--------------+ - 0.44% (8)
select * - 0.44% (8)
[ec2-user@ip-172-31-11-228 ~]$ - 0.44% (8)
* from - 0.44% (8)
for linux - 0.38% (7)
multi-primary mode - 0.38% (7)
server for - 0.38% (7)
group_replication; query - 0.33% (6)
replication configuration - 0.33% (6)
in set - 0.33% (6)
[(none)]> select - 0.33% (6)
| group_replication_applier - 0.33% (6)
| online - 0.33% (6)
set (0.00 - 0.33% (6)
(1 rows - 0.33% (6)
1> select - 0.33% (6)
(sa) account - 0.33% (6)
group_replication_applier | - 0.33% (6)
plugin group_replication - 0.33% (6)
[note] plugin - 0.33% (6)
affected) 1> - 0.33% (6)
administrator (sa) - 0.33% (6)
online | - 0.33% (6)
multi-touch bar - 0.33% (6)
group_replication reported: - 0.33% (6)
global group_replication_single_primary_mode=off; - 0.33% (6)
system administrator - 0.33% (6)
buy cheap - 0.27% (5)
performance_schema.replication_group_members; +---------------------------+--------------------------------------+-------------+-------------+--------------+ - 0.22% (4)
yum install - 0.22% (4)
sec) --启动复制 - 0.22% (4)
| channel_name - 0.22% (4)
| variable_name - 0.22% (4)
select name - 0.22% (4)
group_replication_enforce_update_everywhere_checks=on; query - 0.22% (4)
master tempdb - 0.22% (4)
model msdb - 0.22% (4)
name -------------------------------------------------------------------------------------------------------------------------------- - 0.22% (4)
| +----------------------------------------------------+-------------------------------------------------+ - 0.22% (4)
from sys.databases; - 0.22% (4)
start group_replication; - 0.22% (4)
+----------------------------------+----------------+ | - 0.22% (4)
setup [11:24:34:876] - 0.22% (4)
sql server(r) - 0.22% (4)
license terms - 0.22% (4)
install -y - 0.22% (4)
sudo yum - 0.22% (4)
~]$ sudo - 0.22% (4)
[y/n]: y - 0.22% (4)
to start - 0.22% (4)
account: [11:24:59:810] - 0.22% (4)
the system - 0.22% (4)
password for - 0.22% (4)
the license - 0.22% (4)
for the - 0.22% (4)
| bogon - 0.22% (4)
| +----------------------------------+----------------+ - 0.22% (4)
| member_state - 0.22% (4)
| member_port - 0.22% (4)
you wish - 0.22% (4)
microsoft(r) sql - 0.22% (4)
# group - 0.22% (4)
(sa) account: - 0.22% (4)
wish to - 0.22% (4)
# server - 0.22% (4)
symlink from - 0.22% (4)
| member_id - 0.22% (4)
| member_host - 0.22% (4)
[(none)]> start - 0.22% (4)
new primary - 0.22% (4)
variable_name | - 0.22% (4)
row in - 0.22% (4)
+----------------------------------------------------+-------------------------------------------------+ | - 0.22% (4)
0 [note] - 0.22% (4)
value | - 0.22% (4)
into inventory - 0.22% (4)
group_replication_single_primary_mode=off; query - 0.22% (4)
global group_replication_enforce_update_everywhere_checks=on; - 0.22% (4)
--启动复制 (root@localhost) - 0.22% (4)
from performance_schema.replication_group_members; - 0.22% (4)
1> create - 0.22% (4)
member_state | - 0.22% (4)
member_host | - 0.22% (4)
bogon | - 0.22% (4)
channel_name | - 0.22% (4)
buy generic - 0.22% (4)
member_id | - 0.22% (4)
member_port | - 0.22% (4)
pro with - 0.16% (3)
generic cialisbuy - 0.16% (3)
kamus·comments off - 0.16% (3)
replication in - 0.16% (3)
vnext on - 0.16% (3)
by kamus·comments - 0.16% (3)
buy levitra - 0.16% (3)
with multi-touch - 0.16% (3)
mysql group - 0.16% (3)
off on - 0.16% (3)
my purchase - 0.11% (2)
i returned - 0.11% (2)
terms? if - 0.11% (2)
you accept - 0.11% (2)
and found - 0.11% (2)
[11:24:34:877]in /usr/share/doc/mssql-server/license.txt. - 0.11% (2)
orange 154 - 0.11% (2)
[11:24:34:880] [11:24:45:937]do - 0.11% (2)
of new - 0.11% (2)
[11:24:55:008]please enter - 0.11% (2)
----------- -------------------------------------------------- - 0.11% (2)
----------- 2 - 0.11% (2)
[11:24:59:810]please confirm - 0.11% (2)
the password - 0.11% (2)
password... [11:25:03:006] - 0.11% (2)
[11:24:59:810] [11:24:59:811]setting - 0.11% (2)
from [11:24:34:877]http://go.microsoft.com/fwlink/?linkid=746388 - 0.11% (2)
[11:25:07:728]do you - 0.11% (2)
type "yes": - 0.11% (2)
start the - 0.11% (2)
yes [11:24:45:938] - 0.11% (2)
name quantity - 0.11% (2)
a password - 0.11% (2)
so, please - 0.11% (2)
[11:24:34:876]with the - 0.11% (2)
[11:25:12:058]created symlink - 0.11% (2)
to /usr/lib/systemd/system/mssql-server.service. - 0.11% (2)
from /etc/systemd/system/multi-user.target.wants/mssql-server.service - 0.11% (2)
from /etc/systemd/system/multi-user.target.wants/mssql-server-telemetry.service - 0.11% (2)
to /usr/lib/systemd/system/mssql-server-telemetry.service. - 0.11% (2)
/opt/mssql/bin/sqlservr-setup [11:24:34:876]microsoft(r) - 0.11% (2)
[11:25:12:087] [11:25:12:088]setup - 0.11% (2)
[11:25:12:022]created symlink - 0.11% (2)
on boot? - 0.11% (2)
server service - 0.11% (2)
the sql - 0.11% (2)
now? [y/n]: - 0.11% (2)
new macbook - 0.11% (2)
to enable - 0.11% (2)
y [11:25:11:927]do - 0.11% (2)
purchase of - 0.11% (2)
returned my - 0.11% (2)
about running - 0.11% (2)
for information - 0.11% (2)
unattended [11:24:34:876]mode. - 0.11% (2)
[11:24:34:876] [11:24:34:876]the - 0.11% (2)
product can - 0.11% (2)
for this - 0.11% (2)
--help option - 0.11% (2)
service now? - 0.11% (2)
abort setup - 0.11% (2)
[11:24:34:876]you can - 0.11% (2)
at anytime - 0.11% (2)
by pressing - 0.11% (2)
this program - 0.11% (2)
ctrl-c. start - 0.11% (2)
be downloaded - 0.11% (2)
/etc/systemd/system/multi-user.target.wants/mssql-server.service to - 0.11% (2)
defaultbackupdir defaultdumpdir - 0.11% (2)
table inventory - 0.11% (2)
(id int, - 0.11% (2)
defaultlogdir defaultdatadir - 0.11% (2)
for all - 0.11% (2)
options use - 0.11% (2)
command line - 0.11% (2)
name nvarchar(50), - 0.11% (2)
quantity int); - 0.11% (2)
the 'set' - 0.11% (2)
2> insert - 0.11% (2)
values (2, - 0.11% (2)
'banana', 150); - 0.11% (2)
option: tcpport - 0.11% (2)
1> insert - 0.11% (2)
values (1, - 0.11% (2)
https://packages.microsoft.com/config/rhel/7/prod.repo > - 0.11% (2)
to 'testdb'. - 0.11% (2)
testdb 2> - 0.11% (2)
(4 rows - 0.11% (2)
sa' 1> - 0.11% (2)
1> use - 0.11% (2)
create database - 0.11% (2)
testdb (5 - 0.11% (2)
testdb; 2> - 0.11% (2)
'password of - 0.11% (2)
go changed - 0.11% (2)
第二步:通过yum安装 sudo - 0.11% (2)
> /etc/yum.repos.d/msprod.repo - 0.11% (2)
database context - 0.11% (2)
-y mssql-tools - 0.11% (2)
localhost -u - 0.11% (2)
sqlcmd -s - 0.11% (2)
settings using - 0.11% (2)
list supported - 0.11% (2)
mssql-server ● - 0.11% (2)
systemctl status - 0.11% (2)
[11:25:12:088]setup completed - 0.11% (2)
mssql-server.service - - 0.11% (2)
quantity > - 0.11% (2)
server(r) database - 0.11% (2)
inventory where - 0.11% (2)
/usr/lib/systemd/system/mssql-server-telemetry.service. [11:25:12:087] - 0.11% (2)
/etc/systemd/system/multi-user.target.wants/mssql-server-telemetry.service to - 0.11% (2)
152; 2> - 0.11% (2)
server to - 0.11% (2)
enable sql - 0.11% (2)
start on - 0.11% (2)
boot? [y/n]: - 0.11% (2)
/usr/lib/systemd/system/mssql-server.service. [11:25:12:058]created - 0.11% (2)
y [11:25:12:022]created - 0.11% (2)
engine loaded: - 0.11% (2)
loaded (/usr/lib/systemd/system/mssql-server.service; - 0.11% (2)
pid: 16558 - 0.11% (2)
ago main - 0.11% (2)
1min 59s - 0.11% (2)
(sqlservr) cgroup: - 0.11% (2)
/system.slice/mssql-server.service ├─16558 - 0.11% (2)
sudo /opt/mssql/bin/mssql-conf - 0.11% (2)
/opt/mssql/bin/sqlservr └─16571 - 0.11% (2)
22:25:08 est; - 0.11% (2)
sun 2016-12-04 - 0.11% (2)
affected) (1 - 0.11% (2)
enabled; vendor - 0.11% (2)
preset: disabled) - 0.11% (2)
active: active - 0.11% (2)
(running) since - 0.11% (2)
'orange', 154); - 0.11% (2)
[11:25:11:927]do you - 0.11% (2)
[11:24:34:876]microsoft(r) sql - 0.11% (2)
--停止复制 (root@localhost) - 0.11% (2)
is running. - 0.11% (2)
mode while - 0.11% (2)
single primary - 0.11% (2)
[(none)]> stop - 0.11% (2)
(8.67 sec) - 0.11% (2)
--设置为第一个准备启动mgr(bootstrap)的节点 (root@localhost) - 0.11% (2)
sec) --该参数设置为on,则禁用了在多主模式下一些可能产生未知数据冲突的操作 - 0.11% (2)
--设置单主模式参数为off (root@localhost) - 0.11% (2)
or from - 0.11% (2)
change into - 0.11% (2)
'group_replication_single_primary_mode'; +----------------------------------------------------+-------------------------------------------------+ - 0.11% (2)
variables like - 0.11% (2)
[(none)]> show - 0.11% (2)
| value - 0.11% (2)
| group_replication_single_primary_mode - 0.11% (2)
(hy000): cannot - 0.11% (2)
error 3093 - 0.11% (2)
--如果mgr已经启动,则无法动态修改该参数 (root@localhost) - 0.11% (2)
global group_replication_bootstrap_group=on; - 0.11% (2)
affected (1.29 - 0.11% (2)
| 24803 - 0.11% (2)
| localhost - 0.11% (2)
| 96fe2b5a-08a3-11e7-b383-d7f02f17e847 - 0.11% (2)
2 rows - 0.11% (2)
--group_replication_primary_member值为空,表示启动的是multi-primary mode,否则该参数显示的是单主模式中的primary节点 - 0.11% (2)
variable_value | - 0.11% (2)
where variable_name='group_replication_primary_member'; - 0.11% (2)
from performance_schema.global_status - 0.11% (2)
24802 | - 0.11% (2)
9003e830-08a3-11e7-8ae3-e62d2f6366d2 | - 0.11% (2)
--此时可以从视图中看到整个集群只有一个节点是online (root@localhost) - 0.11% (2)
group_replication_bootstrap_group=off; query - 0.11% (2)
sec) --为了防止后续由于意外再启动另外一个复制组,关闭bootstrap参数 - 0.11% (2)
| 72ad2062-08a3-11e7-a513-5bfce171938d - 0.11% (2)
| 24801 - 0.11% (2)
sec) --此时检查视图,可以发现集群中已经存在两个节点 - 0.11% (2)
affected (5.42 - 0.11% (2)
--设置update检查参数为on (root@localhost) - 0.11% (2)
+---------------------------+--------------------------------------+-------------+-------------+--------------+ 1 - 0.11% (2)
24801 | - 0.11% (2)
until the - 0.11% (2)
conflict detection - 0.11% (2)
elected, enabled - 0.11% (2)
applies all - 0.11% (2)
relay logs' - 0.11% (2)
group_replication_single_primary_mode | - 0.11% (2)
like 'group_replication_single_primary_mode'; - 0.11% (2)
show variables - 0.11% (2)
primary was - 0.11% (2)
'a new - 0.11% (2)
replication into - 0.11% (2)
to set - 0.11% (2)
onlinebuy cialis - 0.11% (2)
reported: 'getstart - 0.11% (2)
group_id 4317e324' - 0.11% (2)
2017-03-16t02:04:33.081756z 28 - 0.11% (2)
'unsetting super_read_only.' - 0.11% (2)
2017-03-16t02:04:33.081743z 0 - 0.11% (2)
+----------------------------------------------------+-------------------------------------------------+ --如果mgr已经启动,则无法动态修改该参数 - 0.11% (2)
group_replication_single_primary_mode=off; error - 0.11% (2)
group_replication_bootstrap_group=on; query - 0.11% (2)
sec) --设置为第一个准备启动mgr(bootstrap)的节点 - 0.11% (2)
--该参数设置为on,则禁用了在多主模式下一些可能产生未知数据冲突的操作 (root@localhost) - 0.11% (2)
(1.29 sec) - 0.11% (2)
--为了防止后续由于意外再启动另外一个复制组,关闭bootstrap参数 (root@localhost) - 0.11% (2)
72ad2062-08a3-11e7-a513-5bfce171938d | - 0.11% (2)
sec) --此时可以从视图中看到整个集群只有一个节点是online - 0.11% (2)
global group_replication_bootstrap_group=off; - 0.11% (2)
sec) --设置单主模式参数为off - 0.11% (2)
affected (8.67 - 0.11% (2)
into or - 0.11% (2)
cannot change - 0.11% (2)
3093 (hy000): - 0.11% (2)
from single - 0.11% (2)
while group - 0.11% (2)
stop group_replication; - 0.11% (2)
running. --停止复制 - 0.11% (2)
replication is - 0.11% (2)
group_replication_primary_member | - 0.11% (2)
[mysqld] # - 0.11% (2)
the --help - 0.11% (2)
program [11:24:34:876]with - 0.11% (2)
start this - 0.11% (2)
pressing ctrl-c. - 0.11% (2)
option for - 0.11% (2)
information about - 0.11% (2)
[11:24:34:876]mode. [11:24:34:876] - 0.11% (2)
in unattended - 0.11% (2)
running it - 0.11% (2)
anytime by - 0.11% (2)
setup at - 0.11% (2)
https://packages.microsoft.com/config/rhel/7/mssql-server.repo > - 0.11% (2)
curl https://packages.microsoft.com/config/rhel/7/mssql-server.repo - 0.11% (2)
enterprise linux - 0.11% (2)
[11:24:34:794][ec2-user@ip-172-31-11-228 ~]$ - 0.11% (2)
sudo /opt/mssql/bin/sqlservr-setup - 0.11% (2)
can abort - 0.11% (2)
[11:24:34:876] [11:24:34:876]you - 0.11% (2)
server(r) setup - 0.11% (2)
[11:24:34:876]the license - 0.11% (2)
terms for - 0.11% (2)
[11:24:45:938] [11:24:55:008]please - 0.11% (2)
"yes": yes - 0.11% (2)
please type - 0.11% (2)
enter a - 0.11% (2)
account: [11:24:59:810]please - 0.11% (2)
account password... - 0.11% (2)
[11:24:59:811]setting system - 0.11% (2)
confirm the - 0.11% (2)
if so, - 0.11% (2)
license terms? - 0.11% (2)
downloaded from - 0.11% (2)
can be - 0.11% (2)
this product - 0.11% (2)
[11:24:34:877]http://go.microsoft.com/fwlink/?linkid=746388 and - 0.11% (2)
found [11:24:34:877]in - 0.11% (2)
accept the - 0.11% (2)
[11:24:45:937]do you - 0.11% (2)
/usr/share/doc/mssql-server/license.txt. [11:24:34:880] - 0.11% (2)
hat enterprise - 0.11% (2)
on public - 0.11% (2)
loose-group_replication_group_seeds= "127.0.0.1:24901,127.0.0.1:24902,127.0.0.1:24903" - 0.11% (2)
loose-group_replication_local_address= "127.0.0.1:24902" - 0.11% (2)
loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" loose-group_replication_start_on_boot=off - 0.11% (2)
loose-group_replication_bootstrap_group= off - 0.11% (2)
configuration multi-primary - 0.11% (2)
configuration datadir=/users/kamus/mysql_data/s2 - 0.11% (2)
# loose-group_replication_single_primary_mode=off - 0.11% (2)
mode ## - 0.11% (2)
# transaction_write_set_extraction=xxhash64 - 0.11% (2)
binlog_format=row # - 0.11% (2)
port=24802 socket=/tmp/s2.sock - 0.11% (2)
datadir=/users/kamus/mysql_data/s2 basedir=/usr/local/cellar/mysql/5.7.17 - 0.11% (2)
server configuration - 0.11% (2)
parameters # - 0.11% (2)
server_id=2 gtid_mode=on - 0.11% (2)
log_slave_updates=on log_bin=binlog - 0.11% (2)
relay_log_info_repository=table binlog_checksum=none - 0.11% (2)
enforce_gtid_consistency=on master_info_repository=table - 0.11% (2)
basedir=/usr/local/cellar/mysql/5.7.17 port=24802 - 0.11% (2)
socket=/tmp/s2.sock # - 0.11% (2)
## group - 0.11% (2)
- 0.11% (2)
- 0.11% (2)
loose-group_replication_single_primary_mode=off # - 0.11% (2)
preview of - 0.11% (2)
2016 by - 0.11% (2)
release of - 0.11% (2)
the next - 0.11% (2)
loose-group_replication_start_on_boot=off loose-group_replication_local_address= - 0.11% (2)
transaction_write_set_extraction=xxhash64 loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" - 0.11% (2)
# server_id=2 - 0.11% (2)
configuration parameters - 0.11% (2)
# replication - 0.11% (2)
gtid_mode=on enforce_gtid_consistency=on - 0.11% (2)
master_info_repository=table relay_log_info_repository=table - 0.11% (2)
configuration # - 0.11% (2)
log_bin=binlog binlog_format=row - 0.11% (2)
binlog_checksum=none log_slave_updates=on - 0.11% (2)
[11:25:03:006] [11:25:07:728]do - 0.11% (2)
ok, 0 rows - 0.99% (18)
0 rows affected - 0.99% (18)
query ok, 0 - 0.99% (18)
[(none)]> set global - 0.77% (14)
(root@localhost) [(none)]> set - 0.77% (14)
affected (0.00 sec) - 0.66% (12)
rows affected (0.00 - 0.66% (12)
select * from - 0.44% (8)
[note] plugin group_replication - 0.33% (6)
(root@localhost) [(none)]> select - 0.33% (6)
[(none)]> select * - 0.33% (6)
rows affected) 1> - 0.33% (6)
| online | - 0.33% (6)
group_replication; query ok, - 0.33% (6)
set global group_replication_single_primary_mode=off; - 0.33% (6)
plugin group_replication reported: - 0.33% (6)
set (0.00 sec) - 0.33% (6)
administrator (sa) account - 0.33% (6)
| group_replication_applier | - 0.33% (6)
system administrator (sa) - 0.33% (6)
in set (0.00 - 0.33% (6)
name from sys.databases; - 0.22% (4)
member_id | member_host - 0.22% (4)
| member_port | - 0.22% (4)
set global group_replication_enforce_update_everywhere_checks=on; - 0.22% (4)
(0.00 sec) --启动复制 - 0.22% (4)
global group_replication_single_primary_mode=off; query - 0.22% (4)
-------------------------------------------------------------------------------------------------------------------------------- master tempdb - 0.22% (4)
| channel_name | - 0.22% (4)
(root@localhost) [(none)]> start - 0.22% (4)
online | +---------------------------+--------------------------------------+-------------+-------------+--------------+ - 0.22% (4)
into inventory values - 0.22% (4)
member_state | +---------------------------+--------------------------------------+-------------+-------------+--------------+ - 0.22% (4)
from performance_schema.replication_group_members; +---------------------------+--------------------------------------+-------------+-------------+--------------+ - 0.22% (4)
2> go name - 0.22% (4)
member_port | member_state - 0.22% (4)
microsoft(r) sql server(r) - 0.22% (4)
sudo yum install - 0.22% (4)
# group replication - 0.22% (4)
+---------------------------+--------------------------------------+-------------+-------------+--------------+ | group_replication_applier - 0.22% (4)
| member_state | - 0.22% (4)
(sa) account: [11:24:59:810] - 0.22% (4)
password for the - 0.22% (4)
you wish to - 0.22% (4)
administrator (sa) account: - 0.22% (4)
for the system - 0.22% (4)
the system administrator - 0.22% (4)
member_host | member_port - 0.22% (4)
| member_id | - 0.22% (4)
go name -------------------------------------------------------------------------------------------------------------------------------- - 0.22% (4)
| member_host | - 0.22% (4)
channel_name | member_id - 0.22% (4)
performance_schema.replication_group_members; +---------------------------+--------------------------------------+-------------+-------------+--------------+ | - 0.22% (4)
| bogon | - 0.22% (4)
from sys.databases; 2> - 0.22% (4)
+---------------------------+--------------------------------------+-------------+-------------+--------------+ | channel_name - 0.22% (4)
* from performance_schema.replication_group_members; - 0.22% (4)
row in set - 0.22% (4)
1> select name - 0.22% (4)
master tempdb model - 0.22% (4)
| +---------------------------+--------------------------------------+-------------+-------------+--------------+ | - 0.22% (4)
sys.databases; 2> go - 0.22% (4)
select name from - 0.22% (4)
name -------------------------------------------------------------------------------------------------------------------------------- master - 0.22% (4)
insert into inventory - 0.22% (4)
0 [note] plugin - 0.22% (4)
group_replication_enforce_update_everywhere_checks=on; query ok, - 0.22% (4)
tempdb model msdb - 0.22% (4)
start group_replication; query - 0.22% (4)
--启动复制 (root@localhost) [(none)]> - 0.22% (4)
kamus·comments off on - 0.16% (3)
macbook pro with - 0.16% (3)
mysql group replication - 0.16% (3)
with multi-touch bar - 0.16% (3)
server vnext on - 0.16% (3)
start on boot? - 0.11% (2)
/etc/systemd/system/multi-user.target.wants/mssql-server.service to /usr/lib/systemd/system/mssql-server.service. - 0.11% (2)
symlink from /etc/systemd/system/multi-user.target.wants/mssql-server.service - 0.11% (2)
symlink from /etc/systemd/system/multi-user.target.wants/mssql-server-telemetry.service - 0.11% (2)
to /usr/lib/systemd/system/mssql-server.service. [11:25:12:058]created - 0.11% (2)
[y/n]: y [11:25:12:022]created - 0.11% (2)
wish to start - 0.11% (2)
y [11:25:11:927]do you - 0.11% (2)
the sql server - 0.11% (2)
[11:25:12:058]created symlink from - 0.11% (2)
wish to enable - 0.11% (2)
sql server to - 0.11% (2)
to /usr/lib/systemd/system/mssql-server-telemetry.service. [11:25:12:087] - 0.11% (2)
service now? [y/n]: - 0.11% (2)
systemctl status mssql-server - 0.11% (2)
cgroup: /system.slice/mssql-server.service ├─16558 - 0.11% (2)
pid: 16558 (sqlservr) - 0.11% (2)
59s ago main - 0.11% (2)
~]$ systemctl status - 0.11% (2)
----------- 2 orange - 0.11% (2)
- microsoft(r) sql - 0.11% (2)
mssql-server ● mssql-server.service - 0.11% (2)
22:25:08 est; 1min - 0.11% (2)
since sun 2016-12-04 - 0.11% (2)
154 (1 rows - 0.11% (2)
● mssql-server.service - - 0.11% (2)
[11:25:03:006] [11:25:07:728]do you - 0.11% (2)
database engine loaded: - 0.11% (2)
loaded (/usr/lib/systemd/system/mssql-server.service; enabled; - 0.11% (2)
active: active (running) - 0.11% (2)
vendor preset: disabled) - 0.11% (2)
[11:25:12:088]setup completed successfully. - 0.11% (2)
purchase of new - 0.11% (2)
about running it - 0.11% (2)
option for information - 0.11% (2)
[11:24:34:876]with the --help - 0.11% (2)
in unattended [11:24:34:876]mode. - 0.11% (2)
[11:24:34:876] [11:24:34:876]the license - 0.11% (2)
product can be - 0.11% (2)
terms for this - 0.11% (2)
start this program - 0.11% (2)
by pressing ctrl-c. - 0.11% (2)
server(r) setup [11:24:34:876] - 0.11% (2)
[11:25:12:087] [11:25:12:088]setup completed - 0.11% (2)
new macbook pro - 0.11% (2)
[11:24:34:876]you can abort - 0.11% (2)
setup at anytime - 0.11% (2)
my purchase of - 0.11% (2)
downloaded from [11:24:34:877]http://go.microsoft.com/fwlink/?linkid=746388 - 0.11% (2)
and found [11:24:34:877]in - 0.11% (2)
account: [11:24:59:810]please confirm - 0.11% (2)
server(r) database engine - 0.11% (2)
the password for - 0.11% (2)
/opt/mssql/bin/sqlservr-setup [11:24:34:876]microsoft(r) sql - 0.11% (2)
(sa) account password... - 0.11% (2)
[11:24:59:811]setting system administrator - 0.11% (2)
/etc/systemd/system/multi-user.target.wants/mssql-server-telemetry.service to /usr/lib/systemd/system/mssql-server-telemetry.service. - 0.11% (2)
why i returned - 0.11% (2)
you accept the - 0.11% (2)
/usr/share/doc/mssql-server/license.txt. [11:24:34:880] [11:24:45:937]do - 0.11% (2)
license terms? if - 0.11% (2)
so, please type - 0.11% (2)
[11:24:55:008]please enter a - 0.11% (2)
"yes": yes [11:24:45:938] - 0.11% (2)
i returned my - 0.11% (2)
2016-12-04 22:25:08 est; - 0.11% (2)
2 orange 154 - 0.11% (2)
~]$ sqlcmd -s - 0.11% (2)
localhost -u sa - 0.11% (2)
model msdb testdb - 0.11% (2)
(5 rows affected) - 0.11% (2)
2> go changed - 0.11% (2)
1> use testdb - 0.11% (2)
-p 'password of - 0.11% (2)
sa' 1> select - 0.11% (2)
affected) 1> create - 0.11% (2)
msdb (4 rows - 0.11% (2)
testdb (5 rows - 0.11% (2)
create database testdb; - 0.11% (2)
database testdb; 2> - 0.11% (2)
model msdb (4 - 0.11% (2)
go 1> select - 0.11% (2)
database context to - 0.11% (2)
'testdb'. 1> create - 0.11% (2)
where quantity > - 0.11% (2)
152; 2> go - 0.11% (2)
inventory values (2, - 0.11% (2)
* from inventory - 0.11% (2)
affected) 1> select - 0.11% (2)
go (1 rows - 0.11% (2)
'orange', 154); 3> - 0.11% (2)
2> insert into - 0.11% (2)
id name quantity - 0.11% (2)
int, name nvarchar(50), - 0.11% (2)
table inventory (id - 0.11% (2)
quantity int); 2> - 0.11% (2)
go 1> insert - 0.11% (2)
(1, 'banana', 150); - 0.11% (2)
----------- -------------------------------------------------- ----------- - 0.11% (2)
affected) 1> use - 0.11% (2)
testdb 2> go - 0.11% (2)
using the 'set' - 0.11% (2)
list supported settings - 0.11% (2)
~]$ sudo /opt/mssql/bin/mssql-conf - 0.11% (2)
go id name - 0.11% (2)
option: tcpport defaultbackupdir - 0.11% (2)
for all command - 0.11% (2)
defaultdumpdir defaultlogdir defaultdatadir - 0.11% (2)
├─16558 /opt/mssql/bin/sqlservr └─16571 - 0.11% (2)
(sqlservr) cgroup: /system.slice/mssql-server.service - 0.11% (2)
(running) since sun - 0.11% (2)
disabled) active: active - 0.11% (2)
enabled; vendor preset: - 0.11% (2)
affected) (1 rows - 0.11% (2)
quantity ----------- -------------------------------------------------- - 0.11% (2)
main pid: 16558 - 0.11% (2)
1min 59s ago - 0.11% (2)
> 152; 2> - 0.11% (2)
line options use - 0.11% (2)
(id int, name - 0.11% (2)
nvarchar(50), quantity int); - 0.11% (2)
'password of sa' - 0.11% (2)
create table inventory - 0.11% (2)
to 'testdb'. 1> - 0.11% (2)
[11:25:12:022]created symlink from - 0.11% (2)
changed database context - 0.11% (2)
sqlcmd -s localhost - 0.11% (2)
install -y mssql-tools - 0.11% (2)
inventory where quantity - 0.11% (2)
-h or --help - 0.11% (2)
rows affected) (1 - 0.11% (2)
(2, 'orange', 154); - 0.11% (2)
values (1, 'banana', - 0.11% (2)
150); 2> insert - 0.11% (2)
loaded: loaded (/usr/lib/systemd/system/mssql-server.service; - 0.11% (2)
information about running - 0.11% (2)
+----------------------------------------------------+-------------------------------------------------+ | variable_name - 0.11% (2)
variables like 'group_replication_single_primary_mode'; - 0.11% (2)
(root@localhost) [(none)]> show - 0.11% (2)
| value | - 0.11% (2)
+----------------------------------------------------+-------------------------------------------------+ | group_replication_single_primary_mode - 0.11% (2)
(hy000): cannot change - 0.11% (2)
group_replication_single_primary_mode=off; error 3093 - 0.11% (2)
+----------------------------------------------------+-------------------------------------------------+ --如果mgr已经启动,则无法动态修改该参数 (root@localhost) - 0.11% (2)
| 24801 | - 0.11% (2)
72ad2062-08a3-11e7-a513-5bfce171938d | bogon - 0.11% (2)
(0.00 sec) --设置为第一个准备启动mgr(bootstrap)的节点 - 0.11% (2)
sec) --该参数设置为on,则禁用了在多主模式下一些可能产生未知数据冲突的操作 (root@localhost) - 0.11% (2)
--设置单主模式参数为off (root@localhost) [(none)]> - 0.11% (2)
global group_replication_bootstrap_group=on; query - 0.11% (2)
affected (1.29 sec) - 0.11% (2)
sec) --此时可以从视图中看到整个集群只有一个节点是online (root@localhost) - 0.11% (2)
set global group_replication_bootstrap_group=off; - 0.11% (2)
--为了防止后续由于意外再启动另外一个复制组,关闭bootstrap参数 (root@localhost) [(none)]> - 0.11% (2)
into or from - 0.11% (2)
single primary mode - 0.11% (2)
24801 | online - 0.11% (2)
group_replication_applier | 72ad2062-08a3-11e7-a513-5bfce171938d - 0.11% (2)
--此时可以从视图中看到整个集群只有一个节点是online (root@localhost) [(none)]> - 0.11% (2)
| +---------------------------+--------------------------------------+-------------+-------------+--------------+ 1 - 0.11% (2)
--同样设置单主模式参数为off (root@localhost) [(none)]> - 0.11% (2)
| 9003e830-08a3-11e7-8ae3-e62d2f6366d2 | - 0.11% (2)
(5.42 sec) --此时检查视图,可以发现集群中已经存在两个节点 - 0.11% (2)
sec) --设置update检查参数为on (root@localhost) - 0.11% (2)
global group_replication_bootstrap_group=off; query - 0.11% (2)
(1.29 sec) --为了防止后续由于意外再启动另外一个复制组,关闭bootstrap参数 - 0.11% (2)
(root@localhost) [(none)]> stop - 0.11% (2)
is running. --停止复制 - 0.11% (2)
while group replication - 0.11% (2)
(8.67 sec) --设置单主模式参数为off - 0.11% (2)
--该参数设置为on,则禁用了在多主模式下一些可能产生未知数据冲突的操作 (root@localhost) [(none)]> - 0.11% (2)
group_replication_bootstrap_group=on; query ok, - 0.11% (2)
sec) --设置为第一个准备启动mgr(bootstrap)的节点 (root@localhost) - 0.11% (2)
affected (8.67 sec) - 0.11% (2)
stop group_replication; query - 0.11% (2)
detection until the - 0.11% (2)
elected, enabled conflict - 0.11% (2)
new primary was - 0.11% (2)
new primary applies - 0.11% (2)
group_replication reported: 'getstart - 0.11% (2)
super_read_only.' 2017-03-16t02:04:33.081756z 28 - 0.11% (2)
group_replication reported: 'unsetting - 0.11% (2)
group_id 4317e324' 2017-03-16t02:04:33.081743z - 0.11% (2)
group_replication reported: 'a - 0.11% (2)
28 [note] plugin - 0.11% (2)
how to set - 0.11% (2)
group replication into - 0.11% (2)
to set mysql - 0.11% (2)
into multi-primary mode - 0.11% (2)
2017-03-16t02:04:32.689278z 0 [note] - 0.11% (2)
'unsetting super_read_only.' 2017-03-16t02:04:33.081756z - 0.11% (2)
2017-03-16t02:04:33.081743z 0 [note] - 0.11% (2)
'getstart group_id 4317e324' - 0.11% (2)
reported: 'a new - 0.11% (2)
primary was elected, - 0.11% (2)
3093 (hy000): cannot - 0.11% (2)
global group_replication_single_primary_mode=off; error - 0.11% (2)
| +----------------------------------------------------+-------------------------------------------------+ --如果mgr已经启动,则无法动态修改该参数 - 0.11% (2)
change into or - 0.11% (2)
from single primary - 0.11% (2)
--停止复制 (root@localhost) [(none)]> - 0.11% (2)
replication is running. - 0.11% (2)
mode while group - 0.11% (2)
group_replication_single_primary_mode | on - 0.11% (2)
| +----------------------------------------------------+-------------------------------------------------+ | - 0.11% (2)
primary applies all - 0.11% (2)
until the new - 0.11% (2)
enabled conflict detection - 0.11% (2)
--group_replication_single_primary_mode=on,表示启动了single-primary模式,那么修改为off就意味着要启动multi-primary模式。 (root@localhost) [(none)]> - 0.11% (2)
show variables like - 0.11% (2)
variable_name | value - 0.11% (2)
'group_replication_single_primary_mode'; +----------------------------------------------------+-------------------------------------------------+ | - 0.11% (2)
bogon | 24802 - 0.11% (2)
96fe2b5a-08a3-11e7-b383-d7f02f17e847 | localhost - 0.11% (2)
program [11:24:34:876]with the - 0.11% (2)
ctrl-c. start this - 0.11% (2)
anytime by pressing - 0.11% (2)
--help option for - 0.11% (2)
generic cialisbuy cialis - 0.11% (2)
license terms for - 0.11% (2)
[11:24:34:876]mode. [11:24:34:876] [11:24:34:876]the - 0.11% (2)
it in unattended - 0.11% (2)
abort setup at - 0.11% (2)
[11:24:34:876] [11:24:34:876]you can - 0.11% (2)
the next release - 0.11% (2)
public preview of - 0.11% (2)
loose-group_replication_single_primary_mode=off # loose-group_replication_enforce_update_everywhere_checks=on - 0.11% (2)
of sql server - 0.11% (2)
hat enterprise linux - 0.11% (2)
sql server(r) setup - 0.11% (2)
sudo /opt/mssql/bin/sqlservr-setup [11:24:34:876]microsoft(r) - 0.11% (2)
install -y mssql-server - 0.11% (2)
this product can - 0.11% (2)
be downloaded from - 0.11% (2)
password... [11:25:03:006] [11:25:07:728]do - 0.11% (2)
[11:24:59:810] [11:24:59:811]setting system - 0.11% (2)
confirm the password - 0.11% (2)
start the sql - 0.11% (2)
server service now? - 0.11% (2)
to start on - 0.11% (2)
enable sql server - 0.11% (2)
[y/n]: y [11:25:11:927]do - 0.11% (2)
(sa) account: [11:24:59:810]please - 0.11% (2)
a password for - 0.11% (2)
[11:24:45:937]do you accept - 0.11% (2)
[11:24:34:877]in /usr/share/doc/mssql-server/license.txt. [11:24:34:880] - 0.11% (2)
[11:24:34:877]http://go.microsoft.com/fwlink/?linkid=746388 and found - 0.11% (2)
the license terms? - 0.11% (2)
if so, please - 0.11% (2)
[11:24:45:938] [11:24:55:008]please enter - 0.11% (2)
type "yes": yes - 0.11% (2)
mode ## # - 0.11% (2)
replication configuration multi-primary - 0.11% (2)
# replication configuration - 0.11% (2)
port=24802 socket=/tmp/s2.sock # - 0.11% (2)
configuration datadir=/users/kamus/mysql_data/s2 basedir=/usr/local/cellar/mysql/5.7.17 - 0.11% (2)
parameters # server_id=2 - 0.11% (2)
gtid_mode=on enforce_gtid_consistency=on master_info_repository=table - 0.11% (2)
configuration # transaction_write_set_extraction=xxhash64 - 0.11% (2)
log_bin=binlog binlog_format=row # - 0.11% (2)
relay_log_info_repository=table binlog_checksum=none log_slave_updates=on - 0.11% (2)
[mysqld] # server - 0.11% (2)
+----------------------------------+----------------+ 1 row - 0.11% (2)
--group_replication_primary_member值为空,表示启动的是multi-primary mode,否则该参数显示的是单主模式中的primary节点 (root@localhost) - 0.11% (2)
2 rows in - 0.11% (2)
| 24803 | - 0.11% (2)
from performance_schema.global_status where - 0.11% (2)
variable_name='group_replication_primary_member'; +----------------------------------+----------------+ | - 0.11% (2)
group_replication_primary_member | | - 0.11% (2)
| +----------------------------------+----------------+ | - 0.11% (2)
variable_name | variable_value - 0.11% (2)
loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" loose-group_replication_start_on_boot=off loose-group_replication_local_address= - 0.11% (2)
"127.0.0.1:24902" loose-group_replication_group_seeds= "127.0.0.1:24901,127.0.0.1:24902,127.0.0.1:24903" - 0.11% (2)
# # group - 0.11% (2)
log_slave_updates=on log_bin=binlog binlog_format=row - 0.11% (2)
master_info_repository=table relay_log_info_repository=table binlog_checksum=none - 0.11% (2)
replication configuration # - 0.11% (2)
transaction_write_set_extraction=xxhash64 loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" loose-group_replication_start_on_boot=off - 0.11% (2)
# ## group - 0.11% (2)
"127.0.0.1:24901,127.0.0.1:24902,127.0.0.1:24903" loose-group_replication_bootstrap_group= off - 0.11% (2)
- 0.11% (2)
server_id=2 gtid_mode=on enforce_gtid_consistency=on - 0.11% (2)
configuration parameters # - 0.11% (2)
configuration multi-primary mode - 0.11% (2)
## group replication - 0.11% (2)
loose-group_replication_bootstrap_group= off # - 0.11% (2)
## # loose-group_replication_single_primary_mode=off - 0.11% (2)
server configuration datadir=/users/kamus/mysql_data/s2 - 0.11% (2)
# # replication - 0.11% (2)
basedir=/usr/local/cellar/mysql/5.7.17 port=24802 socket=/tmp/s2.sock - 0.11% (2)
boot? [y/n]: y - 0.11% (2)

Here you can find chart of all your popular one, two and three word phrases. Google and others search engines means your page is about words you use frequently.

Copyright © 2015-2016 hupso.pl. All rights reserved. FB | +G | Twitter

Hupso.pl jest serwisem internetowym, w którym jednym kliknieciem możesz szybko i łatwo sprawdź stronę www pod kątem SEO. Oferujemy darmowe pozycjonowanie stron internetowych oraz wycena domen i stron internetowych. Prowadzimy ranking polskich stron internetowych oraz ranking stron alexa.