Buy Percona ServicesBuy Now!

Percona Live Europe Presents: MariaDB 10.4 Reverse Privileges (DENY)

 | October 23, 2018 |  Posted In: Events, MariaDB, MySQL

MariaDB Foundation

One of the most common questions about privileges in MySQL and MariaDB is how would a user revoke access to a particular table, in a large database with hundreds or thousands of tables, while keeping the rest available. Currently, there is no easy solution. Just grant access to everything else, individually. Not only does this […]

Read More

Percona Live Europe Presents: Need for speed – Boosting Apache Cassandra’s performance using Netty

 | October 22, 2018 |  Posted In: DevOps, Events, MySQL

My talk is titled Need for speed: Boosting Apache Cassandra’s performance using Netty. Over the years that I have worked in the software industry, making code run fast has fascinated me. So, naturally when I first started contributing to Apache Cassandra, I started looking opportunities to improve its performance. My talk takes us through some […]

Read More

Percona Live Europe Presents: The Latest MySQL Replication Features

 | October 19, 2018 |  Posted In: Events, MySQL

PLE Frankfurt Logo

Considering the modern world of technology, where distributed system play a key role, replication in MySQL® is at the very heart of that change. It is very exciting to deliver this presentation and to be able to show everyone the greatest and the latest features that MySQL brings in order to continue the success that it has always […]

Read More

Percona Live Europe Presents: MariaDB System-Versioned Tables

 | October 17, 2018 |  Posted In: Events, MariaDB, MySQL

PLE Frankfurt Logo

System-versioned tables, or temporal tables, are a typical feature of proprietary database management systems like DB2, Oracle and SQL Server. They also appeared at some point in PostgreSQL, but only as an extension; and also in CockroachDB, but in a somewhat limited fashion. The MariaDB® implementation is the first appearance of temporal tables in the MySQL […]

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

Percona Live Europe Session: What’s New in MariaDB Server 10.3

 | October 16, 2018 |  Posted In: Events, MariaDB

MariaDB Foundation

Having spent my recent years “in the real world”, working with many users, I’ve learnt that a particular new feature does not necessarily excite users as much as one might expect. MariaDB 10.3 however actually has some very interesting features that users do get excited about. So that’s great! My session at Percona Live Europe […]

Read More