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
Cloud
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?
Why Scalability Should Not Be Your First Priority
Businesses are expected to grow, and the websites and applications that support them must be able to grow too. Scalability is a core concern for many founders. But building an application that can smoothly scale from a handful of users to tens of millions is challenging and complex. It takes expertise, time, and an expensive infrastructure platform. Early-stage startups have … [Read more...] about Why Scalability Should Not Be Your First Priority
How To Pick A Data Backup Method For Your Enterprise
The digital age is all about data security and privacy, but that doesn't mean businesses and private individuals have much of a clue when it comes to properly back up their information. Despite the fact that finding the right data backup method isn't always a breeze, it doesn't have to be a migraine headache, nor do you have to spend a small fortune in order to ensure your … [Read more...] about How To Pick A Data Backup Method For Your Enterprise
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