Auditing PostgreSQL Using pgAudit

Posted: January 14, 2021

Auditing in information technology (IT) is a process of examining an organization’s IT infrastructure to ensure compliance with the requirements imposed by recognized standards or established policies. Data protection rules, such as the new GDPR regulations, are becoming increasingly stringent to...

Read Article

mysqldump Best Practices: Part 1 – MySQL Prerequisites

Posted: December 16, 2020

Mysqldump is a client utility that is used to perform logical backups of the MySQL database. This popular migration tool is useful for various use cases of MySQL such as: Backup and restore of databases. Migrating data from one server to another. Migrating data across different managed MySQL...

Read Article

Redis on Azure Performance Benchmark – ScaleGrid for Redis™ vs. Azure Cache

Posted: November 26, 2020

Redis is an advanced key-value store. In fact, it is the number one key value store and eighth most popular database in the world. It has high throughput and runs from memory, but also has the ability to persist data on disk. Redis is a great caching solution for highly demanding applications, and...

Read Article

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

Auditing PostgreSQL Using pgAudit

mysqldump Best Practices: Part 1 – MySQL Prerequisites

Redis on Azure Performance Benchmark – ScaleGrid for Redis™ vs. Azure Cache

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

Search:

About us:

You may also be interested in

MongoDB

Redis™

MySQL

PostgreSQL

Pricing

About Us

Resources

Terms of Service