Scalegrid

How to Deploy MySQL on Ubuntu and Fully Managed

Scalegrid

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.

PostgreSQL EXPLAIN – What are the Query Costs?

Scalegrid

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.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

How to Install PostgreSQL 12 on Ubuntu 20.04 DigitalOcean

Scalegrid

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.

PolyScale.ai – Scaling MySQL & PostgreSQL with Global Caching

Scalegrid

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.

Cache 228

Bring Your Own Cloud Available for DigitalOcean

Scalegrid

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.

PostgreSQL Streaming vs Logical Replication – Comparison

Scalegrid

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.

How to Migrate Redis™ Data Using Redis-Shake

Scalegrid

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.

New Feature for BYOC – Pausing and Resuming Clusters

Scalegrid

At ScaleGrid we always strive to make our service as user friendly and value adding as possible. Some of our users have been wanting to save on their database machine costs during periods when the databases are not in use, such as on weekends or at night.

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

Scalegrid

Do you want to know why a PostgreSQL query is slow? Then EXPLAIN ANALYZE is a great starting point.

MySQL on Azure Performance Benchmark – ScaleGrid vs. Azure Database

Scalegrid

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.

Azure 233

mysqldump Best Practices: Part 1 – MySQL Prerequisites

Scalegrid

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.

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

Scalegrid

If you’re hosting your databases in the cloud, choosing the right cloud service provider is a significant decision to make for your long-term hosting costs. This is especially apparent in today’s world where organizations are doing whatever they can to optimize and reduce their costs.

Azure 238

Auditing PostgreSQL Using pgAudit

Scalegrid

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.

Oracle Cloud Breakdown – Database Hosting Costs on OCI

Scalegrid

When considering a new cloud provider, the big names come to mind - AWS, Azure, and Google Cloud. If you’re a developer, you might even be considering a dev-friendly cloud like DigitalOcean or Linode. But, did you know there’s a (relatively) new player in the cloud game?

Redis vs. Memcached – 2021 Comparison

Scalegrid

Redis stands for REmote DIctionary Server, created in 2009 by Salvatore Sanfilippo. Memcached, on the other hand, was created in 2003 by Brad Fitzpatrick.

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

Scalegrid

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.

What is Greenplum Database? Intro to the Big Data Database

Scalegrid

Greenplum Database is a massively parallel processing (MPP) SQL database that is built and based on PostgreSQL.

New and Evolving PostgreSQL Enterprise Features with Recent Releases

Scalegrid

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.

152
152

mysqldump Best Practices: Part 2 – Migrations Guide

Scalegrid

In the second and final part of our mysqldump best practices we will talk about how to handle the migration and import for stored program objects and views from your MySQL database.

Setting MySQL Configuration Variables – MySQL 5.7 vs MySQL 8.0

Scalegrid

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.

How to Deploy PostgreSQL on DigitalOcean

Scalegrid

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.

ScaleGrid Adds Oracle Cloud for Managed Database Hosting

Scalegrid

PALO ALTO, Calif., March 30, 2021 – ScaleGrid, a leading Database-as-a-Service (DBaaS) provider, has just announced support for Oracle Cloud Infrastructure (OCI) through their fully managed database hosting plans.

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

Scalegrid

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.

Google 169

How To Set Up MySQL on DigitalOcean

Scalegrid

MySQL is the number one open source relational database management system in the world, and is used by millions of developers across all application types.

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

Scalegrid

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.

PostgreSQL Connection Pooling: Part 3 – Pgpool-II

Scalegrid

In our previous posts in this series, we discussed the case for connection pooling and introduced PgBouncer. In this post, we will discuss its most popular alternative – Pgpool-II. Pgpool-II is the swiss army knife of PostgreSQL middleware.

Cache 185

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

Scalegrid

Collecting detailed logs is a critical step when debugging connection related issues with MongoDB. In this short post, we will show how to enable logging on the MongoDB Node.JS driver and Mongoose. We refer to the Mongoose version 5.x and the driver version 3.5 in this discussion.

130
130

Important Health Checks for your MySQL Master-Slave Servers

Scalegrid

In a MySQL master-slave high availability (HA) setup, it is important to continuously monitor the health of the master and slave servers so you can detect potential issues and take corrective actions. In this blog post, we explain some basic health checks you can do on your MySQL master and slave nodes to ensure your setup is healthy.

ScaleGrid PostgreSQL on VMware Cloud Infrastructure

Scalegrid

ScaleGrid recently partnered up with VMware to create a solution that integrates the powerful features of a PostgreSQL DBaaS on vSphere with advanced added support for vVols, allowing DBAs to automate and focus more on their product as opposed to time-consuming database management tasks, scaling and high availability.

MongoDB SSL with self-signed certificates in C#

Scalegrid

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.

C++ 158

Exploring MySQL Binlog Server – Ripple

Scalegrid

MySQL does not limit the number of slaves that you can connect to the master server in a replication topology. However, as the number of slaves increases, they will have a toll on the master resources because the binary logs will need to be served to different slaves working at different speeds.

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

Scalegrid

Wondering which databases are trending in 2019? We asked hundreds of developers, engineers, software architects, dev teams, and IT leaders at DeveloperWeek to discover the current NoSQL vs. SQL usage, most popular databases, important metrics to track, and their most time-consuming database management tasks. Get the latest insights on MySQL , MongoDB , PostgreSQL , Redis , and many others to see which database management systems are most favored this year. SQL vs. NoSQL.

PostgreSQL Connection Pooling: Part 2 – PgBouncer

Scalegrid

When it comes to connection pooling in the PostgreSQL world, PgBouncer is probably the most popular option. It’s a very simple utility that does exactly one thing – it sits between the database and the clients and speaks the PostgreSQL protocol, emulating a PostgreSQL server.

Cache 171

Managing High Availability in PostgreSQL – Part III: Patroni

Scalegrid

In our previous blog posts, we discussed the capabilities and functioning of PostgreSQL Automatic Failover (PAF) by Cluster Labs and Replication Manager (repmgr) by 2ndQuadrant. In the final post of this series, we will review the last solution, Patroni by Zalando, and compare all three at the end so you can determine which high availability framework is best for your PostgreSQL hosting deployment. Managing High Availability in PostgreSQL – Part I: PostgreSQL Automatic Failover.

Redis Transactions & Long-Running Lua Scripts

Scalegrid

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.

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

Scalegrid

Where you decide to host your cloud databases is a huge decision. You have to choose your hosting model, a cloud provider, and then your primary and standby regions to deploy to.

Cloud 155

Which Is the Best PostgreSQL GUI? 2019 Comparison

Scalegrid

PostgreSQL graphical user interface (GUI) tools help these open source database users to manage, manipulate, and visualize their data. In this post, we discuss the top 5 GUI tools for administering your PostgreSQL deployments. PostgreSQL is the fourth most popular database management system in the world, and heavily used in all sizes of applications from small to large.

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

Scalegrid

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.

Azure 130

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

Scalegrid

DigitalOcean is a cost-effective cloud provider that caters to, and is widely adopted by the developer community. ScaleGrid is a fully managed DBaaS that supports MySQL, PostgreSQL and Redis™, along with additional support for MongoDB® database and Greenplum® database.

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

Scalegrid

PALO ALTO, Calif., June 9, 2020 – ScaleGrid, a leading Database-as-a-Service (DBaaS) provider, has just announced support for their MySQL , PostgreSQL and Redis™ solutions on DigitalOcean.

Best MySQL DigitalOcean Performance – ScaleGrid vs. DigitalOcean Managed Databases

Scalegrid

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.

Best Practice for Creating Indexes on your MySQL Tables

Scalegrid

By having appropriate indexes on your MySQL tables, you can greatly enhance the performance of SELECT queries. But, did you know that adding indexes to your tables in itself is an expensive operation, and may take a long time to complete depending on the size of your tables? During this time, you are also likely to experience a degraded performance of queries as your system resources are busy in index-creation work as well.

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

Scalegrid

MySQL Server generates several logs that can help you monitor the activities of the server. However, once these logs are enabled, they can grow in size and start taking up too much disk space. This is why it’s important to have an automated way of archiving and preserving MySQL log files for a certain duration, as well as deleting the old ones.