pxc introduction

1 .Percona XtraDB Cluster Kenny Gryp @gryp 1 07 03 2017 

2 .Agenda 2 • Default asynchronous MySQL replication • Percona XtraDB Cluster: • Introduction / Features / Load Balancing • Use Cases: • High Availability / WAN Replication / Read Scaling • Limitations 

3 .Percona 3 • Percona is the oldest and largest independent MySQL Support, Consulting, Remote DBA, Training, and Software Development company with a global, 24x7 staff of over 100 serving more than 2,000 customers in 50+ countries since 2006 • Our contributions to the MySQL community include: • Percona Server for MySQL, Percona XtraDB Cluster • Percona Server for MongoDB • Percona XtraBackup: online backup • Percona Toolkit • Percona Monitoring & Management… 

4 .Agenda 4 • Default asynchronous MySQL Replication • Percona XtraDB Cluster: • Introduction / Features / Load Balancing • Use Cases: • High Availability / WAN Replication / Read Scaling • Limitations 

5 .MySQL Replication 5 If your HA is based on MySQL Replication - You may be playing a dangerous game ! 

6 .Traditional Replication Approach 6 replication stream Server 1 Server 2 “master” “slave” 

7 .MySQL Replication 7 • Common Topologies: • Master-Master (Only 1 active master) • 1 or more layers of replication 1 2 3 4 5 6 

8 .MySQL Replication 8 • Slaves can be used for reads: • asynchronous, stale data is the rule • data loss possible (*semi-sync) 1 2 3 4 5 6 

9 .MySQL Replication 9 • non-trivial: • external monitoring • scripts for failover 1 2 • add node == restore backup • much better in 3 4 MySQL 5.6: GTIDs 5 6 

10 .Agenda 10 • Default asynchronous MySQL Replication • Percona XtraDB Cluster: • Introduction / Features / Load Balancing • Use Cases: • High Availability / WAN Replication / Read Scaling • Limitations 

11 .Data Centric 11 DATA Server 1 Server 2 Server 3 ... Server N 

12 .Percona XtraDB Cluster 12 

13 .Percona XtraDB Cluster 13 • All nodes have a full copy of the data • Every node is equal • No central management, no SPOF 

14 .Understanding Galera 14 The cluster can be 38 seen as a meeting ! 

15 .PXC (Galera cluster) is a meeting 15 bfb912e5-f560-11e2-0800-1eefab05e57d 

16 .PXC (Galera cluster) is a meeting 16 bfb912e5-f560-11e2-0800-1eefab05e57d 

17 .PXC (Galera cluster) is a meeting 17 bfb912e5-f560-11e2-0800-1eefab05e57d 

18 .PXC (Galera cluster) is a meeting 18 bfb912e5-f560-11e2-0800-1eefab05e57d 

19 .PXC (Galera cluster) is a meeting 19 bfb912e5-f560-11e2-0800-1eefab05e57d 

20 .PXC (Galera cluster) is a meeting 20 bfb912e5-f560-11e2-0800-1eefab05e57d 

21 .PXC (Galera cluster) is a meeting 21 bfb912e5-f560-11e2-0800-1eefab05e57d 

22 .PXC (Galera cluster) is a meeting 22 

23 .PXC (Galera cluster) is a meeting 23 ??? 

24 .PXC (Galera cluster) is a meeting 24 New meeting ! 4fd8824d-ad5b-11e2-0800-73d6929be5cf 

25 . What is Percona XtraDB Cluster ? 25 • Percona Server • + WSREP patches • + Galera library • + Utilities (init, SST and cluster check scripts) • + Percona Changes to Galera 

26 . Percona Server 26 • This is a free open source solution, Percona Server is a MySQL alternative which offers breakthrough performance, scalability, features, and instrumentation. Self-tuning algorithms and support for extremely high-performance hardware make it the clear choice for organisations that demand excellent performance and reliability from their MySQL database server. 

27 . WSREP and Galera 27 • WSREP API is a project to develop generic replication plugin interface for databases (WriteSet Replication) • Galera is a wsrep provider that implements multi- master, synchronous replication • Other 'Similar' Implementations: • MariaDB Galera Cluster • Galera Cluster For MySQL 

28 .What is Percona XtraDB Cluster ? 28 Full compatibility with existing systems 

29 .What is Percona XtraDB Cluster ? 29 Minimal efforts to migrate