5.00 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 3695
Text/HTML 52.05 %
Headings H1 1
H2 4
H3 6
H4 0
H5 0
H6 0
H1
buy viagra onlineorder levitrachannel [k]
H2
面朝大海,春暖花开
mysql enterprise audit in oracle mysql cloud service
how to set mysql group replication into multi-primary mode
public preview of the next release of sql server for linux
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 168
Linki wewnętrzne 3
Linki zewnętrzne 165
Linki bez atrybutu Title 46
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/
mysql enterprise audit in oracle mysql cloud service http://www.dbform.com/html/2017/3672.html
http://www.dbform.com/html/2017/3672.html
kamus http://www.dbform.com/html/author/kamus-2
http://www.addtoany.com/add_to/sina_weibo?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2017%2f3672.html&linkname=mysql%20enterprise%20audit%20in%20oracle%20mysql%20cloud%20service
http://www.addtoany.com/add_to/evernote?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2017%2f3672.html&linkname=mysql%20enterprise%20audit%20in%20oracle%20mysql%20cloud%20service
http://www.addtoany.com/add_to/linkedin?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2017%2f3672.html&linkname=mysql%20enterprise%20audit%20in%20oracle%20mysql%20cloud%20service
http://www.addtoany.com/add_to/facebook?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2017%2f3672.html&linkname=mysql%20enterprise%20audit%20in%20oracle%20mysql%20cloud%20service
http://www.addtoany.com/add_to/twitter?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2017%2f3672.html&linkname=mysql%20enterprise%20audit%20in%20oracle%20mysql%20cloud%20service
http://www.addtoany.com/add_to/instapaper?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2017%2f3672.html&linkname=mysql%20enterprise%20audit%20in%20oracle%20mysql%20cloud%20service
http://www.addtoany.com/add_to/email?linkurl=http%3a%2f%2fwww.dbform.com%2fhtml%2f2017%2f3672.html&linkname=mysql%20enterprise%20audit%20in%20oracle%20mysql%20cloud%20service
- https://www.addtoany.com/share
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
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
241 http://www.dbform.com/page/241
http://www.dbform.com/page/2
proudly powered by wordpress http://wordpress.org/
yoarts http://www.yoarts.com/

Zdjęcia

Zdjęcia 13
Zdjęcia bez atrybutu ALT 0
Zdjęcia bez atrybutu TITLE 7
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/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

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 mysql enterprise audit in oracle mysql cloud service april 22, 2017 by kamus·comments off on mysql enterprise audit in oracle mysql cloud service oracle cloud service似乎是唯一个即使你只提交了创建rds服务的请求,也会自动帮你创建一个虚拟主机,并且提供主机登录权限的服务提供商,也许这就是oracle一直在宣称的iaas+paas的整合。 在创建mysql cloud service时,会要求提供一个ssh登录密钥,所有的oracle云服务主机登录用户都是opc,因此在服务创建完毕,收到通知邮件之后,就可以通过以下命令登录到云主机上。 ssh -i id_rsa_oracle_cloud_enmotech opc@your_host_ip 登录到主机以后,屏幕欢迎词是个小惊喜,oracle贴心得显示了mysql运行状态和存储使用量的提示。 在比较了多方的rds之后,oracle mysql cloud service确实如一直以来宣传的那样,提供了最多的安全选件功能,如果我们用mysql workbench登录到数据库中,在server status页面可以看到:ssl连接,pam验证,密码校验,数据库审计等多种安全功能全部是开启的。 而与之相比,阿里云mysql rds提供的安全功能就少的可怜了。说少不合适,是一项安全功能都没开启。 oracle对于数据库安全性的看重确实超越了大多数数据库提供商,而这也带来了一些小麻烦。 在创建mysql云服务的时候,需要指定数据库root用户的密码,这个密码有比较强的安全要求,需要有大写、小写英文字母,有数字,同时还需要有特殊字符(比如#)。因此在后续创建login path时,在mysql_config_editor命令提示输入密码的时候,需要在密码前后加上双引号(比如”passw#rd”),否则会一直出现拒绝访问的提示。 --opc用户没有办法直接登录mysql,需要切换到oracle用户 [opc@mysql-cloud-mysql-1 ~]$ mysql -uroot -p please switch to "oracle" user to use mysql client [opc@mysql-cloud-mysql-1 ~]$ sudo su - oracle --使用密码直接登录是没有问题的 [oracle@mysql-cloud-mysql-1 ~]$ mysql -uroot -p enter password: welcome to the mysql monitor. commands end with ; or \g. your mysql connection id is 1509246 server version: 5.7.17-enterprise-commercial-advanced-log mysql enterprise server - advanced edition (commercial) copyright (c) 2000, 2016, oracle and/or its affiliates. all rights reserved. oracle is a registered trademark of oracle corporation and/or its affiliates. other names may be trademarks of their respective owners. type 'help;' or '\h' for help. type '\c' to clear the current input statement. mysql> exit bye --创建login path,仍然输入上述一样的密码 [oracle@mysql-cloud-mysql-1 ~]$ mysql_config_editor set --host=localhost --user=root --password enter password: --检查确认login path已经创建成功 [oracle@mysql-cloud-mysql-1 ~]$ mysql_config_editor print --login-path=client [client] user = root password = ***** host = localhost --直接登录报错 [oracle@mysql-cloud-mysql-1 ~]$ mysql error 1045 (28000): access denied for user 'root'@'localhost' (using password: yes) --在密码前后加上双引号重新创建login path [oracle@mysql-cloud-mysql-1 ~]$ mysql_config_editor set --host=localhost --user=root --password enter password: warning : 'client' path already exists and will be overwritten. continue? (press y|y for yes, any other key for no) : y --再次登录,成功 [oracle@mysql-cloud-mysql-1 ~]$ mysql welcome to the mysql monitor. commands end with ; or \g. your mysql connection id is 1510011 server version: 5.7.17-enterprise-commercial-advanced-log mysql enterprise server - advanced edition (commercial) copyright (c) 2000, 2016, oracle and/or its affiliates. all rights reserved. oracle is a registered trademark of oracle corporation and/or its affiliates. other names may be trademarks of their respective owners. type 'help;' or '\h' for help. type '\c' to clear the current input statement. mysql> status -------------- mysql ver 14.14 distrib 5.7.17, for linux-glibc2.5 (x86_64) using editline wrapper connection id: 1510011 current database: current user: root@localhost ssl: not in use current pager: stdout using outfile: '' using delimiter: ; server version: 5.7.17-enterprise-commercial-advanced-log mysql enterprise server - advanced edition (commercial) protocol version: 10 connection: localhost via unix socket server characterset: utf8mb4 db characterset: utf8mb4 client characterset: utf8 conn. characterset: utf8 unix socket: /tmp/mysql.sock uptime: 10 days 13 hours 24 min 56 sec threads: 13 questions: 50733146 slow queries: 0 opens: 6203 flush tables: 1 open tables: 4808 queries per second avg: 55.610 -------------- 在进行audit功能的检查之前,对于默认的mysql命令行提示只有mysql> 这样简陋的显示不能忍,要加上当前登录的用户和数据库名称。在oracle用户的.my.cnf下增加以下行。 [mysql] prompt=\\u@\\h [\\d]>\\_ 再次登录,mysql命令行的提示就比较顺眼了。 [oracle@mysql-cloud-mysql-1 ~]$ mysql welcome to the mysql monitor. commands end with ; or \g. your mysql connection id is 1510385 server version: 5.7.17-enterprise-commercial-advanced-log mysql enterprise server - advanced edition (commercial) copyright (c) 2000, 2016, oracle and/or its affiliates. all rights reserved. oracle is a registered trademark of oracle corporation and/or its affiliates. other names may be trademarks of their respective owners. type 'help;' or '\h' for help. type '\c' to clear the current input statement. root@localhost [(none)]> show databases; +-------------------------+ | database | +-------------------------+ | information_schema | | mem | | mem__advisor_text | | mem__advisors | | mem__bean_config | | mem__config | | mem__enterprise | | mem__events | | mem__instruments | | mem__instruments_config | | mem__inventory | | mem__quan | | mysql | | performance_schema | | sys | | testdb | +-------------------------+ 16 rows in set (0.00 sec) root@localhost [(none)]> use testdb database changed root@localhost [testdb]> show tables; empty set (0.00 sec) root@localhost [testdb]> 接下来进入本文的正题,在oracle mysql cloud service中默认是如何设置audit的? 首先先检查一下audit_log的相关参数设置。 root@localhost [testdb]> show variables like 'audit_log_%'; +-----------------------------+--------------+ | variable_name | value | +-----------------------------+--------------+ | audit_log_buffer_size | 1048576 | | audit_log_connection_policy | all | | audit_log_current_session | on | | audit_log_exclude_accounts | | | audit_log_file | audit.log | | audit_log_filter_id | 0 | | audit_log_flush | off | | audit_log_format | new | | audit_log_include_accounts | | | audit_log_policy | all | | audit_log_rotate_on_size | 1073741824 | | audit_log_statement_policy | errors | | audit_log_strategy | asynchronous | +-----------------------------+--------------+ 13 rows in set (0.01 sec) 那么audit_log_file=audit.log表示仍然使用了默认的名字,到mysql的数据文件目录中检查一下audit.log文件的存在。 [oracle@mysql-cloud-mysql-1 mysql]$ ls -l audit* -rw-r----- 1 oracle oracle 838348830 apr 21 13:42 audit.log -rw-r----- 1 oracle oracle 1073742130 apr 14 23:20 audit.log.14922120508218349.xml 这里可以看到总共的audit日志已经有1.9gb之大,在第一个audit.log达到audit_log_rotate_on_size参数设置的大小之后,自动切换成了新的audit.log。 题外话,之所以有这么巨大的audit.log,是由于启用了mysql enterprise monitor,不断地记录了monitor进程的登录和退出,为了方便后面观察audit.log,先将monitor停止。 [oracle@mysql-cloud-mysql-1 monitor]$ pwd /u01/bin/enterprise/monitor [oracle@mysql-cloud-mysql-1 monitor]$ ./mysqlmonitorctl.sh stop stopping tomcat service . [ ok ] 接下来进行一些常规操作,并观察audit.log文件的输出内容。 1. 用root用户登录,在audit文件中显示一条connect类型的记录。timestamp记录了时间,user标签记录了登录的用户,host标签记录了登录的机器,command_class为connect。 2. 尝试直接ctas一张测试表,在enforce_gtid_consistency=on时会报1786错误,这是gtid特性决定的。 root@localhost [testdb]> create table mytables as select * from information_schema.tables; error 1786 (hy000): statement violates gtid consistency: create table ... select. 在audit.log中也记录下了这次报错的操作,status标签为错误代码1786,status_code标签值为1表示这条sql没有成功执行,sqltext标签记录了整个sql语句。 3. 下面的三条语句,select,create table,insert均没有在audit.log中记录下来。 root@localhost [testdb]> select count(*) from information_schema.tables; +----------+ | count(*) | +----------+ | 591 | +----------+ 1 row in set (0.01 sec) root@localhost [testdb]> create table mytables like information_schema.tables; query ok, 0 rows affected (0.10 sec) root@localhost [testdb]> insert into mytables select * from information_schema.tables; query ok, 592 rows affected (1.94 sec) records: 592 duplicates: 0 warnings: 0 这样的行为是由audit_log_statement_policy=errors参数决定的,默认只记录报错的sql,而不会记录所有的执行语句。 4. 将audit_log_statement_policy参数修改为all,再执行同样的select语句。 root@localhost [testdb]> set global audit_log_statement_policy = all; query ok, 0 rows affected (0.00 sec) root@localhost [testdb]> select count(*) from mytables; +----------+ | count(*) | +----------+ | 592 | +----------+ 1 row in set (0.00 sec) 可以发现audit.log中已经有记录了。 结论:在oracle mysql cloud service中默认会启动mysql enterprise audit组件,并且设置即记录用户登录又记录执行语句(audit_log_policy=all),用户登录情况则不管登录成功还是失败每次都记录(audit_log_connection_policy=all),而执行语句则只记录执行失败的语句(audit_log_statement_policy=errors)。 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 第三步:设置数据库并启动 update@2017-05-11 与之前不同,设置数据库的命令整合到mssql-conf命令中,而不再有sqlservr-setup命令。 [root@opreative-server-3 ~]# /opt/mssql/bin/mssql-conf setup the license terms for this product can be downloaded from http://go.microsoft.com/fwlink/?linkid=746388 and found in /usr/share/doc/mssql-server/license.txt. do you accept the license terms? [yes/no]:y setting up microsoft sql server enter the new sql server system administrator password: confirm the new sql server system administrator password: starting microsoft sql server... enabling microsoft sql server to run at boot... created symlink from /etc/systemd/system/multi-user.target.wants/mssql-server.service to /usr/lib/systemd/system/mssql-server.service. setup completed successfully.[root@opreative-server-3 ~]# /opt/mssql/bin/mssql-conf setup the license terms for this product can be downloaded from http://go.microsoft.com/fwlink/?linkid=746388 and found in /usr/share/doc/mssql-server/license.txt. do you accept the license terms? [yes/no]:y setting up microsoft sql server enter the new sql server system administrator password: confirm the new sql server system administrator password: starting microsoft sql server... enabling microsoft sql server to run at boot... created symlink from /etc/systemd/system/multi-user.target.wants/mssql-server.service to /usr/lib/systemd/system/mssql-server.service. 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的服务的启动状态。 [root@opreative-server-3 ~]# systemctl status mssql-server ● mssql-server.service - microsoft sql server database engine loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; vendor preset: disabled) active: active (running) since thu 2017-05-11 17:00:17 cst; 34s ago docs: https://docs.microsoft.com/en-us/sql/linux main pid: 16147 (sqlservr) cgroup: /system.slice/mssql-server.service ├─16147 /opt/mssql/bin/sqlservr └─16166 /opt/mssql/bin/sqlservr may 11 17:00:20 opreative-server-3 sqlservr[16147]: 2017-05-11 17:00:20.52 spid18s server is listening on [ 0.0.0.0 1433]. may 11 17:00:20 opreative-server-3 sqlservr[16147]: 2017-05-11 17:00:20.53 server server is listening on [ 127.0.0.1 1434]. may 11 17:00:20 opreative-server-3 sqlservr[16147]: 2017-05-11 17:00:20.53 server dedicated admin connection support was established for listening locally on port 1434. may 11 17:00:20 opreative-server-3 sqlservr[16147]: 2017-05-11 17:00:20.53 spid18s sql server is now ready for client connections. this is an informational message... required. may 11 17:00:20 opreative-server-3 sqlservr[16147]: 2017-05-11 17:00:20.86 spid11s starting up database 'tempdb'. may 11 17:00:21 opreative-server-3 sqlservr[16147]: 2017-05-11 17:00:21.03 spid11s the tempdb database has 1 data file(s). may 11 17:00:21 opreative-server-3 sqlservr[16147]: 2017-05-11 17:00:21.03 spid22s the service broker endpoint is in disabled or stopped state. may 11 17:00:21 opreative-server-3 sqlservr[16147]: 2017-05-11 17:00:21.03 spid22s the database mirroring endpoint is in disabled or stopped state. may 11 17:00:21 opreative-server-3 sqlservr[16147]: 2017-05-11 17:00:21.05 spid22s service broker manager has started. may 11 17:00:21 opreative-server-3 sqlservr[16147]: 2017-05-11 17:00:21.08 spid7s recovery is complete. this is an informational message only. no user action is required. hint: some lines were ellipsized, use -l to show in full.[root@opreative-server-3 ~]# systemctl status mssql-server ● mssql-server.service - microsoft sql server database engine loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; vendor preset: disabled) active: active (running) since thu 2017-05-11 17:00:17 cst; 34s ago docs: https://docs.microsoft.com/en-us/sql/linux main pid: 16147 (sqlservr) cgroup: /system.slice/mssql-server.service ├─16147 /opt/mssql/bin/sqlservr └─16166 /opt/mssql/bin/sqlservr may 11 17:00:20 opreative-server-3 sqlservr[16147]: 2017-05-11 17:00:20.52 spid18s server is listening on [ 0.0.0.0 1433]. may 11 17:00:20 opreative-server-3 sqlservr[16147]: 2017-05-11 17:00:20.53 server server is listening on [ 127.0.0.1 1434]. may 11 17:00:20 opreative-server-3 sqlservr[16147]: 2017-05-11 17:00:20.53 server dedicated admin connection support was established for listening locally on port 1434. may 11 17:00:20 opreative-server-3 sqlservr[16147]: 2017-05-11 17:00:20.53 spid18s sql server is now ready for client connections. this is an informational message... required. may 11 17:00:20 opreative-server-3 sqlservr[16147]: 2017-05-11 17:00:20.86 spid11s starting up database 'tempdb'. may 11 17:00:21 opreative-server-3 sqlservr[16147]: 2017-05-11 17:00:21.03 spid11s the tempdb database has 1 data file(s). may 11 17:00:21 opreative-server-3 sqlservr[16147]: 2017-05-11 17:00:21.03 spid22s the service broker endpoint is in disabled or stopped state. may 11 17:00:21 opreative-server-3 sqlservr[16147]: 2017-05-11 17:00:21.03 spid22s the database mirroring endpoint is in disabled or stopped state. may 11 17:00:21 opreative-server-3 sqlservr[16147]: 2017-05-11 17:00:21.05 spid22s service broker manager has started. may 11 17:00:21 opreative-server-3 sqlservr[16147]: 2017-05-11 17:00:21.08 spid7s recovery is complete. this is an informational message only. no user action is required. hint: some lines were ellipsized, use -l to show in full. [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中了,无论如何,这是一个很大的进步,微软这步要是能早一些迈出可能就更好了。 1 2 3 4 5 … 241 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: 2980

One word

Two words phrases

Three words phrases

----------- - 8.09% (241)
sql - 7.28% (217)
-------------- - 5.3% (158)
ver - 4.33% (129)
server - 3.83% (114)
group - 3.05% (91)
mysql - 2.85% (85)
replication - 2.62% (78)
log - 2.21% (66)
rac - 2.08% (62)
group_replication - 2.01% (60)
host - 1.98% (59)
set - 1.91% (57)
for - 1.88% (56)
root - 1.81% (54)
oracle - 1.78% (53)
primary - 1.71% (51)
localhost - 1.64% (49)
audit - 1.48% (44)
row - 1.48% (44)
sys - 1.38% (41)
the - 1.38% (41)
root@localhost - 1.34% (40)
mem - 1.31% (39)
sec - 1.28% (38)
system - 1.21% (36)
rows - 1.17% (35)
mode - 1.11% (33)
sec) - 1.07% (32)
data - 1.07% (32)
use - 1.04% (31)
2017 - 1.04% (31)
affected - 1.04% (31)
[(none)]> - 1.01% (30)
mssql-server - 1.01% (30)
service - 1.01% (30)
(root@localhost) - 0.94% (28)
name - 0.94% (28)
from - 0.84% (25)
single - 0.84% (25)
off - 0.84% (25)
line - 0.81% (24)
opreative-server-3 - 0.81% (24)
16147 - 0.81% (24)
database - 0.77% (23)
enter - 0.77% (23)
2017-05-11 - 0.77% (23)
may - 0.77% (23)
(0.00 - 0.74% (22)
port - 0.74% (22)
linux - 0.74% (22)
all - 0.7% (21)
ok, - 0.7% (21)
query - 0.7% (21)
table - 0.7% (21)
user - 0.7% (21)
testdb - 0.7% (21)
sqlservr[16147]: - 0.67% (20)
microsoft - 0.67% (20)
17:00:21 - 0.67% (20)
17:00:20 - 0.67% (20)
cloud - 0.67% (20)
online - 0.64% (19)
buy - 0.64% (19)
select - 0.64% (19)
cialis - 0.6% (18)
global - 0.57% (17)
start - 0.57% (17)
enterprise - 0.57% (17)
and - 0.54% (16)
-------------------------------------------------- - 0.54% (16)
password - 0.54% (16)
group_replication_single_primary_mode - 0.54% (16)
~]$ - 0.5% (15)
mssql-server.service - 0.5% (15)
audit.log - 0.44% (13)
multi-primary - 0.44% (13)
+---------------------------+--------------------------------------+-------------+-------------+--------------+ - 0.4% (12)
create - 0.4% (12)
you - 0.37% (11)
end - 0.37% (11)
min - 0.37% (11)
inventory - 0.37% (11)
per - 0.37% (11)
connection - 0.37% (11)
information - 0.34% (10)
yum - 0.34% (10)
[oracle@mysql-cloud-mysql-1 - 0.34% (10)
where - 0.34% (10)
127.0.0.1 - 0.34% (10)
order - 0.34% (10)
affected) - 0.34% (10)
generic - 0.34% (10)
statement - 0.3% (9)
via - 0.3% (9)
2016 - 0.3% (9)
status - 0.3% (9)
[testdb]> - 0.3% (9)
into - 0.3% (9)
not - 0.3% (9)
list - 0.3% (9)
how - 0.3% (9)
value - 0.3% (9)
setup - 0.3% (9)
levitra - 0.3% (9)
loaded - 0.3% (9)
admin - 0.3% (9)
new - 0.3% (9)
license - 0.3% (9)
rman - 0.27% (8)
configuration - 0.27% (8)
password: - 0.27% (8)
this - 0.27% (8)
sudo - 0.27% (8)
viagra - 0.27% (8)
run - 0.27% (8)
stop - 0.27% (8)
tempdb - 0.27% (8)
advanced - 0.27% (8)
show - 0.23% (7)
[11:24:34:876] - 0.23% (7)
current - 0.23% (7)
client - 0.23% (7)
type - 0.23% (7)
setting - 0.23% (7)
variable_name - 0.23% (7)
performance_schema - 0.23% (7)
plugin - 0.23% (7)
disabled - 0.23% (7)
... - 0.23% (7)
/opt/mssql/bin/sqlservr - 0.23% (7)
administrator - 0.23% (7)
gtid - 0.23% (7)
error - 0.23% (7)
single-primary - 0.23% (7)
+----------------------------------+----------------+ - 0.2% (6)
tables; - 0.2% (6)
group_replication_primary_member - 0.2% (6)
next - 0.2% (6)
+----------+ - 0.2% (6)
group_replication_applier - 0.2% (6)
insert - 0.2% (6)
enable - 0.2% (6)
reported: - 0.2% (6)
group_replication_single_primary_mode=off; - 0.2% (6)
sqlcmd - 0.2% (6)
and/or - 0.2% (6)
its - 0.2% (6)
[ec2-user@ip-172-31-11-228 - 0.2% (6)
affiliates. - 0.2% (6)
17:00:21.03 - 0.2% (6)
with - 0.2% (6)
change - 0.2% (6)
action - 0.2% (6)
group_replication; - 0.2% (6)
command - 0.2% (6)
has - 0.2% (6)
spid22s - 0.2% (6)
trademark - 0.2% (6)
17:00:20.53 - 0.2% (6)
master - 0.2% (6)
quantity - 0.2% (6)
using - 0.2% (6)
can - 0.2% (6)
+----------------------------------------------------+-------------------------------------------------+ - 0.2% (6)
terms - 0.2% (6)
listening - 0.2% (6)
path - 0.2% (6)
[note] - 0.2% (6)
active - 0.2% (6)
yes - 0.2% (6)
running - 0.2% (6)
account - 0.17% (5)
databases; - 0.17% (5)
enabled - 0.17% (5)
cheap - 0.17% (5)
version: - 0.17% (5)
audit_log_statement_policy - 0.17% (5)
option - 0.17% (5)
information_schema - 0.17% (5)
member_port - 0.13% (4)
member_host - 0.13% (4)
154 - 0.13% (4)
channel_name - 0.13% (4)
performance_schema.replication_group_members; - 0.13% (4)
--启动复制 - 0.13% (4)
group_replication_enforce_update_everywhere_checks=on; - 0.13% (4)
created - 0.13% (4)
stopped - 0.13% (4)
state. - 0.13% (4)
endpoint - 0.13% (4)
broker - 0.13% (4)
required. - 0.13% (4)
spid11s - 0.13% (4)
message - 0.13% (4)
only. - 0.13% (4)
model - 0.13% (4)
msdb - 0.13% (4)
-------------------------------------------------------------------------------------------------------------------------------- - 0.13% (4)
sys.databases; - 0.13% (4)
values - 0.13% (4)
mssql-tools - 0.13% (4)
informational - 0.13% (4)
support - 0.13% (4)
curl - 0.13% (4)
install - 0.13% (4)
vnext - 0.13% (4)
orange - 0.13% (4)
bogon - 0.13% (4)
24802 - 0.13% (4)
[root@opreative-server-3 - 0.13% (4)
~]# - 0.13% (4)
spid18s - 0.13% (4)
- 0.13% (4)
systemctl - 0.13% (4)
symlink - 0.13% (4)
/opt/mssql/bin/mssql-conf - 0.13% (4)
starting - 0.13% (4)
member_state - 0.13% (4)
member_id - 0.13% (4)
(commercial) - 0.13% (4)
edition - 0.13% (4)
count(*) - 0.13% (4)
mysql_config_editor - 0.13% (4)
id: - 0.13% (4)
utf8 - 0.13% (4)
mac - 0.13% (4)
characterset: - 0.13% (4)
other - 0.13% (4)
socket - 0.13% (4)
comments - 0.13% (4)
was - 0.13% (4)
information_schema.tables; - 0.13% (4)
dba - 0.13% (4)
mytables - 0.13% (4)
relay - 0.13% (4)
like - 0.13% (4)
please - 0.13% (4)
5.7.17-enterprise-commercial-advanced-log - 0.13% (4)
your - 0.13% (4)
terms? - 0.1% (3)
accept - 0.1% (3)
2016, - 0.1% (3)
ready - 0.1% (3)
confirm - 0.1% (3)
now - 0.1% (3)
2000, - 0.1% (3)
(c) - 0.1% (3)
downloaded - 0.1% (3)
\g. - 0.1% (3)
hat - 0.1% (3)
+-----------------------------+--------------+ - 0.1% (3)
commands - 0.1% (3)
monitor. - 0.1% (3)
/system.slice/mssql-server.service - 0.1% (3)
welcome - 0.1% (3)
variables - 0.1% (3)
changed - 0.1% (3)
http://go.microsoft.com/fwlink/?linkid=746388 - 0.1% (3)
found - 0.1% (3)
/etc/systemd/system/multi-user.target.wants/mssql-server.service - 0.1% (3)
product - 0.1% (3)
+-------------------------+ - 0.1% (3)
copyright - 0.1% (3)
/usr/share/doc/mssql-server/license.txt. - 0.1% (3)
rights - 0.1% (3)
since - 0.1% (3)
names - 0.1% (3)
'help;' - 0.1% (3)
(running) - 0.1% (3)
'\h' - 0.1% (3)
preset: - 0.1% (3)
disabled) - 0.1% (3)
active: - 0.1% (3)
trademarks - 0.1% (3)
their - 0.1% (3)
owners. - 0.1% (3)
(sqlservr) - 0.1% (3)
cgroup: - 0.1% (3)
pid: - 0.1% (3)
main - 0.1% (3)
ago - 0.1% (3)
respective - 0.1% (3)
vendor - 0.1% (3)
enabled; - 0.1% (3)
mysql> - 0.1% (3)
(sa) - 0.1% (3)
corporation - 0.1% (3)
registered - 0.1% (3)
reserved. - 0.1% (3)
completed - 0.1% (3)
successfully. - 0.1% (3)
statement. - 0.1% (3)
input - 0.1% (3)
loaded: - 0.1% (3)
help. - 0.1% (3)
(/usr/lib/systemd/system/mssql-server.service; - 0.1% (3)
engine - 0.1% (3)
'\c' - 0.1% (3)
clear - 0.1% (3)
- 0.1% (3)
/usr/lib/systemd/system/mssql-server.service. - 0.1% (3)
errors - 0.1% (3)
apr - 0.1% (3)
security - 0.1% (3)
在mysql - 0.1% (3)
were - 0.1% (3)
kamus·comments - 0.1% (3)
life - 0.1% (3)
wordpress - 0.1% (3)
592 - 0.1% (3)
(hy000): - 0.1% (3)
1786 - 0.1% (3)
- 0.1% (3)
enforce_gtid_consistency=on - 0.1% (3)
cialisbuy - 0.1% (3)
onlinebuy - 0.1% (3)
ubuntu - 0.07% (2)
testdb; - 0.07% (2)
oracle11g - 0.07% (2)
levitrabuy - 0.07% (2)
enmo - 0.07% (2)
1433]. - 0.07% (2)
tech - 0.07% (2)
1434]. - 0.07% (2)
'password - 0.07% (2)
0.0.0.0 - 0.07% (2)
context - 0.07% (2)
sa' - 0.07% (2)
17:00:20.52 - 0.07% (2)
int, - 0.07% (2)
152; - 0.07% (2)
└─16166 - 0.07% (2)
154); - 0.07% (2)
'orange', - 0.07% (2)
├─16147 - 0.07% (2)
viagrabuy - 0.07% (2)
wordpress. - 0.07% (2)
- 0.07% (2)
onlineorder - 0.07% (2)
(2, - 0.07% (2)
150); - 0.07% (2)
hello - 0.07% (2)
(id - 0.07% (2)
search - 0.07% (2)
nvarchar(50), - 0.07% (2)
cialisgeneric - 0.07% (2)
'banana', - 0.07% (2)
(1, - 0.07% (2)
int); - 0.07% (2)
'testdb'. - 0.07% (2)
--help - 0.07% (2)
some - 0.07% (2)
hint: - 0.07% (2)
'tempdb'. - 0.07% (2)
在创建mysql - 0.07% (2)
lines - 0.07% (2)
17:00:20.86 - 0.07% (2)
full. - 0.07% (2)
ellipsized, - 0.07% (2)
message... - 0.07% (2)
complete. - 0.07% (2)
recovery - 0.07% (2)
17:00:21.05 - 0.07% (2)
mirroring - 0.07% (2)
ssh - 0.07% (2)
-uroot - 0.07% (2)
manager - 0.07% (2)
file(s). - 0.07% (2)
spid7s - 0.07% (2)
17:00:21.08 - 0.07% (2)
started. - 0.07% (2)
rss - 0.07% (2)
connections. - 0.07% (2)
established - 0.07% (2)
locally - 0.07% (2)
defaultdatadir - 0.07% (2)
1434. - 0.07% (2)
love - 0.07% (2)
options - 0.07% (2)
https://packages.microsoft.com/config/rhel/7/prod.repo - 0.07% (2)
[opc@mysql-cloud-mysql-1 - 0.07% (2)
dedicated - 0.07% (2)
defaultlogdir - 0.07% (2)
defaultdumpdir - 0.07% (2)
supported - 0.07% (2)
16558 - 0.07% (2)
microsoft(r) - 0.07% (2)
settings - 0.07% (2)
'set' - 0.07% (2)
defaultbackupdir - 0.07% (2)
tcpport - 0.07% (2)
option: - 0.07% (2)
/etc/yum.repos.d/msprod.repo - 0.07% (2)
wish - 0.07% (2)
--此时检查视图,可以发现集群中已经存在两个节点 - 0.07% (2)
(5.42 - 0.07% (2)
9003e830-08a3-11e7-8ae3-e62d2f6366d2 - 0.07% (2)
96fe2b5a-08a3-11e7-b383-d7f02f17e847 - 0.07% (2)
--group_replication_primary_member值为空,表示启动的是multi-primary - 0.07% (2)
24803 - 0.07% (2)
--设置update检查参数为on - 0.07% (2)
--同样设置单主模式参数为off - 0.07% (2)
'getstart - 0.07% (2)
group_id - 0.07% (2)
2017-03-16t02:04:32.689278z - 0.07% (2)
72ad2062-08a3-11e7-a513-5bfce171938d - 0.07% (2)
24801 - 0.07% (2)
mode,否则该参数显示的是单主模式中的primary节点 - 0.07% (2)
performance_schema.global_status - 0.07% (2)
port=24802 - 0.07% (2)
basedir=/usr/local/cellar/mysql/5.7.17 - 0.07% (2)
socket=/tmp/s2.sock - 0.07% (2)
parameters - 0.07% (2)
server_id=2 - 0.07% (2)
datadir=/users/kamus/mysql_data/s2 - 0.07% (2)
(0.01 - 0.07% (2)
variable_name='group_replication_primary_member'; - 0.07% (2)
monitor]$ - 0.07% (2)
variable_value - 0.07% (2)
-rw-r----- - 0.07% (2)
[mysqld] - 0.07% (2)
4317e324' - 0.07% (2)
--此时可以从视图中看到整个集群只有一个节点是online - 0.07% (2)
3093 - 0.07% (2)
conflict - 0.07% (2)
cannot - 0.07% (2)
elected, - 0.07% (2)
while - 0.07% (2)
--如果mgr已经启动,则无法动态修改该参数 - 0.07% (2)
detection - 0.07% (2)
--group_replication_single_primary_mode=on,表示启动了single-primary模式,那么修改为off就意味着要启动multi-primary模式。 - 0.07% (2)
mgr的方法。 - 0.07% (2)
applies - 0.07% (2)
'group_replication_single_primary_mode'; - 0.07% (2)
until - 0.07% (2)
running. - 0.07% (2)
--停止复制 - 0.07% (2)
2017-03-16t02:04:33.081743z - 0.07% (2)
'unsetting - 0.07% (2)
(1.29 - 0.07% (2)
--为了防止后续由于意外再启动另外一个复制组,关闭bootstrap参数 - 0.07% (2)
group_replication_bootstrap_group=off; - 0.07% (2)
group_replication_bootstrap_group=on; - 0.07% (2)
--设置为第一个准备启动mgr(bootstrap)的节点 - 0.07% (2)
(8.67 - 0.07% (2)
2017-03-16t02:04:33.081756z - 0.07% (2)
--设置单主模式参数为off - 0.07% (2)
--该参数设置为on,则禁用了在多主模式下一些可能产生未知数据冲突的操作 - 0.07% (2)
super_read_only.' - 0.07% (2)
gtid_mode=on - 0.07% (2)
master_info_repository=table - 0.07% (2)
key - 0.07% (2)
enabling - 0.07% (2)
boot... - 0.07% (2)
any - 0.07% (2)
warning - 0.07% (2)
server... - 0.07% (2)
1510011 - 0.07% (2)
flush - 0.07% (2)
tables: - 0.07% (2)
utf8mb4 - 0.07% (2)
[yes/no]:y - 0.07% (2)
unix - 0.07% (2)
server(r) - 0.07% (2)
--password - 0.07% (2)
17:00:17 - 0.07% (2)
thu - 0.07% (2)
cst; - 0.07% (2)
34s - 0.07% (2)
docs: - 0.07% (2)
[y/n]: - 0.07% (2)
logs' - 0.07% (2)
--host=localhost - 0.07% (2)
--user=root - 0.07% (2)
about - 0.07% (2)
account: - 0.07% (2)
[11:24:59:810] - 0.07% (2)
open - 0.07% (2)
queries - 0.07% (2)
loose-group_replication_local_address= - 0.07% (2)
loose-group_replication_start_on_boot=off - 0.07% (2)
"127.0.0.1:24902" - 0.07% (2)
loose-group_replication_group_seeds= - 0.07% (2)
"127.0.0.1:24901,127.0.0.1:24902,127.0.0.1:24903" - 0.07% (2)
loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" - 0.07% (2)
transaction_write_set_extraction=xxhash64 - 0.07% (2)
binlog_checksum=none - 0.07% (2)
relay_log_info_repository=table - 0.07% (2)
log_slave_updates=on - 0.07% (2)
log_bin=binlog - 0.07% (2)
binlog_format=row - 0.07% (2)
loose-group_replication_bootstrap_group= - 0.07% (2)
loose-group_replication_single_primary_mode=off - 0.07% (2)
https://packages.microsoft.com/config/rhel/7/mssql-server.repo - 0.07% (2)
audit_log_connection_policy - 0.07% (2)
/etc/yum.repos.d/mssql-server.repo - 0.07% (2)
第二步:通过yum安装 - 0.07% (2)
mem__instruments - 0.07% (2)
audit_log_file - 0.07% (2)
audit_log_policy - 0.07% (2)
public - 0.07% (2)
loose-group_replication_enforce_update_everywhere_checks=on - 0.07% (2)
preview - 0.07% (2)
release - 0.07% (2)
audit_log_rotate_on_size - 0.07% (2)
https://docs.microsoft.com/en-us/sql/linux - 0.07% (2)
sql server - 1.21% (36)
rows affected - 1.04% (31)
(root@localhost) [(none)]> - 0.94% (28)
(0.00 sec) - 0.74% (22)
query ok, - 0.7% (21)
0 rows - 0.67% (20)
opreative-server-3 sqlservr[16147]: - 0.67% (20)
11 17:00:20 - 0.67% (20)
11 17:00:21 - 0.67% (20)
sqlservr[16147]: 2017-05-11 - 0.67% (20)
may 11 - 0.67% (20)
set global - 0.5% (15)
[(none)]> set - 0.47% (14)
affected (0.00 - 0.44% (13)
in set - 0.34% (10)
rows affected) - 0.34% (10)
primary mode - 0.34% (10)
17:00:21 opreative-server-3 - 0.34% (10)
* from - 0.34% (10)
select * - 0.34% (10)
group replication - 0.34% (10)
root@localhost [testdb]> - 0.3% (9)
set (0.00 - 0.3% (9)
mysql enterprise - 0.27% (8)
microsoft sql - 0.27% (8)
| +---------------------------+--------------------------------------+-------------+-------------+--------------+ - 0.27% (8)
~]$ mysql - 0.27% (8)
+---------------------------+--------------------------------------+-------------+-------------+--------------+ | - 0.27% (8)
system administrator - 0.23% (7)
multi-primary mode - 0.23% (7)
[oracle@mysql-cloud-mysql-1 ~]$ - 0.23% (7)
server for - 0.23% (7)
cloud service - 0.23% (7)
| online - 0.2% (6)
row in - 0.2% (6)
and/or its - 0.2% (6)
the license - 0.2% (6)
license terms - 0.2% (6)
[(none)]> select - 0.2% (6)
1> select - 0.2% (6)
global group_replication_single_primary_mode=off; - 0.2% (6)
(1 rows - 0.2% (6)
[note] plugin - 0.2% (6)
create table - 0.2% (6)
server is - 0.2% (6)
its affiliates. - 0.2% (6)
group_replication reported: - 0.2% (6)
group_replication; query - 0.2% (6)
online | - 0.2% (6)
group_replication_applier | - 0.2% (6)
the new - 0.2% (6)
mysql cloud - 0.2% (6)
2017-05-11 17:00:21.03 - 0.2% (6)
2017-05-11 17:00:20.53 - 0.2% (6)
replication configuration - 0.2% (6)
| group_replication_applier - 0.2% (6)
[ec2-user@ip-172-31-11-228 ~]$ - 0.2% (6)
plugin group_replication - 0.2% (6)
affected) 1> - 0.2% (6)
variable_name | - 0.17% (5)
value | - 0.17% (5)
buy cheap - 0.17% (5)
oracle mysql - 0.17% (5)
do you - 0.17% (5)
of the - 0.17% (5)
sec) root@localhost - 0.17% (5)
enterprise server - 0.17% (5)
| variable_name - 0.17% (5)
[(none)]> start - 0.13% (4)
--启动复制 (root@localhost) - 0.13% (4)
global group_replication_enforce_update_everywhere_checks=on; - 0.13% (4)
from sys.databases; - 0.13% (4)
select name - 0.13% (4)
group_replication_single_primary_mode=off; query - 0.13% (4)
| member_port - 0.13% (4)
| member_id - 0.13% (4)
from performance_schema.replication_group_members; - 0.13% (4)
| member_host - 0.13% (4)
service broker - 0.13% (4)
name -------------------------------------------------------------------------------------------------------------------------------- - 0.13% (4)
into inventory - 0.13% (4)
| member_state - 0.13% (4)
group_replication_enforce_update_everywhere_checks=on; query - 0.13% (4)
sec) --启动复制 - 0.13% (4)
performance_schema.replication_group_members; +---------------------------+--------------------------------------+-------------+-------------+--------------+ - 0.13% (4)
an informational - 0.13% (4)
start group_replication; - 0.13% (4)
| channel_name - 0.13% (4)
+----------+ | - 0.13% (4)
| bogon - 0.13% (4)
0 [note] - 0.13% (4)
master tempdb - 0.13% (4)
+----------------------------------------------------+-------------------------------------------------+ | - 0.13% (4)
model msdb - 0.13% (4)
this is - 0.13% (4)
| +----------------------------------------------------+-------------------------------------------------+ - 0.13% (4)
1> create - 0.13% (4)
new primary - 0.13% (4)
17:00:21.03 spid22s - 0.13% (4)
connection id - 0.13% (4)
5.7.17-enterprise-commercial-advanced-log mysql - 0.13% (4)
server version: - 0.13% (4)
edition (commercial) - 0.13% (4)
# group - 0.13% (4)
buy generic - 0.13% (4)
administrator password: - 0.13% (4)
server system - 0.13% (4)
~]$ sudo - 0.13% (4)
rows in - 0.13% (4)
created symlink - 0.13% (4)
yum install - 0.13% (4)
new sql - 0.13% (4)
symlink from - 0.13% (4)
server - - 0.13% (4)
version: 5.7.17-enterprise-commercial-advanced-log - 0.13% (4)
member_port | - 0.13% (4)
member_state | - 0.13% (4)
characterset: utf8 - 0.13% (4)
member_host | - 0.13% (4)
channel_name | - 0.13% (4)
member_id | - 0.13% (4)
bogon | - 0.13% (4)
stopped state. - 0.13% (4)
is listening - 0.13% (4)
advanced edition - 0.13% (4)
- advanced - 0.13% (4)
# server - 0.13% (4)
disabled or - 0.13% (4)
| +----------------------------------+----------------+ - 0.13% (4)
/etc/systemd/system/multi-user.target.wants/mssql-server.service to - 0.1% (3)
from /etc/systemd/system/multi-user.target.wants/mssql-server.service - 0.1% (3)
to /usr/lib/systemd/system/mssql-server.service. - 0.1% (3)
preset: disabled) - 0.1% (3)
http://go.microsoft.com/fwlink/?linkid=746388 and - 0.1% (3)
downloaded from - 0.1% (3)
server to - 0.1% (3)
you accept - 0.1% (3)
(running) since - 0.1% (3)
can be - 0.1% (3)
enabled; vendor - 0.1% (3)
terms for - 0.1% (3)
this product - 0.1% (3)
engine loaded: - 0.1% (3)
loaded (/usr/lib/systemd/system/mssql-server.service; - 0.1% (3)
setup completed - 0.1% (3)
mssql-server ● - 0.1% (3)
loaded: loaded - 0.1% (3)
server vnext - 0.1% (3)
database engine - 0.1% (3)
● mssql-server.service - 0.1% (3)
(/usr/lib/systemd/system/mssql-server.service; enabled; - 0.1% (3)
vendor preset: - 0.1% (3)
generic cialisbuy - 0.1% (3)
(sqlservr) cgroup: - 0.1% (3)
active (running) - 0.1% (3)
disabled) active: - 0.1% (3)
status mssql-server - 0.1% (3)
for this - 0.1% (3)
accept the - 0.1% (3)
license terms? - 0.1% (3)
administrator (sa) - 0.1% (3)
confirm the - 0.1% (3)
in /usr/share/doc/mssql-server/license.txt. - 0.1% (3)
and found - 0.1% (3)
systemctl status - 0.1% (3)
product can - 0.1% (3)
be downloaded - 0.1% (3)
completed successfully. - 0.1% (3)
active: active - 0.1% (3)
mysql connection - 0.1% (3)
\g. your - 0.1% (3)
(commercial) copyright - 0.1% (3)
(c) 2000, - 0.1% (3)
affiliates. all - 0.1% (3)
2016, oracle - 0.1% (3)
end with - 0.1% (3)
monitor. commands - 0.1% (3)
~]$ mysql_config_editor - 0.1% (3)
current input - 0.1% (3)
enter password: - 0.1% (3)
welcome to - 0.1% (3)
the mysql - 0.1% (3)
rights reserved. - 0.1% (3)
a registered - 0.1% (3)
or '\h' - 0.1% (3)
type 'help;' - 0.1% (3)
for help. - 0.1% (3)
type '\c' - 0.1% (3)
the current - 0.1% (3)
to clear - 0.1% (3)
respective owners. - 0.1% (3)
of their - 0.1% (3)
oracle corporation - 0.1% (3)
trademark of - 0.1% (3)
affiliates. other - 0.1% (3)
names may - 0.1% (3)
be trademarks - 0.1% (3)
clear the - 0.1% (3)
'\c' to - 0.1% (3)
with ; - 0.1% (3)
commands end - 0.1% (3)
or \g. - 0.1% (3)
your mysql - 0.1% (3)
2000, 2016, - 0.1% (3)
copyright (c) - 0.1% (3)
mysql monitor. - 0.1% (3)
to the - 0.1% (3)
vnext on - 0.1% (3)
buy levitra - 0.1% (3)
enterprise audit - 0.1% (3)
by kamus·comments - 0.1% (3)
off on - 0.1% (3)
oracle and/or - 0.1% (3)
all rights - 0.1% (3)
owners. type - 0.1% (3)
their respective - 0.1% (3)
'help;' or - 0.1% (3)
'\h' for - 0.1% (3)
help. type - 0.1% (3)
trademarks of - 0.1% (3)
may be - 0.1% (3)
registered trademark - 0.1% (3)
reserved. oracle - 0.1% (3)
of oracle - 0.1% (3)
corporation and/or - 0.1% (3)
other names - 0.1% (3)
input statement. - 0.1% (3)
oracle is - 0.1% (3)
show variables - 0.1% (3)
variables like - 0.1% (3)
| value - 0.1% (3)
from information_schema.tables; - 0.1% (3)
[(none)]> show - 0.1% (3)
1> use - 0.07% (2)
testdb 2> - 0.07% (2)
go changed - 0.07% (2)
you wish - 0.07% (2)
database context - 0.07% (2)
testdb (5 - 0.07% (2)
create database - 0.07% (2)
(4 rows - 0.07% (2)
testdb; 2> - 0.07% (2)
to start - 0.07% (2)
sa' 1> - 0.07% (2)
account: [11:24:59:810] - 0.07% (2)
~]# systemctl - 0.07% (2)
were ellipsized, - 0.07% (2)
inventory where - 0.07% (2)
affected) (1 - 0.07% (2)
some lines - 0.07% (2)
action is - 0.07% (2)
required. hint: - 0.07% (2)
quantity > - 0.07% (2)
152; 2> - 0.07% (2)
'password of - 0.07% (2)
in full. - 0.07% (2)
to show - 0.07% (2)
use -l - 0.07% (2)
- microsoft - 0.07% (2)
[y/n]: y - 0.07% (2)
password for - 0.07% (2)
defaultbackupdir defaultdumpdir - 0.07% (2)
option: tcpport - 0.07% (2)
----------- 2 - 0.07% (2)
----------- -------------------------------------------------- - 0.07% (2)
name quantity - 0.07% (2)
orange 154 - 0.07% (2)
the 'set' - 0.07% (2)
password: confirm - 0.07% (2)
list supported - 0.07% (2)
password: starting - 0.07% (2)
settings using - 0.07% (2)
server... enabling - 0.07% (2)
run at - 0.07% (2)
defaultlogdir defaultdatadir - 0.07% (2)
-y mssql-tools - 0.07% (2)
> /etc/yum.repos.d/msprod.repo - 0.07% (2)
sqlcmd -s - 0.07% (2)
since thu - 0.07% (2)
localhost -u - 0.07% (2)
/usr/lib/systemd/system/mssql-server.service. setup - 0.07% (2)
microsoft(r) sql - 0.07% (2)
command line - 0.07% (2)
for all - 0.07% (2)
options use - 0.07% (2)
boot... created - 0.07% (2)
https://packages.microsoft.com/config/rhel/7/prod.repo > - 0.07% (2)
the system - 0.07% (2)
cst; 34s - 0.07% (2)
manager has - 0.07% (2)
informational message... - 0.07% (2)
required. may - 0.07% (2)
2017-05-11 17:00:20.86 - 0.07% (2)
up database - 0.07% (2)
spid11s starting - 0.07% (2)
connections. this - 0.07% (2)
started. may - 0.07% (2)
sudo /opt/mssql/bin/mssql-conf - 0.07% (2)
spid18s sql - 0.07% (2)
name nvarchar(50), - 0.07% (2)
now ready - 0.07% (2)
for client - 0.07% (2)
'tempdb'. may - 0.07% (2)
quantity int); - 0.07% (2)
broker endpoint - 0.07% (2)
the service - 0.07% (2)
values (1, - 0.07% (2)
'banana', 150); - 0.07% (2)
values (2, - 0.07% (2)
2> insert - 0.07% (2)
the database - 0.07% (2)
mirroring endpoint - 0.07% (2)
spid11s the - 0.07% (2)
1> insert - 0.07% (2)
tempdb database - 0.07% (2)
data file(s). - 0.07% (2)
17:00:21.05 spid22s - 0.07% (2)
1434. may - 0.07% (2)
on port - 0.07% (2)
/opt/mssql/bin/sqlservr may - 0.07% (2)
/opt/mssql/bin/sqlservr └─16166 - 0.07% (2)
to 'testdb'. - 0.07% (2)
table inventory - 0.07% (2)
spid18s server - 0.07% (2)
2017-05-11 17:00:20.52 - 0.07% (2)
/system.slice/mssql-server.service ├─16147 - 0.07% (2)
message only. - 0.07% (2)
ago docs: - 0.07% (2)
'orange', 154); - 0.07% (2)
https://docs.microsoft.com/en-us/sql/linux main - 0.07% (2)
pid: 16147 - 0.07% (2)
no user - 0.07% (2)
is complete. - 0.07% (2)
0.0.0.0 - 0.07% (2)
admin connection - 0.07% (2)
server dedicated - 0.07% (2)
support was - 0.07% (2)
established for - 0.07% (2)
listening locally - 0.07% (2)
1434]. may - 0.07% (2)
127.0.0.1 - 0.07% (2)
spid7s recovery - 0.07% (2)
1433]. may - 0.07% (2)
(id int, - 0.07% (2)
2017-05-11 17:00:21.08 - 0.07% (2)
server server - 0.07% (2)
2017-05-11 17:00:17 - 0.07% (2)
socket=/tmp/s2.sock # - 0.07% (2)
--设置单主模式参数为off (root@localhost) - 0.07% (2)
(8.67 sec) - 0.07% (2)
[(none)]> stop - 0.07% (2)
--停止复制 (root@localhost) - 0.07% (2)
sec) --该参数设置为on,则禁用了在多主模式下一些可能产生未知数据冲突的操作 - 0.07% (2)
--设置为第一个准备启动mgr(bootstrap)的节点 (root@localhost) - 0.07% (2)
sec) --为了防止后续由于意外再启动另外一个复制组,关闭bootstrap参数 - 0.07% (2)
affected (1.29 - 0.07% (2)
global group_replication_bootstrap_group=on; - 0.07% (2)
is running. - 0.07% (2)
mode while - 0.07% (2)
--如果mgr已经启动,则无法动态修改该参数 (root@localhost) - 0.07% (2)
| group_replication_single_primary_mode - 0.07% (2)
'group_replication_single_primary_mode'; +----------------------------------------------------+-------------------------------------------------+ - 0.07% (2)
error 3093 - 0.07% (2)
(hy000): cannot - 0.07% (2)
single primary - 0.07% (2)
or from - 0.07% (2)
change into - 0.07% (2)
group_replication_bootstrap_group=off; query - 0.07% (2)
--此时可以从视图中看到整个集群只有一个节点是online (root@localhost) - 0.07% (2)
stop group_replication; - 0.07% (2)
running. --停止复制 - 0.07% (2)
replication is - 0.07% (2)
while group - 0.07% (2)
affected (8.67 - 0.07% (2)
sec) --设置单主模式参数为off - 0.07% (2)
group_replication_bootstrap_group=on; query - 0.07% (2)
sec) --设置为第一个准备启动mgr(bootstrap)的节点 - 0.07% (2)
--该参数设置为on,则禁用了在多主模式下一些可能产生未知数据冲突的操作 (root@localhost) - 0.07% (2)
from single - 0.07% (2)
into or - 0.07% (2)
like 'group_replication_single_primary_mode'; - 0.07% (2)
| 24801 - 0.07% (2)
| 72ad2062-08a3-11e7-a513-5bfce171938d - 0.07% (2)
group_replication_single_primary_mode | - 0.07% (2)
+----------------------------------------------------+-------------------------------------------------+ --如果mgr已经启动,则无法动态修改该参数 - 0.07% (2)
cannot change - 0.07% (2)
3093 (hy000): - 0.07% (2)
group_replication_single_primary_mode=off; error - 0.07% (2)
--group_replication_single_primary_mode=on,表示启动了single-primary模式,那么修改为off就意味着要启动multi-primary模式。 (root@localhost) - 0.07% (2)
all relay - 0.07% (2)
| +-------------------------+ - 0.07% (2)
mysql welcome - 0.07% (2)
characterset: utf8mb4 - 0.07% (2)
--user=root --password - 0.07% (2)
| mem__instruments - 0.07% (2)
[testdb]> show - 0.07% (2)
1 oracle - 0.07% (2)
set (0.01 - 0.07% (2)
+-----------------------------+--------------+ | - 0.07% (2)
set --host=localhost - 0.07% (2)
--password enter - 0.07% (2)
audit in - 0.07% (2)
in oracle - 0.07% (2)
onlinebuy cialis - 0.07% (2)
-uroot -p - 0.07% (2)
mysql -uroot - 0.07% (2)
--host=localhost --user=root - 0.07% (2)
mysql_config_editor set - 0.07% (2)
statement. mysql> - 0.07% (2)
-rw-r----- 1 - 0.07% (2)
oracle oracle - 0.07% (2)
28 [note] - 0.07% (2)
super_read_only.' 2017-03-16t02:04:33.081756z - 0.07% (2)
reported: 'unsetting - 0.07% (2)
4317e324' 2017-03-16t02:04:33.081743z - 0.07% (2)
reported: 'a - 0.07% (2)
was elected, - 0.07% (2)
primary applies - 0.07% (2)
detection until - 0.07% (2)
enabled conflict - 0.07% (2)
'getstart group_id - 0.07% (2)
2017-03-16t02:04:32.689278z 0 - 0.07% (2)
select count(*) - 0.07% (2)
table mytables - 0.07% (2)
[testdb]> create - 0.07% (2)
count(*) | - 0.07% (2)
+----------+ 1 - 0.07% (2)
into multi-primary - 0.07% (2)
set mysql - 0.07% (2)
how to - 0.07% (2)
(1.29 sec) - 0.07% (2)
--为了防止后续由于意外再启动另外一个复制组,关闭bootstrap参数 (root@localhost) - 0.07% (2)
# loose-group_replication_single_primary_mode=off - 0.07% (2)
mode ## - 0.07% (2)
configuration multi-primary - 0.07% (2)
loose-group_replication_bootstrap_group= off - 0.07% (2)
# loose-group_replication_enforce_update_everywhere_checks=on - 0.07% (2)
public preview - 0.07% (2)
enterprise linux - 0.07% (2)
of sql - 0.07% (2)
next release - 0.07% (2)
loose-group_replication_group_seeds= "127.0.0.1:24901,127.0.0.1:24902,127.0.0.1:24903" - 0.07% (2)
loose-group_replication_local_address= "127.0.0.1:24902" - 0.07% (2)
enforce_gtid_consistency=on master_info_repository=table - 0.07% (2)
server_id=2 gtid_mode=on - 0.07% (2)
parameters # - 0.07% (2)
relay_log_info_repository=table binlog_checksum=none - 0.07% (2)
log_slave_updates=on log_bin=binlog - 0.07% (2)
loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" loose-group_replication_start_on_boot=off - 0.07% (2)
# transaction_write_set_extraction=xxhash64 - 0.07% (2)
binlog_format=row # - 0.07% (2)
hat enterprise - 0.07% (2)
https://packages.microsoft.com/config/rhel/7/mssql-server.repo > - 0.07% (2)
at boot... - 0.07% (2)
to run - 0.07% (2)
enabling microsoft - 0.07% (2)
sql server... - 0.07% (2)
/opt/mssql/bin/mssql-conf setup - 0.07% (2)
found in - 0.07% (2)
setting up - 0.07% (2)
terms? [yes/no]:y - 0.07% (2)
/usr/share/doc/mssql-server/license.txt. do - 0.07% (2)
starting microsoft - 0.07% (2)
enter the - 0.07% (2)
-y mssql-server - 0.07% (2)
第二步:通过yum安装 sudo - 0.07% (2)
> /etc/yum.repos.d/mssql-server.repo - 0.07% (2)
~]# /opt/mssql/bin/mssql-conf - 0.07% (2)
setup the - 0.07% (2)
up microsoft - 0.07% (2)
[yes/no]:y setting - 0.07% (2)
from http://go.microsoft.com/fwlink/?linkid=746388 - 0.07% (2)
port=24802 socket=/tmp/s2.sock - 0.07% (2)
datadir=/users/kamus/mysql_data/s2 basedir=/usr/local/cellar/mysql/5.7.17 - 0.07% (2)
24803 | - 0.07% (2)
localhost | - 0.07% (2)
96fe2b5a-08a3-11e7-b383-d7f02f17e847 | - 0.07% (2)
| 24802 - 0.07% (2)
+---------------------------+--------------------------------------+-------------+-------------+--------------+ 2 - 0.07% (2)
sec) --group_replication_primary_member值为空,表示启动的是multi-primary - 0.07% (2)
variable_name='group_replication_primary_member'; +----------------------------------+----------------+ - 0.07% (2)
performance_schema.global_status where - 0.07% (2)
mode,否则该参数显示的是单主模式中的primary节点 (root@localhost) - 0.07% (2)
| 9003e830-08a3-11e7-8ae3-e62d2f6366d2 - 0.07% (2)
--此时检查视图,可以发现集群中已经存在两个节点 (root@localhost) - 0.07% (2)
72ad2062-08a3-11e7-a513-5bfce171938d | - 0.07% (2)
sec) --此时可以从视图中看到整个集群只有一个节点是online - 0.07% (2)
global group_replication_bootstrap_group=off; - 0.07% (2)
24801 | - 0.07% (2)
+---------------------------+--------------------------------------+-------------+-------------+--------------+ 1 - 0.07% (2)
(5.42 sec) - 0.07% (2)
sec) --设置update检查参数为on - 0.07% (2)
--同样设置单主模式参数为off (root@localhost) - 0.07% (2)
| variable_value - 0.07% (2)
| group_replication_primary_member - 0.07% (2)
loose-group_replication_start_on_boot=off loose-group_replication_local_address= - 0.07% (2)
transaction_write_set_extraction=xxhash64 loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" - 0.07% (2)
configuration # - 0.07% (2)
- 0.07% (2)
- 0.07% (2)
server configuration - 0.07% (2)
loose-group_replication_single_primary_mode=off # - 0.07% (2)
## group - 0.07% (2)
log_bin=binlog binlog_format=row - 0.07% (2)
binlog_checksum=none log_slave_updates=on - 0.07% (2)
basedir=/usr/local/cellar/mysql/5.7.17 port=24802 - 0.07% (2)
configuration datadir=/users/kamus/mysql_data/s2 - 0.07% (2)
+----------------------------------+----------------+ 1 - 0.07% (2)
# replication - 0.07% (2)
configuration parameters - 0.07% (2)
master_info_repository=table relay_log_info_repository=table - 0.07% (2)
gtid_mode=on enforce_gtid_consistency=on - 0.07% (2)
# server_id=2 - 0.07% (2)
server enter - 0.07% (2)
query ok, 0 - 0.67% (20)
ok, 0 rows - 0.67% (20)
opreative-server-3 sqlservr[16147]: 2017-05-11 - 0.67% (20)
0 rows affected - 0.67% (20)
[(none)]> set global - 0.47% (14)
(root@localhost) [(none)]> set - 0.47% (14)
affected (0.00 sec) - 0.44% (13)
rows affected (0.00 - 0.44% (13)
11 17:00:21 opreative-server-3 - 0.34% (10)
may 11 17:00:21 - 0.34% (10)
17:00:21 opreative-server-3 sqlservr[16147]: - 0.34% (10)
11 17:00:20 opreative-server-3 - 0.34% (10)
17:00:20 opreative-server-3 sqlservr[16147]: - 0.34% (10)
may 11 17:00:20 - 0.34% (10)
select * from - 0.34% (10)
set (0.00 sec) - 0.3% (9)
microsoft sql server - 0.27% (8)
in set (0.00 - 0.27% (8)
server for linux - 0.23% (7)
[oracle@mysql-cloud-mysql-1 ~]$ mysql - 0.23% (7)
sql server for - 0.23% (7)
and/or its affiliates. - 0.2% (6)
[(none)]> select * - 0.2% (6)
(root@localhost) [(none)]> select - 0.2% (6)
| group_replication_applier | - 0.2% (6)
the license terms - 0.2% (6)
row in set - 0.2% (6)
sqlservr[16147]: 2017-05-11 17:00:20.53 - 0.2% (6)
| online | - 0.2% (6)
[note] plugin group_replication - 0.2% (6)
(1 rows affected) - 0.2% (6)
plugin group_replication reported: - 0.2% (6)
set global group_replication_single_primary_mode=off; - 0.2% (6)
rows affected) 1> - 0.2% (6)
| variable_name | - 0.17% (5)
oracle mysql cloud - 0.17% (5)
+---------------------------+--------------------------------------+-------------+-------------+--------------+ | channel_name - 0.13% (4)
| member_state | - 0.13% (4)
name -------------------------------------------------------------------------------------------------------------------------------- master - 0.13% (4)
| member_id | - 0.13% (4)
member_host | member_port - 0.13% (4)
* from performance_schema.replication_group_members; - 0.13% (4)
1> select name - 0.13% (4)
sys.databases; 2> go - 0.13% (4)
group_replication_single_primary_mode=off; query ok, - 0.13% (4)
go name -------------------------------------------------------------------------------------------------------------------------------- - 0.13% (4)
master tempdb model - 0.13% (4)
insert into inventory - 0.13% (4)
from sys.databases; 2> - 0.13% (4)
name from sys.databases; - 0.13% (4)
sec) --启动复制 (root@localhost) - 0.13% (4)
[(none)]> start group_replication; - 0.13% (4)
-------------------------------------------------------------------------------------------------------------------------------- master tempdb - 0.13% (4)
2> go name - 0.13% (4)
global group_replication_enforce_update_everywhere_checks=on; query - 0.13% (4)
tempdb model msdb - 0.13% (4)
| member_port | - 0.13% (4)
server system administrator - 0.13% (4)
new sql server - 0.13% (4)
system administrator password: - 0.13% (4)
the new sql - 0.13% (4)
yum install -y - 0.13% (4)
server is listening - 0.13% (4)
group replication configuration - 0.13% (4)
an informational message - 0.13% (4)
state. may 11 - 0.13% (4)
disabled or stopped - 0.13% (4)
2017-05-11 17:00:20.53 server - 0.13% (4)
is listening on - 0.13% (4)
listening on [ - 0.13% (4)
sql server system - 0.13% (4)
2017-05-11 17:00:21.03 spid22s - 0.13% (4)
endpoint is in - 0.13% (4)
created symlink from - 0.13% (4)
this is an - 0.13% (4)
17:00:21.03 spid22s the - 0.13% (4)
| channel_name | - 0.13% (4)
member_id | member_host - 0.13% (4)
member_state | +---------------------------+--------------------------------------+-------------+-------------+--------------+ - 0.13% (4)
from performance_schema.replication_group_members; +---------------------------+--------------------------------------+-------------+-------------+--------------+ - 0.13% (4)
start group_replication; query - 0.13% (4)
group_replication_enforce_update_everywhere_checks=on; query ok, - 0.13% (4)
--启动复制 (root@localhost) [(none)]> - 0.13% (4)
online | +---------------------------+--------------------------------------+-------------+-------------+--------------+ - 0.13% (4)
or stopped state. - 0.13% (4)
member_port | member_state - 0.13% (4)
| +---------------------------+--------------------------------------+-------------+-------------+--------------+ | - 0.13% (4)
| bogon | - 0.13% (4)
| member_host | - 0.13% (4)
channel_name | member_id - 0.13% (4)
is in disabled - 0.13% (4)
performance_schema.replication_group_members; +---------------------------+--------------------------------------+-------------+-------------+--------------+ | - 0.13% (4)
select name from - 0.13% (4)
+---------------------------+--------------------------------------+-------------+-------------+--------------+ | group_replication_applier - 0.13% (4)
5.7.17-enterprise-commercial-advanced-log mysql enterprise - 0.13% (4)
server - advanced - 0.13% (4)
rows in set - 0.13% (4)
enterprise server - - 0.13% (4)
version: 5.7.17-enterprise-commercial-advanced-log mysql - 0.13% (4)
server version: 5.7.17-enterprise-commercial-advanced-log - 0.13% (4)
mysql enterprise server - 0.13% (4)
- advanced edition - 0.13% (4)
into inventory values - 0.13% (4)
advanced edition (commercial) - 0.13% (4)
welcome to the - 0.1% (3)
(sqlservr) cgroup: /system.slice/mssql-server.service - 0.1% (3)
active: active (running) - 0.1% (3)
mysql monitor. commands - 0.1% (3)
end with ; - 0.1% (3)
by kamus·comments off - 0.1% (3)
mysql connection id - 0.1% (3)
vendor preset: disabled) - 0.1% (3)
loaded (/usr/lib/systemd/system/mssql-server.service; enabled; - 0.1% (3)
license terms for - 0.1% (3)
this product can - 0.1% (3)
the current input - 0.1% (3)
[oracle@mysql-cloud-mysql-1 ~]$ mysql_config_editor - 0.1% (3)
database engine loaded: - 0.1% (3)
systemctl status mssql-server - 0.1% (3)
copyright (c) 2000, - 0.1% (3)
2016, oracle and/or - 0.1% (3)
or '\h' for - 0.1% (3)
owners. type 'help;' - 0.1% (3)
help. type '\c' - 0.1% (3)
to clear the - 0.1% (3)
variable_name | value - 0.1% (3)
current input statement. - 0.1% (3)
of their respective - 0.1% (3)
may be trademarks - 0.1% (3)
rights reserved. oracle - 0.1% (3)
its affiliates. all - 0.1% (3)
is a registered - 0.1% (3)
trademark of oracle - 0.1% (3)
affiliates. other names - 0.1% (3)
corporation and/or its - 0.1% (3)
be downloaded from - 0.1% (3)
http://go.microsoft.com/fwlink/?linkid=746388 and found - 0.1% (3)
from /etc/systemd/system/multi-user.target.wants/mssql-server.service to - 0.1% (3)
administrator (sa) account - 0.1% (3)
mysql group replication - 0.1% (3)
(commercial) copyright (c) - 0.1% (3)
2000, 2016, oracle - 0.1% (3)
do you accept - 0.1% (3)
the license terms? - 0.1% (3)
mssql-server ● mssql-server.service - 0.1% (3)
loaded: loaded (/usr/lib/systemd/system/mssql-server.service; - 0.1% (3)
the mysql monitor. - 0.1% (3)
server vnext on - 0.1% (3)
commands end with - 0.1% (3)
your mysql connection - 0.1% (3)
enabled; vendor preset: - 0.1% (3)
disabled) active: active - 0.1% (3)
all rights reserved. - 0.1% (3)
can be downloaded - 0.1% (3)
respective owners. type - 0.1% (3)
trademarks of their - 0.1% (3)
'help;' or '\h' - 0.1% (3)
for help. type - 0.1% (3)
'\c' to clear - 0.1% (3)
you accept the - 0.1% (3)
names may be - 0.1% (3)
its affiliates. other - 0.1% (3)
oracle is a - 0.1% (3)
for this product - 0.1% (3)
/etc/systemd/system/multi-user.target.wants/mssql-server.service to /usr/lib/systemd/system/mssql-server.service. - 0.1% (3)
registered trademark of - 0.1% (3)
sql server to - 0.1% (3)
oracle corporation and/or - 0.1% (3)
show variables like - 0.1% (3)
or \g. your - 0.1% (3)
oracle and/or its - 0.1% (3)
affiliates. all rights - 0.1% (3)
reserved. oracle is - 0.1% (3)
a registered trademark - 0.1% (3)
(c) 2000, 2016, - 0.1% (3)
edition (commercial) copyright - 0.1% (3)
with ; or - 0.1% (3)
\g. your mysql - 0.1% (3)
connection id is - 0.1% (3)
of oracle corporation - 0.1% (3)
other names may - 0.1% (3)
(0.00 sec) root@localhost - 0.1% (3)
| value | - 0.1% (3)
group replication in - 0.1% (3)
clear the current - 0.1% (3)
type '\c' to - 0.1% (3)
be trademarks of - 0.1% (3)
their respective owners. - 0.1% (3)
type 'help;' or - 0.1% (3)
monitor. commands end - 0.1% (3)
'\h' for help. - 0.1% (3)
to the mysql - 0.1% (3)
inventory values (1, - 0.07% (2)
inventory values (2, - 0.07% (2)
'banana', 150); 2> - 0.07% (2)
1> insert into - 0.07% (2)
the service broker - 0.07% (2)
name nvarchar(50), quantity - 0.07% (2)
int); 2> go - 0.07% (2)
'orange', 154); 3> - 0.07% (2)
* from inventory - 0.07% (2)
(1, 'banana', 150); - 0.07% (2)
1> select * - 0.07% (2)
has 1 data - 0.07% (2)
file(s). may 11 - 0.07% (2)
154); 3> go - 0.07% (2)
inventory (id int, - 0.07% (2)
values (2, 'orange', - 0.07% (2)
2> insert into - 0.07% (2)
the database mirroring - 0.07% (2)
model msdb testdb - 0.07% (2)
affected) (1 rows - 0.07% (2)
msdb testdb (5 - 0.07% (2)
sqlservr[16147]: 2017-05-11 17:00:21.08 - 0.07% (2)
-s localhost -u - 0.07% (2)
complete. this is - 0.07% (2)
spid7s recovery is - 0.07% (2)
go (1 rows - 0.07% (2)
use testdb 2> - 0.07% (2)
context to 'testdb'. - 0.07% (2)
1> create table - 0.07% (2)
2017-05-11 17:00:21.05 spid22s - 0.07% (2)
service broker manager - 0.07% (2)
go changed database - 0.07% (2)
has started. may - 0.07% (2)
from inventory where - 0.07% (2)
the tempdb database - 0.07% (2)
support was established - 0.07% (2)
dedicated admin connection - 0.07% (2)
database context to - 0.07% (2)
affected) 1> create - 0.07% (2)
msdb (4 rows - 0.07% (2)
for listening locally - 0.07% (2)
'password of sa' - 0.07% (2)
database testdb; 2> - 0.07% (2)
1434]. may 11 - 0.07% (2)
2 orange 154 - 0.07% (2)
go 1> insert - 0.07% (2)
17:00:20.53 server server - 0.07% (2)
int, name nvarchar(50), - 0.07% (2)
[ 127.0.0.1 - 0.07% (2)
go 1> select - 0.07% (2)
on port 1434. - 0.07% (2)
sqlcmd -s localhost - 0.07% (2)
starting up database - 0.07% (2)
2017-05-11 17:00:20.86 spid11s - 0.07% (2)
name quantity ----------- - 0.07% (2)
'tempdb'. may 11 - 0.07% (2)
2> go changed - 0.07% (2)
quantity > 152; - 0.07% (2)
2017-05-11 17:00:21.03 spid11s - 0.07% (2)
required. may 11 - 0.07% (2)
an informational message... - 0.07% (2)
orange 154 (1 - 0.07% (2)
17:00:20.53 spid18s sql - 0.07% (2)
server is now - 0.07% (2)
-------------------------------------------------- ----------- 2 - 0.07% (2)
connections. this is - 0.07% (2)
ready for client - 0.07% (2)
[ec2-user@ip-172-31-11-228 ~]$ sqlcmd - 0.07% (2)
only. no user - 0.07% (2)
service broker endpoint - 0.07% (2)
quantity int); 2> - 0.07% (2)
the 'set' option: - 0.07% (2)
supported settings using - 0.07% (2)
sudo /opt/mssql/bin/mssql-conf list - 0.07% (2)
'testdb'. 1> create - 0.07% (2)
1> use testdb - 0.07% (2)
1 data file(s). - 0.07% (2)
tempdb database has - 0.07% (2)
informational message... required. - 0.07% (2)
tcpport defaultbackupdir defaultdumpdir - 0.07% (2)
17:00:20.86 spid11s starting - 0.07% (2)
up database 'tempdb'. - 0.07% (2)
17:00:21.03 spid11s the - 0.07% (2)
testdb; 2> go - 0.07% (2)
1> create database - 0.07% (2)
(4 rows affected) - 0.07% (2)
is required. hint: - 0.07% (2)
(5 rows affected) - 0.07% (2)
table inventory (id - 0.07% (2)
no user action - 0.07% (2)
started. may 11 - 0.07% (2)
recovery is complete. - 0.07% (2)
2017-05-11 17:00:21.08 spid7s - 0.07% (2)
of sa' 1> - 0.07% (2)
some lines were - 0.07% (2)
to show in - 0.07% (2)
microsoft(r) sql server(r) - 0.07% (2)
database mirroring endpoint - 0.07% (2)
ellipsized, use -l - 0.07% (2)
broker manager has - 0.07% (2)
17:00:21.05 spid22s service - 0.07% (2)
for client connections. - 0.07% (2)
is now ready - 0.07% (2)
sa -p 'password - 0.07% (2)
options use -h - 0.07% (2)
id name quantity - 0.07% (2)
all command line - 0.07% (2)
since thu 2017-05-11 - 0.07% (2)
ago docs: https://docs.microsoft.com/en-us/sql/linux - 0.07% (2)
17:00:17 cst; 34s - 0.07% (2)
curl https://packages.microsoft.com/config/rhel/7/prod.repo > - 0.07% (2)
● mssql-server.service - - 0.07% (2)
action is required. - 0.07% (2)
----------- -------------------------------------------------- ----------- - 0.07% (2)
hint: some lines - 0.07% (2)
were ellipsized, use - 0.07% (2)
affected) 1> select - 0.07% (2)
-l to show - 0.07% (2)
main pid: 16147 - 0.07% (2)
defaultlogdir defaultdatadir for - 0.07% (2)
admin connection support - 0.07% (2)
17:00:20.53 server dedicated - 0.07% (2)
127.0.0.1 1434]. - 0.07% (2)
was established for - 0.07% (2)
listening locally on - 0.07% (2)
spid18s sql server - 0.07% (2)
port 1434. may - 0.07% (2)
server server is - 0.07% (2)
where quantity > - 0.07% (2)
/opt/mssql/bin/sqlservr may 11 - 0.07% (2)
├─16147 /opt/mssql/bin/sqlservr └─16166 - 0.07% (2)
2017-05-11 17:00:20.52 spid18s - 0.07% (2)
152; 2> go - 0.07% (2)
1433]. may - 0.07% (2)
on [ 0.0.0.0 - 0.07% (2)
informational message only. - 0.07% (2)
loose-group_replication_start_on_boot=off loose-group_replication_local_address= "127.0.0.1:24902" - 0.07% (2)
(0.00 sec) --该参数设置为on,则禁用了在多主模式下一些可能产生未知数据冲突的操作 - 0.07% (2)
sec) --设置单主模式参数为off (root@localhost) - 0.07% (2)
rows affected (8.67 - 0.07% (2)
[(none)]> stop group_replication; - 0.07% (2)
--设置为第一个准备启动mgr(bootstrap)的节点 (root@localhost) [(none)]> - 0.07% (2)
set global group_replication_bootstrap_group=on; - 0.07% (2)
(0.00 sec) --此时可以从视图中看到整个集群只有一个节点是online - 0.07% (2)
group_replication_bootstrap_group=off; query ok, - 0.07% (2)
sec) --为了防止后续由于意外再启动另外一个复制组,关闭bootstrap参数 (root@localhost) - 0.07% (2)
rows affected (1.29 - 0.07% (2)
running. --停止复制 (root@localhost) - 0.07% (2)
group replication is - 0.07% (2)
on | +----------------------------------------------------+-------------------------------------------------+ - 0.07% (2)
| group_replication_single_primary_mode | - 0.07% (2)
value | +----------------------------------------------------+-------------------------------------------------+ - 0.07% (2)
like 'group_replication_single_primary_mode'; +----------------------------------------------------+-------------------------------------------------+ - 0.07% (2)
--如果mgr已经启动,则无法动态修改该参数 (root@localhost) [(none)]> - 0.07% (2)
error 3093 (hy000): - 0.07% (2)
primary mode while - 0.07% (2)
or from single - 0.07% (2)
cannot change into - 0.07% (2)
| 72ad2062-08a3-11e7-a513-5bfce171938d | - 0.07% (2)
bogon | 24801 - 0.07% (2)
--设置单主模式参数为off (root@localhost) [(none)]> - 0.07% (2)
affected (8.67 sec) - 0.07% (2)
stop group_replication; query - 0.07% (2)
--停止复制 (root@localhost) [(none)]> - 0.07% (2)
sec) --该参数设置为on,则禁用了在多主模式下一些可能产生未知数据冲突的操作 (root@localhost) - 0.07% (2)
(0.00 sec) --设置为第一个准备启动mgr(bootstrap)的节点 - 0.07% (2)
--为了防止后续由于意外再启动另外一个复制组,关闭bootstrap参数 (root@localhost) [(none)]> - 0.07% (2)
affected (1.29 sec) - 0.07% (2)
global group_replication_bootstrap_group=on; query - 0.07% (2)
replication is running. - 0.07% (2)
mode while group - 0.07% (2)
group_replication_single_primary_mode | on - 0.07% (2)
| +----------------------------------------------------+-------------------------------------------------+ | - 0.07% (2)
'group_replication_single_primary_mode'; +----------------------------------------------------+-------------------------------------------------+ | - 0.07% (2)
+---------------------------+--------------------------------------+-------------+-------------+--------------+ 1 row - 0.07% (2)
| +----------------------------------------------------+-------------------------------------------------+ --如果mgr已经启动,则无法动态修改该参数 - 0.07% (2)
global group_replication_single_primary_mode=off; error - 0.07% (2)
from single primary - 0.07% (2)
change into or - 0.07% (2)
3093 (hy000): cannot - 0.07% (2)
[(none)]> show variables - 0.07% (2)
all relay logs' - 0.07% (2)
set (0.01 sec) - 0.07% (2)
| +----------+ | - 0.07% (2)
+----------+ | count(*) - 0.07% (2)
root@localhost [testdb]> select - 0.07% (2)
root@localhost [testdb]> create - 0.07% (2)
information_schema.tables; query ok, - 0.07% (2)
| +----------+ 1 - 0.07% (2)
| count(*) | - 0.07% (2)
[testdb]> select count(*) - 0.07% (2)
* from information_schema.tables; - 0.07% (2)
[testdb]> create table - 0.07% (2)
--password enter password: - 0.07% (2)
set --host=localhost --user=root - 0.07% (2)
2017 by kamus·comments - 0.07% (2)
enterprise audit in - 0.07% (2)
mysql_config_editor set --host=localhost - 0.07% (2)
--user=root --password enter - 0.07% (2)
1 oracle oracle - 0.07% (2)
root@localhost [testdb]> show - 0.07% (2)
~]$ mysql welcome - 0.07% (2)
how to set - 0.07% (2)
into multi-primary mode - 0.07% (2)
28 [note] plugin - 0.07% (2)
'unsetting super_read_only.' 2017-03-16t02:04:33.081756z - 0.07% (2)
2017-03-16t02:04:33.081743z 0 [note] - 0.07% (2)
'getstart group_id 4317e324' - 0.07% (2)
group_replication reported: 'a - 0.07% (2)
new primary was - 0.07% (2)
new primary applies - 0.07% (2)
detection until the - 0.07% (2)
elected, enabled conflict - 0.07% (2)
applies all relay - 0.07% (2)
the new primary - 0.07% (2)
4317e324' 2017-03-16t02:04:33.081743z 0 - 0.07% (2)
reported: 'getstart group_id - 0.07% (2)
replication into multi-primary - 0.07% (2)
set mysql group - 0.07% (2)
reported: 'unsetting super_read_only.' - 0.07% (2)
2017-03-16t02:04:33.081756z 28 [note] - 0.07% (2)
conflict detection until - 0.07% (2)
was elected, enabled - 0.07% (2)
'a new primary - 0.07% (2)
set global group_replication_bootstrap_group=off; - 0.07% (2)
sec) --此时可以从视图中看到整个集群只有一个节点是online (root@localhost) - 0.07% (2)
server... enabling microsoft - 0.07% (2)
starting microsoft sql - 0.07% (2)
password: confirm the - 0.07% (2)
sql server enter - 0.07% (2)
run at boot... - 0.07% (2)
~]# /opt/mssql/bin/mssql-conf setup - 0.07% (2)
enter the new - 0.07% (2)
[yes/no]:y setting up - 0.07% (2)
found in /usr/share/doc/mssql-server/license.txt. - 0.07% (2)
from http://go.microsoft.com/fwlink/?linkid=746388 and - 0.07% (2)
setting up microsoft - 0.07% (2)
license terms? [yes/no]:y - 0.07% (2)
on public preview - 0.07% (2)
release of sql - 0.07% (2)
of the next - 0.07% (2)
# loose-group_replication_single_primary_mode=off # - 0.07% (2)
hat enterprise linux - 0.07% (2)
https://packages.microsoft.com/config/rhel/7/mssql-server.repo > /etc/yum.repos.d/mssql-server.repo - 0.07% (2)
in /usr/share/doc/mssql-server/license.txt. do - 0.07% (2)
/opt/mssql/bin/mssql-conf setup the - 0.07% (2)
第二步:通过yum安装 sudo yum - 0.07% (2)
administrator password: confirm - 0.07% (2)
password: starting microsoft - 0.07% (2)
https://docs.microsoft.com/en-us/sql/linux main pid: - 0.07% (2)
34s ago docs: - 0.07% (2)
2017-05-11 17:00:17 cst; - 0.07% (2)
(running) since thu - 0.07% (2)
16147 (sqlservr) cgroup: - 0.07% (2)
/system.slice/mssql-server.service ├─16147 /opt/mssql/bin/sqlservr - 0.07% (2)
spid18s server is - 0.07% (2)
sqlservr[16147]: 2017-05-11 17:00:20.52 - 0.07% (2)
└─16166 /opt/mssql/bin/sqlservr may - 0.07% (2)
server database engine - 0.07% (2)
- microsoft sql - 0.07% (2)
/usr/lib/systemd/system/mssql-server.service. setup completed - 0.07% (2)
boot... created symlink - 0.07% (2)
to run at - 0.07% (2)
sql server... enabling - 0.07% (2)
the system administrator - 0.07% (2)
for the system - 0.07% (2)
~]# systemctl status - 0.07% (2)
you wish to - 0.07% (2)
administrator (sa) account: - 0.07% (2)
multi-primary mode ## - 0.07% (2)
- 0.07% (2)
variable_value | +----------------------------------+----------------+ - 0.07% (2)
where variable_name='group_replication_primary_member'; +----------------------------------+----------------+ - 0.07% (2)
* from performance_schema.global_status - 0.07% (2)
sec) --group_replication_primary_member值为空,表示启动的是multi-primary mode,否则该参数显示的是单主模式中的primary节点 - 0.07% (2)
| group_replication_primary_member | - 0.07% (2)
| +----------------------------------+----------------+ 1 - 0.07% (2)
# # replication - 0.07% (2)
basedir=/usr/local/cellar/mysql/5.7.17 port=24802 socket=/tmp/s2.sock - 0.07% (2)
server configuration datadir=/users/kamus/mysql_data/s2 - 0.07% (2)
+---------------------------+--------------------------------------+-------------+-------------+--------------+ 2 rows - 0.07% (2)
localhost | 24803 - 0.07% (2)
affected (5.42 sec) - 0.07% (2)
(0.00 sec) --设置update检查参数为on - 0.07% (2)
| 24801 | - 0.07% (2)
72ad2062-08a3-11e7-a513-5bfce171938d | bogon - 0.07% (2)
--此时检查视图,可以发现集群中已经存在两个节点 (root@localhost) [(none)]> - 0.07% (2)
group_replication_applier | 9003e830-08a3-11e7-8ae3-e62d2f6366d2 - 0.07% (2)
| 96fe2b5a-08a3-11e7-b383-d7f02f17e847 | - 0.07% (2)
| | group_replication_applier - 0.07% (2)
24802 | online - 0.07% (2)
configuration parameters # - 0.07% (2)
server_id=2 gtid_mode=on enforce_gtid_consistency=on - 0.07% (2)
# server_id=2 gtid_mode=on - 0.07% (2)
replication configuration parameters - 0.07% (2)
socket=/tmp/s2.sock # # - 0.07% (2)
datadir=/users/kamus/mysql_data/s2 basedir=/usr/local/cellar/mysql/5.7.17 port=24802 - 0.07% (2)
enforce_gtid_consistency=on master_info_repository=table relay_log_info_repository=table - 0.07% (2)
binlog_checksum=none log_slave_updates=on log_bin=binlog - 0.07% (2)
generic cialisbuy cialis - 0.07% (2)
# transaction_write_set_extraction=xxhash64 loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" - 0.07% (2)
binlog_format=row # # - 0.07% (2)
# server configuration - 0.07% (2)
mode ## # - 0.07% (2)
replication configuration # - 0.07% (2)
# # group - 0.07% (2)
log_slave_updates=on log_bin=binlog binlog_format=row - 0.07% (2)
master_info_repository=table relay_log_info_repository=table binlog_checksum=none - 0.07% (2)
transaction_write_set_extraction=xxhash64 loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" loose-group_replication_start_on_boot=off - 0.07% (2)
- 0.07% (2)
replication configuration multi-primary - 0.07% (2)
# ## group - 0.07% (2)
"127.0.0.1:24901,127.0.0.1:24902,127.0.0.1:24903" loose-group_replication_bootstrap_group= off - 0.07% (2)
0.0.0.0 1433]. - 0.07% (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.