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

Measuring Scalability and Performance With TCP

Extracting performance and scalability metrics from tcp

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 by modeling the system’s behavior at greater load than you currently have? Now it is as easy as running tcpdump and processing the result with [...]

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

Running an E-Commerce Database In The Cloud

running_ecommerce_database_in_the_cloud

ideeli is one of the first companies to build a large-scale Web application on the Ruby on Rails platform, and pioneered many scaling techniques that are now common practice. The application handles an unusual and demanding load pattern, with large and sudden spikes in traffic. And it is hosted entirely in the AWS cloud hosting [...]

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

Why SQL Wins

why_sql_wins

A look at the state of current database architectures and trends through a historical perspective. The talk explores why NoSQL is not the answer to our current problems, and outlines why we should not throw away decades of relational database research and development. Presented by Paul Mikesell (Clustrix) • Sergei Tsarev (Clustrix) • Dmitri Mikhailov [...]

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

Improvements in MySQL 5.5 and 5.6

improvements_mysql_55_and_56

MySQL 5.5 and 5.6 include many great improvements to the database server, from the Performance Schema to multi-threaded replication. Peter goes beyond merely explaining what they are and what they do. He tells you what the new features are actually going to help you with, and help you understand when to use them and when [...]