© 2018 Percona. 1 Peter Zaitsev Using MySQL for Distributed Database Architectures CEO, Percona PingCAP Infra Meetup, Shanghai, China, May 26, 2018 © 2018 Percona. 2 About Percona Solutions enterprises © 2018 Percona. 3 Presentation Cover Basics Why Going Distributed How to do it © 2018 Percona. 4 Distributed ? MySQL Deployment on More than one System © 2018 Percona. 5 Modern Active Users Possible 15M of Daily Active Users counting time of day skew © 2018 Percona. 8 Distributed Systems Tend To be More Complicated to Develop Against More Complicated to Operate Have

26 Inline Expression . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 Distributed Primary Key . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 Hint Sharding Route Pagination . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38 4.3 Distributed Transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40 4.3.1 Background 165 Governance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 166 Distributed Transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 167 DistSQL . . .

1.8 Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 3.2 Distributed Transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 3.2.1 Background Implementation classes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 317 5.10 Distributed Transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 317 5.10.1 can not cast to Long exception occurs. . . . . . . . . 458 8.3.6 Sharding Why is the default distributed auto‐augment key strategy provided by ShardingSphere not continuous and most of them end with

1.8 Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 3.2 Distributed Transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 3.2.1 Background Implementation classes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 344 5.10 Distributed Transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 344 5.10.1 can not cast to Long exception occurs. . . . . . . . . 497 8.3.6 Sharding Why is the default distributed auto‐augment key strategy provided by ShardingSphere not continuous and most of them end with

Data Sharding . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 1.2.2 Distributed Transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 1.2.3 Database Governance 14 Inline Expression . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 Distributed Primary Key . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 Hint Sharding Route Pagination . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57 3.2 Distributed Transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59 3.2.1 Background

1.8 Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 8.2 Distributed Transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 8.2.1 Background can not cast to Long exception occurs. . . . . . . . . 550 13.4.6 Sharding Why is the default distributed auto‐augment key strategy provided by ShardingSphere not continuous and most of them end with does my custom distributed primary key do not work after imple‐ menting KeyGenerateAlgorithm interface and configuring type property? . 551 13.4.9 Sharding In addition to internal distributed primary key

1.8 Appendix with SQL operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 8.2 Distributed Transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 8.2.1 Background can not cast to Long exception occurs. . . . . . . . . 579 13.3.6 Sharding Why is the default distributed auto‐augment key strategy provided by ShardingSphere not continuous and most of them end with does my custom distributed primary key do not work after imple‐ menting KeyGenerateAlgorithm interface and configuring type property? . 580 13.3.9 Sharding In addition to internal distributed primary key

30 Inline Expression . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 Distributed Primary Key . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 Hint Sharding Route Pagination . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41 4.4 Distributed Transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43 4.4.1 Background DatabaseDiscoveryType . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 234 6.10 Distributed Transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 234 6.10.1

30 Inline Expression . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 Distributed Primary Key . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35 Hint Sharding Route Pagination . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42 4.4 Distributed Transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44 4.4.1 Background 9.1 DatabaseDiscoveryProviderAlgorithm . . . . . . . . . . . . . . . . . . . . . . . 246 6.10 Distributed Transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 246 6.10.1

Implementation Principle . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 Elastic Distributed Implementation . . . . . . . . . . . . . . . . . . . . . . . . . 10 Registry Data Structure . . 58 Common Listener Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . 58 Distributed Listener Configuration . . . . . . . . . . . . . . . . . . . . . . . . . 58 ii 6.2.4 Event Tracing . . . . . . . . 91 10.6 What should you do if you suspect that ElasticJob has a problem in a distributed envi‐ ronment, but it cannot be reproduced and cannot be debugged in the online environment? 91