Planet MariaDB Server
Fixing Ghosted GTIDs
MySQL auto-positioning is an integral part of replication with GTID, but it’s neither required nor guaranteed to work. It’s possible to enable GTIDs but disable auto-positioning, and it’s possible that…
Percona Server for MySQL 8.0 – New Data Masking Feature
Database administrators are responsible for maintaining the privacy and integrity of data. When the data contains confidential information, your company has a legal obligation to ensure that privacy is maintained.…
Quick hack for GTID_OWN lack
One of the benefits of MySQL GTIDs is that each server remembers all GTID entries ever executed. Normally these would be ranges, e.g. 0041e600-f1be-11e9-9759-a0369f9435dc:1-3772242 or multi-ranges, e.g. 24a83cd3-e30c-11e9-b43d-121b89fcdde6:1-103775793, 2efbcca6-7ee1-11e8-b2d2-0270c2ed2e5a:1-356487160, 46346470-6561-11e9-9ab7-12aaa4484802:1-26301153,…
Quick hack for GTID_OWN lack
One of the benefits of MySQL GTIDs is that each server remembers all GTID entries ever executed. Normally these would be ranges, e.g. 0041e600-f1be-11e9-9759-a0369f9435dc:1-3772242 or multi-ranges, e.g. 24a83cd3-e30c-11e9-b43d-121b89fcdde6:1-103775793, 2efbcca6-7ee1-11e8-b2d2-0270c2ed2e5a:1-356487160, 46346470-6561-11e9-9ab7-12aaa4484802:1-26301153,…
Percona Live Europe Presents: Test Like a Boss
My first talk is a tutorial Testing like a boss: Deploy and Test Complex Topologies With a Single Command, scheduled at Percona Live Europe in Amsterdam on September 30th at…
Are your Database Backups Good Enough?
In the last few years there have been several examples of major service problems affecting businesses data: outages causing data inconsistencies; unavailability or data loss, and worldwide cyberattacks encrypting your…
Percona Live Europe ’19: MongoDB 4.2
It’s all about MongoDB® 4.2 this time. MongoDB 4.2 released like a month ago (still newborn) and I am going to cover what’s new in three different areas: sharding, indexing,…
Using Terraform and Kubernetes to provision MariaDB on Azure
In previous post I used Terraform to provision a managed version of MariaDB (AWS RDS for MariaDB). There exist various managed version of MariaDB on the major cloud providers :…
Using Terraform and Kubernetes to provision MariaDB on Azure
In previous post I used Terraform to provision a managed version of MariaDB (AWS RDS for MariaDB). There exist various managed version of MariaDB on the major cloud providers :…
Minimalist Tooling for MySQL/MariaDB DBAs
In my roles as a DBA at various companies, I generally found the tooling to be quite lacking. Everything from metrics collection, alerting, backup management; they were either missing, incomplete…
MySQL 5.6/Maria 10.1 : How we got from 30k qps to 101k qps…..
Late one evening, I was staring at one of our large MySQL installations and noticed the database was hovering around 7-10 run queue length (48 cores, ~500 gigs memory, fusionIO…
How to Build a Percona Server “Stack” on a Raspberry Pi 3+
The blog post How to Compile Percona Server for MySQL 5.7 in Raspberry Pi 3 by Walter Garcia, inspired me to create an updated install of Percona Server for the…
MySQL Optimizer: Naughty Aberrations on Queries Combining WHERE, ORDER BY and LIMIT
Sometimes, the MySQL Optimizer chooses a wrong plan, and a query that should execute in less than 0.1 second ends-up running for 12 minutes!This is not a new problem: bugs…
My experience talking at JConf Colombia
Sharing my experience presenting Vaadin at JConf Colombia 2019.
Impact of innodb_file_per_table Option On Crash Recovery Time
Starting at version MySQL5.6+ by default innodb_file_per_table is enabled and all data is stored in separate tablespaces. It provides some advantages. I will highlight some of them: You can reclaim…