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.
A panel discussion hosted by Robin Schumacher that presents topics to a variety of data warehousing experts about issues concerning their industry.
MySQL 5.0 and higher versions support stored routines that are based on the SQL:2003 standard. The introduction of stored programs in MySLQ 5 has been a significant milestone of the MySQL language. This tutorial will offer a brief overview of the stored program language and focus on how to improve and tune stored programs.
This session explains how the BLOB Streaming engine solves the problems involved in storing pictures, films, MP3 files, and other binary and text objects (BLOBs) in the database.
Take advantage of MySQL partitioning to allow your database applications to scale in both size and performance. A practical look at applying partitioning to OLTP database systems.
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.
Do you backup your data periodically? If not, this is your session. Learn about the possible options for backing up your data and how to get it back if you've lost something.
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.
Benchmarking and Profiling are extrememly important and a large array of tools exist for the job. Join Tom Hanlon for a tour of the current landscape. Demos of each tool wil be shown.
Join us for a presentation of the wonderful world of benchmarks and monitoring tools. Here you will learn what is available, how each tool works, and a demonstration using each tool against a running database from a veteran MySQL expert.
Learn how to use Connector/J's extension points to solve interesting problems and add functionality without changing the core code of the driver.
Novice and experienced DBAs alike will learn, share, and discuss best practices that will help them be successful.
This session explains how MySQL can take advantage of advanced technologies in the Solaris OS, thereby expanding the MySQL user base into new and larger enterprises.
Data Warehousing and Business Intelligence is gaining mission critical status in managing today's enterprise. It is critical that these datamarts are built on good foundation. This tutorial focuses on design principles and techniques to build a solid foundation for datamarts using MySQL.
Replicated databases are complex to manage, don't provide seamless availability, and require application changes to provide scaling benefits. We show how Continuent's new Tungsten architecture rides new technology trends to create data services with high availability and performance using commodity hardware and off-the-shelf MySQL databases. Tungsten: it's coming to open source!
Rick Falkvinge, founder of the Swedish Pirate Party, talks about the rise and success of pirates and why pirates are necessary in today's politics. He'll also outline the next steps in the pirates' strategy to change global copyright laws.
Have you been ripping your hair out trying to mix and mash multiple data sources, all of different formats, into something that actually makes sense? There's something to be said for getting all your ducks in a row, and in this session, we'll show you how to regain your sanity when it comes to a distributed, heterogeneous data environment.
This session will describe the benefits and approach to building OnLine Analytical Processing (OLAP) applications using MySQL Enterprise and Pentaho's Mondrian OLAP Project.
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.
For many companies, getting hacked is a matter of when, not if. This session shows how to find database vulnerabilities by Google hacking, providing methods minimizing the impact of being hacked.
This talk will present a basic introduction to the DBAccessLayer or DBSlayer, a lightweight web-friendly mechanism for connection pooling and proxying against MySQL.
MySQL 5.1 includes new functionality that allows you to create your own INFORMATION_SCHEMA tables with the new plugin interface. Learn how to implement these along with some real-world examples.
Noted Solaris and DTrace expert Ben Rockwood will show how to evaluate and introspect MySQL's behavior, and gain information that isn't normally attainable by developers and system administrators.
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.
This talk tests Amazon EC2's (Elastic Compute Cloud) suitability for MySQL scale-out applications, including benchmarks and war-stories from active deployments.
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.
In this discussion we'll focus on the architecture, approaches, and challenges of cheaply loading the daily and historical stock market data into MySQL necessary for financial data applications.
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.
Grazr is a new platform for aggregating, consolidating, and sharing information. We would like to share lessons we've learned with others considering using MySQL as the foundation for their product.
A crash course on what to do AFTER your web site has been hacked via SQL injection, XSS, CSRF, etc. How to track down the problem and fix it. Talk will focus on PHP/MySQL.
This session will cover issues including High Availability database architecture using
MySQL/DRDB/Heartbeat, modular application design, scale planning, and day-to-day operations of an HA MySQL implementation.
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.
Learn how to obtain expert insight and learn best practices to help you achieve operational business intelligence throughout your organization from data warehousing to business intelligence functionality and performance.
At some point in every software project involving a database it becomes necessary for the developers who created (or inherited) the project to step back and take a look at their database. Mike Hillyer will guide the audience through the principles of database normalization and review some common normalization scenarios encountered by many application developers.
In this presentation, Mike Frost, product manager for DataDirect Technologies, will introduce a strategy for separating application logic from MySQL database access logic. The presentation will describe the benefits of a loosely coupled approach for all application and data access logic.
This session takes a tour of the internals of the PBXT storage engine, revealing some unique solutions to the problems of transactional isolation, consistency, and durability.
You may have heard Innodb has limited scalability with multiple CPUs and some of these were fixed in recent MySQL 5.0 versions. In this presentations we will look into which problems are fixed.
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.
Learn about a horizontal scalable architecture for accessing exponentially growing datasets, and performance results obtained on several filesystems, MySQL storage engines, and partitioning.
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.
NIFTY Corporation will discuss their experiences with MySQL and how
they changed the configuration in TypePad to meet the Japanese
market's requirement, such as more availability, more cell phone
support, and so on.
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.
As organizations struggle to cope with increasing amounts of data, MySQL users are looking for ways to scale their data warehouse system. Come learn about new engine technology with proven scalability to 30TB, designed to support complex, ad hoc queries.
Online backup and restore of mission critical MySQL servers has never been easy. Sure it’s not so bad if you have a small data set and you can afford to take your server offline for a backup. Seriously, how many MySQL deployments fit those requirements?
This session helps you make sense of the myriad of MySQL backup options out there.
Learn how Paggo utilized a Replicated Cluster to guarantee the necessary High Availability and contingency for financial transactions.
A wealth of tips and tricks to solve real world SQL problems with SQL wizardy and MySQL magic. All you need is your commandline, and a lot of curiosity.
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 that can enhance existing MySQL server features and create new ones. This tutorial explains how to create new syntax, filter queries, and how to deal with multiple servers.
In this tutorial, the developers behind MySQL Replication start by explaining the architecture and major replication concepts and then walk you through a configuration to show what you can do with it.
MySQL Sandbox is a tool to install a side server or a replication system in "seconds," in complete isolation, without need to remember complex sequence of commands.
More information coming soon
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).
A hands-on discussion of the MySQL Workbench tool showing the benefits for Ruby/Python/PHP, as well as .NET/Java developers. Efficient database schema design and maintenance has never been so easy.
LINQ is perhaps the most powerful new feature in the .NET Framework, allowing you to query in memory structures like tables in a database. Learn how to use the ADO.NET Entity Framework to construct LINQ queries or Entity SQL queries to interact with data in your MySQL database.
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 session we discuss the new backup feature for MySQL 6.0, the new replication features coming up, and new contributions from the community in the replication arena. Don't miss it!
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.
MySQL has created many resources online for opening up contributions from the community. From MySQL Forge, to the DevZone, to code reviews in public, MySQL is primed for more external contributions!
Learn about all the tricks required to make MySQL Cluster high performance. This includes using real-time scheduling, batching in all its form, cluster interconnects, and locking threads to CPUs.
This session offers an introduction to the concept of utilizing LVM filesystem snapshots to perform consistent backups of MySQL databases without having to interrupt the normal server operations. While this technique isn't a "real" hot backup, it still provides a viable and free alternative to other backup methods like SQL dumps.
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.
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.
ScaleDB is a transactional storage engine for MySQL. It is based on
innovative indexing technology that provides high performance for large, disk based data sets. It provides for MySQL the functionality of Materialized Views and as it operates over the source data, it obviates the need to maintain a replica and synchronize between the source data and the replica.
Learn the places in MySQL that need to be secured and how to secure them for most commercial security audits.
The PCI express-based, MySQL optimized interconnect reduces latency and overhead and incorporates two levels of fault tolerance. The performance improvements allow customers to reduce their hardware investments and cost of operation and reduce time consuming performance tuning for developers. All fully transparent to the application.
Sphinx is an open source full-text search engine designed for indexing databases and integrated especially well with MySQL. We'll talk about its features, capabilities, and real-world applications.
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.
Why would you join a table to itself? It's an elegant solution to many problems beyond the text book example of an employee's table! And if you're brave, you might even solve a Sudoku with one SELECT.
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.
Scientists are trying to understand dark matter, discover distant galaxies, hunt for the Higgs boson, detect asteroids, and take movies of molecules. Their science is fascinating but their analysis requirements may seem like science fiction. Few have experienced the reality of petascale analytics so far, but everybody, including you, will face it tomorrow. Are we ready?
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.
As MySQL powers the businesses, a good backup will go a long way to ensure you recover your data without impacting your business. In this session we review the top considerations for backing up MySQL.
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.
UC Berkeley's email system serves 70,000 users. Based on free software, a 22 node MySQL cluster ties the components together. See integration examples with Exim and the SQLAlchemy ORM for Python.
MySQL's Spatial Extensions and Ruby on Rails are a powerful combination for quickly and simply creating powerful spatially enabled applications.
This presentation and demonstration will highlight advances that are bringing the power of interactive Ajax web technology and powerful metadata to bring secure self-service business intelligence to business-users and OEM applications. Topics covered will include drag & drop report and dashboard design, JSR-168 portal support, and the new ad hoc query facility.
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.