Managing High Availability in PostgreSQL – Part II

Posted Leave a commentPosted in Technical

Are you deploying PostgreSQL in the cloud and want to understand your options for achieving high availability? In our previous blog post, Managing High Availability in PostgreSQL – Part I, we discussed the capabilities and functioning of PostgreSQL Automatic Failover (PAF) by ClusterLabs. In Part II, we’re introducing you to an alternative open source tool, Replication Manager from 2ndQuadrant, to be […]

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

Posted Leave a commentPosted in Technical

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 advanced Redis Cluster sharding […]

MySQL Tutorial – Understanding The Seconds Behind Master Value

Posted Leave a commentPosted in Big Data, Cloud

In a MySQL hosting replication setup, the parameter Seconds_Behind_Master (SBM), as displayed by the SHOW SLAVE STATUS command, is commonly used as an indication of the current replication lag of the slave. In this blog post, we examine how to understand and interpret the MySQL Seconds Behind Master value in various situations. Possible Values of  Seconds Behind Master […]

How to Connect Your MongoDB Deployments to Robo 3T GUI

Posted Leave a commentPosted in Technical

Robo 3T (formerly Robomongo) is a popular desktop graphical user interface (GUI) for your MongoDB hosting deployments that allows you to interact with your data through visual indicators instead of a text-based interface. This open source tool has cross-platform support and actually embeds the mongo shell within its interface to provide both shell and GUI-based interaction. As a highly-popular GUI […]

MySQL High Availability Framework Explained – Part I

Posted Leave a commentPosted in Technical

In this two-part blog series, we will explain the details and functionality of a High Availability (HA) framework for MySQL hosting using MySQL semi-synchronous replication and the Corosync plus Pacemaker stack. In Part I, we’ll walk you through the basics of High Availability, the components of an HA framework, and then introduce you to the HA framework for MySQL. MySQL High Availability […]

Managing High Availability in PostgreSQL – Part I

Posted Leave a commentPosted in Cloud, Technical

Managing high availability in your PostgreSQL hosting is very important to ensuring your clusters maintain exceptional uptime and strong operational performance so your data is always available to your application. In an earlier blog post, we introduced you to configuring high availability for PostgreSQL using streaming replication, and now we’re going to show you how to best manage PostgreSQL high […]

Top 5 Benefits of Shared MongoDB Hosting

Posted Leave a commentPosted in Big Data, Cloud, Technical

Shared MongoDB hosting is one of the most cost-effective and easy-to-setup options for deploying MongoDB in the cloud, and is used by thousands of companies around the world to host their databases. In this post, we outline the top five benefits of using shared MongoDB hosting to help you decide whether it’s the right for your business. Shared MongoDB […]

Latest PostgreSQL Trends: Most Time-Consuming Tasks & Important Metrics to Track

Posted Leave a commentPosted in Big Data, Cloud

PostgreSQL, the fourth most popular database and DBMS of the Year in 2017, has exploded in popularity amongst the development and database communities across the world. Stealing market share from leaders Oracle, MySQL, and Microsoft SQL Server, PostgreSQL hosting is also highly leveraged by new businesses in exciting spaces like IoT, e-commerce, SaaS, analytics, and more. Read the […]