Buy Percona ServicesBuy Now!

Tame Kubernetes with These Open-Source Tools

 | July 8, 2019 |  Posted In: DevOps, Kubernetes, Tools

Kubernetes’ popularity as the most-preferred open-source container-orchestration system has skyrocketed in the recent past. The overall container market is expected to cross USD 2.7 billion by 2020 with a CAGR of 40 percent.  Three orchestrators spearhead this upward trend, namely Kubernetes, Mesos, and Docker Swarm. However, referring to the graph below, Kubernetes clearly leads the […]

Read More

MySQL Setup at Hostinger Explained

 | December 11, 2018 |  Posted In: MySQL, Tools

mysql setup at hostinger

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. We do not have elephant-sized databases for internal services like API, billing, and […]

Read More

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

 | October 26, 2018 |  Posted In: Events, MySQL, PostgreSQL, Tools

pgchameleon logo

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 of interest that keep me focused on the project. So I’m looking forward to sharing this with the conference delegates. pg_chameleon can achieve two tasks […]

Read More

Export to JSON from MySQL All Ready for MongoDB

 | October 16, 2018 |  Posted In: Entry Level, MongoDB, MySQL, Tools

export-data-to-JSON-from-MySQL

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 functions that actually create JSON values, so I will be using these functions in this article to export to JSON from MySQL: JSON_OBJECT JSON_ARRAY These […]

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

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