Exploring MySQL Binlog Server – Ripple

Posted: May 22, 2020

MySQL does not limit the number of slaves that you can connect to the master server in a replication topology. However, as the number of slaves increases, they will have a toll on the master resources because the binary logs will need to be served to different slaves working at different speeds. If...

Read Article

What is Greenplum Database? Intro to the Big Data Database

Posted: May 13, 2020

Greenplum Database is a massively parallel processing (MPP) SQL database that is built and based on PostgreSQL. It can scale towards a multi-petabyte level data workload without a single issue, and it allows access to a cluster of powerful servers that will work together within a single SQL...

Read Article

Reducing Your Database Hosting Costs: DigitalOcean vs. AWS vs. Azure

Posted: April 28, 2020

If you’re hosting your databases in the cloud, choosing the right cloud service provider is a significant decision to make for your long-term hosting costs. This is especially apparent in today's world where organizations are doing whatever they can to optimize and reduce their costs. Over the...

Read Article

Bring Your Own Cloud (BYOC) vs. Dedicated Hosting at ScaleGrid

Posted: April 16, 2020

Where you decide to host your cloud databases is a huge decision. You have to choose your hosting model, a cloud provider, and then your primary and standby regions to deploy to. But, if you’re considering leveraging a managed databases provider, you have another decision to make - are you able...

Read Article

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

Exploring MySQL Binlog Server – Ripple

What is Greenplum Database? Intro to the Big Data Database

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

Search:

About us:

You may also be interested in

MongoDB

Redis™

MySQL

PostgreSQL

Pricing

About Us

Resources

Terms of Service