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.
There are many challenges when building a reliable, flexible architecture that can manage unpredictable behaviors of today's internet business. This presentation will review some of the lessons learned from building one of the world's largest distributed systems; Amazon.com.
Social applications integrate information about many different facets of people’s lives. Join us as Jeff Rothschild from Facebook looks at the power of the social graph, how it can increase the utility and adoption of applications, and its implications on storage architectures.
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.
It's very important to have a firm grasp of ActiveRecord if one plans on using it with Rails or Ruby; this talk will cover ActiveRecord from the top level abstractions to the nitty-gritty with SQL.
A panel discussion hosted by Robin Schumacher that presents topics to a variety of data warehousing experts about issues concerning their industry.
In this session we'll go beyond the basics to demonstrate the creation of data-driven applications using .NET and MySQL. We'll include discussion of ASP.NET Ajax with MySQL and LINQ in .NET 3.x.
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.
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.
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.
Have a burning question about Pythian or MySQL? Whether you want to know what it's like to work at Pythian, what it's like to be a client of Pythian, or just have a MySQL question you have not gotten answered yet, The Pythian Group's Database Mastros are on hand to answer your questions. Or, just listen and sip some free booze. Yes, we said it. Free Booze.
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.
*Release your inner geek at this festive Web 2.0 code-athon!*
* For newbies, get a hands-on look at the latest Ajax and Web 2.0 technologies.
* For rock stars, compete for the title of Fastest Web 2.0 Developer in the West!
This BoF mixes hands on tutorials for Ajax and Web 2.0 newbies with the action and excitement of a white knuckle coding competition.
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.
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.
Forum for discussing the evolution of Online Backup.
This session will walk through everything from using BitKeeper to access the source trees, to the CMake build system, and using the free command line and GUI-based tools to build and debug MySQL.
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.
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.
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.
Visit the exhibitors, mingle with other attendees, and enjoy great refreshments and drinks at the evening reception.
MySQL provides you with a choice of storage engines to power your data warehouse applications. Choosing the right storage engine can make all the difference. If your are experiencing performance shortfalls, then you need to attend this BOF session. Storage engines will be compared, and a revolutionary new storage engine technology, Fractal Trees, will be introduced.
A high-level introduction to high-availability database clustering on Linux with MySQL Enterprise, Heartbeat, and DRBD.
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.
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.
Deadlocks, wait timeouts, and other transaction issues—how to develop transactional applications with InnoDB and what to expect from Falcon.
A popular and lighthearted session in quiz format. Fun and educational, a broad range of "what not to do" is explored, taking examples from the scary real world.
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.
What’s the worst disaster you expect to happen? What can you do to better prepare for the disaster? Join us in this heart-racing, real-life inspired presentation for answers to these questions and more.
Data-driven businesses that use data analysis to direct their decisions, are collecting data at ever-increasing rates. At the heart of these businesses is the database used to store and analyze that data. Tokutek's storage engine significantly accelerates both insertions and range queries. Our storage engine achieves high performance through the use of cache-oblivious algorithmics.
Drupal is an open source social publishing software that empowers individuals, teams, and communities to easily publish, manage and organize web content. Tens of thousands of organizations use Drupal to power community web portals, corporate web sites, social networking sites, personal web sites or blogs, and much more. MySQL skills are in high demand to help manage these growing sites.
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.
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.
This talk tests Amazon EC2's (Elastic Compute Cloud) suitability for MySQL scale-out applications, including benchmarks and war-stories from active deployments.
Visit the exhibitors, mingle with other attendees, and enjoy great refreshments and drinks at the evening reception.
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.
Take the opportunity to network one last time at this closing event. Say thank you and exchange contact information until next year.
The history of computing is full of algorithms such as graphics processing that are fine-tuned in general purpose CPUs over decades. Only when they are finally ported to dedicated hardware are tremendous improvements in speed, cost, and power realized. Raj Cherabuddi explains how a new SQL chip will revolutionize today’s database query processing.
General discussion on the Federated Storage Engine. Where development stands, what are the plans for the engine, how can the engine be improved. Also, anyone who wants to know how to use the new pluggable FederatedX storage engine.
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.
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.
A discussion of the use of and internals of the NDB API (through C++ and Java) and execution in MySQL Cluster.
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.
Discuss Sphinx engine and full text search questions in general, share your usage experience, submit your ideas for new features, and have a nice full text evening with Sphinx project lead as your host.
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.
Mike Callaghan will describe enhancements to InnoDB that improve its scalability on servers with many disks and many CPU cores, results from benchmarks, and results from production systems.
MySQL can be made Highly Available in countless ways, which can make picking the right one tough. We'll compare and contrast many of the popular tools, including Replication, DRBD, Cluster, and more.
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.
Meet and greet fellow InnoDB users along with Innobase's Heikki Tuuri and Ken Jacobs for a lively and wide-ranging discussion about technology and directions for InnoDB, the most popular, proven and best-performing transactional storage engine for MySQL.
If you're new to MySQL, new to transactional applications, or wondering about how InnoDB compares to other emerging storage engines, this session is for you. Your business can depend on reliable, fast, and proven transactional capabilities.
Ken Jacobs and Heikki Tuuri will describe the InnoDB architecture in depth, and discuss the new powerful performance-enhancing capabilities in InnoDB.
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.
How to extend your LAMP stack for rapid web application development by using an integrated environment of various frameworks (Zend for PHP, YUI for Ajax), Smarty for templating, and other libraries.
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.
Sun Microsystems and JasperSoft invite all MySQL OEM customers and prospects to join us for a cocktail reception, Wednesday, April 16, 2008, from 5:30PM-7:30PM, in the Bayshore Ballroom at the Hyatt Regency Santa Clara.
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.
A meetup of MySQL meetup organisers and participants
Not heard of Memcached? This means you haven't scaled your application yet, or that you are having problems. Lets consider some solutions.
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.
General discussion of Memcached Functions for MySQL, new user-defined functions (UDFs) utilizing Brian Aker's libmemcached client library that allow you to interact with a memcached server through MySQL
Memcached is awesome, come hack on it!
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.
Almost from it's inception PHP has enjoyed a symbiotic relationship with MySQL. Even though both projects continue grown in new and exciting directions, 70% of all PHP users still use MySQL for their data storage. Come talk about where the relationship has been, where it stands now and where things are going. Come celebrate the relationship of these two friends.
In this BoF Session, Zmanda will review best practices for backup and recovery of MySQL databases.
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.
New addition to the MySQL Conference & Expo for 2008, the MySQL open source career fair offers sponsors the opportunity to promote job openings to the hundreds of MySQL developer DBAs and system administrators attending the conference. The one-day fair will take place on the last day of the conference, Thursday, April 17, from 10:00 AM – 3:00 PM.
MySQL Cluster is a fault-tolerant, high performance, in memory
clustered storage engine. Additionally, it provides a direct API that
works underneath the SQL layer that can be used for clients with truly
high performance needs.
In this BoF we will talk the design and status of a new backend for OpenLDAP, back-ndb, developed by Symas Corp that offers realtime LDAP performance, scalability and high availability.
A hands-on MySQL Cluster 5.1 tutorial where you'll install and setup MySQL Cluster (on your laptop) and learn about what it is, what it can do, and basic administration skills.
Learn how Paggo utilized a Replicated Cluster to guarantee the necessary High Availability and contingency for financial transactions.
The MySQL Enterprise Monitor provides a consolidated view into the health, performance and availability of all your MySQL servers. Join the MySQL Enterprise Tools Engineering team for an early look at the new Query Analyzer feature and help shape how this new feature can be delivered to best fit your needs.
Phorum is the message board software used by MySQL. One reason they chose Phorum was because of its speed. We have to use some tricks and fancy SQL to make this happen. Learn how.
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 will be an Engineering led discussion of the new MySQL Enterprise Load Balancing, Query Analysis and Connection Manager functionality. These new tools are designed to alleviate common pain points felt by those using replication to scale the performance of high-traffic, online applications and web sites.
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 will host a partner meeting, in conjunction with our Conference, on Monday April 14, 2008 from 5:30pm to 7:30pm. As a current or prospective partner, this is a unique opportunity to learn about company goals, future directions, product roadmaps, partnership opportunities.
In this session we'll put features that do the same thing up against each other and see which performs better. We find the optimal way to do smaller things. Everything is backed up by benchmarks and discussion.
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 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.
The MySQL Conference Quiz Show pits teams of contestants against each other in a battle of geek wit, ingenuity, MySQL knowledge, and speed.
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
For everybody not attending the tutorial on Monday this is a chance to ask questions about the MySQL Workbench scripting capabilities.
A discussion of the MySQL Workbench road-map in general and the MySQL Workbench 5.1 release in particular.
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).
The power of MySQL Workbench will be shown by using it in several real world scenarios. These will cover migration, automation of schema transformation processes, and schema reporting.
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!
Make plans to join us at a new addition to the MySQL Conference & Expo for 2008: The Open Source Career Fair. The Fair offers sponsors the opportunity to promote job openings to the hundreds of MySQL developer DBAs, and system administrators attending the conference.
Free software and open communities are the lifeblood of network innovation. Sun Microsystems CEO Jonathan Schwartz will highlight the rising open source tide and how Sun's recently announced acquisition of MySQL furthers free software as a platform for the web economy.
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 panel will discuss the impact of Open Source Software on Software as a Service (SaaS)companies and their ability to effectively deliver on Service Level Agreements to their clients.
Join us for this 75 minute Seminar on how MySQL Enterprise can help you strengthen your position as a trusted adviser and drive revenue.
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!
PBXT a transactional storage engine from the open source company PrimeBase Technologies will be one of the new engines available in MySQL 5.1. Also available will be the Blob Streaming Storage Engine.
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.
In this BoF session, join Kickfire and some of our MySQL geek consultant friends to share your input on what the industry should address to get the best query performance in MySQL. The query fairy will buy the beer. There is magic after all.
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.
Experience from international customer base and multilingual projects: character set conversion issues, performance impact, limitations, security concerns, and more.
A walk through modern web application database development tips and tricks: MySQL-specific features, web-oriented schemas and queries, and storage engine behavior.
Protecting corporate data through effective backup and recovery is the most critical task for a database administrator. As MySQL moves into mission-critical transaction environments, the ability to perform online backups without causing any application downtime is a must. Similarly, the ability for MySQL DBAs to go back in time and restore data just before an error is equally important.
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.
Replication is one of the most important features in MySQL. Having the ability to replicate data across data centers is invaluable. Learn how to set up replication, monitoring, and problem-solving.
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.
This lively panel discussion keynote will address the challenges large, modern web properties face in scaling MySQL. Panelists from Facebook, YouTube, and Flickr pair up with MySQL engineers in discussing the current and future problem domain and possible solutions.
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.
With the help of MySQL 5, Ticketmaster event databases are meeting the growing global live entertainment demand. Learn how they are implementing databases for the Beijing Olympics, and the new features and limitations they encountered upgrading from MySQL 4 to 5.
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.
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.
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.
Learn about the revolutionary hardware and software behind the first high-performance database appliance for MySQL. Find out how Kickfire packs the power of 10s of CPUs into a single SQL chip and delivers record-breaking query performance for reporting and analysis in the industry’s smallest form factor appliance. Raj Cherabuddi will explain all and share the astounding benchmark data.
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.
In his annual State of MySQL keynote, Marten discusses the current and future role of MySQL in the modern online world. The presentation also covers the acquisition by Sun of MySQL, the role open source is playing for users and customers all over the planet, and what the visions for the future are.
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.
Put your MySQL problems before Arjen, PeterZ and a gang of other active MySQL Community members present at the MySQL Conference. See if they can work it out!
Have a drink, mingle with fellow conference participants, and enter our raffle to win great prizes, including a a Sony PS3! Sponsored by Sun Microsystems.
Traditionally running complex queries on large database workloads requires expensive high-performance hardware. In this talk, Chamdani will present the key system techniques that remove the I/O bottlenecks to deliver order of magnitude(s) performance improvements on large query intensive applications.
This talk will cover the basics of using MySQL with Ruby, providing an overview of the three most popular and pragmatic options: the mysql gem, DBI/DataObjects, and ActiveRecord.
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.
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.
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?
TheTicketDepartment.com is an Online Ticket Brokerage that ties into approximately 800 brokers. Learn how they have tied MySQL 5.1 DB into a MySQL 3.23 DB App using replication and triggers.
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.
Following the planned sessions during the day, it's time for MySQL participants to take the floor. BoFs are informal conversations that you and other participants plan. Check the BoF board in the Grand Ballroom Foyer for schedule information.
MySQl has become the database of choice for web applications. In this session, SugarCRM Co-Founder and Chief Technology Office Jacob Taylor will discuss best practices for tuning MySQL to maximize performance and availability. Topics will technical tips and tricks he has learned for performing maintenance and updates to MySQL while minimizing performance degradation.
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.
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 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.
Until this point, SaaS applications have been created in separate silos. However, now there are non-proprietary platform choices as part of the Web 2.0 architecture and other emerging technologies that enable mash-ups and composite applications. Learn how web operations have expanded to include application and business services that affect application development and integration.
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.
Following the planned sessions during the day, it's time for MySQL participants to take the floor. BoFs are informal conversations that you and other participants plan. Check the BoF board in the Grand Ballroom Foyer for schedule information.
Have you been yearning to deal with your menu structure or social network using plain SQL queries, joining on to your other data? What if... that can actually be done?
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.
Much of the data in a database is about people. Identity 2.0 technologies will lower the friction for people to provide and easily move data about themselves online. This fast paced keynote will offer a background on Identity 2.0, discuss current roadblocks and future opportunities, and explore the potential impacts these will have on databases.
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.
Zmanda Recovery Manager (ZRM) for MySQL is a comprehensive, certified, enterprise backup and recovery solution specifically designed for MySQL databases. With ZRM, MySQL database administrators (DBAs) can manage mission-critical, high-volume transaction processing environments with confidence.
Sorry, this tutorial has been canceled.