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 [...]
Once MySQL users discover dual-master replication, they are often tempted to allow their applications to write to both at the same time. This talk will explore the dangers of doing so as well as the (limited) possibilities it allows. Illustrated examples will be used to show how this breaks down ACID compliance at fundamental levels. [...]
MySQL users commonly ask: What indexes do I need? Why aren’t my indexes helping me? Don’t indexes cause overhead? This webinar will provide practical, step by step methods for finding the queries you need to optimize and choosing the best indexes for them. Presented by Bill Karwin at Percona Webinars – October 3rd, 2012.
In this webinar, we will walk through the configuration of a MySQL highly available cluster using the Percona Replication Manager (PRM). PRM is a way to achieve high availability using regular MySQL replication. Other topics like adding and removing nodes and troubleshooting will also be covered. VirtualBox images will be provided in order to reproduce [...]
In this webinar, we will walk through the installation and basic configuration of Percona XtraDB Cluster. We will also discuss and demonstrate basic operations such as adding and removing a cluster node. We will discuss basic monitoring and troubleshooting and discuss the basic failure scenarios. Presented by Peter Boros at Percona Webinars – September 19th, [...]
Searching text data for words and substrings is deceptively difficult to do efficiently. What are the options, and how do they compare? This talk will compare several solutions for full text search, including MyISAM FULLTEXT, InnoDB FULLTEXT, Sphinx Search, Apache Solr, and trigraphs. Presented by Bill Karwin at Percona Webinars – August 22th, 2012.