MySQLCluster plural: mysqlclusters 1. 创建 CRD • Clientset • Informers • Listers • DeepCopy code-generator MySQL 容器化系统架构 REST CLI Kubernetes Master API Server Scheduler Controller Manager NodeM

warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle. Use of This Documentation This documentation Client only and Full setup types. Select the Only install GA products option to restrict the product set to include GA products only when using these setup types. Note Commercial-only MySQL products, such

position.update(metadata.binlog_position,metadata.binlog_file, metadata.executed_gtid_set); metadata.transaction(position, [&]() { position.update(metadata.binlog_position,metadata.binlog_file, metadata.executed_gtid_set); metadata.transaction(position, [&]() { WITH READ LOCK;").execute(); fetchMasterStatus(connection); connection->query("SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;").execute(); connection->query("START

og 以及冲突检测时使用到主键以及事务的数据快照版本(gtid_set) • 比较规则。将事务所涉及的主键以及数据版本信息(gtid_set)跟write set 里面的信息进行比较: 主键不存在与write set中，不冲突。 主键存在，则比较事务版本信息，即比较gtid_set，如果是包含关系， 则不冲突。否则，冲突。 • 冲突检查在各节点内部独立完成，不需要节点间的通信。 ������1-9578876�! Db_name_1:table_name_3:key3:1-9578876! Key3����������� gtid_set 1-9578876��1-9578874, �����! write set: ! ��1-�������:! NODE A! NODE C! NODE B! Ta! gtid_excuted: 1-9578875! a 3,3,3! Ta:delete from test1 where b=3 ! primary key�3 ,snapshot: 1-9578875! ! Tb:update test1 set b=4 where a=3! primary key�3 ,snapshot: 1-9578875! ! Tb:delete from test1 where b=1 ! primary key�1

com/docs/en/integrations/lookerstudio#on-premise-clickhouse-server-setup Don’t fail on commands such as SET SQL_AUTO_IS_NULL = 0 Enabling ClickHouse -> MySQL types translation in SHOW [FULL] COLUMNS queries ● TCP Connection ● MySQL authentication support ● Incoming command packets handler * ● Result set protocols - text and binary * https://dev.mysql.com/doc/dev/mysql-server/latest/PAGE_PROTOCOL.html “standard” queries (COM_QUERY) which return just a plain text result set, COM_STMT_EXECUTE responds with binary protocol result set. ● Missing the entire binary protocol implementation. ● Added in 23

10.1.1.1, 10.1.1.113, 10.1.1.75, 10.1.1.108 # ping_ips 监控了网关 IP 和其他的 DB 节点 IP auto_set_online 60 monitor_user mmm_monitor monitor_password d/mysql-mmm-monitor stop 6.5.4.2 MMM 的基本管理 查看集群的状态 mmm_control show 将 db1 设置成 online 状态 mmm_control set_online db1 更多管理命令请使用 mmm_control help 查看，或者参考： http://blog.chinaunix.net/uid-20639775-id-154606

Public et MySQL Enterprise Edition MySQL Enterprise Edition includes the most comprehensive set of advanced features, management tools and technical support to achieve the highest levels of MySQL

Information is Available ? © 2018 Percona. 29 Queries Causing the Most Load © 2018 Percona. 30 Working set of Most Frequent Queries © 2018 Percona. 31 Slowest Query © 2018 Percona. 32 Any Killed Queries

n Smart conflict resolution Cross Vendor Redundancy © 2018 Percona. 28 Sharding Split data set by certain criteria and store such “shards” on separate “clusters” © 2018 Percona. 29 Typical

cluster ROM Cluster 'ROM' is available -- Checking whether target cluster has the most recent GTID set - Promoting cluster 'BRU' - Updating metadata -- Changing replication source of 127.0.0.1:5552