© 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 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 Additional

Greenplum Text 292 Greenplum Command Center 293 Hardware Requirements 293 VMware Greenplum on DCA Systems 293 Storage 293 Hadoop Distributions 294 VMware vSphere Requirements 294 Public Cloud Requirements 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 by Broadcom 17 Principles of VMware vSphere Distributed Switch to Uplink Assignment 352 Using Four 100GbE Links 353 Enabling VMware vSphere Distributed Switch (vDS) Health Check 354 Next Steps 355

Requirements 142 Platform Requirements 0 Operating Systems 142 Software Dependencies 143 Java 145 Hardware and Network 145 Tanzu Greenplum on DCA Systems 145 Storage 146 Data Domain Boost (Tanzu Greenplum) Inc. 9 Calculating Space Requirements for Metadata and Logs 246 Configuring Your Systems 246 Configuring Your Systems 0 Disable or Configure SELinux 248 Disable or Configure Firewall Software 248 Recommended data directory locations on all segment hosts 267 Next Steps 268 Validating Your Systems 268 Validating Your Systems 0 Validating Network Performance 268 Validating Disk I/O and Memory Bandwidth 269

Requirements 141 Platform Requirements 0 Operating Systems 141 Software Dependencies 142 Java 144 Hardware and Network 144 Tanzu Greenplum on DCA Systems 144 Storage 145 Data Domain Boost (Tanzu Greenplum) Size 238 Calculating Space Requirements for Metadata and Logs 239 Configuring Your Systems 239 Configuring Your Systems 0 Disable or Configure SELinux 241 Disable or Configure Firewall Software 241 Recommended data directory locations on all segment hosts 259 Next Steps 260 Validating Your Systems 260 Validating Your Systems 0 Validating Network Performance 260 Validating Disk I/O and Memory Bandwidth 261

On-Premise Hardware Requirements 273 Operating Systems 273 Software Dependencies 275 Java 277 Hardware and Network 277 VMware Greenplum on DCA Systems 277 Storage 278 VMware Greenplum Tools and Extensions 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 Uplink Assignment 336 Using Four 100GbE Links 336 Enabling VMware vSphere Distributed Switch (vDS) Health Check 337 Next Steps 338 Setting Up VMware vSphere DRS and HA 338 Enabling DRS 338 Enabling HA

On-Premise Hardware Requirements 255 Operating Systems 255 Software Dependencies 256 Java 258 Hardware and Network 259 VMware Greenplum on DCA Systems 259 Storage 259 Data Domain Boost (VMware Greenplum) 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 Uplink Assignment 317 Using Four 100GbE Links 317 Enabling VMware vSphere Distributed Switch (vDS) Health Check 318 Next Steps 319 Setting Up VMware vSphere DRS and HA 319 Enabling DRS 319 Enabling HA

Hardware 221 Operating Systems 222 Software Dependencies 222 Java 224 Hardware and Network 224 VMware Tanzu Greenplum 6 Documentation VMware, Inc 9 Tanzu Greenplum on DCA Systems 225 Storage 225 Data 272 Verifying the Distributed Virtual Switch Settings 273 Creating the Distributed Port Groups 273 Configuring the Distributed Port Groups 274 Principles of VMware Vsphere Distributed Switch to Uplink Uplink Assignment 274 Using Four 100GbE Links 275 Enabling VMware Vsphere Distributed Switch (vDS) Health Check 275 Next Steps 276 Setting Up VMware vSphere DRS and HA 276 Enabling DRS 276 Enabling HA

Requirements for On-Premise Hardware 248 Operating Systems 248 Software Dependencies 249 Java 251 Hardware and Network 251 Tanzu Greenplum on DCA Systems 251 Storage 251 Data Domain Boost (Tanzu Greenplum) 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 Uplink Assignment 306 Using Four 100GbE Links 307 Enabling VMware vSphere Distributed Switch (vDS) Health Check 308 Next Steps 308 VMware Tanzu Greenplum 6 Documentation VMware, Inc 13 Setting Up VMware

Requirements 136 Platform Requirements 0 Operating Systems 136 Software Dependencies 137 Java 139 Hardware and Network 139 Tanzu Greenplum on DCA Systems 139 Storage 140 Data Domain Boost 140 Tools Size 172 Calculating Space Requirements for Metadata and Logs 173 Configuring Your Systems 173 Configuring Your Systems 0 Disable or Configure SELinux 175 Disable or Configure Firewall Software 175 Recommended data directory locations on all segment hosts 193 Next Steps 193 Validating Your Systems 193 Validating Your Systems 0 Validating Network Performance 194 Validating Disk I/O and Memory Bandwidth 195

Requirements for On-Premise Hardware 244 Operating Systems 244 Software Dependencies 245 Java 247 Hardware and Network 247 Tanzu Greenplum on DCA Systems 248 Storage 248 VMware Tanzu Greenplum 6 Documentation 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 Uplink Assignment 302 Using Four 100GbE Links 302 Enabling VMware vSphere Distributed Switch (vDS) Health Check 303 Next Steps 304 Setting Up VMware vSphere DRS and HA 304 Enabling DRS 304 Enabling HA