1 / 16

Deploy and Scale MySQL Cluster Like a Pro Without Opening the Manual

Deploy and Scale MySQL Cluster Like a Pro Without Opening the Manual. Andrew Morgan (clusterdb.com) MySQL Product Manager. Agenda. Overview of MySQL Cluster MySQL Cluster auto-installer Deploy your first Cluster Configure and deploy a more complex, distributed Cluster

moira
Download Presentation

Deploy and Scale MySQL Cluster Like a Pro Without Opening the Manual

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Deploy and Scale MySQL Cluster Like a Pro Without Opening the Manual Andrew Morgan (clusterdb.com) MySQL Product Manager

  2. Agenda • Overview of MySQL Cluster • MySQL Cluster auto-installer • Deploy your first Cluster • Configure and deploy a more complex, distributed Cluster • MySQL Cluster Manager • Single command to bootstrap a Cluster • Add nodes to a running Cluster • Backup & Restore

  3. MySQL Cluster: Overview HIGH SCALE, READS + WRITES 99.999% AVAILABILITY LOW TCO SQL + NoSQL REAL-TIME • Auto-Sharding, Multi-Master • ACID Compliant, OLTP + Real-Time Analytics • Shared nothing, no Single Point of Failure • Self Healing + On-Line Operations • Open Source + Commercial Editions • Commodity hardware + Management, Monitoring Tools • Key/Value + Complex, Relational Queries • SQL + Memcached + JavaScript + Java + JPA + HTTP/REST & C++ • In-Memory Optimization + Disk-Data • Predictable Low-Latency, Bounded Access Time

  4. MySQL Cluster Architecture Clients Application Layer Data Layer Management MySQL Cluster Data Nodes

  5. MySQL Cluster Architecture Clients Application Layer Data Layer Management Management MySQL Cluster Data Nodes

  6. MySQL Cluster Architecture Clients Application Layer Data Layer Management Management MySQL Cluster Data Nodes

  7. MySQL Cluster 7.3: Auto-Installer Auto-Discover Specify Workload • Fast configuration • Auto-discovery • Workload optimized • Repeatable best practices • For MySQL Cluster 7.2 + 7.3 Define Topology Deploy

  8. MySQL Cluster 7.3: Auto-Installer Easy to run: bin/ndb_setup setup.bat • Multi-host support • Remote deployments MySQL Cluster Auto-Installer

  9. Enhancing DevOps Agility, Reducing Downtime

  10. How Does MySQL Cluster Manager Help? Example: Initiating upgrade from MySQL Cluster 7.0 to 7.3 With MySQL Cluster Manager Before MySQL Cluster Manager upgrade cluster --package=7.3 mycluster; Total: 1 Command - Unattended Operation • 1 x preliminary check of cluster state • 8 x ssh commands per server • 8 x per-process stop commands • 4 x scp of configuration files (2 x mgmd & 2 x mysqld) • 8 x per-process start commands • 8 x checks for started and re-joined processes • 8 x process completion verifications • 1 x verify completion of the whole cluster. • Excludes manual editing of each configuration file. Total: 46 commands - 2.5 hours of attended operation

  11. Initial Cluster

  12. Extended Cluster

  13. Evaluate MySQL Cluster CGE 30-Day Trial • Navigate to http://edelivery.oracle.com/ and step through (selecting “MySQL Database” as the Product Pack) • Select MySQL Cluster Manager

  14. Getting Started

  15. Graphic Section Divider

More Related