We did it! Hear how we went from a third party database system to a 60G MySQL Cluster hosting large external web services and intensive internal data applications flawlessly, in three months.
Harnessing the performance of MyISAM to simply scale-out highly write-intensive applications.
A lightning tour of the design, implementation, and use of MySQL External Language Stored Procedures framework, with examples using C, Java, XML-RPC, and more.
Is high availability on your agenda? Then this tutorial is a must. It's high-availability clustering on Linux with MySQL and DRBD in a nutshell.
A deep tour into the design of Maria, a new MVCC storage engine for MySQL from the original authors of MySQL that is designed to support transactions and automatic recovery.
The Large Synoptic Survey Telescope will produce a 20 petabyte database. To support this huge database, we are investigating a new generic scalable architecture with MySQL as a core component. Learn how it can be used by others to manage extremely large databases.
Batched Key Access is an advanced technique that is able to speed up the execution of queries with multitable joins to the factor of 5 and more.
Beyond the basics of today's ORM-based approaches, this discusses object-oriented querying in PHP, allowing developers to execute complex MySQL queries without needing to write a single line of SQL.
Your first MySQL Plugin or UDF extension is only 10 minutes away using this code generator. Focus on the actual functionality and let the generator take care of glue code and build infrastructure.
This session provides an introduction to application development with Mono and MySQL; the current state of Mono, including its support for databases through ADO.NET and LINQ; and explores how one open source ASP.NET application provides support for Mono and MySQL.
A high-level introduction to high-availability database clustering on Linux with MySQL Enterprise, Heartbeat, and DRBD.
MySQL can bring a production environment the basis needed to create the tools for managing large datasets. Searches can be implemented in an efficient manor and the database lends itself for collaboration between multisites. dbBlender is a project to integrate MySQL in Blender to solve many of the problems with large datasets and multisite projects.
This talk will present a basic introduction to the DBAccessLayer or DBSlayer, a lightweight web-friendly mechanism for connection pooling and proxying against MySQL.
In this session you will learn how to create embedded MySQL applications through a tour of the MySQL embedded library C API.
EXPLAIN is one of MySQL's most-used and least-understood features, and it's not documented fully. This session helps EXPLAIN make sense by showing how it really maps to a query execution plan.
MySQL has a wealth of extension points. Through plugins and UDFs you can extend the server to create custom environments.
Falcon is MySQL’s new transactional storage engine, currently in beta. Falcon, however, is not InnoDB and was not designed as a drop in replacement. The talk will discuss the architectural and philosophical differences between Falcon and InnoDB, and the problems that may be encountered when switching between InnoDB and Falcon.
This talk is intended for users contemplating using Falcon for new applications. Starkey and Harrison will discuss the differences between Falcon and other storage engines, the types of applications for which Falcon is a good fit, and ways to exploit Falcon's strengths at the design stage.
The more popular a web site gets, the more power it takes to run it. Brian Moon will share the journey of their web site from one server, to the cluster they run today, including how they have used MySQL.
This presentation covers new Full Text Search features in MySQL 5.1. We also show some common tasks and solutions with Full Text Search in MySQL as well as benchmark results.
MySQL Fellow, Monty Widenius, will talk about the architectural and design challenges currently facing the MySQL server developers, including a bit of history behind why the architecture of MySQL looks the way it does. He will then talk about the future architecture of the MySQL server and the plans he and others have to solve the design issues of the present day.
Geo distance / proximity search is a very common task in social networking (and other Web 2.0) applications. Example: "For the given user, find all users that live near by." Learn how to perform geo distance searches with MySQL.
The information schema is an underestimated feature: it has many applications but many people are unaware of them. This talk will introduce its components and demonstrate its applications.
Some data, such as user-created content, grows so large so fast it simply can't be stored in one database. This session will present HiveDB, an open source system for horizontally partitioning MySQL.
Ken Jacobs and Heikki Tuuri will describe the InnoDB architecture in depth, and discuss the new powerful performance-enhancing capabilities in InnoDB.
In the course of six months IMVU’s user base quadrupled in size. This session will focus on the techniques used to incrementally add scalability without making large changes to the application layer or disrupt ongoing feature development by the rest of the team.
Large MySQL deployments and Memcached go hand and hand. This tutorial details how to get started, the ins and outs of deploying Memcached as a key caching layer in your applications, and how to keep scaling.
Master-Master replication provides high availability and serviceability for the applications. Publishing web sites is a read-intensive operation, and the combination of Master-Slave replication with an application layer that intelligently splits database read and write operations allows for rapid scale out. Hear how Clickability solves issues for both environments.
Automatically detect your replication environments and display their configurations. Monitor the health and performance of those systems.
This presentation discusses how MySQL was leveraged to provide a large scale personalization technology platform solution for a site like ebay.com, which processes over 2 billion URL requests per day.
This session presents the new Online Backup capability. Existing backup options and details of how they compare with the new features will be presented.
MySQL Proxy is a tool to route, rewrite, handle, and block queries on the MySQL Protocol level. Load Balancing, Query Replay, Online Query Rewrites, and more with a grain of scripting.
MySQL Workbench is a highly customizable tool to help you make your everyday job more efficient. This tutorial will show how to write configurable, flexible, cross-platform plugins (C++, Python, LUA).
This talk describes new subquery optimizations in MySQL 6.0: what they are, how they are reflected in EXPLAIN output, and how they give orders-of-magnitude speedups for real-world queries.
In this presentation learn how MySQL, InnoDB, and Solaris helped Fotolog gain the top performance it desired as the world's largest photo blogging community through tuning and schema optimizations.
This talk will focus on the significant changes Hyperic’s developers made to Hyperic HQ's underlying database code in order to add support for a MySQL backend, and provide tips for other developers.
This talk will describe the MySQL Plugin API, its design principles, how it is used, and what plugin types are supported. It will cover both old and very new features, and discuss the future of the API.
This talk presents new open source tools that allow users to set up and run database scale-out benchmarks easily. Hodges illustrates with benchmark results from your favorite MySQL configurations.
Ask Bjoern Hansen will be covering the overall platform and architecture considerations involved in tuning applications from a holistic perspective. You'll be shown design scaleable architectures for dynamic, high-volume web sites. Topics covered include caching, scalable database design, replication, load-balancing, and architectural decisions derived from many years of experience.
Tips and tricks to speed up deployment of your replicated database server environment. Come learn all the goodies from the creators of the MySQL replication system!
Flickr implemented a real-time collection of referrers to Photos, streams, sets and collections. MySQL myISAM/INNODB, curl, Java are the only component used in the setup and it scales linearly. This talk is about building a model for capacity planning, scaling for triple the request rate, and scaling linearly for an intensive application.
Most existing work in scaling MySQL has focused on high read throughput
environments similar to web applications. Burton and Moore will present the backend architecture behind Spinn3r—their scalable web crawler.
In this session, Cole and Bergen will take a look at the hardware of recent past, today's hardware, and what hardware trends will become interesting during 2008 and beyond.
Services Oriented Architecture offers a number of benefits over the standard paradigm including parallel asynchronous request, decoupling your code from your data, and abstracting scalability.
Bill Karwin has answered questions from SQL users for over ten years. Some techniques have emerged as widely used, but flawed, making them brittle, buggy solutions and create security or scalability risks in your projects. In this tutorial, Karwin describes SQL techniques that should be called antipatterns, illustrates their weaknesses, and offers better solutions.
This presentation will consist of two major blocks: explaining tricky features of stored routine behavior and providing examples of advanced use, such as using dynamic SQL in stored routines.
PHP/MySQL applications are used more and more to perform enterprise-critical tasks. The audience will learn how to efficiently test PHP/MySQL applications with PHPUnit and its DbUnit extension.
What enhancements can you expect in the MySQL Server in the next few years? What new tools, services, and software is MySQL going to deliver this year and next to help you deploy and maintain MySQL applications? This session will let you in on all the plans MySQL has for the server, the Enterprise Monitor, the upcoming Load Balancer and Query Analyzer, management tools, and more.
Understanding and tuning the query cache can be daunting. It's not really complicated; it only seems that way. Baron will explain it in ways you'll understand and remember.
Lucene is a high performance, scalable, full-text search engine library that allows you to add search to any application. This presentation shows you how you can use Lucene within your environment.
Each database product has strengths and weaknesses. Having chosen MySQL as your database product, leverage the strengths of the product to maximize design and performance. Learn the things to avoid.
Preserving backward compatibility often prevents projects from benefitting from new MySQL features. Learn how to write elegant PHP code and SQL protected against the future as well as the past.
MySQL's Spatial Extensions and Ruby on Rails are a powerful combination for quickly and simply creating powerful spatially enabled applications.
One of the most powerful, yet underutilized MySQL features are User Defined Functions and Aggregates. Learn how to use them to dramatically improve the speed of your data warehouse processing.
This technical session highlights three benchmark tools that MySQL users and web developers can use to compare, test, and tune MySQL performance: SPECjAppServer2004, EAStress, and FABAN.
Designed to deliver pointed information on the flaws in the MySQL and PostgreSQL communities, what they can learn from each other and how they both can improve the open source database landscape.
During this tutorial, attendees will get a detailed introduction into the MySQL UDF interface and will learn to write and deploy their own UDFs for both Windows and Linux platforms.