ScaleGrid

Master MySQL Point in Time Recovery

MySQL Point in Time Recovery (PITR) enables restoration to a specific point after a backup. It relies on binary log files to record changes needed for recovery.

Setting Up MongoDB SSL Encryption

Secure your MongoDB connections with SSL to prevent eavesdropping and tampering of your data. Enabling SSL is now as easy as selecting a checkbox.

What is a Distributed Storage System

Learn the essentials of distributed storage systems: their critical role in data management, challenges, and benefits for tech-driven businesses.

MySQL Backups: Methods & Best Practices

Secure your MySQL databases with a proper backup strategy implementation. Never lose important data in case of database failure with MySQL Backups.

Crucial Redis Monitoring Metrics You Must Watch

How do you ensure that your Redis deployment is healthy and meeting requirements? Do you know which Redis monitoring metrics to watch?

MongoDB Rollback: How to Minimize Data Loss

A mongodb rollback does sound daunting but there are simple steps to recover your data in case your system experiences a rollback.

What is a Workload in Cloud Computing

Unlock the secrets of cloud computing workloads: from computational tasks to hosting databases, learn how to optimize cost and efficiency.

Best Practices in Cloud Security Monitoring

Explore effective cloud security monitoring practices, tools, and strategies for a robust cloud infrastructure in our insightful guide.

Enterprise Cloud Security Strategy For 2024

Fortify your cloud in 2024 with Enterprise Cloud Security: a guide on multilayered strategies, compliance, and ScaleGrid's robust solutions.

Multi Cloud vs Hybrid Cloud Strategy

Discover the ideal cloud approach in 'Multi Cloud vs Hybrid Cloud': a guide comparing flexibility, control, and real-world applications.

Artificial Intelligence in Cloud Computing

Explore how artificial intelligence transforms cloud services, optimizing performance and efficiency for the future of technology

Key Advantages of DBMS for Efficient Data Management

Discover the advantages of Database Management Systems (DBMS) and how ScaleGrid's DBMS solution revolutionizes data management.

Optimize MongoDB® Pagination

Paging through your data is one of the most common operations with MongoDB®. Let's walk through an example to see the ways of paging through data in MongoDB®.

Redis® Monitoring Strategies for 2024

Learn the basics of Redis monitoring to optimize your instances. Key metrics & essential tools to ensure peak performance of your Redis server.

Mastering MongoDB® Timeout Settings

Boost database efficiency with our guide on MongoDB timeout settings for administrators and developers seeking robust performance solutions.

DBaaS vs Self-Managed Cloud Databases

In the digital age, data management has transformed from locally hosted servers to cloud solutions. The choice of self-managed cloud databases vs DBaaS is a

How to Deploy MySQL on Ubuntu and Fully Managed

Learn step-by-step how to install and setup MySQL, using either ScaleGrid's automated process or a self-managed solution on Ubuntu 20.04

PostgreSQL Streaming vs Logical Replication – Comparison

In this article we go over the pros & cons of both logical and streaming replication methods in PostgreSQL and their use cases.

PostgreSQL EXPLAIN – What are the Query Costs?

In this post, we dive deep into the startup and total cost of query plans in PostgreSQL, how to get and analyze them in order to optimize your queries.

Bring Your Own Cloud Available for DigitalOcean

Since our release of our fully managed dedicated database hosting on DigitalOcean, we have gotten many questions regarding the potential support for Bring Your Own Cloud on DigitalOcean. Today we can proudly announce that full support for BYOC on DigitalOcean is available in our console. With BYOC on DigitalOcean, you get all the benefits of a fully managed DBaaS, while all your databases are hosted within your own DigitalOcean account. You also get SSH access to the underlying machines of your deployment. This allows you to leverage external plugins and tools to better support your deployment and improve performance. A feature exclusively available to BYOC deployments on DigitalOcean is the ability to utilize Virtual Private Clouds, or VPC for short. VPC networks provide a more secure connection between resources because the network is inaccessible from the public internet and other VPC networks. Are you using the DigitalOcean App Platform to deploy your app? By hosting your databases

How to Install PostgreSQL 12 on Ubuntu 20.04 DigitalOcean

Need a PostgreSQL 12 Ubuntu 20.04 setup guide? We got you covered! Check out how you can easily install and set up your very own PostgreSQL database!

How to Migrate Redis™ Data Using Redis-Shake

Need to migrate your Redis data? Redis-Shake makes it easy for you to move your data or split it between different servers. Check out this simple guide!

How to Deploy PostgreSQL on DigitalOcean

In this post, we show how you can easily deploy a PostgreSQL deployment on DigitalOcean in just a few simple steps with the help of ScaleGrid. Try it yourself

Introduction to auto_explain: How to Log Slow Postgres Query Plans Automatically

Automatically log slow query plans with auto_explain and learn how to fix the problematic PostgreSQL queries that are slowing you down.

New and Evolving PostgreSQL Enterprise Features with Recent Releases

In this blog post we present some of the new and evolving enterprise features of the PostgreSQL DBMS that make it a real competitor to other DBMS such as Oracle

PolyScale.ai – Scaling MySQL & PostgreSQL with Global Caching

In this guest post from PolyScale.ai, they show us a new way of improving latency, performance, and scaling in MySQL and PostgreSQL.

ScaleGrid Raises Growth Equity Round from Spotlight Equity Partners to Accelerate Expansion and Further Invest in Product Roadmap

ScaleGrid Raises Growth Equity Round from Spotlight Equity Partners to Accelerate Expansion and Further Invest in Product Roadmap

How to enable logging for Mongoose and the MongoDB Node.JS driver

In this blog post, we guide you through how to enable logging for Mongoose and the MongoDB Node.JS driver, a critical step when debugging connection issues.

ScaleGrid PostgreSQL on VMware Cloud Infrastructure

Take advantage of the benefits of a DBaaS on your VMware infrastructure. Read about how ScaleGrid PostgreSQL integrates with VMware Cloud infrastructure!

New Feature for BYOC – Pausing and Resuming Clusters

Reduce machine costs on your databases with our new feature for Bring Your Own Cloud deployments, pausing and resuming deployments.

Redis vs. Memcached – 2021 Comparison

In this 2021 comparison of Redis and Memcached, we compare the different features and functions as well as their performance. See who comes out on top!

mysqldump Best Practices: Part 2 – Migrations Guide

In this blog series we discuss common aspects you should handle upfront to ensure a successful dump & restore activity. In part 2, we focus on migration.

ScaleGrid Adds Oracle Cloud for Managed Database Hosting

ScaleGrid has just announced support for OCI through their DBaaS. ScaleGrid now offers OCI hosting for MySQL, PostgreSQL, Redis™ and MongoDB® database.

Oracle Cloud Breakdown – Database Hosting Costs on OCI

In this post, we compare Oracle Cloud pricing vs. AWS, Azure, GCP, DigitalOcean and Linode for managed MySQL, PostgreSQL, Redis™ and MongoDB® database hosting.

How To Set Up MySQL on DigitalOcean

With just a few simple steps, you can set up a fully managed MySQL database on DigitalOcean for the best possible performance. This tutorial explains how.

Auditing PostgreSQL Using pgAudit

pgAudit is an extension that provides the logs needed to facilitate a PostgreSQL database audit. In this post, we explain how to install and interpret pgAudit.

mysqldump Best Practices: Part 1 – MySQL Prerequisites

In this blog series we discuss common aspects you should handle upfront to ensure a successful dump & restore activity. In part 1, we focus on prerequisites.

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

In this performance benchmark, we put ScaleGrid for Redis™ up against Azure Cache for Redis. See which provider gives you the most value for your money!

Setting MySQL Configuration Variables – MySQL 5.7 vs MySQL 8.0

In this blog post, we will explain the differences in managing the configuration variables between MySQL 5.7 and MySQL 8.0.

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

ScaleGrid announces support for their fully managed hosting plans on GCP for MySQL, PostgreSQL and Redis™. Bring Your Own Cloud (BYOC) Available.

MongoDB SSL with self-signed certificates in C#

A simple guide on how to connect MongoDB SSL to your C# Application using Self-Signed Certificates for maximum security and availability.

MySQL on Azure Performance Benchmark – ScaleGrid vs. Azure Database

In this performance benchmark for MySQL on Azure, we put ScaleGrid up against Azure Database. See which provider gives you the most value for your money!

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

Compare PgBouncer vs. Pgpool-II to see which PostgreSQL connection pooler offers the best features, and analyze throughput (TPS) in a performance benchmark.

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

In this post, we are going to show you tips and techniques on how to effectively store and index JSON data in PostgreSQL. Learn more about JSONB in PostgreSQL.

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

Compare Oracle vs. PostgreSQL - see the differences in these SQL database costs, features, and ease of use for developers and database administrators (DBA’s).

Redis Transactions & Long-Running Lua Scripts

Redis Lua scripting is the popularly recommended approach for handling transactions. Learn the common Lua Scripts error and how to handle for sentinel systems.

MongoDB Index Builds – Preventing Users From Triggering New Builds

How to prevent your users from accidentally triggering MongoDB index builds from the MongoDB CLI to stop them from bringing your cluster down.

Best MySQL DigitalOcean Performance – ScaleGrid vs. DigitalOcean Managed Databases

Compare ScaleGrid MySQL vs. DigitalOcean Managed Databases - See which offers the best MySQL throughput, latency, and pricing on DigitalOcean across workloads.

ScaleGrid DigitalOcean Support for MySQL, PostgreSQL and Redis™ Now Available

ScaleGrid announces support for their fully managed hosting plans on DigitalOcean for MySQL, PostgreSQL and Redis™. See how developers can improve performance

Comparing PostgreSQL DigitalOcean Performance & Pricing – ScaleGrid vs. DigitalOcean Managed Databases

Which PostgreSQL hosting services offers the best performance? Compare ScaleGrid vs. DigitalOcean Managed Databases on Throughput, Latency, Pricing and Features

Exploring MySQL Binlog Server – Ripple

How MySQL Ripple binlog server can help you improve the performance of your master server by introducing a proxy server between the master and slave servers.

What is Greenplum Database? Intro to the Big Data Database

In this blog post, we explain what Greenplum is, and break down the Greenplum database MPP architecture, advantages, major use cases, and how to get started.

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

Compare three of the most popular cloud providers, AWS vs. Azure vs DigitalOcean database hosting costs for MongoDB® to see which cloud is best for your app

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

Compare ScaleGrid’s Bring Your Own Cloud (BYOC) plan vs Dedicated Hosting to determine the best model for your MySQL, PostgreSQL, Redis and MongoDB deployment

PostgreSQL Connection Pooling: Part 3 – Pgpool-II

Learn more about Pgpool-II connection pooling for PostgreSQL. How to set up Pgpool-II, how it works, and limitations to see if it's right for your application.

COVID-19 Preparedness at ScaleGrid

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

Important Health Checks for your MySQL Master-Slave Servers

Learn the MySQL health checks to monitor your high availability setup to detect potential issues so you can take corrective actions on your master slave servers

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

Follower clusters allows you to sync two DB clusters. Learn the top use cases for MongoDB, MySQL and Postgres: analyzing, optimizing and testing app performance

How to Monitor MySQL Deployments with Prometheus & Grafana at ScaleGrid

In this post, we discuss how to set up open source Prometheus event monitoring with Grafana dashboard to visualize your MySQL database performance at ScaleGrid.

PostgreSQL Connection Pooling: Part 2 – PgBouncer

PgBouncer is the most popular PostgreSQL connection pooler. In this post, we explain how PgBouncer works, its pros and cons, and how to setup connection pooling

The Best Way to Host MongoDB on DigitalOcean

The best way to host MongoDB on DigitalOcean cloud, including advantages, Droplet types, SSD disk types, replica sets vs. shards, and managed service providers.

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

How to detect and fix extra transactions on a crashed MySQL master server in semisynchronous replication, and re-slave it back into your master-slave setup.

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

Latest ScyllaDB trends - cloud vs. on-premise, most popular cloud providers, databases used with ScyllaDB, most time-consuming tasks, and ScyllaDB vs. Cassandra

Best Practice for Creating Indexes on your MySQL Tables

How to add indexes to your MySQL tables with rolling index creation to improve the performance of your SELECT queries without impacting your regular workload.

Making it Easier to Manage a Production PostgreSQL Database

Learn the operational challenges with PostgreSQL, including master failover detection, automatic failover, major version upgrades with zero downtime, and VACUUM

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

Compare top PostgreSQL high availability frameworks - PostgreSQL Automatic Failover (PAF), Replication Manager (repmgr) and Patroni to improve your app uptime

How to Improve MySQL AWS Performance 2X Over Amazon RDS at The Same Cost

Compare MySQL Amazon RDS vs. MySQL Hosting at ScaleGrid on AWS High Performance instances to achieve higher throughput and lower latency for the same price.

PostgreSQL Connection Pooling: Part 1 – Pros & Cons

In this intro to PostgreSQL Connection Pooling, we discuss the pros and cons of using a connection pooler, and how it helps you manage your database connections

PostgreSQL Trends: Most Popular Cloud Providers, Languages, VACUUM, Query Management Strategies & Deployment Types in Enterprise

Analyze the most popular cloud providers for PostgreSQL, VACUUM methods, query management strategies, and on-premises vs. public cloud use in enterprise orgs.

Redis Cloud Gets Easier with Fully Managed Hosting on Azure

ScaleGrid launches fully managed Redis hosting service on Microsoft Azure cloud. Automate your backups, upgrades, scaling, replication, sharding and monitoring

ScaleGrid Fully Managed Hosting for Redis™ Now Available on Azure

ScaleGrid launches fully managed Redis™ hosting service on Microsoft Azure cloud. Automate your backups, upgrades, scaling, replication, sharding and monitoring

Which Is the Best PostgreSQL GUI? 2019 Comparison

See the 5 best PostgreSQL GUI tools for data visualization and managing your open source databases: 1) pgAdmin, 2) DBeaver, 3) Navicat, 4) DataGrip, 5) OmniDB

Top Redis Use Cases by Core Data Structure Types

See the top Redis use cases by core data structure type, including Redis Strings, Lists, Sets, Sorted Sets and Hashes. Used as a database, cache, message broker

Managing High Availability in PostgreSQL – Part III: Patroni

Compare the best PostgreSQL high availability frameworks server test scenarios: PostgreSQL Automatic Failover (PAF) vs. Replication Manager (repmgr) vs. Patroni

Which is the Best MongoDB GUI? — 2019 Update

There are a number of options when it comes to MongoDB GUI, some good and some bad. Our customers regularly ask us which UI we recommend read on to find out.

How to Setup a WordPress MySQL Database in the Cloud

Learn the best way to setup a cloud MySQL database for your WordPress website so you can query your data such as posts, pages, images, user profiles, and more.

Fully Managed PostgreSQL Hosting on AWS and Azure Launches in Time For Legacy Migrations

ScaleGrid launches fully managed PostgreSQL hosting on AWS and Azure cloud and on-premise with advanced monitoring, high availability, and disaster recovery.

The Best Way to Host MySQL on Azure Cloud

The best way to host MySQL on Azure cloud, including managed solutions, high availability, backups, disk and instance types to optimize database performance.

Connecting MongoDB to Ruby with Self-Signed Certificates for SSL

MongoDB Tutorial - How to connect to a MongoDB server with self-signed certificates for SSL using Ruby MongoDB driver and Object-Document-Mapper (ODM) mongoid.

2019 Open Source Database Report: Top Databases, Public Cloud vs. On-Premise, Polyglot Persistence

Find the latest database trends: Open Source vs. Commercial, SQL vs. NoSQL, Top Clouds, Public Cloud vs. On-Premise vs. Hybrid Cloud, and Polyglot Persistence.

ScaleGrid DBaaS Expands MySQL Hosting Services Through AWS Cloud

ScaleGrid launches fully managed MySQL hosting service on AWS cloud. Automate high availability, disaster recovery, polyglot persistence and database monitoring

Managing MySQL Server Logs: Rotate, Compress, Retain & Delete

How to setup and manage MySQL server error logs, general logs and slow query logs. Automatically archive, compress, delete and retain to control disk space use.

PyMongo Tutorial: Testing MongoDB Failover in Your Python App

How to connect an SSL-enabled MongoDB replica set with self-signed certificates using PyMongo, and testing MongoDB failover behavior in your Python app code.

MySQL High Availability Framework Explained – Part III: Failure Scenarios

Learn how the MySQL high availability framework recovers from these 3 important failover scenarios, master goes down, slave goes down, and split-brain scenario

2019 PostgreSQL Trends Report: Private vs. Public Cloud, Migrations, Database Combinations & Top Reasons Used

See the latest PostgreSQL trends report on public cloud vs private cloud vs hybrid cloud, most popular cloud providers, migration trends, multi database combos

Managing High Availability in PostgreSQL – Part II

Deploying PostgreSQL in the cloud and want to achieve high availability? Learn how to setup with open source tool, Replication Manager (repmgr) by 2ndQuadrant.

2019 Database Trends – SQL vs. NoSQL, Top Databases, Single vs. Multiple Database Use

Which databases are trending in 2019? Discover NoSQL vs. SQL, most popular databases, important metrics to track, and the most time-consuming management tasks.

Installing WordPress 5 on ZEIT Now with MySQL Hosting

Want to deploy WordPress 5.0 on ZEIT Now global serverless deployment platform with cheap MySQL hosting instances? Configure your MySQL database to get started.

Intro to Redis Cluster Sharding – Advantages, Limitations, Deploying & Client Connections

In this post, you'll learn about Redis Cluster sharding opportunities, the advantages and limitations, when to deploy, and how to connect to your Redis Cluster.

MySQL Tutorial – Understanding The Seconds Behind Master Value

In a MySQL hosting replication setup, Seconds Behind Master (SBM) indicates the slave replication lag. Learn how to interpret this value in various situations.

Highly Available Redis Clusters with Automated Sharding Launches at ScaleGrid

Redis Clusters launches on ScaleGrid's Redis hosting plans. The native sharding implementation available within Redis, an open-source in-memory data structure

How To Connect To Your MongoDB Deployments Using Robo 3T GUI

How to connect your ScaleGrid MongoDB hosting DBaaS to Robo 3T's free GUI. Interact with your data through visual indicators instead of a text-based interface.

MySQL High Availability Framework Explained – Part II

Learn about MySQL semisynchronous replication and configuration settings to ensure redundancy and data consistency in a MySQL High Availability Framework setup.

How DevOps Should Use DBaaS (Database-as-a-Service) To Optimize Their Application Development​

DBaaS makes it easy for DevOps to manage their SQL and NoSQL operations without requiring technical expertise. Automate your backups, create clusters, monitor

10 Best Startups in Cloud – 2018

ScaleGrid makes 2018 10 Best Startups in Cloud list. See how we optimize NoSQL and SQL database hosting and management across the globe, other cloud startups

Slow MySQL Start Time in GTID mode? Binary Log File Size May Be The Issue

Experiencing slow MySQL startup times in GTID mode? Your binary log files could be slowing your restart. See how to debug and increase your MySQL startup speed.