Welcome to the Percona Community blog!

If you’re interested in contributing, you can submit a pull request on GitHub with either your own topic or pick one of our open topics.

Percona Live Presents: Globalizing Player Accounts with MySQL at Riot Games

Percona Live Presents: Gonymizer, A Tool to Anonymize Sensitive PostgreSQL Data Tables for Use in QA and Testing

SmithRX is a next generation pharmacy benefit platform that is using the latest technology to radically reshape the prescription benefit management industry. To move quickly, we require the ability to iterate and test new versions of our software using production like data without violating Health Information Portability and Accountability Act (HIPAA) regulations.

Percona Live Presents: An Open-Source, Cloud Native Database

Percona Live Presents: The State of Databases in 2019

Percona Live Presents: The First Ever TiDB Track

The PingCAP team has always been a strong supporter of Percona and the wider open source database community. As the people who work day in and day out on TiDB, an open source NewSQL database with MySQL compatibility, open source database is what gets us in the morning, and there’s no better place to share that passion than Percona Live.

Percona Live Presents: The MySQL Query Optimizer Explained Through Optimizer Trace

During my presentation at Percona Live 2019 I will show how using Optimizer Trace can give insight into the inner workings of the MySQL Query Optimizer. Through the presentation, the audience will both be introduced to optimizer trace, learn more about the decisions the query optimizer makes, and learn about the query execution strategies the query optimizer has at its disposal. I’ll be covering the main phases of the MySQL optimizer and its optimization strategies, including query transformations, data access strategies, the range optimizer, the join optimizer, and subquery optimization.

Percona Live Presents: Vitess – Running Sharded MySQL on Kubernetes

The topic I’m presenting addresses a growing and unfulfilled need: the ability to run stateful workloads in Kubernetes. Running stateless applications is now considered a solved problem. However, it’s currently not practical to put databases like MySQL in containers, give them to Kubernetes, and expect it to manage their life cycles.

London Open Source Database Community Meetup

I strongly believe in the community.

#ilovefs Valentine's Day Celebration (I Love Free Software)

Free Software Foundation Europe (FSFE) is celebrating the creators of free software with their I Love Free Software campaign #ilovefs, a social campaign for Valentine’s Day.

An Introduction To MongoDB Replication

MongoDB® is database software that stores data in the same format as JSON. The data structure of the database can be changed when required. The performance of the database is good and developers can easily use to it to connect their code to the database.

Writing a Killer Conference Proposal

Some Notes on MariaDB system-versioned Tables

As mentioned in a previous post, I gave a talk at Percona Live Europe 2018 about system-versioned tables. This is a new MariaDB 10.3 feature, which consists of preserving old versions of a table rows. Each version has two timestamps that indicate the start (INSERT,UPDATE) of the validity of that version, and its end (DELETE, UPDATE). As a result, the user is able to query these tables as they appear at a point in the past, or how data evolved in a certain time range. An alternative name for this feature is temporal table, and I will use it in the rest of this text.

MySQL Setup at Hostinger Explained

Ever wondered how hosting companies manage their MySQL database architecture? At Hostinger, we have various MySQL setups starting from the standalone replica-less instances to Percona XtraDB Cluster (later just PXC), ProxySQL routing-based and even absolutely custom and unique solutions which I’m going to describe in this blog post.

Percona Live Europe Presents: ClickHouse at Messagebird: Analysing Billions of Events in Real-Time*

Percona Live Europe Presents: pg_chameleon MySQL to PostgreSQL Replica Made Easy

«1 2 3 4 5 6 7 8 »