Welcome to Planets9s, a weekly communication on all the latest resources and technologies that we create at Severalnines around automation and management of open source databases. I trust that these resources will be useful to you and would love to get your feedback on them.
Download our whitepaper on automation & management of open source databases
Whether you’re looking into ways to automate various aspects of administering your open source databases or to take better control of your data, this whitepaper covers what tools to build (or buy) for effective management, database deployment options beyond Chef or Puppet, important aspects of monitoring and managing open source database infrastructures and how ClusterControl enables a systematic approach to their operations.
Managing MySQL Replication for High Availability
If you’re looking into deploying a MySQL Replication topology or maintaining one, you’ll find great insight in this webinar replay about topology changes, managing slave lag, promoting slaves, repairing replication issues, fixing broken nodes, managing schema changes and scheduling backups. Multi-datacenter replication is also covered.
High availability read-write splitting with php-mysqlnd, MySQL Replication and HAProxy
MySQL Replication is used in a variety of use cases - scale out read workloads, provide high availability and geographic redundancy, offload backups and reporting/analytic jobs. However it has a big drawback - the application needs to be able to send writes to the master only. In this blog post, we explore the use of php-mysqlnd_ms with a PHP application (Wordpress) on a standard MySQL Replication backend.
Do share these resources with your colleagues and follow us in our social media channels.
Have a good weekend,