mysql pxc LIMITATIONS 8.0.19-10
-
Replication works only with InnoDB storage engine. Any writes to tables of other types are not replicated
-
Unsupported queries: LOCK TABLES and UNLOCK TABLES is not supported in multi-master setups Lock functions, such as GET_LOCK(), RELEASE_LOCK(), and so on
-
Query log cannot be directed to table. If you enable query logging, you must forward the log to a file:
log_output = FILE
Use general_log and general_log_file to choose query logging and the log file name.
-
Maximum allowed transaction size is defined by the wsrep_max_ws_rows and wsrep_max_ws_size
wsrep_max_ws_rows:Defines the maximum number of rows each write-set can contain.
最大允许值是 1048576。
wsrep_max_ws_size: Defines the maximum write-set size (in bytes).
值范围1024到2147483647
LOAD DATA INFILE 每10000行或者更少提交一次,大事务使用LOAD DATA INFILE 会被拆分成很多小事务
禁用特性:
It doesn’t work as expected with autocommit=0 when enabled.
-
Transaction issuing COMMIT may still be aborted at that stage. 在PXC中,两个事务写入相同的行并提交,只有一个事务能提交成功,失败的将中止,返回错误代码
(Error: 1213 SQLSTATE: 40001 (ER_LOCK_DEADLOCK)).
-
XA transactions are not supported. 提交时有可能回滚
https://dev.mysql.com/doc/refman/8.0/en/xa.html
-
集群的写吞吐量受到最弱的节点的限制。推荐至少3个节点, 第三个节点可以是仲裁的节点
-
enforce_storage_engine=InnoDB is not compatible with wsrep_replicate_myisam=OFF wsrep_replicate_myisam is set to OFF by default
参考: https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1435482
-
避免 ALTER TABLE … IMPORT/EXPORT It can lead to node inconsistency if not executed in sync on all nodes.
-
All tables must have a primary key . The DELETE statement is not supported on tables without a primary key.
Node Host IP
1 pxc1 172.16.0.61
1 pxc2 172.16.0.62
1 pxc3 172.16.0.63
Note: Avoid creating a cluster with two or any even number of nodes, because this can lead to split brain. For more information, see Cluster Failover
本文地址:https://blog.csdn.net/j_ychen/article/details/107915697
如对本文有疑问,
点击进行留言回复!!
相关文章:
-
-
-
-
-
-
-
-
mysql解决时区相关问题
前言:在使用 mysql 的过程中,你可能会遇到时区相关问题,比如说时间显示错误、时区不是东八区、程序取得的时间和数据库存储的时间不一致等等问题。其实,这些问题...
[阅读全文]
-
-
mysql如何查询日期与时间
前言: 在项目开发中,一些业务表字段经常使用日期和时间类型,而且后续还会牵涉到这类字段的查询。关于日期及时间的查询等各类需求也很多,本篇文章简单讲讲日期及时间字...
[阅读全文]
-
深入了解mysql长事务
前言: 本篇文章主要介绍mysql长事务相关内容,比如说我们开启的一个事务,一直没提交或回滚会怎样呢,出现事务等待情况应该如何处理,本篇文章将给你答案。注意:本...
[阅读全文]
网友评论