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

Peer-to-site 4 wireguard-vpn-peer2site-introduction Introduction 4 wireguard-vpn-peer2site-router On router 4 wireguard-vpn-peer2site-inside Inside device 3 wireguard-vpn-site2site Site-to-site 3 HA - Migrate from crmsh to pcs 2 Databases 3 databases-introduction Introduction 3 databases-mysql MySQL 3 databases-postgresql PostgreSQL 2 Monitoring 3 logging-monitoring-alerting Logging, Monitoring LDAP LDAP and Kerberos Troubleshooting WireGuard VPN Introduction Peer to site Introduction On router Inside device Site to site Default gateway Other tasks Security tips Troubleshooting Virtualization

in the release notes of the version. Before running upgrade scripts drop the following indexes: MySQL alter table dhosts drop index dhosts_1; alter table dservices drop index dservices_1; alter table Database upgrade scripts are located in directory upgrades/dbpatches/1.8/: • MySQL: upgrades/dbpatches/1.8/mysql/patch.sql • Oracle: upgrades/dbpatches/1.8/oracle/patch.sql • PostgreSQL: upgrades/dbpatches/1 support arrays. 6.4 Other changes • In previous versions, Zabbix server was able to reconnect to MySQL database if it temporarily became unavailable. With 1.8.2, this is also supported for PostgreSQL

既然如此，我们就好好的来探索一下 Linux 的网络世界吧！首先， Linux 到底可以达成哪些网络功能呢？这可就 多着咯！不论是 WWW, Mail, FTP, DNS, 或者是 DHCP, NAT 与 Router 等等，Linux 系统都可以达到，而 且，只要一部 Linux 就能够达到上面所有的功能了！当然，那是在不考虑网络安全与效能的情况下，你可以使用一 部 Linux 主机来达成所有的网络功能。 Tips: 由于网络卡卡号是跟着网络卡走的，并不会因为重灌操作系统而改变， 所以防火墙软件大多也能够针对网络 卡来进行抵挡的工作喔！ 不过抵挡网卡仅能在局域网络内进行而已，因为 MAC 不能跨 router 嘛！！ 为什么资料量最小要 46 最大为 1500 bytes 呢？ 讯框内的数据内容最大可达 1500bytes 这我们现在知道了，那为何要规范最小数据为 46bytes 呢？这是由于 上面跑吧？你无法确认所有的网络媒体都是支持那么大的 MTU 对吧！ 如果你的 9000 bytes 封包通过一个不支持 Jumbo frame 的网络媒体时，好一点的是该网络媒体 (例如 switch/router 等) 会主动的帮你重组而进行传送，差一点的可能就直接回报这个封包无效而丢弃了～这个时候可 就糗大啰～ 所以， MTU 设定为 9000 这种事情，大概仅能在内部网络的环境中作～举例来说，很多的内部丛集系

French 1.2 Daemon improvements 1.3 Miscellaneous improvements Fixed issues with mysql user parameter configuration script mysql.size parameter. It con- tained a complex bash expression and was failing if Zabbix protocols) stays limited at 16MB • Zabbix server and proxy will now retry connections to MySQL if connecting to a DNS name and resolution fails • When encoding email subject from UTF-8 to Base64 1.3 Suppressed warning messages about deprecated mysql extension Before Zabbix 2.0.8, PHP version 5.5+ users would get a warning message about the mysql PHP extension being deprecated. Starting with Zabbix

indexes in Zabbix MySQL database schema ** Redundant indexes were removed in several Zabbix MySQL database tables. This should improve performance and slightly reduce the database size for MySQL users in these on child-table columns having foreign key constraints Such indexes were created automatically on MySQL, now they are created also on PostgreSQL, Oracle, DB2 to improve performance of Zabbix server and be set to 0.0001 seconds. 18.3 Miscellaneous improvements Fixed issues with mysql user parameter configuration script mysql.size parameter. It con- tained a complex bash expression and was failing if

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,

will be set to 0.0001 seconds. 3 Miscellaneous improvements Fixed issues with mysql user parameter configuration script mysql.size parameter. It contained a complex bash expression and was failing if the 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

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,

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,