Yes, SCaLE, or the Southern California Linux Expo is back. Friday is the MySQL track with eight presentations. A big thanks to all the presenters and we hope to see you at the LAX Hilton July 29th!
MySQL 8.0 New Features
- Dave Stokes
- Audience:Everyone
- Topic:MySQL
- MySQL now features quarterly releases that come with new features. So if you do not know about hash joins, replica set, JSON document validation, or other new features then you need to be in this presentation.!
- Room:
- Carmel
- Time:
- Friday, July 29, 2022 - 10:00 to 11:00
State of MySQL Security in 2022
- Alexander Rubin
- Audience:Developer
- Topic:MySQL
- In this talk we will look into the state of MySQL Security in 2022. We will cover the new security focused features available in MySQL (and MySQL Compatible variants) as well as share best practices to consider for secure MySQL deployment.
- Room:
- Carmel
- Time:
- Friday, July 29, 2022 - 11:00 to 12:00
Forward to the Past: Point in time recovery for MySQL
- Pep Pla
- Audience:Intermediate
- Topic:MySQL
- Disasters happen. Somebody runs a process that renders the data in your database unusable, inconsistent, or just deleted. Wouldn't it be great to be able to recover your database to the state just before the disaster happened?
- In this talk we will learn the basics of Point in time recovery for MySQL:
- - Disasters happen.
- - You need three things.
- - I know what you did last transaction: the binary logs.
- - I need some backup.
- - The quest for the third thing: find the last transaction before the disaster.
- - Putting all together the traditional way.
- - Make it faster using replication.
- - What you can't recover, or at least you can't easily recover: the transactions executed after the disaster.
- Room:
- Carmel
- Time:
- Friday, July 29, 2022 - 13:00 to 14:00
Query Optimization 101 in MySQL
- Matthew Boehm
- Queries are essential to retrieving data from your database. How do you know if your queries are performing well? What is an index, and how does it help access the data? We will answer these questions and many more as we take our first steps into the realm of query optimization.
- Room:
- Carmel
- Time:
- Friday, July 29, 2022 - 14:00 to 15:00
I need some (MySQL) backup!
- Pep Pla
- Audience:Intermediate
- Topic:MySQL
- "If you have a hammer, all you see is nails." also known as the Law of the Instrument describes the cognitive bias that involves over-reliance on a familiar tool. To protect MySQL data, a DBA must have a toolbox full of the proper utensils. To know only one approach is not enough.
- In this talk, we will cover the following topics:
- - Why your backup strategy is probably wrong?
- - Backups: Cold, hot... and warm?
- - The right answer is not always the logical one.
- - Replication is not the solution.
- - Cold backups: rsync, snapshots...
- - Warm backup using rsync.
- - The logical song:
- - Mysqldump.
- - Mydumper.
- - Mysqlpump.
- - MySQL shell.
- - Getting physical:
- - Percona XtraBackup: my swiss army knife.
- - MySQL Enterprise Backup.
- - Point-in-time recovery.
- - Don't try this at prod: Test your backups.
- Room:
- Carmel
- Time:
- Friday, July 29, 2022 - 15:00 to 16:00
The Great Migration: Galera Cluster to InnoDB Cluster
- Michael Marx
- Topic:MySQL
- Since the introduction of replication in MySQL, users have been trying to automate the promotion of a replica to a primary as well as automating the failover of TCP connections from one database server to another in the event of a database failure: planned or unplanned. For over a decade, users and organizations have designed various types of solutions to achieve this. Though, many of these solutions were problematic. Eventually, a solution was introduced to the community that clustered the MySQL Server. This product is known as Percona XtraDB Cluster and uses a technology called Galera to achieve high availability.
- To compete with this product, MySQL eventual introduced cluster for MySQL, known as InnoDB Cluster. This is the official high availability solution for and from MySQL. It utilizes some of the same principles as Percona XtraDB Cluster, but it includes a mysql shell with an API that makes setting up, configuring, and monitor the InnoDB Cluster much easier than Galera. In addition, the InnoDB Cluster includes a proxy called router that allows for automatic failover of TCP connections if a node in the cluster becomes unavailable.
- Through this presentation the InnoDB Cluster will be explored in detail as well as simple instructions on how to move from Percona XtraDB Cluster to MySQL InnoDB Cluster.
- Room:
- Carmel
- Time:
- Friday, July 29, 2022 - 16:00 to 17:00
The Great Migration: Galera Cluster to InnoDB Cluster
- Michael Marx
- Topic:MySQL
- Since the introduction of replication in MySQL, users have been trying to automate the promotion of a replica to a primary as well as automating the failover of TCP connections from one database server to another in the event of a database failure: planned or unplanned. For over a decade, users and organizations have designed various types of solutions to achieve this. Though, many of these solutions were problematic. Eventually, a solution was introduced to the community that clustered the MySQL Server. This product is known as Percona XtraDB Cluster and uses a technology called Galera to achieve high availability.
- To compete with this product, MySQL eventual introduced cluster for MySQL, known as InnoDB Cluster. This is the official high availability solution for and from MySQL. It utilizes some of the same principles as Percona XtraDB Cluster, but it includes a mysql shell with an API that makes setting up, configuring, and monitor the InnoDB Cluster much easier than Galera. In addition, the InnoDB Cluster includes a proxy called router that allows for automatic failover of TCP connections if a node in the cluster becomes unavailable.
- Through this presentation the InnoDB Cluster will be explored in detail as well as simple instructions on how to move from Percona XtraDB Cluster to MySQL InnoDB Cluster.
- Room:
- Carmel
- Time:
- Friday, July 29, 2022 - 16:00 to 17:00
MySQL Indexes
- Dave Stokes
- Audience:Everyone
- Topic:MySQL
- Nobody complains where the database is fast. But adding one index speeds things up. But the second index makes things worse? There is a lot of mythology about indexes in the MySQL area and this talk will show that getting performance out of an index is simple engineering and not magic. You will walk out of this session know how indexes are built, how to use them to provide better information to the query optimizer, and how to make sure that what you are doing is a positive change and not hurting your instance performance.
- Room:
- Carmel
- Time:
- Friday, July 29, 2022 - 17:00 to 18:00
