Setting MySQL Configuration Variables – MySQL 5.7 vs MySQL 8.0

Posted: November 4, 2020

MySQL configuration variables are a set of server system variables used to configure the operation and behavior of the server. In this blog post, we will explain the differences in managing the configuration variables between MySQL 5.7 and MySQL 8.0. We will explain three different ways for...

Read Article

ScaleGrid Launches Google Cloud Platform (GCP) Support for Managed Database Hosting

Posted: October 14, 2020

PALO ALTO, Calif., October 14, 2020 – ScaleGrid, a leading Database-as-a-Service (DBaaS) provider, has just announced the launch of Google Cloud Platform (GCP) hosting through their fully managed DBaaS plans. In addition to their AWS, Azure and DigitalOcean hosting solutions, ScaleGrid will now...

Read Article

MongoDB SSL with self-signed certificates in C#

Posted: September 18, 2020

When deploying MongoDB in production, it is strongly recommended that you use an SSL-enabled geo-distributed replica-set configuration for maximum security and availability. ScaleGrid provides you two options for setting up SSL. One option is purchasing your own CA-signed SSL certificates and...

Read Article

MySQL on Azure Performance Benchmark – ScaleGrid vs. Azure Database

Posted: August 26, 2020

Microsoft Azure is one of the most popular cloud providers in the world, and a natural fit for database hosting on applications leveraging Microsoft across their infrastructure. MySQL is the number one open source database that’s commonly hosted through Azure instances. While Microsoft offers...

Read Article

PostgreSQL Connection Pooling: Part 4 – PgBouncer vs. Pgpool-II

Posted: July 29, 2020

In our previous posts in this series, we spoke at length about using PgBouncer and Pgpool-II, the connection pool architecture and pros and cons of leveraging one for your PostgreSQL deployment. In our final post, we will put them head-to-head in a detailed feature comparison and compare the...

Read Article

Using JSONB in PostgreSQL: How to Effectively Store & Index JSON Data in PostgreSQL

Posted: July 17, 2020

JSON stands for JavaScript Object Notation. It is an open standard format which organizes data into key/value pairs and arrays detailed in RFC 7159. JSON is the most common format used by web services to exchange data, store documents, unstructured data, etc. In this post, we are going to show you...

Read Article

PostgreSQL vs. Oracle: Difference in Costs, Ease of Use & Functionality

Posted: July 13, 2020

Oracle Database is a commercial, proprietary multi-model database management system produced by Oracle Corporation, and the largest relational database management system (RDBMS) in the world. While Oracle remains the #1 database on the market, its popularity has steadily declined by over 18% since...

Read Article

Redis Transactions & Long-Running Lua Scripts

Posted: July 8, 2020

Redis offers two mechanisms for handling transactions - MULTI/EXEC based transactions and Lua scripts evaluation. Redis Lua scripting is the recommended approach and is fairly popular in usage. Our Redis™ customers who have Lua scripts deployed often report this error - “BUSY Redis is busy...

Read Article

MongoDB Index Builds – Preventing Users From Triggering New Builds

Posted: June 30, 2020

Index builds on MongoDB production clusters need to be handled with the utmost care. We have documented the issues in detail in one of our previous blog posts - The Perils of Building Indexes on MongoDB. Depending on the size of your data, both foreground and background builds can bring your...

Read Article

Best MySQL DigitalOcean Performance – ScaleGrid vs. DigitalOcean Managed Databases

Posted: June 22, 2020

MySQL is the all-time number one open source database in the world, and a staple in RDBMS space. DigitalOcean is quickly building its reputation as the developers cloud by providing an affordable, flexible and easy to use cloud platform for developers to work with. MySQL on DigitalOcean is a...

Read Article

Setting MySQL Configuration Variables – MySQL 5.7 vs MySQL 8.0

MongoDB SSL with self-signed certificates in C#

PostgreSQL Connection Pooling: Part 4 – PgBouncer vs. Pgpool-II

Using JSONB in PostgreSQL: How to Effectively Store & Index JSON Data in PostgreSQL

Redis Transactions & Long-Running Lua Scripts

MongoDB Index Builds – Preventing Users From Triggering New Builds

Best MySQL DigitalOcean Performance – ScaleGrid vs. DigitalOcean Managed Databases

Search:

About us:

You may also be interested in

MongoDB

Redis™

MySQL

PostgreSQL

Pricing

About Us

Resources

Terms of Service