Home/Kristi Anderson
Author

Kristi Anderson

5 articles by Kristi Anderson.

Databases — MySQL on Azure Performance Benchmark – ScaleGrid vs. Azure Database - High Scalability -

MySQL on Azure Performance Benchmark – ScaleGrid vs. Azure Database - High Scalability -

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. While Microsoft offers their own Azure Database product, there are other alternatives available that may be able to help you impr

KAKristi Anderson·September 1, 2020Databases
Databases — Reducing Your Database Hosting Costs: DigitalOcean vs. AWS vs. Azure - High Scalability -

Reducing Your Database Hosting Costs: DigitalOcean vs. AWS vs. Azure - High Scalability -

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. Over the last few weeks, we have been inundated with requests from SMB customers looking to improve the ROI on the

KAKristi Anderson·May 12, 2020Databases
Databases — Important Health Checks for your MySQL Master-Slave Servers - High Scalability -

Important Health Checks for your MySQL Master-Slave Servers - High Scalability -

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. The monitoring program or script must alert the high availabili

KAKristi Anderson·February 17, 2020Databases
Databases — Follower Clusters – 3 Major Use Cases for Syncing SQL & NoSQL Deployments - High Scalability -

Follower Clusters – 3 Major Use Cases for Syncing SQL & NoSQL Deployments - High Scalability -

Follower clusters are a ScaleGrid feature that allows you to keep two independent database systems (of the same type) in sync. Unlike cloning or replication, this allows you to maintain an active, point-in-time copy of your production data. This extra cluster, known as a follower cluster, can be leveraged for multiple use cases, including for analyzing, optimizing and testing your application perf

KAKristi Anderson·January 22, 2020Databases
Databases — PostgreSQL Connection Pooling: Part 2 – PgBouncer - High Scalability -

PostgreSQL Connection Pooling: Part 2 – PgBouncer - High Scalability -

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. A client connects to PgBouncer with the exact same syntax it would use when connecting directly to PostgreSQL – PgBouncer i

KAKristi Anderson·January 8, 2020Databases