PostgreSQL is an open source object-relational database system that has soared in popularity over the past 30 years from its active, loyal, and growing community. For the 2nd year in a row, PostgreSQL has kept the title of #1 fastest growing database in the world according to the DBMS of the Year report by the experts at DB-Engines. So what makes PostgreSQL so special, and how … [Read more...] about 2019 PostgreSQL Trends Report: Private vs. Public Cloud, Migrations, Database Combinations & Top Reasons Used
database performance
Intro to Redis Cluster Sharding Advantages, Limitations, Deploying & Client Connections
Redis Cluster is the native sharding implementation available within Redis that allows you to automatically distribute your data across multiple nodes without having to rely on external tools and utilities. At ScaleGrid, we recently added support for Redis Clusters on our platform through our fully managed Redis hosting plans. In this post, we're going to introduce you to the … [Read more...] about Intro to Redis Cluster Sharding Advantages, Limitations, Deploying & Client Connections
MySQL High Availability Framework Explained Part II
In Part I, we introduced a High Availability (HA) framework for MySQL hosting and discussed various components and their functionality. Now in Part II, we will discuss the details of MySQL semi-synchronous replication and the related configuration settings that help us ensure redundancy and consistency of the data in our HA setup. Make sure to check back in for Part III where … [Read more...] about MySQL High Availability Framework Explained Part II
How DevOps Should Use DBaaS (Database-as-a-Service) To Optimize Their Application Development?
Database-as-a-Service (DBaaS) is quickly gaining in popularity across the tech world. These software platform solutions helps users easily manage their database operations without having to really understand any of the abstractions. This allows developers, DBA's and DevOps engineers to quickly automate their backups, create new SQL and NoSQL clusters, and monitor the … [Read more...] about How DevOps Should Use DBaaS (Database-as-a-Service) To Optimize Their Application Development?
Improving MySQL by Replicating to the In-Memory Database Tarantool
Replicating MySQL is one of the in-memory-database Tarantool's killer functions. It allows you to keep your existing MySQL database while at the same time accelerating it and scaling it out horizontally. Even if you aren't interested in extensive expansion, simply replacing existing replicas with Tarantool can save you money, because Tarantool is more efficient per core than … [Read more...] about Improving MySQL by Replicating to the In-Memory Database Tarantool