Buy Percona ServicesBuy Now!

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

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

Deploying MySQL on Kubernetes with a Percona-based Operator

 | October 11, 2018 |  Posted In: Advanced Level, DevOps, MySQL, Percona Server for MySQL

Kubernetes MySQL Operator

In the context of providing managed WordPress hosting services, at Presslabs we operate with lots of small to medium-sized databases, in a DB-per-service model, as we call it. The workloads are mostly reads, so we need to efficiently scale that. The MySQL® asynchronous replication model fits the bill very well, allowing us to scale horizontally […]

Read More

Percona Live Europe Tutorial: Elasticsearch 101

 | October 3, 2018 |  Posted In: Events, Information, 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