Vinicius joined Percona Support Engineer team in 2017. Vinicius has a Bachelor's degree in Computer Science. He has a passion for technology and databases systems. In the free time, like to watch movies and is a fan of Lord of the Rings.
Security is always a challenge when we come to data but regulations like GDPR brings a new layer on top of it with rules more and more restrictive to access and manipulate data. Join us in this presentation to check security best practices, traditional and new features available for MySQL including features coming with the new MySQL 8.
On this talk DBA's and sysadmins will walk through the security features available on the OS and MySQL:
MySQL 8 features (undo, redo and binlog encryption)
We will share our experience of working with 2000 support customers and help the audience to become familiar with all the security concepts and methods, and give you the necessary knowledge to apply to your environment.
This is a hands-on tutorial covers how to set up monitoring for MySQL, MongoDB, and PostgreSQL database servers using the Percona Monitoring and Management (PMM) platform.
PMM is an open-source collection of tools for managing and monitoring MySQL, MongoDB, and PosgreSQL performance. It provides thorough time-based analysis for database servers to ensure that they work as efficiently as possible.
You will learn about:
- MySQL, MongoDB, and PostgreSQL monitoring best practices
- Metrics and time series
- Data collection, management and visualization tools
- Monitoring deployment
- How to use graphs to spot performance issues
- Query analytics for MySQL and MongoDB
- Alerting using Grafana
- Trending and capacity planning
- How to monitor HA
Please bring a laptop with an ssh client as you will be connecting to a Cloud-provisioned instance on which you will deploy PMM.
MongoDB 4.0 brings transactional properties from the SQL world to the NoSQL world. Now supporting snapshot isolation, commits and rollbacks are one of the most exciting features of MongoDB 4.0. Moreover, MongoDB 4.0 brings interesting enhancements like change streams, SHA-2 authentication, and security enhancements to create users using authentication restrictions.
In this session we will walk through the new features available on MongoDB 4.0:
Security enhancements and SHA-2 authentication
Change streams and read concern
MMAP deprecation on 4.2
MongoDB mobile database