Welcome to this week’s Planets9s, covering all the latest resources and technologies we create around automation and management of open source database infrastructures.
Database Cluster Management - Manual vs Automation via ClusterControl
Database Cluster management tasks include restart/recovery of services that fail, topology changes, reconfiguration, rolling upgrades, backups and performing security procedures. Since the tasks usually involve multiple servers, these can be repetitive and error-prone. This blog looks at efficiency gains when using ClusterControl to manage a MySQL Galera cluster as compared to manual ways.
MySQL Query Tuning webinar: Working with optimizer and SQL tuning
Join us next Tuesday for the third and final part of our webinar trilogy on MySQL Query Tuning, in which we look at the query tuning process and tools to help with that. For Part 3, Krzysztof Książek, Senior Support Engineer at Severalnines, will take a look at working with the optimizer as well as SQL tuning. This will include a discussion on how execution plans are calculated and a closer look at InnoDB statistics, how to hint the optimizer and finally, how to optimize SQL.
Management and Automation of Open Source Databases
Proprietary databases have been around for decades with a rich third party ecosystem of management tools. But what about open source databases? This whitepaper discusses the various aspects of open source database automation and management as well as the tools available to efficiently run them.
That’s it for this week! Feel free to share these resources with your colleagues and follow us in our social media channels.
Have a good end of the week,