....................................................................... v 1 MySQL Installer for Windows ................................................................................................ ........................................................................ 3 3 Setting Alternative Server Paths with MySQL Installer ..................................................................... .................................................................................... 9 4.1 MySQL Server Configuration with MySQL Installer .............................................................

Document Store Oracle Premier Support “We chose MySQL Enterprise Edition over Microsoft SQL Server as it provided all the tools we needed to secure our database at low costs, compared to the astronomically sharding of data • Java, C++, memcached, HTTP Drivers • Java, C++, memcached, HTTP • MySQL Native C Library • MySQL Drivers for ODBC, JDBC,.Net, Python, C, C++ • Community Drivers for PHP Optimized for use with SSD • Multiple Index Type (B-tree, R-tree, Hash, Full Text, etc.) • Server-side Thread Pool • Connection Thread Caching • Diagnostics, and SQL Tracing OLTP and

............................................................. 3 3. Optimizing MySQL Server and Percona Server for SSDs ................................................................... 5 4. Flush need to be considered to maximize performance and system value. In the software domain, MySQL Server is a commonly used Relational Database Management System (RDBMS).This whitepaper clarifies how today's substantial business advantage. The paper focuses on Percona Server – a free, fully compatible, open source MySQL Server enhancement. Because Percona Server is optimized for the I/O subsystem, it was selected

подключения к MemSQL начиная с версии клиента 8.0 необходимо добавлять опцию --default-auth=mysql_native_password В ClickHouse реализовано переключение плагина аутентификации в случае несовпадения 9 найден баг в стандартном MySQL клиенте, предложен патч с исправлением: https://github.com/mysql/mysql-server/pull/267 Исходный код: https://github.com/yandex/ClickHouse/commits?author=yurriy 12 Результаты

产品的任何特性或功能的开发、发行和时间规划均由 Oracle 自行决定。 4/16/2017 版权所有 2015，Oracle 和/或其附属公司。保留所有权利。 3 MySQL 复制 MySQL 半同步 复制 Windows/ Solaris/ Clusterware 群集或 Oracle VM Group Replication MySQL Cluster MySQL 高可用性解决方案 4/16/2017 和/或其附属公司。保留所有权利。 •Oracle Clusterware 将服务器场中 的服务器组合为一个群集 – 以 Oracle RAC 为核心 •Oracle Cluster 12c 包括 MySQL Server 代理 •对 MySQL 数据库进行计划内迁移 和自动故障转移 – 对使用受管 VIP 的应用程序不可见 – 共享存储，一次 1 个实例 4/16/2017 在 Oracle Clusterware Clara, CA, US Major Building Blocks (1) 22 M M M M M Com. API Replication Plugin API MySQL Server Group Comm. System (Corosync) Group Com. Engine 2017/4/16 Percona Live 2016 - Santa Clara, CA

'FULL') " "OR (Variable_name = 'default_authentication_plugin' AND upper(Value) = 'MYSQL_NATIVE_PASSWORD');"; MySQLBlockInputStream variables_input(connection, check_query, variables_header

keepalived 作为故障转移，提高系统的可用性。但是一般的 mysql 高可用为了实现 mysql 数据的一致性，一般都是采用单点写入，本方案采用 keepalived 中的 sorry_server 来实现写入数据库为单点的需求。本方案实现的功能是当网络有问题、 mysql 有问题、服务器宕机、keepalived 服务停止后,服务器能自动跳转到备用机， 当主服务器服务启动起来后会自动切换回来。 VIP 分别进行设置，为读写分离做准备。  扩展不是很方便。  可以在后面添加多个从服务器，并做到负载均衡。 缺点：  在启动或者恢复后会立即替换掉定义的 sorry_server，因此如果要实现指 定条件替换或者不替换需要通过其他方式实现，比如：临时更改 mysql 的端口等。  切换需要 1s 左右的时间。 2.4 方案实战 2.4.1 适用场景 zhangxy@test.com } notification_email_from jiankong@test.com smtp_server mail.test.com smtp_connect_timeout 30 router_id LVS1 } vrrp_sync_group test

• 少碎片、支持大文件、能够进行索引压缩 少碎片、支持大文件、能够进行索引压缩 • 二进制层次的文件可以移植 二进制层次的文件可以移植 (Linux (Linux   Windows) Windows) • 访问速度飞快，是所有 访问速度飞快，是所有 MySQL MySQL 文件引擎中速度最快的 文件引擎中速度最快的 • 不支持一些数据库特性，比如 事务、外键约束等 不支持一些数据库特性，比如

MySQL Group Replication) © 2018 Percona. 12 Q1:What Failure Modes Do you Consider ? Server Crash/Server Hardware Failure Software Bugs and Storage Corruption Network Failure “Datacenter” Failure application server 1 application server 2 application server 3 PXC node 1 PXC node 2 PXC node 3 ProxySQL © 2018 Percona. 57 ProxySQL on application side application server 1 application server 2 application application server 3 PXC node 1 PXC node 2 PXC node 3 5 7 ProxySQL ProxySQL ProxySQL © 2018 Percona. 58 ProxySQL at PMM © 2018 Percona. 59 Cloud Only Options •Amazon RDS •Amazon Aurora •Google

Files High Compression (column store + LZ4) • Typically 100x faster than MySQL on Single Server • Semi-Linear Scalability to 100s of nodes High Performance © 2018 Percona. 8 MySQL Wire User Account etc Has information about Connection Events Available in MySQL Enterprise, Percona Server, MariaDB © 2018 Percona. 18 Audit Log Record Example {"audit_record":{"name":"Query","record localhost []","host":"localhost","os_user":"","ip":"","db":"sbtest"}} © 2018 Percona. 19 Percona Server Configuration • Install Audit Plugin • INSTALL PLUGIN audit_log SONAME 'audit_log.so'; • Configure