pxc introduction

Percona XtraDB Cluster - West Flanders Meetup

展开查看详情

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