In our latest product update we have a few exciting updates which includes new MongoDB® database version support as well as a minor addition to our UI. Check out this product update to find out more about what’s new, and also what’s in store for the future at ScaleGrid. Payment Button There is now a…
MySQL is a popular open-source relational database management system for online applications and data warehousing. It’s renowned for its dependability, effectiveness, and simplicity. However, there is always a chance of data loss due to hardware malfunction, software defects, or other unforeseen circumstances, just like with any computer system. Because of this, preserving the availability and…
It is estimated that the average person generates approximately 1.7 megabytes of data every minute and about 50 gigabytes every month. With so much data being generated every day, companies are all looking for ways to improve the dependability of their infrastructure, increase data availability, and reduce downtime. One technique that organizations have been deploying…
Welcome to 2023 everyone! A new year and with that comes many new possibilities, especially over here at ScaleGrid. We’ve got a few new exciting additions to our management console that we are sure will come in handy for many of you. Regardless of the size of your company, the importance of a secure and…
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 interface where you can view all of…
ScaleGrid customers can now deploy new and upgrade existing PostgreSQL deployments to version 14.4 released a couple months ago. This new version comes with a wide range of different improvements, mainly in terms of performance, monitoring and security. In this blog post, we will highlight a few of the main improvements in this version of…
![[Tutorial] How to Deploy MySQL on Ubuntu 20.04](https://scalegrid.io/wp-content/uploads/2022/05/MySQL-DigitalOcean-Guide-ScaleGrid-1038x576.jpg)
In this blog post, we will show you a step-by-step guide on how to install and set up a MySQL server both manually on the Ubuntu 20.04 operating system, as well as by using ScaleGrid’s managed database service. In the following sections of this tutorial, we will help you through every step to successfully set…
Replicating the information stored on your database is essential for distributing data and ensuring you have a backup that can be used for disaster recovery, in case something goes wrong. PostgreSQL replication comes in two forms, and both have their niche uses. Understanding how to apply one or both of these data replication methods can…
Understanding the Postgres EXPLAIN cost EXPLAIN is very useful for understanding the performance of a Postgres query. It returns the execution plan generated by PostgreSQL query planner for a given statement. The EXPLAIN command specifies whether the tables referenced in a statement will be searched using an index scan or a sequential scan. Some of…
PostgreSQL Features and Use Cases PostgreSQL is an open-source Object-relational Database Management System (DBMS). It’s an advanced database management and analysis system that’s mainly used for eCommerce platforms, payment transactions, and various data warehousing solutions. It has been around for over 30 years and is regularly updated every year, supports various SQL functions like triggers,…
Get more database tips, articles and the latest news by subscribing to our monthly newsletters!