All Things Distributed

SEPTEMBER 1, 2023

It is time to celebrate EC2-Classic, which defined early cloud computing, and which is finally retiring.

Cloud 208

Cloud 208

Percona

SEPTEMBER 1, 2023

MySQL users can easily be confused by the seemingly infinite differences between MySQL and PostgreSQL. The good news is that for someone familiar with MySQL, they have the basics of databases covered and can explore some of the treasures to be discovered in the new PostgreSQL environment. One of the interesting facets that you need to explore that has no corresponding counterpart in the MySQLverse is table inheritance.

Open Source 108

Open Source Code Testing Database 108

Kovair

SEPTEMBER 1, 2023

Imagine you have recently downloaded a newly launched game. Isn’t it frustrating if the game freezes abruptly, disrupting your gameplay?

Games 52

Games Testing 52

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. In this blog post, we will talk about MongoDB sharding and walk through the main reasons why you should start a cluster (independent of the approach you have chosen). Database architects working with MongoDB encounter specific challenges related to database systems and system growth.

Best Practices 75

Best Practices Traffic Database Servers 75

Percona

SEPTEMBER 1, 2023

This blog was originally published in November 2021 and was updated in September 2023. MySQL server performance can sometimes be perplexing, and if you’ve ever wondered about the role of triggers in influencing your MySQL server’s memory allocation, this post is for you. MySQL triggers are a powerful tool for database administrators and developers, enabling them to automate tasks, enforce data consistency, and respond to events within the database seamlessly.

Cache 64

Cache Database Games Healthcare 64

Percona

SEPTEMBER 1, 2023

This blog was originally published in February 2019 and was updated in September 2023. Web applications rely on databases to run the internet, powering everything from e-commerce platforms to social media networks to streaming services. MySQL is one of the most popular database management systems, playing a pivotal role in the functionality and performance of web applications.

Performance 52

Performance Storage Social Media Database 52

Percona

SEPTEMBER 1, 2023

This post was originally published in June 2020 and was updated in September 2023. While there is no magic bullet for MySQL performance tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. While much information has been published on this topic over the years, I wanted to break down some of the more critical settings that anyone can implement with no guesswork required.

Tuning 52

Tuning Database Performance Hardware 52