Fri.Jun 23, 2023

article thumbnail

MySQL or PostgreSQL: Which is Better?

Percona

For more than a quarter of a century, people have been discussing “Which is better, MySQL or PostgreSQL?” — with no resolution. When people ask me which is better, I have to ask them what they want to do and how they want to do it. I’ll explain using a bad analogy: What type of car is best? This depends on your needs. If you want to go fast, a top fuel dragster will set you back close to a million dollars by the time you buy the chassis, spare engines, tooling, and transp

Database 122
article thumbnail

Presentation: Leveraging Determinism

InfoQ

Frank Yu discusses how to decrease bandwidth usage and buffering across the system, protect against thundering herd problems, and simplify the logic of gateway and persistence services.

Systems 52
article thumbnail

Is My Backup Stuck? A Quick Guide for Reviewing Percona XtraBackup Threads

Percona

In Percona Managed Services , one key aspect of managing the databases is configuring backups. Percona XtraBackup is one of the best tools for performing physical database backups. It is a good practice to compress the backups to save costs on storage and to encrypt the backups so those can’t be used if the files are compromised as long as you keep your encryption keys safe!

Servers 83