1 Data Sheet / MySQL Enterprise Edition / Version 2.1 Copyright © 2023, Oracle and/or its affiliates / Public et MySQL Enterprise Edition MySQL Enterprise Edition includes the most the highest levels of MySQL scalability, security, reliability, and uptime. It reduces the risk, cost, and complexity in developing, deploying, and managing business-critical MySQL applications. • Achieve Achieve database high availability using MySQL InnoDB Cluster and MySQL InnoDB ClusterSet • Build, deploy, and manage a private DBaaS and microservices using MySQL Operator for Kubernetes • Meet exponential

MySQL Installer Guide Abstract This document describes MySQL Installer, an application that simplifies the installation and updating process for a wide range of MySQL products, including MySQL Workbench Workbench and MySQL Shell. For notes detailing the changes in each release of MySQL Installer, see MySQL Installer Release Notes. For legal information, see the Legal Notices. For help with using MySQL, please please visit the MySQL Forums, where you can discuss your issues with other MySQL users. Document generated on: 2023-12-18 (revision: 77523) Table of Contents Preface and Legal Notices ...............

Best Practices for MySQL with SSDs Page 1 Best Practices for MySQL with SSDs A whitepaper by: Vijay Balakrishnan Changho Choi Veronica Lagrange Lagrange Hubbert Smith Samsung Semiconductor, Inc. Best Practices for MySQL with SSDs Page 2 Table of Contents 1. Introduction ......................................................... ............................................................................. 3 3. Optimizing MySQL Server and Percona Server for SSDs ..............................................................

© 2018 Percona. 1 Peter Zaitsev Analyzing MySQL Logs with ClickHouse CEO, Percona April 27,2018 © 2018 Percona. 2 ClickHouse is my love at the first sight © 2018 Percona. 3 Why ? Fast and and Efficient Built with Purpose Practical Features Easy to Use MySQL inspired © 2018 Percona. 4 MySQL inspired © 2018 Percona. 5 Why Keep and Analyze Raw Logs ? Raw Logs Contain ultimate store + LZ4) • Typically 100x faster than MySQL on Single Server • Semi-Linear Scalability to 100s of nodes High Performance © 2018 Percona. 8 MySQL Wire Protocol Compatibility with ProxySQL

Sync Clickhouse with MySQL/MongoDB Company: Xiaoxin Tech. Industry: Education Team: Big Data Leader: wangchao@xiaoheiban.cn About 100 billion data this year till now 30 million users We use binlog/oplog CRUD directly Can’t update/delete table frequently in Clickhouse Possible Solutions 2. MySQL Engine Not suitable for big tables Not suitable for MongoDB Possible Solutions 3. Reinit whole Must Listen ● Merge sharding tables ● SolidKey Typical Provider Config { Type: mysql, // mysql, mongodb, redis Listen: binlog, // binlog, kafka DataSource: user:pass@tcp(example

Using MySQL for Distributed Database Architectures CEO, Percona PingCAP Infra Meetup, Shanghai, China, May 26, 2018 © 2018 Percona. 2 About Percona Solutions for your success with MySQL,MariaDB Consulting, Training, Software Our Software is 100% Free and Open Source Support Broad Ecosystem – MySQL, MariaDB, Amazon RDS, Google CloudSQL In Business for 11 years More than 3000 customers, including © 2018 Percona. 4 Distributed ? MySQL Deployment on More than one System © 2018 Percona. 5 Modern MySQL Scalability © 2018 Percona. 6 Single MySQL Instance Can Do Hundreds of Thousands

Handler • MySQL Database Engine • BloomFilter Skipping Index • Query Predicate Optimizer • And more ~ 400+ commit https://github.com/zhang2014 MySQL Table Engine • Mapping to MySQL table • Fetch from MySQL • Fetch data from MySQL when execute query MySQL Database Engine • Mapping to MySQL database • Fetch table list from MySQL • Fetch table struct from MySQL • Fetch data from MySQL when when execute query MaterializeMySQL Database Engine • Mapping to MySQL database • Consume MySQL BINLOG and store to MergeTree • Experimental feature (20.8, recommend latest stable version) MaterializeMySQL

MySQL 企业版 全球广受欢迎的开源数据库 重要特性  Oracle MySQL 服务云  MySQL 数据库  MySQL 企业级备份  MySQL 企业级高可用性  MySQL 企业级可扩展性  MySQL 企业级身份验证  MySQL 企业级 TDE  MySQL 企业级加密  MySQL 企业级防火墙 企业级防火墙  MySQL 企业级审计  MySQL Enterprise Monitor  Enterprise Manager for MySQL  MySQL Query Analyzer  超过 225 个 MySQL 顾问程序  600 多个受控变量  60 多种性能图表  MySQL Workbench  Oracle 标准支持服务 “借助 “借助 MySQL Query Analyzer， 我们可以识别和分析存在问题的 SQL 代码，同时将数据库性能提 升两倍。更加重要的是，我们在三 天内就完成了这一任务，而过去则 需要数周之久。” —Keith Souhrada， 软件开发工程师， Big Fish Games MySQL 企业版提供了全面的高级功能、管理工具和技术支持，实现了高水平的 MySQL 可

Sync Clickhouse with MySQL/MongoDB Company: Xiaoxin Tech. Industry: Education Team: Big Data Leader: wangchao@xiaoheiban.cn About 100 billion data this year till now 30 million users We use binlog/oplog CRUD directly Can’t update/delete table frequently in Clickhouse Possible Solutions 2. MySQL Engine Not suitable for big tables Not suitable for MongoDB Possible Solutions 3. Reinit whole Provider Must Listen ● Merge sharding tables ● SolidKey Typical Provider Config { Type: mysql, // mysql, mongodb, redis Listen: binlog, // binlog, kafka DataSource: user:pass@tcp(example.com:3306)/user

Zabbix 6.0.0 新功能 Zabbix server 的高可用集群 新版本附带了针对 Zabbix server 的原生高可用解决方案。 该解决方案由多个 zabbix_server 实例或节点组成，其中一次只能有一个节点处于活动状态（工作），而其他节点处于待机状态，准备好 在当前节点停止或故障时接管。 另请参阅：高可用集群。 服务 对服务的监控进行了一些更新。服务监控提供了 Zabbix 可以支持克隆服务。克隆按钮已添加到服务的配置表单中。克隆服务时，会保留其父链接，而不会保留子链接。 主键 主键现在用于新安装中的所有表，包括历史表。 现有安装不会自动升级主键。在现有安装中 手动升级历史表主键的说明适用于MySQL/MariaDB、PostgreSQL、TimescaleDB v1 和v2 以 及Oracle。 新增小部件 新版本中添加了以下几个仪表板小部件。 Top 主机 Top hosts 小部件 性能，已经放弃了对一些旧数据库版本的支持。这主要适 用于接近使用寿命的数据库版本以及存在可能会干扰正常性能的未修复问题的版本。 从 Zabbix 6.0 开始，官方支持以下数据库 版本： • MySQL/Percona 8.0.X • MariaDB 10.5.X - 10.6.X • PostgreSQL 13.X - 14.X • Oracle 19c - 21c • TimescaleDB