PostgreSQL Connection Pooling: Part 3 – Pgpool-II

Posted: March 23, 2020

In our previous posts in this series, we discussed the case for connection pooling and introduced PgBouncer. In this post, we will discuss its most popular alternative - Pgpool-II. Pgpool-II is the swiss army knife of PostgreSQL middleware. It supports high-availability, provides automated load...

Read Article

COVID-19 Preparedness at ScaleGrid

Posted: March 23, 2020

Customers & Friends, With the impact of COVID-19 growing around the world, we are taking proactive steps to prepare our infrastructure to continue seamlessly as we navigate this critical time. In an abundance of caution to the rapidly growing climate of the pandemic, we are taking extreme...

Read Article

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

PostgreSQL Connection Pooling: Part 3 – Pgpool-II

COVID-19 Preparedness at ScaleGrid

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

Search:

About us:

You may also be interested in

MongoDB

Redis™

MySQL

PostgreSQL

Pricing

About Us

Resources

DPA