PXC break fix lab

在本教程中,我们将介绍十个场景,在这些场景中,您的PerconaXtradb集群(PXC)/Galera安装可能会变得复杂。我们将在这些场景中打破这些情况,然后您将有机会诊断和修复它们。学习一些最复杂的故障排除技术。
情节:
-新节点无法加入群集
-数据共享(节点追赶):SST、IST
-群集重新启动失败
-数据不一致
-延迟清除gcache
-网络延迟问题
-阻塞事务

展开查看详情

1.PXC Break/Fix Tutorial In this tutorial, we'll walk through over several scenarios where things can get complex with your Percona XtraDB Cluster (PXC)/Galera installation. We will break things in these scenarios and then you'll have a chance to diagnose and fix them. Learn some of the most complex troubleshooting techniques. This tutorial assume that you are somehow familar with the Percona XtraDB Cluster. Galera focus points When talking about Galera, the main key points are the following: ● Node sync: Boostraping, State Transfer, Node joining/leaving. Data replication. ● Network layer (Maintain the cluster as a whole): Quorum, Primary Component, Cluster Stability. ● Data consistency (Guarantee data is the same): Certification, Flow Control. Besides the omnipresent topic on databases, and our reason to live: ​Performance. Environment All the scenarios will take place on a basic 3-node PXC Cluster Creation of the VMs and the cluster are available at the Environment link:​ ​here Galera key scenarios Data Consistency Flow control

2.PXC Strict Mode GRA Files Auto increment Data Consistency Multi Master Schema Requirements Multi thread Network The only sign of a node failure is the loss of connection to the node as seen by other nodes. That's why understanding network in a galera context is key to a happy PXC journeys Quorum WAN Partition Handling (Network Hiccup) GTID Node Sync Getting the pieces together. You only have a cluster when you have the nodes connected and synced. State Transfers Group communication