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
database performance
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
MongoDB Write Concern: 3 Must-Know Caveats
'Write concern' in MongoDB describes the level of write acknowledgment you can expect from it. It's a rather important setting to remember in your write operations and its behavior is useful to understand, especially in distributed MongoDB deployments (i.e. replica sets and sharded clusters). In this post, we discuss 3 gotchas when using MongoDB write concern. Read the original … [Read more...] about MongoDB Write Concern: 3 Must-Know Caveats
Data Integrity and Performance Considerations in MySQL Semisynchronous Replication
MySQL semisynchronous replication provides improved data integrity because when a commit returns successfully, it's known that the data exists in at least two places “ the master and its slave. In this blog post, we review some of the MySQL configurations that influence the data integrity and performance aspects of semisynchronous replication. We'll be using InnoDB storage … [Read more...] about Data Integrity and Performance Considerations in MySQL Semisynchronous Replication
