Planet MariaDB Server
Percona Live Europe Presents: MariaDB System-Versioned Tables
System-versioned tables, or temporal tables, are a typical feature of proprietary database management systems like DB2, Oracle and SQL Server. They also appeared at some point in PostgreSQL, but only…
Export to JSON from MySQL All Ready for MongoDB
This post walks through how to export data from MySQL® into JSON format, ready to ingest into MongoDB®. Starting from MySQL 5.7+, there is native support for JSON. MySQL provides…
Percona Live Europe Session: What’s New in MariaDB Server 10.3
** Having spent my recent years “in the real world”, working with many users, I’ve learnt that a particular new feature does not necessarily excite users as much as one…
Percona Live Europe Tutorial: Query Optimization and TLS at Large Scale
For Percona Live Europe this year, I got accepted a workshop on query optimization and a 50-minute talk covering TLS for MySQL at Large Scale, talking about our experiences at…
Generating Identifiers – from AUTO_INCREMENT to Sequence
There are a number of options for generating ID values for your tables. In this post, Alexey Mikotkin of Devart explores your choices for generating identifiers with a look at…
Deploying MySQL on Kubernetes with a Percona-based Operator
In the context of providing managed WordPress hosting services, at Presslabs we operate with lots of small to medium-sized databases, in a DB-per-service model, as we call it. The workloads…
Percona Live Europe Tutorial: Elasticsearch 101
For Percona Live Europe, I’ll be presenting the tutorial Elasticsearch 101 alongside my colleagues and fellow presenters from ObjectRocket Alex Cercel, DBA, and Mihai Aldoiu, Data Engineer. Here’s a brief overview…
Minimize MySQL Deadlocks with 3 Steps
MySQL has locking capabilities, for example table and row level locking, and such locks are needed to control data integrity in multi-user concurrency. Deadlocks—where two or more transactions are waiting…
[MySQL][replication]unknown error reading log event on the master
MySQL 5.7 and 8.0 have an issue of stopping replication on all slaves.
[MySQL][replication]unknown error reading log event on the master
MySQL 5.7 and 8.0 have an issue of stopping replication on all slaves.
Multi-master with MariaDB 10 – a tutorial
The goal of this tutorial is to show you how to use multi-master to aggregate databases with the same name, but different data from different masters, on the same slave.…
7 Checks to Successfully Upgrade MongoDB Replica Set in Production
MongoDB ships powerful features in each release. The new release brings new features while revisions add bug fixes, security patches or improvements to existing features. To bring most out these releases to…
Question about Semi-Synchronous Replication: the Answer with All the Details
I was recently asked a question by mail about MySQL Lossless Semi-Synchronous Replication. As I think the answer could benefit many people, I am answering it in a blog post.…
Easy and Effective Way of Building External Dictionaries for ClickHouse with Pentaho Data Integration Tool
In this post, I provide an illustration of how to use Pentaho Data Integration (PDI) tool to set up external dictionaries in MySQL to support ClickHouse. Although I use MySQL…
When MySQL Goes Away
Handling MySQL errors in Go is not easy. There are a lot of MySQL server error codes, and the Go MySQL driver as its own errors, and Go database/sql has…