How to Monitor MySQL Deployments with Prometheus & Grafana at ScaleGrid

Posted: January 3, 2020

Monitoring your MySQL database performance in real-time helps you immediately identify problems and other factors that could be causing issues now or in the future. It's also a good way to determine which components of the database can be enhanced or optimized to increase your efficiency and...

Read Article

PostgreSQL Connection Pooling: Part 2 – PgBouncer

Posted: December 19, 2019

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...

Read Article

The Best Way to Host MongoDB on DigitalOcean

Posted: December 16, 2019

MongoDB is the #3 open source database and the #1 NoSQL database in the world. It’s a cross-platform document-oriented database that uses JSON-like documents with schema, and is leveraged broadly across startup apps up to enterprise-level businesses developing modern apps. While you may assume a...

Read Article

Re-Slaving a Crashed MySQL Master Server in Semisynchronous Replication Setup

Posted: December 9, 2019

In a MySQL 5.7 master-slave setup that uses the default semisynchronous replication setting for rpl_semi_sync_master_wait_point, a crash of the master and failover to the slave is considered to be lossless. However, when the crashed master comes back, you may find that it has transactions that are...

Read Article

ScyllaDB Trends – How Users Deploy The Real-Time Big Data Database

Posted: November 25, 2019

ScyllaDB is an open-source distributed NoSQL data store, reimplemented from the popular Apache Cassandra database. Released just four years ago in 2015, Scylla has averaged over 220% year-over-year growth in popularity according to DB-Engines. We’ve heard a lot about this rising database from the...

Read Article

Best Practice for Creating Indexes on your MySQL Tables – Rolling Index Builds

Posted: November 20, 2019

By having appropriate indexes on your MySQL tables, you can greatly enhance the performance of SELECT queries. But, did you know that adding indexes to your tables in itself is an expensive operation, and may take a long time to complete depending on the size of your tables? During this time, you...

Read Article

Making it Easier to Manage a Production PostgreSQL Database

Posted: November 12, 2019

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...

Read Article

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

Posted: October 31, 2019

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. In these blogs, we dove deep into how...

Read Article

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

Posted: October 24, 2019

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...

Read Article

PostgreSQL Connection Pooling: Part 1 – Pros & Cons

Posted: October 17, 2019

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. It would be a shame if your database crashed,...

Read Article

How to Monitor MySQL Deployments with Prometheus & Grafana at ScaleGrid

PostgreSQL Connection Pooling: Part 2 – PgBouncer

Re-Slaving a Crashed MySQL Master Server in Semisynchronous Replication Setup

Best Practice for Creating Indexes on your MySQL Tables – Rolling Index Builds

Making it Easier to Manage a Production PostgreSQL Database

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

PostgreSQL Connection Pooling: Part 1 – Pros & Cons

Search:

About us:

You may also be interested in

MongoDB

Redis™

MySQL

PostgreSQL

Pricing

About Us

Resources

DPA