Using Sysbench to Generate Test Data for Sharded Table in MySQL
Sysbench is a great tool to generate test data and perform MySQL OLTP benchmarks. Commonly, one would do a prepare-run-cleanup cycle when performing benchmark using Sysbench. By default, the table generated by Sysbench is a...
PostgreSQL Replication Best Practices – Part 2
In the first part of this blog, we mentioned some important concepts related to a good PostgreSQL replication environment. Now, let’s see how to combine all these things together in an easy way using ClusterControl....
MySQL Replication Best Practices
MySQL Replication has been the most common and widely used solution for high availability by huge organizations such as Github, Twitter, and Facebook. Although easy to set up, there are challenges faced when using...
PostgreSQL Replication Best Practices – Part 1
Using replication for your PostgreSQL databases could be useful not only to have a high availability and fault tolerant environment but also to improve the performance on your system by balancing the traffic between the...
How to Measure Database Performance
Running production environments, you may be wondering how your database is performing? Does it deliver a proper level of performance? How can we measure it? Database performance is a very vast topic, but we would...
Connection Management in PostgreSQL: A Guide
Performance is always important in any system. You will need to make good use of the available resources to ensure the best response time possible and there are different ways to do this. Every connection...
Understanding Indexes in MySQL: Part Three
This blog post is the third part of the series of blogs about indexes in MySQL. In the second part of the blog post series about MySQL indexes, we covered indexes and storage engines and touched upon some...
Understanding Indexes in MySQL: Part Two
This blog post is the second part of the series of blogs about indexes in MySQL. In the first part of the blog post series about MySQL indexes, we have covered quite many things, including what...
Understanding MySQL’s New Heatwave
Data Analytics is important in any company as you can see what happened in the past to be able to make smart decisions or even predict future actions using the existing data. Analyze a huge...
Understanding Lock Granularity in MySQL
If you’ve been working with MySQL for some time, you have probably heard the terms “table-level locking” and “row-level locking”. These terms refer to the lock granularity in MySQL - in this blog we will...
How Database Automation Lowers The Total Cost of Ownership of Infrastructure Services
With the pandemic scorching the world for more than a year already, businesses are looking for a reduction in the cost of operating a business. In many cases, IT is one of the most expensive...
A Guide to Database Automation with Severalnines ClusterControl
Nowadays, database automation is a very hot topic. Database automation, simply speaking, refers to leveraging processes and tools to make administrative tasks for database developers and database administrators simpler. Why Database Automation? Database automation refers...