-
Paxos, Transaction_context_log_event, Binlog Event, group_replication_applier
-
小参数,大作用
-
Paxos, 超过半数, N/2+1, LZ4
-
Hook, before_commit
-
distributed, state machine
-
COUNT_TRANSACTIONS_IN_QUEUE, COUNT_TRANSACTIONS_ROWS_VALIDATING
-
Paxos,group_replication_unreachable_majority_timeout
-
ONLINE, UNREACHABLE, ERROR, RECOVERING, OFFLINE
-
group_replication_unreachable_majority_timeout, group_replication_exit_state_action
-
SET GLOBAL group_replication_bootstrap_group=ON,START GROUP_REPLICATION,SET GLOBAL group_replication_bootstrap_group=OFF
-
GTID_SUBSET(),GTID_SUBTRACT()
-
GTID-based Replication's Restrictions
-
--set-gtid-purged=ON,@@GLOBAL.GTID_PURGED,@@GLOBAL.GTID_EXECUTED,@@SESSION.SQL_LOG_BIN
-
MASTER_AUTO_POSITION
-
RESET MASTER,RESET SLAVE [ALL] [FOR CHANNEL channel]
-
gtid_next,gtid_executed,gtid_purged
-
gtid_executed,gtid_next,gtid_owned
-
GTID,GTID Sets,mysql.gtid_executed,gtid_executed,gtid_purged
-
Metadata Lock, innodb_trx, metadata_locks
-
efficient retrieval, high fanout, key, pointer...
-
order by, Quicksort, sort_buffer_size, max_length_for_sort_data...
-
XA Transactions...
-
sequence...
-
schema.xml, rule.xml, server.xml, log4j.xml...
-
Keepalived的HA功能...
-
schema, table, dataNode, dataHost, rule, sequence...
-
alter table...
-
flush tables with read lock的使用...
-
使用pt-online-schema-change变更数据表某字段长度, 完成后, 查看表结构定义, 却出现了乱码...
-
MHA的管理用户mha_mgr的密码中包含特殊字符, 引起的切换失败.
coveringindex
分享到朋友圈
- 关注技术:python Mysql MongoDB
- 入住博客:2017-01-23 4年