Part 2 MySQL InnoDB Cluster 8.0 in a Nutshell-full day tutorial

在本教程中,与会者将接触到虚拟机,并将标准的主从体系结构迁移到新的mysql innodb集群(本机组复制),同时将停机时间降到最低。在解释了什么是组复制以及它是如何工作的(背后的魔力)之后,我们将使用多个用例来了解MySQL组复制。我们还将让与会者更熟悉这项新技术,并解释自8.0.14以来我们引入的新功能的所有好处,如支持的不同数据一致性模型。
在我们的实验中,我们将尝试:
-完全停止节点
-杀死一个节点
-重新加入节点
-产生冲突并查看集群的行为
-创建数据不一致
-从完全群集中断中恢复
最后,我们将检查如何将mysql-innodb集群与proxysql等外部路由解决方案集成。我们还将了解如何使用集群向性能模式和sys模式公开的内容来做出正确的选择。
我们将重点介绍MySQL8.0在组复制和InnoDB集群方面所做的新改进。

展开查看详情

1. 1 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 1/230

2. 2 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 2/230

3. 3 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial MySQL InnoDB Cluster in a Nutshell Hands-On Tutorial Percona Live USA - Austin, TX 2019 Frédéric Descamps - MySQL Community Manager - Oracle Kenny Gryp - MySQL Product Manager - Oracle file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 3/230

4. 4 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial   Safe Harbor Statement The following is intended to outline our general product direction. It is intended for information purpose only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied up in making purchasing decisions. The development, release and timing of any features or functionality described for Oracle´s product remains at the sole discretion of Oracle. file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 4/230 Copyright @ 2019 Oracle and/or its affiliates. All rights reserved.

5. 5 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial Who are we ? file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 5/230 Copyright @ 2019 Oracle and/or its affiliates. All rights reserved.

6. 6 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial   Frédéric Descamps @lefred MySQL Evangelist Managing MySQL since 3.23 devops believer http://about.me/lefred file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 6/230 Copyright @ 2019 Oracle and/or its affiliates. All rights reserved.

7. 7 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial   Kenny Gryp @gryp MySQL Product Manager     High Availability & InnoDB file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 7/230 Copyright @ 2019 Oracle and/or its affiliates. All rights reserved.

8. 8 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial how will the session proceed? Agenda file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 8/230 Copyright @ 2019 Oracle and/or its affiliates. All rights reserved.

9. 9 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial Agenda Prepare your workstation file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 9/230 Copyright @ 2019 Oracle and/or its affiliates. All rights reserved.

10. 10 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial Agenda Prepare your workstation What is MySQL InnoDB Cluster & Group Replication ? file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 10/230 Copyright @ 2019 Oracle and/or its affiliates. All rights reserved.

11. 11 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial Agenda Prepare your workstation What is MySQL InnoDB Cluster & Group Replication ? Migrating from Asynchronous Replication to Group Replication file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 11/230 Copyright @ 2019 Oracle and/or its affiliates. All rights reserved.

12. 12 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial Agenda Prepare your workstation What is MySQL InnoDB Cluster & Group Replication ? Migrating from Asynchronous Replication to Group Replication Monitoring file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 12/230 Copyright @ 2019 Oracle and/or its affiliates. All rights reserved.

13. 13 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial Agenda Prepare your workstation What is MySQL InnoDB Cluster & Group Replication ? Migrating from Asynchronous Replication to Group Replication Monitoring Connecting to the cluster file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 13/230 Copyright @ 2019 Oracle and/or its affiliates. All rights reserved.

14. 14 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial Agenda Prepare your workstation What is MySQL InnoDB Cluster & Group Replication ? Migrating from Asynchronous Replication to Group Replication Monitoring Connecting to the cluster Various Configuration Options file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 14/230 Copyright @ 2019 Oracle and/or its affiliates. All rights reserved.

15. 15 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial Agenda Prepare your workstation What is MySQL InnoDB Cluster & Group Replication ? Migrating from Asynchronous Replication to Group Replication Monitoring Connecting to the cluster Various Configuration Options Application Behavior & Consistency Guarantees file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 15/230 Copyright @ 2019 Oracle and/or its affiliates. All rights reserved.

16. 16 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial Agenda Prepare your workstation What is MySQL InnoDB Cluster & Group Replication ? Migrating from Asynchronous Replication to Group Replication Monitoring Connecting to the cluster Various Configuration Options Application Behavior & Consistency Guarantees Failure Scenarios - Labs file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 16/230 Copyright @ 2019 Oracle and/or its affiliates. All rights reserved.

17. 17 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial VirtualBox Setup your workstation file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 17/230 Copyright @ 2019 Oracle and/or its affiliates. All rights reserved.

18. 18 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial Setup your workstation Install VirtualBox 6.0 On the USB key, COPY MySQLInnoDBCluster_PLUS19.ova and click on it Ensure you have vboxnet0 network interface Older VirtualBox: VirtualBox Pref. -> Network -> Host-Only Networks -> + New VirtualBox: Global Tools -> Host Network Manager -> + file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 18/230 Copyright @ 2019 Oracle and/or its affiliates. All rights reserved.

19. 19 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial Login on your workstation Start all virtual machines (mysql1, mysql2, mysql3 & mysql4) Try to connect to all VM´s from your terminal or putty (root password is X) : ssh root@192.168.56.11 mysql1 ssh root@192.168.56.12 mysql2 ssh root@192.168.56.13 mysql3 ssh root@192.168.56.14 mysql4 file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 19/230 Copyright @ 2019 Oracle and/or its affiliates. All rights reserved.

20. 20 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial LAB1: Current situation file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 20/230 Copyright @ 2019 Oracle and/or its affiliates. All rights reserved.

21. 21 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial LAB1: Current situation all running database servers (mysql1 & mysql2) are using MySQL 5.7.24 file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 21/230 Copyright @ 2019 Oracle and/or its affiliates. All rights reserved.

22. 22 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial LAB1: Current situation launch run_app.sh on mysql1 into a screen session verify that mysql2 is a running replica file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 22/230 Copyright @ 2019 Oracle and/or its affiliates. All rights reserved.

23. 23 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial Summary   ROLE INTERNAL IP mysql1 master 192.168.56.11 mysql2 replica 192.168.56.12 mysql3 n/a 192.168.56.13 mysql4 n/a 192.168.56.14 file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 23/230 Copyright @ 2019 Oracle and/or its affiliates. All rights reserved.

24. 24 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial Summary   ROLE INTERNAL IP mysql1 master 192.168.56.11 mysql2 replica 192.168.56.12 mysql3 n/a 192.168.56.13 mysql4 n/a 192.168.56.14 write this down somewhere ! file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 24/230 Copyright @ 2019 Oracle and/or its affiliates. All rights reserved.

25. 25 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial Easy High Availability MySQL InnoDB Cluster file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 25/230 Copyright @ 2019 Oracle and/or its affiliates. All rights reserved.

26. 26 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial Ease-of-Use Built-in HA InnoDB Out-of-Box Solution Everything Integrated cluster Extreme Scale-Out High Performance file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 26/230 Copyright @ 2019 Oracle and/or its affiliates. All rights reserved.

27. 27 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial InnoDB Cluster's Architecture App App lica lica t ion tion My My SQL SQL Con Con nec nec tor tor My My SQL SQL Rou Rou ter ter Mp M M B r My SQL She D e ll Inno lust c file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 27/230 Copyright @ 2019 Oracle and/or its affiliates. All rights reserved.

28. 28 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial Group Replication: heart of MySQL InnoDB Cluster file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 28/230 Copyright @ 2019 Oracle and/or its affiliates. All rights reserved.

29. 29 / 230 5/25/2019 MySQL InnoDB Cluster and Group Replication in a Nutshell: Hands-On Tutorial Group Replication: heart of MySQL InnoDB Cluster file:///home/fred/workspace/MySQL-InnoDB-Cluster---Nutshell/MySQL InnoDB Cluster - Nutshell.html#226 29/230 Copyright @ 2019 Oracle and/or its affiliates. All rights reserved.