© 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

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 deployment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72 Operation and maintenance platform and RESTFul API deployment (optional) . . 72 6.3.2 Dump Job Information . . . . . . . . . . .

Changed Features 274 Removed Features 280 Deprecated Features 282 Known Issues and Limitations 283 Platform Requirements 286 Operating System Requirements 286 Software Dependencies 287 Java 290 VMware Master 297 VMware Greenplum 6 Documentation VMware by Broadcom 14 Segments 297 Google Compute Platform (GCP) 297 Virtual Machine Type 297 Compute 297 Memory 298 Network 298 Storage 298 GCP Recommendations Up VMware vSphere Network 351 Verifying the Distributed Virtual Switch Settings 351 Creating the Distributed Port Groups 352 Configuring the Distributed Port Groups 352 VMware Greenplum 6 Documentation

Changed Features 242 Removed Features 248 Deprecated Features 250 Known Issues and Limitations 251 Platform Requirements 255 VMware vSphere Requirements 255 On-Premise Hardware Requirements 255 Operating Storage (EBS) 265 Ephemeral 265 AWS Recommendations 265 Master 265 Segments 265 Google Compute Platform (GCP) 266 Virtual Machine Type 266 VMware Greenplum 6 Documentation VMware, Inc 11 Compute 266 315 Verifying the Distributed Virtual Switch Settings 315 Creating the Distributed Port Groups 316 Configuring the Distributed Port Groups 317 Principles of VMware vSphere Distributed Switch to Uplink

Changed Features 261 Removed Features 267 Deprecated Features 268 Known Issues and Limitations 270 Platform Requirements 273 VMware vSphere Requirements 273 On-Premise Hardware Requirements 273 Operating 284 Master 284 Segments 284 VMware Greenplum 6 Documentation VMware, Inc. 13 Google Compute Platform (GCP) 284 Virtual Machine Type 284 Compute 284 Memory 284 Network 284 Storage 284 GCP Recommendations 334 Verifying the Distributed Virtual Switch Settings 334 Creating the Distributed Port Groups 335 Configuring the Distributed Port Groups 336 Principles of VMware vSphere Distributed Switch to Uplink

Features 241 Deprecated Features 242 Known Issues and Limitations 243 Platform Requirements 247 Supported Platforms 247 Platform Requirements for On-Premise Hardware 248 Operating Systems 248 Software Storage (EBS) 256 Ephemeral 257 AWS Recommendations 257 Master 257 Segments 257 Google Compute Platform (GCP) 258 Virtual Machine Type 258 Compute 258 Memory 258 Network 258 Storage 258 GCP Recommendations 304 Verifying the Distributed Virtual Switch Settings 305 Creating the Distributed Port Groups 305 Configuring the Distributed Port Groups 306 Principles of VMware vSphere Distributed Switch to Uplink

Documentation 141 Client Documentation 141 Related Documentation 141 Related Products 141 Platform Requirements 142 Platform Requirements 0 Operating Systems 142 Software Dependencies 143 Java 145 Hardware Package 285 Uninstalling the R Data Science Library Package 286 Greenplum Platform Extension Framework (PXF) 286 Greenplum Platform Extension Framework (PXF) 0 Installing Additional Supplied Modules 286 Storage (EBS) 318 Ephemeral 319 AWS Recommendations 319 Master 319 Segments 319 Google Compute Platform (GCP) 319 Virtual Machine Type 319 Compute 319 Memory 319 Network 320 Storage 320 GCP Recommendations

Documentation 140 Client Documentation 140 Related Documentation 140 Related Products 140 Platform Requirements 141 Platform Requirements 0 Operating Systems 141 Software Dependencies 142 Java 144 Hardware Package 276 Uninstalling the R Data Science Library Package 276 Greenplum Platform Extension Framework (PXF) 277 Greenplum Platform Extension Framework (PXF) 0 Installing Additional Supplied Modules 277 Storage (EBS) 309 Ephemeral 310 AWS Recommendations 310 Master 310 Segments 310 Google Compute Platform (GCP) 310 Virtual Machine Type 310 Compute 310 Memory 310 Network 311 VMware Greenplum v6.18

Removed Features 238 Deprecated Features 239 Known Issues and Limitations 240 Platform Requirements 244 Platform Requirements for On-Premise Hardware 244 Operating Systems 244 Software Dependencies Storage (EBS) 253 Ephemeral 253 AWS Recommendations 254 Master 254 Segments 254 Google Compute Platform (GCP) 254 Virtual Machine Type 254 Compute 254 Memory 254 Network 254 Storage 254 GCP Recommendations 300 Verifying the Distributed Virtual Switch Settings 301 Creating the Distributed Port Groups 301 Configuring the Distributed Port Groups 302 Principles of VMware vSphere Distributed Switch to Uplink

Server Documentation 132 Client Documentation 132 Related Documentation 132 Related Products 132 Platform Requirements 134 Operating Systems 134 Software Dependencies 135 Java 137 Hardware and Network Data Science Library Package 281 Uninstalling the R Data Science Library Package 281 Greenplum Platform Extension Framework (PXF) 282 Installing Additional Supplied Modules 282 Configuring Timezone Storage (EBS) 313 Ephemeral 314 AWS Recommendations 314 Master 314 Segments 314 Google Compute Platform (GCP) 314 Virtual Machine Type 314 Compute 314 Memory 314 Network 315 Storage 315 GCP Recommendations