Automating MySQL Deployments on Kubernetes
容器还没有为数据库做好准备的神话仍然存在。我们不买它。
我们已经为Kubernetes构建并开放源代码的mysql操作符,以解决这个问题,作为开放WordPress托管基础设施PressLabs堆栈中的一个层。
我们使用许多中小型DBS,每个服务模型都有一个DB,我们称之为DBS。工作负载主要是读取的,因此我们需要有效地扩展它。MySQL异步复制模型非常适合这个需求,允许从一台服务器(具有明显的可用性缺陷)横向扩展到数十个节点。
该运营商基于Percona Server for MySQL进行操作改进,如“实用程序用户和备份锁”,并依靠Orchestrator进行自动故障切换。
我们计划将其与Percona管理和监控相结合。社区对它自动化的操作以及确保数据安全存储的反馈是非常受欢迎的。
展开查看详情
1.Automating MySQL Deployments on Kubernetes Calin Don & Flavius Mecea Presslabs
2.Automating MySQL Deployments on Kubernetes Percona Live 2018
3.00. Who are we? Calin Don Flavius Mecea Co-founder & CTO Project Lead @Presslabs @Presslabs
4.01. Context 02. The Need 03. Solution 04. Use cases 05. Outcomes 06. Demo 07. Project status 08. Future plans
5.01. Context
6.01. Context 2007 2011 2013 2015 2018 WordPress Managed Record: 2,2 BN Top tier in Open-Source development WordPress pageviews in a Enterprise Stack agency hosting month hosting
7.01. Context / Why Kubernetes? ● Ubiquitous technology ● Open-source ● The core of our Stack
8.02. The Need
9.02. The Need 1. Easy MySQL Cluster deployment in Kubernetes 2. Scalable MySQL Cluster* 3. High availability for MySQL 4. Automated backups & restore 5. Built-in monitoring
10.03. The Need didn’t fit our scaling model didn’t provide enough automation
11.03. Solution
12.03. Solution Kubernetes Operator for managing MySQL Clusters with asynchronous or semi-synchronous replication. ● Self-healing clusters ● Highly available reads ● Virtually highly available writes ● Replication lag detection and mitigation ● Resource abuse control ● Automated backups and restores
13.03. Solution How it’s made
14.03. Solution Node internals
15.03. Solution Percona is battle-tested in Enterprise environments. NOW UPCOMING ● Percona XtraBackup ● Percona Monitoring & Management ● Percona Toolkit ● Percona Server for MySQL
16.04. Use Cases
17.04. Use Cases ● Microservices ● Ephemeral databases for testing ● On-premise DBaaS
18.05. Outcomes
19.05. Outcomes / Evaluation setup ~ $50 ~ $50
20.05. Outcomes / Evaluation setup Target performance vs required resources QPS
21.05. Outcomes / Evaluation setup Target performance vs required resources QPS
22.05. Outcomes / Evaluation setup Target performance vs required resources QPS
23.05. Outcomes / Evaluation setup Target performance vs required resources QPS
24.05. Outcomes / Evaluation setup Target performance vs required resources QPS
25.05. Outcomes / Costs ~ $50 ~ $250
26.Calin Don
27.06. Demo time!
28.Demo - install MySQL Operator $ helm repo add presslabs https://presslabs.github.io/charts $ helm install presslabs/mysql-operator --name mysql-operator
29.Demo - install MySQL Operator $ helm repo add presslabs https://presslabs.github.io/charts $ helm install presslabs/mysql-operator --name mysql-operator NAME: mysql-operator LAST DEPLOYED: Fri Nov 2 12:09:24 2018 NAMESPACE: default STATUS: DEPLOYED ...