BIG DATA CONFERENCE

EUROPE 2021

Online Edition

September 28-30

Online

Lukas Vileikis

Technical Evangelist

Severalnines, Lithuania

Biography

Lukas is an ethical hacker, a trainer and a frequent conference speaker.
Lukas runs one of the biggest & fastest data breach search engines in the world – BreachDirectory.com, works with world renowned database engineers and frequently blogs in multiple places including his blog over at lukasvileikis.com

Workshop

Improving Performance and Security in MySQL

Abstract

This workshop will cover the things that developers and DBAs can do to improve security in MySQL by mainly covering security-related issues pertaining to MySQL, but also putting some performance aspects into the mix – people will learn how to secure their MySQL instances and keep them performing at the best of their ability at the same time.

Agenda

Part 1: Improving Performance in MySQL:

    • MySQL Storage Engines
    • Optimizing MySQL for High Performance
    • Optimizing Schema and Data Types in MySQL
    • Query Performance Optimization, Character Sets & Collations, Indexing…

Part 2: Improving Security in MySQL:

    • MySQL Access Control – Accounts, Privileges & Roles, etc.
    • MySQL Security Plugins
    • MySQL Backups & Backup Security
    • MySQL and Data Breaches – Big Data
Objectives

The main goal of this workshop is to introduce participants to the performance & security aspects of MySQL and help them build performant & secure software using this relational database management system.

Target audience

The target audience involves people interested in web development, big data, data breaches and data science – generally everyone who is interested in how MySQL functions on a deeper level is encouraged to attend. The attendees should have some general knowledge about MySQL.

Technical requirements

Installations:

    • WAMP if Windows is in use, XAMPP if you’re using Linux / if you’re not able to use WAMP

Technical knowledge:

    • Basic knowledge about MySQL and web servers.

A general requirement would be a web server (preferably local) running Apache & MySQL. Flavor of MySQL doesn’t matter: either MySQL, MariaDB or Percona Server.