PolarDB-X 如 何 做 生 态兼 容 好的 MySQL 兼容性可以做到什么程度 胡中泉（舟济） 阿里云数据库解决方案架构师为什么要兼容 MySQL 01 The longer you look back, the farther you can look forward.也从阿里巴巴的“去IOE”运动说起 业务驱动下的分布式技术实践之路 5月17日，支付宝最后一台小型 机下线标志去IOE落下帷幕 反推出了天价账单也谈所谓的“中间件” 中间件只是起点，PolarDB-X 可能是离终点最近的那个 对近十年的探索以及五年的上云 经验进行重新思考，面向未来设 从运维视角实现计算存储一体化 计新架构 产品形态 基于MySQL XA实现分布式事务 基于外部组件进行扩容 支持扩容 分布式事务 一体化尝试 Review 2.0 开源 2016 2017 2018 2019 2020 2021 2021年10月20日，云栖大会宣 it probably is a duck.业务系统 上游 Single Source of Truth 问题背景 数据孤岛怎么办？ 下游MySQL 怎么做 Binlog Maxwell DebeziumPolarDB-X 完全兼容 MySQL Binlog 可行性 • 多节点产生多个增量事件队列 • 不同队列中事件之间的顺序 • 分布式事务完整性 • DDL 引起的多 Schema

Secure connections to Zabbix database It is now possible to configure secure TLS connections to MySQL and PostgreSQL databases from: • Zabbix frontend • Zabbix server or proxy Restricting agent checks Memcached instances (see description). MySQL monitoring plugin A MySQL plugin for Zabbix agent 2 is now available as part of the out-of-the-box monitoring of MySQL instances (see description). Agent 2 Minimum required versions updated The minimum required versions for supported databases now are: • MySQL 5.5.62 • MariaDB 10.0.37 • PostgreSQL 9.2.24 • Oracle 11.2 TimescaleDB native compression support

Parameter structure for Zabbix agent 2 plugins has been updated: • For Ceph, Docker, Memcached, MySQL, Oracle, and Redis plugins, a Uri can now only be specified as a named session parameter. • For line parameters: • printing all built-in agent items with values • testing a user parameter with ”mysql.ping” key defined in the specified configuration file • installing a ”Zabbix Agent” service for Windows it by Hostname value from the config file shell> zabbix_agentd --print shell> zabbix_agentd -t "mysql.ping" -c /etc/zabbix/zabbix_agentd.conf shell> zabbix_agentd.exe -i shell> zabbix_agentd.exe -i -m

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1804 4 Monitor MySQL with Zabbix agent 2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . code points (instead of 255 in previous versions). A longer value will be truncated. Note that on MySQL, the effective maximum length in characters will be less if the returned value contains multibyte entered, such as scripts, expressions, macro values, etc. Miscellaneous Database TLS connection for MySQL on SLES 12 The packages for server/proxy installation on SUSE Linux Enterprise Server version 12

performance. Starting from Zabbix 6.0, the following database versions are officially supported: • MySQL/Percona 8.0.X • MariaDB 10.5.X - 10.6.X • PostgreSQL 13.X - 14.X • Oracle 19c - 21c • TimescaleDB for MySQL/MariaDB, PostgreSQL, TimescaleDB v1 and v2, and Oracle. 14 utf8mb4 support for MySQL utf8mb4 encoding with utf8mb4_bin collation is now supported for Zabbix installations with the MySQL/MariaDB MySQL/MariaDB database. Previously only utf8 encoding was supported, which with MySQL stands for utf8mb3 encoding and thus supports only a subset of proper UTF-8 characters. In the new version utf8mb4 support

item, referencing the current host sum(last_foreach(/*/vfs.fs.size[/,total]?[group=”MySQL Servers”])) grpsum[”MySQL Servers”,”vfs.fs.size[/,total]”,last] Aggregate calculation (formerly, aggregate performance. Starting from Zabbix 5.4, the following database versions are officially supported: • MySQL/Percona 5.7.28-8.0.X • MariaDB 10.0.37-10.5.X • PostgreSQL 10.9-13.X • Oracle 12.1.0.2 - 19c • available allowing to monitor validity and expiration dates of TLS/SSL website certificates. • Plugins MySQL and PostgreSQL now support encrypted TLS connection between the agent and monitored databases. TLS

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1862 4 Monitor MySQL with Zabbix agent 2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . command-line parameters: • printing all built-in agent items with values • testing a user parameter with ”mysql.ping” key defined in the specified configuration file • installing a ”Zabbix Agent” service for Windows by extending it by Hostname value from the config file zabbix_agentd --print zabbix_agentd -t "mysql.ping" -c /etc/zabbix/zabbix_agentd.conf zabbix_agentd.exe -i zabbix_agentd.exe -i -m -c zabbix_agentd

line parameters: • printing all built-in agent items with values • testing a user parameter with ”mysql.ping” key defined in the specified configuration file • installing a ”Zabbix Agent” service for Windows it by Hostname value from the config file shell> zabbix_agentd --print shell> zabbix_agentd -t "mysql.ping" -c /etc/zabbix/zabbix_agentd.conf shell> zabbix_agentd.exe -i shell> zabbix_agentd.exe -i -m requires a separate database. Attention: Note that databases supported with Zabbix proxy are SQLite, MySQL and PostgreSQL. Using Oracle or IBM DB2 is at your own risk and may contain some limitations as,

常见问题 1. Q：可以更新或清空队列（如菜单 “管理”→“队列” 中所展示的队列）？ A: 不可以。 2. Q: 如何从一个数据库迁移到另一个数据库？ A: 只需要转存数据 (对于 MySQL, 使用参数 -t 或 --no-create-info), 用 Zabbix 的 schema 文件创建新的数据库，并导入数据。 3. Q: 想用下划线替换监控项 key 中的所有空格，因为空格只在老版本中起作用，而在 Administration → Queue)? A: No. 2. Q: How do I migrate from one database to another? A: Dump data only (for MySQL, use flag -t or --no-create-info), create the new database using schema files from Zabbix and import should be imported (no images.sql nor data.sql) MySQL shell> mysql -uroot -p mysql> create database zabbix character set utf8 collate utf8_bin; mysql> grant all privileges on zabbix.* to zabbix@localhost

Templates The template Azure by HTTP has been updated and now includes metrics to monitor Microsoft Azure MySQL servers out-of-the-box. You can get this template: • In Configuration → Templates in new installations; line parameters: • printing all built-in agent items with values • testing a user parameter with ”mysql.ping” key defined in the specified configuration file • installing a ”Zabbix Agent” service for Windows it by Hostname value from the config file shell> zabbix_agentd --print shell> zabbix_agentd -t "mysql.ping" -c /etc/zabbix/zabbix_agentd.conf shell> zabbix_agentd.exe -i shell> zabbix_agentd.exe -i -m