MySQL Webinars and Videos from Percona
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. [...]
The webinar will show best practices to deploy and test a large number of MySQL instances in an efficient way using tools well know by the DevOps community like puppet, vagrant, and mcollective. Presented by Frédéric Descamps at Percona Webinars – October 31, 2012.
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.
Proper indexing is a key ingredient of database performance and MySQL is no exception. In this session we will talk about how MySQL uses indexes for query execution, how to come up with an optimal index strategy, how to decide when you need to add an index, and how to discover indexes which are not [...]
The most massive crime of identity theft in history was perpetrated in 2007 by exploiting an SQL Injection vulnerability. This issue is one of the most common and most serious threats to web application security. In this presentation, you’ll see some common myths busted and you’ll get a better understanding of defending against SQL injection. [...]
