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 ...