Buy Percona ServicesBuy Now!

An Introduction To MongoDB Replication

 | January 14, 2019 |  Posted In: Entry Level, MongoDB

mongodb replication

MongoDB® is database software that stores data in the same format as JSON. The data structure of the database can be changed when required. The performance of the database is good and developers can easily use to it to connect their code to the database. The database, MongoDB is platform independent and runs in the […]

Read More

Writing a Killer Conference Proposal

 | January 3, 2019 |  Posted In: Entry Level, Events

writing a killer conference proposal

If you’re planning to submit a proposal to Percona Live but suffering a little writer’s block, or at least want to be sure to make a good impression on our track selectors, there’s some great content online that can help. If you’re an old hand, you probably won’t need this, though it’s possible you’ll find […]

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

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