In this full-day tutorial, Florian and Yves explore the Pacemaker cluster stack, fully integrated with MySQL. We cover DRBD based and MySQL replication based cluster solutions, and combined configurations — all within one high availability framework.
Vadim is main architect of Percona XtraBackup, In this tutorial he will cover every details of XtraBackup: - Original idea behind product - Internal design - Comparison with other backup solutions for MySQL - Work principles - Purpose of files in package - Basic usage - Parallel backup - Streaming backup - More complex usage: * Incremental backups * Differential backups * Partial backups * Move InnoDB tables between servers * Parallel compressed backups * lock and lockless modes * synergy with Percona Server All this with real-time detailed examples.
Aimed towards developers who want to learn more about mysql. You will learn to: * understand indexing, created proper schema's * query optimization * Storage Engines/InnoDB Basics * general MySQL configuration and troubleshooting
This "classical" Innodb and XtraDB architecture tutorial was updated to reflect changes and new features in latest versions of MySQL and Percona Server. It will cover the most important aspects of Innodb and XtraDB architecture as well as teach you to use them to archive best application performance and avoid bottlenecks. We will also look at Innodb settings corresponding to different architectural aspects.
Percona Toolkit is the must-have toolkit for serious MySQL administrators, with well-tested tools for many purposes such as query analysis and replication management. This half-day tutorial will show examples (with occasional hands-on exercises) of when and how to use the most important tools:
Choosing right Hardware components, configuring them properly, and optimizing Linux settings are very important for MySQL and other database server deployments. But they are frequently overlooked. I have seen many cases that H/W and Linux settings were wrongly configured on production environments. Changing configurations after going live is not easy. Some Linux settings such as I/O scheduler can be changed dynamically, but many of the settings can not be changed without stopping MySQL.
Like many things in MySQL, choosing a high-availability solution for MySQL has traditionally been an exercise in tradeoffs. There are many alternatives to choose from, many good enough but none perfect.
MySQL replication is the backbone of the web economy. Its usage has allowed tiny startup companies to become internet giants without huge investments in hardware and licenses. This tutorial will introduce MySQL replication from the ground up. It will cover the basics of how replication works before explaining how to set replication and extend your cluster of servers.
It is essential to understand how your system performs at different workloads to measure the impacts of changes and growth and to understand how those impacts will manifest. Measuring the performance of current workloads is not trivial and the creation of a staging environment where different workloads need to be tested has it's own set of challenges.
The Sakila sample database makes for a great mini-tutorial on how to design, create, load and use a data warehouse. This is the main thread of this mini tutorial. While the main thread of the turorial focuses on general business intelligence and data warehouse concepts, the tutorial also contains hands-on parts. The hands-on parts are a great way to get introduced to a variety of open source tools (mainly focused on the Pentaho) for building and developing data warehouses and business intelligence applications. To facilitate attendees in participating themselves in the hands-on parts, I...
MySQL security is critical to most organizations. This tutorial takes an in-depth look at using white-hat google hacking (the good kind of hacking, where you have permission) techniques to show you what the "bad guys" can do. You will learn about the following hacking strategies and how they are done: SQL injection, cross-site scripting (XSS), cross-site request forgery (CSRF), gateway vulnerabilities and social engineering, all without violating Google's Terms of Service. We will also discuss how to minimize impact and how to perform forensics.
Learn everything there is to know about being a MySQL DBA in 3 hours. this tutorial will teach you all the most important topics of being a MySQL DBA. At the same time it will prepare you for the MySQL DBA certification. This tutorial will go through all the most important topics of being a DBA and we will explain them in detail. This will both prepare for being a DBA and the MySQL certification.
The performance of a DBMS system depends on its two main components - optimizer and storage engine (typically InnoDB). The primary focus of MySQL community has been the storage engine, however, recent versions of both MySQL and MariaDB have (partially overlapping) improved optimizer features, better optimizer control and diagnostics. The goal of this tutorial is to empower the MariaDB/MySQL user with the knowledge how to utilize and control both new and old optimizer features to achieve performance improvements from several times up to several orders of magnitude. A.