Don’t fail on commands such as SET SQL_AUTO_IS_NULL = 0 Enabling ClickHouse -> MySQL types translation in SHOW [FULL] COLUMNS queries By default, String/FixedString types are reported as BLOB MySQL Tableau Online How it started … 8 QuickSight Tableau Online Missing ClickHouse -> MySQL types translation Too many nulls… And what’s up with that “Radio” column? Testing a Particular BI tool for Compatibility

with MySQL © 2018 Percona. 19 Main Concepts Replication Sharding Failover Management Traffic Management © 2018 Percona. 20 Replication Having Multiple Copies of the data, updated with 31 Failover Management Many Replication Modes Require “Failover” Need some Tool To Decide on Failover Need some Tool to Perform Failover © 2018 Percona. 32 Traffic Management Scaling with with Large Number of Connections Routing Traffic to Right “Shard” Read-Write Splitting Load Management Avoiding “Dead” Nodes © 2018 Percona. 33 Options in MySQL © 2018 Percona. 34 Replication

Applications Notice This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications Installer from the Start menu and click Add from the dashboard. For a description of the available management operations, see Product Catalog. MySQL Installer Configuration Files All MySQL Installer files in the InnoDB Cluster (3306 by default). • Management User: An administrative user with root-level privileges. • Password: The password for the management user. • Classic MySQL protocol connections

Enterprise Edition MySQL Enterprise Edition includes the most comprehensive set of advanced features, management tools and technical support to achieve the highest levels of MySQL scalability, security, reliability documents with MySQL Document Store • Get 24x7 assistance in the development, deployment, and management of MySQL applications. Highlights MySQL Database MySQL Enterprise HA MySQL Operator microservices • Private DBaaS Security • OpenSSL by Default • SQL Roles • Password management High-Performance • Performance Schema • Information Schema • SYS Schema • Resource

SECONDARY. WARNING: The cluster internal session is not the primary member anymore. For cluster management operations 32 / 55 更改主集群中的主成员 mysqlsh> bru.setPrimaryInstance('localhost:3332') please obtain SECONDARY. WARNING: The cluster internal session is not the primary member anymore. For cluster management operations 33 / 55 更改副本集群中的主成员 mysqlsh> lis.setPrimaryInstance('localhost:4442') please

a lot of data ? © 2018 Percona. 37 Want Processed Logs ? Check out Percona Monitoring and Management © 2018 Percona. 38 Need Help ? Percona - MySQL, MariaDB, MongoDB, PostgreSQL Support and

QL AB公司开发，目前属于Oracle 旗下产品。MySQL是最流行的关系型数据库管理系统之一，在Web应用方面，MySQL 是最好的RDBMS (Relational Database Management System，关系数据库管理系 统）应用软件之一。 MySQL是一种关系数据库管理系统，关系数据库将数据保存在不同的表中，而不是将 所有数据放在一个大仓库内，这样就增加了速度并提高了灵活性。

and system value. In the software domain, MySQL Server is a commonly used Relational Database Management System (RDBMS).This whitepaper clarifies how today's data centers combine SSDs and MySQL to achieve