Planet MariaDB Server
Fixing Common PostgreSQL Performance Bottlenecks
Overview In this article, I look at how poorly designed sharding systems and replication systems in PostgreSQL affect query performance in high volume situations, and how to ensure data consistency…
Not JOINing on PERFORMANCE_SCHEMA
The tables in PERFORMANCE_SCHEMA (P_S) are not actually tables. You should not think of them as tables, even if your SQL works on them. You should not JOIN them, and…
Installing the Latest MariaDB from the Repository on Debian 10 and Downgrading to Older Minor Version
I had not written any new blog posts here since this one for quite a some time, for two reasons. First of all, I have another project to spend time…
Installing the Latest MariaDB from the Repository on Debian 10 and Downgrading to Older Minor Version
I had not written any new blog posts here since this one for quite a some time, for two reasons. First of all, I have another project to spend time…
On the Observability of Outliers
At work, I am in an ongoing discussion with a number of people on the Observability of Outliers. It started with the age-old question “How do I find slow queries…
Using your FRM file to get Schema and then import idb files..
This is a topic that overall you never should have to do… Why? Because you created backups right… You have tested and know the backups work so you can just…
Query Metrics Requirements for MySQL
Let’s answer a question which, to my knowledge, has never been systematically addressed: What are the requirements for a production-ready query metrics app at scale? I am uniquely qualified to…
How to build a high-performance application on Tarantool from scratch
I came to Mail.ru Group in 2013, and I required a queue for one task. First of all, I decided to check what the company had already got. They told…
About me
My name is Michal Hrušecký, I was born in 1984 in Prague, Czech republic and I’m still living in the same city. I used to work in SuSE Linux s.…
About me
My name is Michal Hrušecký, I was born in 1984 in Prague, Czech republic and I’m still living in the same city. I used to work in SuSE Linux s.…
Zero downtime schema change with Liquibase & Percona
I am always surprised to learn something new whenever I talk to a member of the open-source community. No matter how much I think I have heard of every use…
Mayastor: Lightning Fast Storage for Kubernetes
At MayaData we like new tech. Tech that makes our databases perform better. Tech like lockless ring buffers, NVMe-oF, and Kubernetes. In this blog post we’re going to see those…
MySQL 8.0 Document Store, Discovery of a New World – Percona Live ONLINE Talk Preview
Percona Live Online Agenda Slot: Wed 21 Oct • New York 5:00 a.m. • London 10:00 a.m. • New Delhi 2:30 p.m. • Singapore 5:00 p.m. Abstract MySQL Document Store…
The State of ProxySQL, 2020 Edition – Percona Live ONLINE Talk Preview
Percona Live Online Agenda Slot: Wed 21 Oct • New York 7:30 a.m. • London 12:30 p.m. • New Delhi 5:00 p.m. • Singapore 7:30 p.m. Abstract ProxySQL is a…
Engineering Data Reliably Using SLO Theory – Percona Live ONLINE Talk Preview
Percona Live Online Agenda Slot: Tue 20 Oct • New York 12:30 p.m. • London 5:30 p.m. • New Delhi 10:00 p.m. • Singapore 12:30 a.m. (next day) Abstract Not…