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 ..read more

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 ..read more

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 ..read more

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 ..read more

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 ..read more

Migrating ScaleGrid for Redis™ data from one server to another is a common requirement that we hear from our customers. Two of the main reasons we hear are often due to migration of hardware, or the need to split data between servers. Typically, you want to migrate with minimal downtime while using the standard Redis ..read more

PostgreSQL is a widely-used, enterprise-grade, and open-source relational database management system and is the fourth most popular database in the world according to DB-Engines. It is an RDBMS that is rapidly growing within the developer community. DigitalOcean, a fast-growing cloud provider that’s increasing in popularity amongst developers and companies, is a great host to consider ..read more

Do you want to know why a PostgreSQL query is slow? Then EXPLAIN ANALYZE is a great starting point. But query plans can depend on other server activity, can take a while to run, and can change over time, so if you want to see the actual execution plans of your slowest queries, auto_explain is ..read more

PostgreSQL also introduced many other breakthrough features in versions 10 through 11, 12 and 13 that make it a real competitor against Oracle, such as partitioning enhancements, parallel query and logical replication. In this blog post, we will showcase some of the new and notable PostgreSQL features included in more recent versions of PostgreSQL. New ..read more

Guest post by Ben Hagan from PolyScale.ai Data-driven applications span a wide breadth of complexity, from simple microservices to real-time event-driven systems under significant load. However, as any development and/or DevOps team tasked with performance improvements will attest, making data-driven apps fast globally is “non-trivial”. Modern application architectures such as the JAMstack enforce the separation ..read more