PyMongo Tutorial: Testing MongoDB Failover in Your Python App

Posted Leave a commentPosted in Cloud, Technical

Python is a powerful and flexible programming language used by millions of developers around the world to build their applications. It comes as no surprise that Python developers commonly leverage MongoDB hosting, the most popular NoSQL database, for their deployments due to its flexible nature and lack of schema requirements. So, what’s the best way to use MongoDB with Python? PyMongo is […]

MySQL High Availability Framework Explained – Part III: Failover Scenarios

Posted Leave a commentPosted in Cloud, Technical

In this three-part blog series, we introduced a High Availability (HA) Framework for MySQL hosting in Part I, and discussed the details of MySQL semisynchronous replication in Part II. Now in Part III, we review how the framework handles some of the important MySQL failure scenarios and recovers to ensure high availability. MySQL Failover Scenarios Scenario 1 – Master MySQL Goes […]

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 […]