In Part I, we introduced a High Availability (HA) framework for MySQL hosting and discussed various components and their functionality. Now in Part II, we will discuss the details of MySQL semi-synchronous replication and the related configuration settings that help us ensure redundancy and consistency of the data in our HA setup. Make sure to check back in for Part III where … [Read more...] about MySQL High Availability Framework Explained Part II
MySQL
How DevOps Should Use DBaaS (Database-as-a-Service) To Optimize Their Application Development?
Database-as-a-Service (DBaaS) is quickly gaining in popularity across the tech world. These software platform solutions helps users easily manage their database operations without having to really understand any of the abstractions. This allows developers, DBA's and DevOps engineers to quickly automate their backups, create new SQL and NoSQL clusters, and monitor the … [Read more...] about How DevOps Should Use DBaaS (Database-as-a-Service) To Optimize Their Application Development?
Improving MySQL by Replicating to the In-Memory Database Tarantool
Replicating MySQL is one of the in-memory-database Tarantool's killer functions. It allows you to keep your existing MySQL database while at the same time accelerating it and scaling it out horizontally. Even if you aren't interested in extensive expansion, simply replacing existing replicas with Tarantool can save you money, because Tarantool is more efficient per core than … [Read more...] about Improving MySQL by Replicating to the In-Memory Database Tarantool
Slow MySQL Start Time in GTID? Binary Log File Size May Be The Issue
Have you been experiencing slow MySQL startup times in GTID mode? We recently ran into this issue on one of our MySQL hosting deployments and set out to solve the problem. In this blog, we break down the issue that could be slowing down your MySQL restart times, how to debug for your deployment, and what you can do to decrease your start time and improve your understanding … [Read more...] about Slow MySQL Start Time in GTID? Binary Log File Size May Be The Issue
MySQL High Availability Framework Explained – Part I
In this two-part blog series, we will explain the details and functionality of a High Availability (HA) framework for MySQL hosting using MySQL semi-synchronous replication and the Corosync plus Pacemaker stack. In Part I, we'll walk you through the basics of High Availability, the components of an HA framework, and then introduce you to the HA framework for MySQL. MySQL High … [Read more...] about MySQL High Availability Framework Explained – Part I
