《mysql_wp_fabric》.pdfVIP

MySQL Fabric A Guide to Managing MySQL High Availability and Scaling Out A MySQL® White Paper May 2014 Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Table of Contents 1 EXECUTIVE SUMMARY 3 2 WHAT MYSQL FABRIC PROVIDES 4 2.1 HIGH AVAILABILITY 4 2.1.1 Different Points of High Availability 4 2.1.2 MySQL Replication 5 2.1.3 What MySQL Fabric Adds in Terms of High Availability6 2.3 SCALING OUT - SHARDING 7 3 WHERE MYSQL FABRIC SITS WITH OTHER MYSQL OFFERINGS FROM ORACLE 8 4 CURRENT LIMITATIONS 9 5 ARCHITECTED FOR EXTENSIBILITY 9 6 GETTING HANDS-ON - TUTORIALS10 6.1 ADDING HIGH AVAILABILITY 10 6.2 ADDING SCALE-OUT WITH SHARDING 19 7 OPERATIONAL BEST PRACTICES 27 7.1 ORACLE UNIVERSITY 27 7.2 MYSQL CONSULTING 27 7.2.1 MySQL Enterprise Edition and MySQL Cluster Carrier Grade Edition (CGE) 27 8 CONCLUSION 29 9 ADDITIONAL RESOURCES 29 Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Page 2 1 Executive Summary MySQL is famous for being a very easy to use database and with the InnoDB storage engine it delivers great performance, functionality and reliability. MySQL/InnoDB now scales-up extremely well as you add more cores to the server and this continues to improve with each release but at some point a limit is reached where scaling up is no longer enough. It could be youre already using the largest available machine or its just more economical to use multiple, commodity servers. Sca