Planet MariaDB Server
Percona Live Europe Presents: pg_chameleon MySQL to PostgreSQL Replica Made Easy
What excites me is the possibility that this tool is giving to other people. Also, the challenges I’ve faced and the new ideas for the future releases are always source…
Percona Live Europe Presents: MariaDB 10.4 Reverse Privileges (DENY)
One of the most common questions about privileges in MySQL and MariaDB is how would a user revoke access to a particular table, in a large database with hundreds or…
Percona Live Europe Presents: Need for speed – Boosting Apache Cassandra’s performance using Netty
My talk is titled Need for speed: Boosting Apache Cassandra’s performance using Netty. Over the years that I have worked in the software industry, making code run fast has fascinated…
Percona Live Europe Presents: The Latest MySQL Replication Features
Considering the modern world of technology, where distributed system play a key role, replication in MySQL® is at the very heart of that change. It is very exciting to deliver this presentation…
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.…