Scalegrid

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.

PyMongo Tutorial: Testing MongoDB Failover in Your Python App

Scalegrid

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?

Making it Easier to Manage a Production PostgreSQL Database

Scalegrid

The past several years have seen increasing adoption for PostgreSQL. PostgreSQL is an amazing relational database. Feature-wise, it is up there with the best, if not the best. There are many things I love about it – PL/ PG SQL, smart defaults, replication (that actually works out of the box), and an active and vibrant open source community. However, beyond just the features, there are other important aspects of a database that need to be considered.

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

Scalegrid

Wondering which databases are trending in 2019?

PostgreSQL Trends: Most Popular Cloud Providers, Languages, VACUUM, Query Management Strategies & Deployment Types in Enterprise

Scalegrid

PostgreSQL popularity is skyrocketing in the enterprise space. As this open source database continues to pull new users from expensive commercial database management systems like Oracle, DB2 and SQL Server, organizations are adopting new approaches and evolving their own to maintain the exceptional performance of their SQL deployments. We recently attended the PostgresConf event in San Jose to hear from the most active PostgreSQL user base on their database management strategies.

Cloud 139

PostgreSQL Connection Pooling: Part 1 – Pros & Cons

Scalegrid

A long time ago, in a galaxy far far away, ‘threads’ were a programming novelty rarely used and seldom trusted. In that environment, the first PostgreSQL developers decided forking a process for each connection to the database is the safest choice.

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.

Top Redis Use Cases by Core Data Structure Types

Scalegrid

Redis , short for Remote Dictionary Server, is a BSD-licensed, open-source in-memory key-value data structure store written in C language by Salvatore Sanfillipo and was first released on May 10, 2009. Depending on how it is configured, Redis can act like a database, a cache or a message broker. It’s important to note that Redis is a NoSQL database system.

2019 PostgreSQL Trends Report: Private vs. Public Cloud, Migrations, Database Combinations & Top Reasons Used

Scalegrid

PostgreSQL is an open source relational database system that has soared in popularity over the past 30 years from its active, loyal, and growing community.

The Best Way to Host MySQL on Azure Cloud

Scalegrid

Are you looking to get started with the world’s most popular open-source database, and wondering how you should setup your MySQL hosting ? So many default to Amazon RDS, when MySQL performs exceptionally well on Azure Cloud. While Microsoft Azure does offer a managed solution, Azure Database, the solution has some major limitations you should know about before migrating your MySQL deployments.

Azure 161

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.

What’s the Best PostgreSQL High Availability Framework? PAF vs. repmgr vs. Patroni Infographic

Scalegrid

Wondering which high availability framework to use for your PostgreSQL deployments ? We compared the top 3 frameworks, PostgreSQL Automatic Failover (PAF) vs. Replication Manager (repmgr) vs. Patroni , in our Managing High Availability in PostgreSQL series.

How to Improve MySQL AWS Performance 2X Over Amazon RDS at The Same Cost

Scalegrid

AWS is the #1 cloud provider for open-source database hosting, and the go-to cloud for MySQL deployments. As organizations continue to migrate to the cloud, it’s important to get in front of performance issues, such as high latency, low throughput, and replication lag with higher distances between your users and cloud infrastructure.

AWS 100

Fully Managed PostgreSQL Hosting on AWS and Azure Launches in Time For Legacy Migrations

Scalegrid

PALO ALTO, Calif., July 17, 2019 – ScaleGrid, a leader in the Database-as-a-Service (DBaaS) space, has just announced support for PostgreSQL hosting in the cloud. The fully managed platform allows organizations to automate their time-consuming PostgreSQL operations, focus on database development, and optimize performance with advanced monitoring, high availability, and disaster recovery on AWS and Azure.

Azure 138

How To Connect To Your MongoDB Deployments Using Robo 3T GUI

Scalegrid

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.

How to Setup a WordPress MySQL Database in the Cloud

Scalegrid

WordPress is the largest website builder platform in the world, supporting over 34% of all websites on the internet today. MySQL is a free open source relational database management system that is leveraged across a majority of WordPress sites, and allows you to query your data such as posts, pages, images, user profiles, and more.

MySQL Tutorial – Understanding The Seconds Behind Master Value

Scalegrid

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 this value in various situations. Possible Values of Seconds Behind Master.

Speed 141

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

Scalegrid

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.

Connecting MongoDB to Ruby with Self-Signed Certificates for SSL

Scalegrid

Given the popularity of our post on connecting MongoDB SSL with Self-Signed Certificates in Node.js , we decided to write a tutorial on connecting MongoDB with Ruby. In this blog, we’ll show you how to connect to a MongoDB server configured with self-signed certificates for SSL using both the Ruby MongoDB driver and the popular Object-Document-Mapper (ODM) mongoid. ScaleGrid currently uses self-signed certificates for SSL when creating nodes for a new cluster.

C++ 100

Managing High Availability in PostgreSQL – Part II

Scalegrid

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.

Installing WordPress 5 on ZEIT Now with MySQL Hosting

Scalegrid

Want to deploy WordPress 5.0 on the Now platform by ZEIT ? Our friends over at ZEIT’s Now global serverless deployment platform whipped up a great tutorial for WordPress5-on-Now using cheap MySQL hosting instances from ScaleGrid. With such strong interest in this installation, we decided to write up the steps to configure your MySQL database on the ScaleGrid side to get you up and running ever faster with WordPress on Now. Leave your comments: [link]. now/wordpress summary: ? ?

MySQL High Availability Framework Explained – Part II: Semisynchronous Replication

Scalegrid

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 semisynchronous replication and the related configuration settings that help us ensure redundancy and consistency of the data in our HA setup.

Highly Available Redis Clusters with Automated Sharding Launches at ScaleGrid

Scalegrid

PALO ALTO, Calif., January 24, 2019 – ScaleGrid , a rising leader in the Database-as-a-Service (DBaaS) space, has just announced support for Redis Clusters on their fully managed Redis hosting plans. Redis Cluster is the native sharding implementation available within Redis, an open-source in-memory data structure project, that allows you to automatically shard across multiple Redis nodes without having to rely on external tools and utilities.

Which is the Best MongoDB GUI? — 2019 Update

Scalegrid

A good UI is an important part of the development experience. The MongoDB Shell works great for administrative actions, but when working with larger amounts of data, the UI becomes fairly important.

2019 Open Source Database Report: Top Databases, Public Cloud vs. On-Premise, Polyglot Persistence

Scalegrid

Ready to transition from a commercial database to open source, and want to know which databases are most popular in 2019? Wondering whether an on-premise vs. public cloud vs. hybrid cloud infrastructure is best for your database strategy? Or, considering adding a new database to your application and want to see which combinations are most popular?

Redis Cloud Gets Easier with Fully Managed Hosting on Azure

Scalegrid

PALO ALTO, Calif., October 2, 2019 – ScaleGrid, a rapidly growing leader in the Database-as-a-Service (DBaaS) space, has just launched their new fully managed Redis on Azure service. This Redis management solution allows startups up to enterprise-level organizations automate their Redis operations on Microsoft Azure dedicated cloud servers, alongside their other open source database deployments, including MongoDB , MySQL and PostgreSQL.

Azure 29

MySQL High Availability Framework Explained – Part III: Failure Scenarios

Scalegrid

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 Failure Scenarios. Scenario 1 – Master MySQL Goes Down. The Corosync and Pacemaker framework detects that the master MySQL is no longer available.

Time to First Byte: What It Is and Why It Matters

CSS Wizardry

CIO research: Cloud complexity of growing concern

Dynatrace

Dynatrace news. My favorite slide, that I used in nearly every one of my presentations, is a simple statement; “You have one of the hardest jobs in the world.”. I see people nod their head, smile and sometimes pull out a phone and take a photo.

Cloud 229

Troubleshooting Knative Prometheus GC Issues with Dynatrace

Dynatrace

Dynatrace news. In my current work, I spend a lot of time with keptn – an Open Source Control Plane for Continuous Deployment and Automated Operations. I deployed keptn on a GKE cluster and it’s been running there for the past couple of weeks.

Keeping DevOps cool in a heated environment

Dynatrace

Dynatrace news. Cloud platforms are somewhat a staple component to enterprises’ IT environments today, helping to achieve objectives and drive better business operations, but more often than not we don’t see the outcomes or rewards reaped from the use of such platforms.

DevOps 214

Self-Host Your Static Assets

CSS Wizardry

One of the quickest wins—and one of the first things I recommend my clients do—to make websites faster can at first seem counter-intuitive: you should self-host all of your static assets, forgoing others’ CDNs/infrastructure.

Cache 284

Improved content validation for Synthetic browser and clickpath monitors

Dynatrace

Dynatrace news. With the release of Dynatrace 1.178, we’ve added a new type of content validation capability for synthetic browser and clickpath monitors. The contains visible text option mimics the Find (Ctrl+F/Cmd+F) functionality of a web browser.

Giving data a heartbeat

Dynatrace

Dynatrace news. I love data. I have spent virtually my entire career looking at data. Synthetic data, network data, system data, and the list goes on.

Dynatrace W3C Trace Context support provides more interoperability between monitoring environments

Dynatrace

Dynatrace news. As the popularity of microservices architecture increases, more teams are getting involved with the delivery of individual product features.

AI-powered, automated observability and deep visibility into serverless apps running on Google Cloud Run

Dynatrace

Dynatrace news. Cloud Run brings serverless to containers. You can run containers on Cloud Run for Anthos for consistency between on-prem and cloud environments, or in fully managed Cloud Run environments.

Google 130

How to get the most value out of Session Replay: Use cases and examples

Dynatrace

Dynatrace news. At Dynatrace, we’re constantly striving to come up with solutions that can help modernize your performance and user experience monitoring strategies.

Explore Autonomous Cloud Management at an Autonomous Cloud Lab

Dynatrace

Dynatrace news. The path to Autonomous Cloud Management (ACM) and NoOps is a transformational journey that reaches all parts of an organization. It fundamentally changes how teams and tools work together with a common goal: deliver software faster, more frequently and with a higher degree of quality.

Cloud 213

Game changing — From zero to Autonomous Cloud Management today

Dynatrace

Dynatrace news. I’m going to revisit the Dynatrace digital transformation in this blog, because it is also an excellent story that began our journey to Autonomous Cloud Management (ACM).

Games 214

Unleash the power of the Dynatrace Markdown Dashboard Tile

Dynatrace

Dynatrace news. Dynatrace Dashboards are constantly updated with new capabilities. If you want to get up to speed, check out my recent Performance Clinics: “ AI-Powered Dashboarding ” and “ Advanced Business Dashboarding and Analytics ”.

Build automated self-healing systems with xMatters and Dynatrace (Part 2 of 3)

Dynatrace

Dynatrace news. Welcome back to the blog series in which we share how you can easily solve three common problem scenarios by using Dynatrace and xMatters Flow Designer.

How AI Solves the Kubernetes Complexity Conundrum

Dynatrace

Dynatrace news. Kubernetes has certainly earned its reputation as a pivotal part in enterprise IT’s shift from yesterday’s monoliths to today’s more dynamic microservices, containers and multi-cloud infrastructures. But the shift has been a double-edged sword.

AI-powered custom log metrics for faster troubleshooting

Dynatrace

Dynatrace news. You might already use Dynatrace Log Monitoring to gain direct access to the log content of your system’s mission-critical processes. Log Monitoring is a great way to search for text patterns like log files with errors or exceptions.