Buy Percona ServicesBuy Now!

Percona Live Europe Presents: Test Like a Boss

 | September 25, 2019 |  Posted In: Events, MySQL, Tools

My first talk is a tutorial Testing like a boss: Deploy and Test Complex Topologies With a Single Command, scheduled at Percona Live Europe in Amsterdam on September 30th at 13:30. My second talk is Amazing sandboxes with dbdeployer scheduled on October 1st at 11:00. It is the same topic as the tutorial, but covers […]

Read More

Minimalist Tooling for MySQL/MariaDB DBAs

 | August 14, 2019 |  Posted In: MariaDB, MySQL, Tools

In my roles as a DBA at various companies, I generally found the tooling to be quite lacking. Everything from metrics collection, alerting, backup management; they were either missing, incomplete or implemented poorly. DBA-Tools was born from a desire to build backup tools that supported my needs in smaller/non-cloud environments. As BASH is easily the […]

Read More

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