Buy Percona ServicesBuy Now!

How to contribute Dashboards to PMM

 | May 4, 2020 |  Posted In: Entry Level, Information, Intermediate Level, Open Source Databases, Tools

Have you already contributed to Percona’s open-source products or perhaps you wanted to try doing so? I will tell you how to become a contributor to the popular open-source product from Percona in just a few hours. You don’t need any serious developer skills. We earlier explained how to contribute to PMM documentation in our […]

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

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