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

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85 Install MySQL and etcd . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 97 MySQL versions 5.6 to 8.0 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 99 MySQL Compatibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .