Database Security Sessions

Wednesday 11:00AM-11:50AM

@ Room 204

Nikolay Samokhvalov - Nombox

postgres_dba (https://github.com/NikolayS/postgres_dba) - is a brand new open source DBA tool set, which can be used by any application developer to find database issues possible solutions much faster.

In this talk, we'll discuss why is it important to have proper tools to analyze database health, and why DBA's work very often looks like black magic.

Taking PostgreSQL as an example (including its managed cloud versions like Heroku Postgres or AWS RDS Postgres), we'll discuss what should be done to make DBA's tasks of maintaining and optimizing databases more efficient and automated.

We'll cover these topics:
- controlling sizes of tables and indexes;
- controlling bloat level and autovacuum;
- index set optimization;
- major disadvantages of current approaches to group slowest queries;
- using machine learning to find, analyze slowest and optimize slowest queries iteratively.


Open Source Databases
 Experience: Intermediate
Developer, Operations

Wednesday 12:50PM-1:40PM

@ Room 204

Andrew Regner - Facebook

Since the beginning, Facebook has used a conventional username/password to secure access to production MySQL instances. Over the last few years we've been working on moving to x509 TLS client certificate authenticated connections. Given the many types of languages and systems at Facebook that use MySQL in some way - this required a massive amount of changes for a lot of teams.

This talk is part technical overview of how our new solution works and part hard-learned tricks for getting an entire company to change their underlying mysql client libraries.


MySQL / MariaDB
 Experience: Intermediate
Business / Case Studies, Operations

Wednesday 1:50PM-2:40PM

@ Room 204

Jeff Sandstrom - Percona, Tyler Duzan - Percona

The EU's General Data Protection Regulation (GDPR) goes into effect on 25 May 2018. Your company's lawyers and compliance staff are (hopefully) well-versed on the subject, but what does GDPR mean for the DBA?


mariadb
 Experience: Beginner
Business / Case Studies

Wednesday 3:00PM-3:50PM

@ Room 204

Kimberly Wilkins - ObjectRocket

With the recent explosion of cryptocurrencies and the rapid rise of associated blockchain technologies, some seem to assume that blockchain will replace many other types of databases. Many even believe that blockchains are a database. We won't debate that in this session. However, we will discuss what blockchain is, why this technology is taking off, its basic architecture and functionality and how it really works. We'll also cover smart contracts a bit before pointing out where gaps still exist.
It is in those gap areas that NoSQL databases such as MongoDB and Elasticsearch still have a great seat at the table and have plenty to offer in this growing ecosystem.


MongoDBOpen Source Databases
 Experience: Intermediate
Developer, Business / Case Studies

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA