Buy Percona ServicesBuy Now!

Percona Live Europe Tutorial: Query Optimization and TLS at Large Scale

 | October 15, 2018 |  Posted In: Events, MariaDB, MySQL, Open Source Databases

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 the Wikimedia Foundation. Workshop The 3-hour workshop on Monday, titled Query Optimization with MySQL 8.0 and MariaDB 10.3: The Basics is a beginners’ tutorial–though dense […]

Read More

Generating Identifiers – from AUTO_INCREMENT to Sequence

 | October 12, 2018 |  Posted In: Entry Level, MariaDB, MySQL, Tools

generating complex sequences

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 auto_increment, triggers, UUID and sequences. AUTO_INCREMENT Frequently, we happen to need to fill tables with unique identifiers. Naturally, the first example of such identifiers is […]

Read More

Deploying MySQL on Kubernetes with a Percona-based Operator

 | October 11, 2018 |  Posted In: Advanced Level, DevOps, MySQL, Percona Server for MySQL

Kubernetes MySQL 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 are mostly reads, so we need to efficiently scale that. The MySQL® asynchronous replication model fits the bill very well, allowing us to scale horizontally […]

Read More

Percona Live Europe Tutorial: Elasticsearch 101

 | October 3, 2018 |  Posted In: Events, MariaDB, MongoDB, MySQL, Tools

Elasticsearch logo

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 of our tutorial. Elasticsearch® is well known as a highly scalable search engine that stores data in a structure optimized for language based searches but […]

Read More

Minimize MySQL Deadlocks with 3 Steps

 | September 24, 2018 |  Posted In: Entry Level, MySQL

application deadlock in MySQL transactions

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 for one another to give up locks before the transactions can proceed successfully—are an unwanted situation. It is a classic problem for all databases including […]

Read More