Important Health Checks for your MySQL Master-Slave Servers

Posted: February 17, 2020

In a MySQL master-slave high availability (HA) setup, it is important to continuously monitor the health of the master and slave servers so you can detect potential issues and take corrective actions. In this blog post, we explain some basic health checks you can do on your MySQL master and slave...

Read Article

Follower Clusters – 3 Major Use Cases for Syncing SQL & NoSQL Deployments

Posted: January 20, 2020

Follower clusters are a ScaleGrid feature that allows you to keep two independent database systems (of the same type) in sync. Unlike cloning or replication, this allows you to maintain an active, point-in-time copy of your production data. This extra cluster, known as a follower cluster, can be...

Read Article

How to Monitor MySQL Deployments with Prometheus & Grafana at ScaleGrid

Posted: January 3, 2020

Monitoring your MySQL database performance in real-time helps you immediately identify problems and other factors that could be causing issues now or in the future. It's also a good way to determine which components of the database can be enhanced or optimized to increase your efficiency and...

Read Article

PostgreSQL Connection Pooling: Part 2 – PgBouncer

Posted: December 19, 2019

When it comes to connection pooling in the PostgreSQL world, PgBouncer is probably the most popular option. It's a very simple utility that does exactly one thing - it sits between the database and the clients and speaks the PostgreSQL protocol, emulating a PostgreSQL server. A client connects to...

Read Article

The Best Way to Host MongoDB on DigitalOcean

Posted: December 16, 2019

MongoDB is the #3 open source database and the #1 NoSQL database in the world. It’s a cross-platform document-oriented database that uses JSON-like documents with schema, and is leveraged broadly across startup apps up to enterprise-level businesses developing modern apps. While you may assume a...

Read Article

Re-Slaving a Crashed MySQL Master Server in Semisynchronous Replication Setup

Posted: December 9, 2019

In a MySQL 5.7 master-slave setup that uses the default semisynchronous replication setting for rpl_semi_sync_master_wait_point, a crash of the master and failover to the slave is considered to be lossless. However, when the crashed master comes back, you may find that it has transactions that are...

Read Article

ScyllaDB Trends – How Users Deploy The Real-Time Big Data Database

Posted: November 25, 2019

ScyllaDB is an open-source distributed NoSQL data store, reimplemented from the popular Apache Cassandra database. Released just four years ago in 2015, Scylla has averaged over 220% year-over-year growth in popularity according to DB-Engines. We’ve heard a lot about this rising database from the...

Read Article

Best Practice for Creating Indexes on your MySQL Tables – Rolling Index Builds

Posted: November 20, 2019

By having appropriate indexes on your MySQL tables, you can greatly enhance the performance of SELECT queries. But, did you know that adding indexes to your tables in itself is an expensive operation, and may take a long time to complete depending on the size of your tables? During this time, you...

Read Article

Making it Easier to Manage a Production PostgreSQL Database

Posted: November 12, 2019

The past several years have seen increasing adoption for PostgreSQL. PostgreSQL is an amazing relational database. Feature-wise, it is up there with the best, if not the best. There are many things I love about it - PL/ PG SQL, smart defaults, replication (that actually works out of the box), and...

Read Article

What’s the Best PostgreSQL High Availability Framework? PAF vs. repmgr vs. Patroni Infographic

Posted: October 31, 2019

Wondering which high availability framework to use for your PostgreSQL deployments? We compared the top 3 frameworks, PostgreSQL Automatic Failover (PAF) vs. Replication Manager (repmgr) vs. Patroni, in our Managing High Availability in PostgreSQL series. In these blogs, we dove deep into how...

Read Article

Important Health Checks for your MySQL Master-Slave Servers

Follower Clusters – 3 Major Use Cases for Syncing SQL & NoSQL Deployments

How to Monitor MySQL Deployments with Prometheus & Grafana at ScaleGrid

PostgreSQL Connection Pooling: Part 2 – PgBouncer

Re-Slaving a Crashed MySQL Master Server in Semisynchronous Replication Setup

Best Practice for Creating Indexes on your MySQL Tables – Rolling Index Builds

Making it Easier to Manage a Production PostgreSQL Database

What’s the Best PostgreSQL High Availability Framework? PAF vs. repmgr vs. Patroni Infographic

Search:

About us:

You may also be interested in

MongoDB

Redis™

MySQL

PostgreSQL

Pricing

About Us

Resources

DPA