Preventing Downtime in Production MySQL Servers

Preventing Downtime in Production MySQL Servers

Everyone wants to prevent database downtime by being proactive. But how effective are the common measures such as inspecting logs and analyzing SQL? To be truly proactive, one must prevent problems, which requires studying and understanding the reasons for downtime. We have analyzed a selection of emergency issues that we have resolved to better understand [...]

Verifying Replication Integrity with Percona Toolkit

verifying-mysql-replication-integrity

Percona Toolkit 2.0 has a newly upgraded tool for verifying replication integrity, pt-table-checksum. This unique tool verifies that your replicas have exactly the same logical dataset as their masters. No other tool offers this capability, yet it’s vitally important to check that replication isn’t causing data drift, and correct any problems that might be uncovered. [...]

Measuring Scalability and Performance with TCP

measuring-scalability-and-performance-with-tcp-webinar

What if you had all the data you needed to measure system performance and scalability at any tier, discover performance and stability problems before they happen, and plan for capacity and performance by modeling the system’s behavior at greater load than you currently have? Now it is as easy as running tcpdump and processing the [...]

Using Percona Toolkit for Smooth MySQL Operations Every Day

using-percona-toolkit-for-smooth

What if you had all the data you needed to measure system performance and scalability at any tier, discover performance and stability problems before they happen, and plan for capacity and performance by modeling the system’s behavior at greater load than you currently have? Now it is as easy as running tcpdump and processing the [...]

Detecting MySQL IO problems on Linux at different abstraction layers

detecting-mysql-io-problems

MySQL running in the LAMP stack is a complex system, luckily there is a lot of good instrumentation for investigation into the three fundamental performance problems: high CPU load, disk bandwidth problems and internal locks contention. This webinar will discuss how to detect MySQL IO problems on Linux on different abstraction layers: Using high level [...]

Creating Backups with Percona XtraBackup

Creating-Backups-with-Percona-XtraBackup

This webinar discusses how to make the process of creating consistent physical backups much easier and faster with Percona XtraBackup.

MySQL Data Recovery Webinar

MySQL-Data-Recovery-Webinar

This webinar shows how to use the Percona InnoDB Data Recovery Toolkit to recover lost or corrupted data from InnoDB tables. Slides are here. More MySQL webinars.

Understanding HandlerSocket – A NoSQL PlugIn For MySQL

understanding-handler-socket-nosql-mysql

Ryan Lowe’s webinar on March 29, 2011. The much-anticipated ability to access MySQL data via a NoSQL solution has been realized. Using HandlerSocket, significant performance gains can be realized for certain workloads. In this webinar, we’ll answer the following questions: What is HandlerSocket? Where does HandlerSocket fit in my application stack? Why would I want [...]

Choosing a MySQL High Availability Solution

choosing-high-availability-solution

Yves Trudeau’s MySQL webinar about MySQL high availability solutions. (More MySQL webinars). Original file is uploaded to blip.tv.

Managing Big Data with Percona Server, XtraBackup, and Tungsten

percona-server-xtrabackup-continuent-tungsten-big-data

Vadim Tkachenko’s MySQL webinar with Robert Hodges about managing big datasets with Percona Server, XtraBackup, and Tungsten. (More MySQL webinars). Original file is uploaded to blip.tv.