![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MariaDB Galera Cluster
lwei_998
这个作者很懒,什么都没留下…
展开
-
WSREP: Only binlog_format = 'ROW' is currently supported
Mariadb Galera Cluster 节点启动时出现如下错误:mysqld_safe Starting mysqld daemon with databases from /3336/data mysqld_safe WSREP: Running position recovery with –log_error=’/3336/data/wsrep_r ecovery.NzULcc...原创 2018-05-21 18:57:49 · 790 阅读 · 0 评论 -
Mariadb Galera Cluster DDL 的救星pt-online-schema-change
版本信息:MariaDB [information_schema]> select * from GLOBAL_status where variable_name in ('wsrep_provider_name','wsrep_provider_version') union all select * from GLOBAL_VARIABLES where variable_name...原创 2018-05-25 21:51:56 · 883 阅读 · 0 评论 -
WSREP: Node consistency compromised, aborting
Mariadb Galera Cluster中的两个节点几乎同时宕机,检查日志发现如下错误[Warning] WSREP: BF applier failed to open_and_lock_tables: 1146, fatal: 0 wsrep = (exec_mode: 1 conflict_state: 0 seqno: 1080339)[ERROR] Slave SQL: ...原创 2018-05-22 13:45:43 · 1503 阅读 · 0 评论 -
ERROR 1192 (HY000): Can't execute the given command because you have active locked tables or an acti
MariaDB [test]> rename table mgc_new to mgc;ERROR 1192 (HY000): Can't execute the given command because you have active locked tables or an active transaction#perror 1192 MySQL error code 1192...原创 2018-05-28 11:16:32 · 9791 阅读 · 2 评论 -
DDL导致的死锁
MariaDB Galera Cluster 中做DDL时会引起死锁,但这个死锁并不是由于并发导致的。而是Galera Cluster中特有的“坑”。当在MariaDB Galera Cluster中做DDL时,相关表的读写事务都会报死锁的异常。 ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting ...原创 2018-05-23 19:06:19 · 2103 阅读 · 0 评论 -
ERROR 1180 (HY000): Got error 5 "Input/output error" during COMMIT
MariaDB [(none)]> select * from information_schema.GLOBAL_status where variable_name in ('wsrep_provider_name','wsrep_provider_version') union all select * from information_schema.GLOBAL_VARIABLES ...原创 2018-05-24 14:30:10 · 3257 阅读 · 0 评论 -
ERROR 1047 (08S01): WSREP has not yet prepared node for application use
同事问三个节点的Galera Cluster中如果只剩一个节点了,那么还能提供读写服务吗? 分两种情况: 一、节点正常关闭的情况 如果集群中的两个节点都正常关闭,集群中剩余的一个节点还是可以提供读写服务的。MariaDB [(none)]> SHOW STATUS WHERE Variable_name IN ( 'wsrep_local_state_uuid','wsrep...原创 2018-05-24 16:38:08 · 7875 阅读 · 0 评论 -
如何将Mariadb Galera Cluster中的节点转换为slave
由于架构变化需要将Mariadb Galera Cluster中的一个节点转移为slave,步骤如下:正常停止集群中的待转换节点找到该节点最后一个事务的xid值查找候选master上Xid(第2步中找到的xid)所在binlog中下一个事务开始的位置change master启动slave【实验】1.正常停止Mariadb Galera Cluster集群中的待转换节点2.查找待转换为slave节...原创 2018-05-30 10:33:22 · 974 阅读 · 0 评论