Welcome to Percona Live Online 2021
Online Open Source Database Conference
Back To Schedule
Thursday, May 13 • 13:30 - 14:00
A QLDB Cheatsheet for MySQL Users

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.

Amazon's new ledger database (QLDB) is an auditor's best friend and lives up to the stated description of "Amazon QLDB can be used to track each and every application data change and maintains a complete and verifiable history of changes over time."

This presentation will go over what was done to take a MySQL application that provided auditing activity changes for key data, and how it is being migrated to QLDB.

While QLDB does use a SQL-format for DML, and you can perform the traditional INSERT/UPDATE/DELETE/SELECT. The ability to extend these statements to manipulate Amazon Ion data (a superset of JSON) gives you improved data manipulation and for example the FROM SQL statement.

Get a blow by blow comparison of MySQL structures (multiple tables and lots of columns) and SQL converted into a single QLDB table, with immutable, and cryptographically verifiable transaction log. No more triggers, duplicated tables, extra auditing for abuse of binary log activity.

We also cover the simplicity of using X Protocol and JSON output for data migration, and the complexity of AWS RDS not supporting X Protocol.

avatar for Ronald Bradford

Ronald Bradford

Lead Database Engineer/Architect, Lifion by ADP
A seasoned professional in the RDBMS industry, Ronald brings over a decade of AWS experience with using MySQL and supporting technologies in the Cloud. His broad architectural expertise across a variety of different industry sectors helps organizations tackle the needs of ensuring... Read More →

Thursday May 13, 2021 13:30 - 14:00 EDT
Room #6