Kubernetes Operator 实践 —— MySQL 容器化 刘林 搜狗资深工程师 关于我 搜狗商业平台研发部 资深开发工程师 l 主要从事商业平台研发工作，在构建高性能、高可用大规模 系统方面有丰富的实践经验 l 目前专注于云计算、DevOps 等相关领域，负责搜狗商业云 平台的设计研发工作 刘林 1. 背景介绍 2. Operator 的基本原理 3. MySQL MySQL Operator 设计实践 4. 小结 搜狗商业平台 技术体系广 服务多迭代快 搜狗产品矩阵 商业平台 信息流广告 搜索广告 品牌广告 代理商 广告主 技术体系 CRM 广告平台 物料展现 审核平台 大数据平台 基础架构 Golang C++ JavaScript Java Python 质量要求高 业务响应快 故障恢复快 Cluster1 CI&&CD 统一配 置中心 Cluster2 Node Node Node Node 商业云平台 BizCloud • 弹性伸缩能力不足 • 机器资源利用率不高 • 服务管理复杂 问题 有状态服务的需求越来越多 有状态服务容器化 1. 背景介绍 2. Operator 的基本原理 3. MySQL Operator 设计实践 4. 小结 无状态服务 服务调度 有状态服务集群

Connector/Python, MySQL Connector/ODBC, MySQL Connector/ J, and MySQL Connector/C++. To install MySQL Connector/Node.js, see https://dev.mysql.com/ downloads/connector/nodejs/. Note To install newer MySQL connectors the Server data files feature before attempting to install the server again. For help, see Product Features To Install). The Server data files check box was removed from the feature tree for MySQL Server To proceed, deselect the Server data files feature before attempting to install the server again. The Server data files check box was removed from the feature tree for MySQL Server 8.0.21 (or higher).

InnoDB ClusterSet • Build, deploy, and manage a private DBaaS and microservices using MySQL Operator for Kubernetes • Meet exponential growth in users and data with MySQL Enterprise Scalability management of MySQL applications. Highlights MySQL Database MySQL Enterprise HA MySQL Operator for Kubernetes MySQL Enterprise Backup MySQL Enterprise Scalability MySQL Enterprise Authentication JDBC,.Net, Python, C, C++ • Community Drivers for PHP, Perl, Python, Ruby, Go, Rust MySQL Operator for Kubernetes • Containers and microservices • Private DBaaS Security • OpenSSL by Default

ADDDATE(), TODAYOFWEEK(), … ● Missing functions: FROM_DAYS(), TIMESTAMP(), MAKEDATE(), REGEXP operator, … ● Missing aliases: INSTR() for positionCaseInsensitive(), STR_TO_DATE() for parseDateTimeOrNull()

! Key3����������� gtid_set 1-9578876��1-9578874, �����! write set: ! ��1-�������:! NODE A! NODE C! NODE B! Ta! gtid_excuted: 1-9578875! a,b,c! 1,1,1! 2,2,2! 3,3,3! Ta:delete from test1 where test1 where b=1 ! primary key�1 ,snapshot: 1-9578875! ! Test1:! ��2-�������������:! NODE A! NODE C! NODE B! Ta! gtid_excuted: 1-9578875! a,b,c! 1,1,1! 2,2,2! 3,3,3! Ta:delete from test1 where snapshot: 1-9578875! ! Test1,a�pri key ! Test1������������Ta�Tb�� �����! ��3-�����������! NODE A! NODE C! NODE B! Ta! ���� gtid_excuted ������ ������ ������ ����! Ta:delete from test1 where b=3 !

PXC/Galera Properties Write to Any Node Certification Based Replication Virtually Synchronous; Can ensure no stale reads Built in Fail-Over Built-in Node Provisioning © 2018 Percona. 44 Transaction 3 PXC node 1 PXC node 2 PXC node 3 ProxySQL © 2018 Percona. 57 ProxySQL on application side application server 1 application server 2 application server 3 PXC node 1 PXC node 2 PXC node 3 5 7

deadtime 30 warntime 10 initdead 60 udpport 694 ucast eth0 10.1.1.75 auto_failback on node dbserver node puppet ping 10.1.1.1 respawn hacluster /usr/lib64/heartbeat/ipfail backup 的 ha.cf deadtime 30 warntime 10 initdead 60 udpport 694 ucast eth0 10.1.1.113 auto_failback on node dbserver node puppet ping 10.1.1.1 respawn hacluster /usr/lib64/heartbeat/ipfail  haresources deadtime 30 warntime 10 initdead 60 udpport 694 ucast eth0 10.1.1.108 auto_failback on node dbserver1 node dbserver2 ping 10.1.1.1 respawn hacluster /usr/lib64/heartbeat/ipfail backup(dbserver2)的

•Agent：用于连接监控模块，上报系统运行状况。 GRPC API Schedule Filter Strategy Docker API Manger 分布式监控 Node Docker Docker Docker Docker Node Docker Docker Docker Docker 集群 报警 • 为了保证容器内的MySQL实例有更好的磁盘IO性能。采用了本地宿主机磁盘挂载到容器内的方式(每个

Engine • Mapping to MySQL database • Consume MySQL BINLOG and store to MergeTree • Experimental feature (20.8, recommend latest stable version) MaterializeMySQL Database Engine MaterializeMySQL Database

Replication MySQL Shell Setup, Manage, Orchestrate “High Availability becomes a core first class feature of MySQL!” MySQL Router应用能透明的和数据库连结 -支持负载均衡,高可用读写分离和数据分片 MySQL Router 应用端 MySQL Router Group