MySQL Webinars and Videos from Percona
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 [...]
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 [...]
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.
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, [...]
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 [...]
A lot of people are interested in XtraDB Cluster as a replacement for conventional MySQL master/slave architectures to eliminate replication lag and finally achieve a highly-available masterless cluster of MySQL servers. But what would migration look like? This talk will go over a high-level overview of XtraDB cluster, as well as operational concerns, possible migration [...]
Percona XtraDB Cluster is a new, high availability (HA) solution for MySQL. This webinar will present XtraDB Cluster and some of its powerful features such as: Synchronous replication Multi-master replication support Parallel replication Automatic node provisioning The Percona XtraDB Cluster internal architecture will be described. How XtraDB Cluster provides the new features listed above will [...]
Learn how to use Percona Monitoring Plugins to increase MySQL uptime and availability. The Percona Monitoring Plugins are high-quality components to add enterprise-grade MySQL monitoring and graphing capabilities to your existing in-house, on-premises monitoring solutions. The components are designed to integrate seamlessly with widely deployed solutions such as Nagios and Cacti, and are delivered in [...]
MySQL’s configuration file is often the focus of too much attention and too much tweaking of variables that make no difference — or worse, have the potential to negatively impact performance. The sample default configuration files that come with MySQL are unfortunately not very helpful or good, either. You’ll learn a practical approach to generate [...]
