ITPub博客

首页 > 数据库 > MySQL > Percona XtraDB Cluster sum

Percona XtraDB Cluster sum

原创 MySQL 作者:biggerl 时间:2015-10-12 14:02:44 0 删除 编辑

Percona XtraDB Cluster Errata


1、Create Table As Select (CTAS) under highly concurent DDL workload (other than CTAS) may deadlock.
For fresh installs, it is highly recommended to use the meta-packages to install packages. Refer to Installing



2、iptables allow: 3306, 4444, 4567 and 4568.SELinux or apparmor should be disabled

Port for group communication, default 4567. It can be changed by the option:
wsrep_provider_options ="gmcast.listen_addr=tcp://0.0.0.0:4010; "

Port for State Transfer, default 4444. It can be changed by the option:
wsrep_sst_receive_address=10.11.12.205:5555

Port for Incremental State Transfer, default port for group communication + 1 (4568). It can be changed by the option:
wsrep_provider_options = "ist.recv_addr=10.11.12.206:7777; "

3、wsrep_slave_threads = 多线程进行并行复制

4、 wsrep_causal_reads  = ON | OFF (default)
There might be a small period of time when the slave is out-of-sync from master. 
because the master may apply event faster than a slave. And if you do read from the slave, you may read the data that has not changed yet

in the ON  case, the read on the slave will wait until event is applied (this however will increase the response time of the read).

……

……




来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/29974949/viewspace-1813811/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2014-10-24

  • 博文量
    39
  • 访问量
    96958