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 [...]

Performances des bases de données

mysql-dba-swiss-armi-knife

Il sera question de la performance des bases de données. Quels sont les problèmes qui se posent généralement à ce propos? Quelles méthodes et quels outils peut-on mettre en oeuvre pour y faire face? Frédéric Descamps travaille pour Percona. Il est un consultant Open Source expérimenté aussi bien dans les projets d’infrastructure que dans le [...]

Breaking Down Query Latency With DTrace

breaking_down_mysql_latency_w_dtrace

There have been many high-level talks about how to use MySQL and DTrace together, but very little technical detail. This talk will show you how to instrument MySQL and InnoDB internals at a very deep level, using filesystem operation latency as a key example. Other topics will include tracing InnoDB’s thread concurrency code. Presented by [...]

Diagnosing MySQL Replication Failures

diagnosing_replication_failures

Replication is one of MySQL’s most widely-used features, and despite significant improvements over the years, it still fails. When this happens, it can be due to any number of factors, either internal or external to your MySQL database. No matter how it fails, it is always a problem that should be taken seriously. For those [...]

High Performance Near Real Time Analytics with Columnar Databases and MySQL

high_performance_near_real_time_analytics

Graham drives Infobright’s product-development vision and processes, including research and development and quality assurance. Graham’s specialities include business integration, computational linguistics, artificial intelligence and database design. Graham has worked in several roles, from product design and development and business process re-engineering to customer deployment and managing large scale projects and programs for Fortune 500 companies. [...]

How NoSQL Complements MySQL

how_mysql_and_nosql_coexist

A relational database used to be the answer for almost every project that required data storage. A few years ago, that changed. The increased visibility and features in NoSQL solutions have driven many companies to think about, test, and implement some form of NoSQL technology in their stacks. Even MySQL itself offers NoSQL interfaces to [...]

MySQL at Facebook, Current and Future

mysql_at_facebook_current_and_future

Harrison discusses how Facebook uses MySQL now, what challenges face the world’s largest MySQL user, how they’ve solved many of them, and what remains. Facebook’s MySQL deployment is notable not only for its size, but also for how openly Facebook shares the details about their deployment. Don’t miss this talk. Presented by Harrison Fisk (Facebook) [...]

MySQL High Availability With Pacemaker

mysql_high_availability_w_pacemaker

Have you been unhappy with the high-availability solutions for MySQL that are based on replication? At Percona, we have seen a number of problems with existing tools. Some people discussed using Heartbeat and Pacemaker instead, but the implementations were not suitable for the problems they tried to solve. Yves recently had an insight into a [...]

State of the MySQL Ecosystem

state_of_the_mysql_ecosystem

Peter Zaitsev, founder and CEO of Percona, speaks about the state of the MySQL ecosystem. ;Peter managed the High Performance Group within MySQL until 2006, when he founded Percona. Peter has a Master’s Degree in Computer Science and is an expert in database kernels, computer hardware, and application scaling. Presented by Peter Zaitsev at Percona [...]