TONIGHT Solomon Chang proudly presents: MySQL Clustering

1. Welcome to the UUASC LA Chapter • TONIGHT • Solomon Chang • proudly presents: • MySQL Clustering

2. NDB Cluster • High Availability* • Shared-Nothing Architecture • Redundancy

3. Server Requirements • Any machine that can run MySQL

4. Server Requirements • Any machine that can run MySQL • Non-Microsoft Operating System

5. Server Requirements • Any machine that can run MySQL • Non-Microsoft Operating System • A buttload of RAM

7. Types of Nodes • Data Nodes • ndbd • Management Nodes • ndb_mgmd • API Nodes • mysqld • ndb_mgm

9. Bits and Pieces • Partition (AKA Fragment) • A portion of a table • Replica • A copy of a Partition • Node Group • A collection of individual data nodes

15. Security of Nodes

16. Security of Nodes • Authentication: None

17. Security of Nodes • Authentication: None • Encryption: None

18. Security of Nodes • Authentication: None • Encryption: None • Management and Data Nodes are very trusting as to who or what connects to them

21. Transports • Gigabit Ethernet • Bare recommended minimum • SCI • Scalable Coherent Interconnect • Infiniband

22. Performance • Primary Key are hashes

23. Performance • Primary Key are hashes • Hashed values determine which rows are distributed to which data nodes

24. Performance • Primary Key are hashes • Hashed values determine which rows are distributed to which data nodes • Pushdown

25. Performance • Primary Key are hashes • Hashed values determine which rows are distributed to which data nodes • Pushdown • Spreading query work across multiple data nodes • set engine_condition_pushdown = 1

26. Data Node Setup In /etc/my.cnf: [MYSQLD] ndbcluster ndb-connectstring=10.0.0.152 [MYSQL_CLUSTER] ndb-connectstring=10.0.0.152

27. Management Node Setup • config.ini sections • [ndbd] • [ndb_mgmd] • [mysqld]

28. Management Node Setup • config.ini sections • [ndbd] • [ndb_mgmd] • [mysqld] • Sections can be blank

29. Management Node Setup • config.ini sections • [ndbd] • [ndb_mgmd] • [mysqld] • Sections can be blank • There can be multiple instances of a section

30. SQL Node Setup Just like the Data Node Setup In /etc/my.cnf: [MYSQLD] ndbcluster ndb-connectstring=10.0.0.152 [MYSQL_CLUSTER] ndb-connectstring=10.0.0.152

31. SQL Node Setup The Management Node already knows this is a SQL node from its config.ini file

32. Enough Talking It's showtime

33. Cluster Replication Cluster replication is exactly the same as regular MySQL replication, with the exception of the Binary Log Injection Thread.

35. Backup and Restoration Why would a fault-tolerant, completely redundant system would ever need to have a backup for restoring data?

36. Disk-Based NDB Cluster

37. HA Caveat • SQL Nodes