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

7 Checks to Successfully Upgrade MongoDB Replica Set in Production

 | August 29, 2018 |  Posted In: MongoDB, Open Source Databases

checklist for the upgrade of MongoDB replica set

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 your plate you should always consider upgrading your MongoDB deployments. Planning your database upgrade can avoid the nightmares caused due to database-upgrade-gone-wrong or avoid not-so-simple rollbacks in your production […]

Read More

Easy and Effective Way of Building External Dictionaries for ClickHouse with Pentaho Data Integration Tool

 | August 2, 2018 |  Posted In: MySQL, Open Source Databases

pentaho pdt with clickhouse

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 in this example, you can use any PDI supported source. ClickHouse ClickHouse is an open-source column-oriented DBMS (columnar database management system) for online analytical processing. […]

Read More

TiSpark: More Data Insights, No More ETL

 | June 18, 2018 |  Posted In: Open Source Databases

TiSpark query path selection

When we released TiDB 2.0 in April, part of that announcement also included the release of TiSpark 1.0–an integral part of the TiDB platform that makes complex analytics on “fresh” transactional data possible. Since then, many people in the TiDB community have been asking for more information about TiSpark. In this post, I will explain […]

Read More