Automation and Management of Database Clusters
0 likes537 views
Automation and Management of Database Clusters by Vinay Joosery, Severalnines Presented 10.6.2014 at the MariaDB Roadshow in Helsinki, Finland.
Automation and Management of Database Clusters
- 1. Confidential Automation and Management of Database Clusters June 10, 2014 Vinay Joosery Severalnines vinay@severalnines.com
- 3. Confidential Agenda ! Database Infrastructure Lifecycle ! Deploy, Monitor, Manage, Scale ! ClusterControl Overview ! Demo 3 Copyright Severalnines AB
- 4. Confidential Database Infrastructure Lifecycle 4 Copyright 2013 Severalnines AB
- 5. Confidential Database TCO 5 Copyright Severalnines AB Source: IDC, Maximizing the Business Value of Enterprise Database Applications
- 6. Confidential Infrastructure Lifecycle 6 Copyright 2012 Severalnines AB Manage Scale MonitorDeploy
- 7. Confidential Deployment - Beyond Puppet or Chef ! Puppet/Chef are appropriate for a group of single-node components ! E.g. webservers can be clones of each other.. ! Distributed databases are complex ! Different node types & roles ! Orchestration of procedures in a specific order ! Using e.g. Chef for deploying a distributed database ! Yes, it is possible ! Not much Chef functionality is leveraged ! Prepare to write code 7 Copyright Severalnines AB
- 8. Confidential Monitoring - Beyond Nagios ! What do you do when the application is slow? ! Is it Disk? CPU? RAM? Badly written queries? ! What are the symptoms? (Replication queues, Page Faults, locks, # connections, ) ! How do you avoid problems? ! How do you plan for capacity? 8 Copyright Severalnines AB
- 9. Confidential Management - Beyond Monitoring 9 Copyright Severalnines AB
- 10. Confidential Scaling - Beyond Manual Operations 10 Copyright 2012 Severalnines AB
- 11. Confidential ClusterControl Overview 11 Copyright 2013 Severalnines AB
- 12. Confidential ClusterControl In a nutshell 12 Copyright 2012 Severalnines AB Manage Scale MonitorDeploy
- 13. Confidential Supported Databases SQL ! MariaDB Cluster ! MySQL Galera Cluster (Codership) ! Percona XtraDB Cluster ! MySQL Cluster (NDB) ! MySQL Replication 5.6 ! Standalone MySQL/MariaDB NoSQL ! MongoDB Sharded Cluster ! MongoDB Replica Set ! TokuMX Cluster Copyright Severalnines AB 13
- 14. Confidential ClusterControl Automation & Management ! Provisioning ! Deploy a cluster in minutes ! On-premises or in the cloud ! Monitoring ! Systems view ! 1sec resolution ! DB / OS stats ! Real-time / historical ! Management ! Multi cluster/data-center ! Automate repair/recovery, upgrades, backups, cloning, ! One-click scaling 14 Copyright Severalnines AB
- 15. Confidential 15 Copyright 2013 Severalnines AB
- 16. Confidential Demo time 16 Copyright 2013 Severalnines AB
- 17. Confidential Thank You! ! Cluster Configurator ! www.severalnines.com/config ! ClusterControl ! www.severalnines.com/clustercontrol ! Severalnines Blog ! www.severalnines.com/blog 17