Big Data Days 2021

Online Edition

28-30 Cентября

онлайн

Lukas Vileikis

Technical Evangelist

Lithuania, Severalnines

Биография

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

Мастер-класс

Improving Performance and Security in MySQL

Абстракт

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.

Содержание

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

Целевая аудитория

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.

Предварительные условия курса

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.

« Hазад