MySQL Webinars and Videos from Percona
MySQL scalability depends on getting many things right including the architecture, hardware, operating system, MySQL version, MySQL configuration, schema design and indexing, and query design. To avoid having any one of them become the bottleneck that limits the scalability of the entire system, you need to follow best practices in all of these technology areas. [...]
Percona Toolkit is a must-have set of tools that can help serious MySQL administrators perform tasks that are common but difficult to do manually. Years of deployments by tens of thousands of users including some of the best-known Internet sites, have proven the reliability of the Percona Toolkit tools for MySQL. In this presentation, you [...]
MySQL 5.6 offers many long-awaited features. Among the biggest advances in functionality are the enhancements in query planning and optimization. How do we take advantage of this new functionality? In this webinar, we will examine the difference between MySQL 5.6 and MySQL 5.5 query performance in detail by: • Comparing the low level row operations, [...]
The long-awaited MySQL 5.6 is now generally available. You may find yourself wondering what advantages 5.6 provides and if the benefits exceed the effort of upgrading. This rapidly paced technical session will provide an overview of the most important developments in MySQL 5.6 including the new optimizer, replication, and transparency features. Date of Presentation: March [...]
Imagine a query that barely fits your monitor screen such as a 7 table join. In this MySQL webinar, we will discuss filling the gap between reading explain output and optimizing really large queries. Practical techniques used to address real-world situations will be shared, while pointing out common mistakes organizations often make. The talk will [...]
The MySQL ecosystem contains many projects and MySQL database engines. Shard-Query (a free open source project) can be used together with these different engines to build fault tolerant distributed database systems. This presentation will describe why distributed databases are needed in today’s compute environment and will describe the means to build three different types of [...]
Using MySQL replication gives you an opportunity to scale out read queries. However, MySQL replication is asynchronous so the slave may fall behind. This MySQL webinar shows the correct ways to check when the slave is safe to query and how to architect your PHP application to adapt dynamically when the slave is out of [...]
Building a robust and high performance MySQL application requires a combination of using the right techniques and avoiding the wrong ones. In this MySQL webinar you will learn the most common traps that lead to bad performance, complicated architectures, and waste of money when you are designing or running a MySQL application. You will then [...]
Percona Toolkit is the must-have toolkit for serious MySQL administrators with well-tested tools developed by Percona to solve real-world challenges faced by our customers. This webinar will present 10 of these tools, including usage examples that will help attendees understand when and how to use these tools in their environments. Presented by Fernando Ipar at [...]
MySQL is the first choice for a large majority of web applications thanks to its ease of use and low cost of operation. However, running big apps on MySQL is still a challenge even for experts. In this webinar we will show you how to combine Percona Server and Percona XtraBackup with Continuent Tungsten to [...]
