Q1:What Failure Modes Do you Consider ? Server Crash/Server Hardware Failure Software Bugs and Storage Corruption Network Failure “Datacenter” Failure Developer Mistakes/Intruder Actions © 2018 Percona 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 Replicated Data © 2018 Percona. 24 Where Replication Happens Storage Level Database Level Application Level © 2018 Percona. 25 Storage Level Replication Replication in SAN/NAS, DRBD Typically provides

jumping to 1GB/s (1000X). For storage, something similar has indeed happened with the transition from Hard Disk Drives (HDDs) to Solid State Devices (SSDs). In the past, storage administrators sized systems provide those IOPS. Often, this resulted in buying more HDD capacity than was necessary. Now, storage administrators typically size a system based on the needed capacity, then buy a quantity of SSDs 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

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 TECHNICAL SPECIFICATION Flexible Architecture • Open Source • Multi-threaded • Pluggable Storage-Engine • InnoDB, NDB, MyISAM, ANSI SQL Standards • ANSI SQL • SubQueries, Joins, Cursors

storage->set(storage->partition_by, partition_expression); if (ASTPtr order_by_expression = getOrderByPolicy(primary_keys, unique_keys, keys, increment_columns)) storage->set(storage->order_by storage->set(storage->order_by, order_by_expression); storage->set(storage->engine, makeASTFunction("ReplacingMergeTree", std::make_shared(version_column_name))); Select history data MaterializeMySQL

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

数据冗余存储 冗余应用服务器 数据路由 4/16/2017 版权所有 2015，Oracle 和/或其附属公司。保留所有权利。 7 • MySQL Replication • Shared Storage • Group Replication • MySQL Cluster 从数据库 • 会话线程：处理来自应用程序的查询 － 将 数据写入主数据库，将关联事件写入二进制 日志 • 转储线程：读取二进制日志中的事件，然后 数据冗余存储 冗余应用服务器 数据路由 4/16/2017 版权所有 2015，Oracle 和/或其附属公司。保留所有权利。 14 • MySQL Replication • Shared Storage • Group Replication • MySQL Cluster 4/16/2017 版权所有 2015，Oracle 和/或其附属公司。保留所有权利。 15 •预安装且预配置 •完全集成且经过 数据冗余存储 冗余应用服务器 数据路由 4/16/2017 版权所有 2015，Oracle 和/或其附属公司。保留所有权利。 18 • MySQL Replication • Shared Storage • Group Replication • MySQL Cluster MySQL Group Replication • MySQL Group Replication是什么? “任何一个都可以更新

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

0. 创建 CRD 3. 集群管理 2. 调度 pod Ceph MySQL-Operator 主流程 API Server Reflector DeltaFIFO Local Storage Callbacks OnAdd OnUpdate OnDelete WorkQueue List/Watch - CRD - Pod Write Informer Worker metadata: { name: "dbiflow", namespace: “default"}, spec: { replicas: 3, version: "5.5", port: 3613, storage: {type: "local", size: "80G"}, resources: { request: {cpu: 4, memory:8}}}}' http://***/apis/mysql

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是一种关系数据库管理系统，关系数据库将数据保存在不同的表中，而不是将 所有数据放在一个大仓库内，这样就增加了速度并提高了灵活性。