Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Shine Light On Creepers in Your MySQL Garden

Shine Light On Creepers in Your MySQL Garden

 27 April - 12:50 PM - 1:40 PM @ Room 204
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Wildcard
Topics:
MySQL

Description

Join Jeremy Glick and Andrew Moore whilst they share their experiences persuading MySQL to meet various regulatory compliance standards. Previous methods of logging for compliance included UDFs, triggers and other unreliable means to fill a gap in the core offering. However, given some of today's new requirements, they are no longer viable solutions. Did you know that MySQL has had a pluggable audit interface since version 5.5.3? This feature has presented several new logging options from multiple vendors and many of them are open source and free to use. Jeremy and Andrew will share these options with you, go through the decision-making process, and give a brief tutorial on setting up and configuring the prominent audit plugins on the market today. This talk will cover all the major plugins including McAfee, MariaDB, Oracle, and Percona. By the end of this session, you will have all the information you need to select the right audit plugin for your organization. This talk will include: - Selecting the right audit plugin - Balancing performance and security - Methods of storing logs (files, ELK stack, etc.) - Elasticsearch ELK stack demo

Speakers

Andrew Moore's picture

Andrew Moore

MySQL Practice Manager, Percona

Biography:

Loves MySQL, Dolphins and reading.

Jeremy Glick's picture

Jeremy Glick

MySQL Database Engineer, ZipRecruiter

Biography:

Jeremy Glick is a MySQL Database Engineer at ZipRecruiter. Before that, he worked as a consultant for various technology companies with systems ranging from dozens to hundreds of database servers. Jeremy is also the organizer of the Chicago MySQL Meetup. He holds multiple MySQL certifications and is a RedHat RHCE.

Share this talk