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
sql
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
Managing High Availability in PostgreSQL Part I
Managing high availability in your PostgreSQL hosting is very important to ensuring your clusters maintain exceptional uptime and strong operational performance so your data is always available to your application. In an earlier blog post, we introduced you to configuring high availability for PostgreSQL using streaming replication, and now we're going to show you how to best … [Read more...] about Managing High Availability in PostgreSQL Part I
Latest PostgreSQL Trends: Most Time-Consuming Tasks & Important Metrics to Track
PostgreSQL, the fourth most popular database and DBMS of the Year in 2017, has exploded in popularity amongst the development and database communities across the world. Stealing market share from leaders Oracle, MySQL, and Microsoft SQL Server, PostgreSQL hosting is also highly leveraged by new businesses in exciting spaces like IoT, e-commerce, SaaS, analytics, and more. Read … [Read more...] about Latest PostgreSQL Trends: Most Time-Consuming Tasks & Important Metrics to Track
