Personal schedule for John Schulz
Download or
subscribe to John Schulz's
schedule.
Setting realistic expectations and choosing appropriate architectures rely on having solid benchmarks. This tutorial will show you how to use the available tools.
In addition once you have built your application monitoring is key.
Join us while we give you a three hour tour of the tools available.
Tools such as mysqlslap, supersmack, jmeter, xenoss, enterprise monitor, nagios and more.
Read more.
The MySQL plugin API is a generic extension point for the MySQL (>=5.1) server. It allows users to add new features like storage engines and information schema tables, and to extend existing features such as FULLTEXT search.
In this tutorial, you will learn how to write your own plugins from one of the designers of the plugin API. Basic C/C++ programming skills are recommended but not required.
Read more.
You don't have to read source code -- understanding how MySQL works can be achieved through the system data. Learn a wide range of topics in this 3-hour tutorial, and leave armed with tons of knowledge about how MySQL 5.0, 5.1 and 6.0 work. You will take home a healthy understanding of performance tuning, storage engines, replication and many tips and tricks to help you be a better DBA.
Read more.
The MySQL Replication developers walk through some of the new Replication features of MySQL 5.1 and MySQL 6.0, such as row-based replication, heart-beating and semi-synchronous replication.
Read more.
This session describes the joint Sun/MySQL performance & scalability project. We will look at the key performance issues, what has been achieved so far and share initial results. We will indicate some of what's on the roadmap for the immediate future. Wherever possible, best practices and recommendations for achieving optimal performance will be offered.
Read more.
Working in an Agile environment poses unique challenges for DBAs used to more traditional environments. This session, co-presented by Laine Campbell of Palomino DB, Inc. and Sheeri K. Cabral of The Pythian Group, will explain how to function more effectively as an Agile DBA, giving you tips and tricks to better survive in an Agile development environment.
Read more.
The Falcon Storage Engine is designed to take advantage of multi-core computers. It is reaching GA at a time when computer performance is being increased mostly by adding more cores. Falcon's unique characteristics will be explained and contrasted with InnoDB and other MySQL storage engines.
Read more.
Ever wondered what would happen if we could rethink a decade worth of design changes? Drizzle is a fork of the MySQL server targeted at web development and cloud computing. We are looking at how to create database for modern multi-core, large memory databases that fit inside of an overall application framework.
Read more.
A tour of External Language Stored Procedures for MySQL and how they overcome the challenges involved when using MySQL's UDFs and SQL stored procedures.
Read more.
Advanced uses of MySQL Proxy require a deeper understanding of queries running through Proxy than
tokenization can offer. Using a parser and supplementary infrastructure makes accurate query rewriting
possible to do sharding, better error messages or accomodating legacy applications.
We will look at how to implement these features and demonstrates how it can be used in other
applications, too.
Read more.
Experienced SQL developers know how to solve a class of quite different problems efficiently with the help of an auxiliary sequence table: We'll learn from them with easy to understand hands-on examples -- and meet the SeqEngine, a pluggable storage engine for MySQL 5.1 that helps us to apply the expert's tricks even more efficiently.
Read more.
Binlogs are essential for the MySQL Replication. MySQL Proxy can unleash the full power of binlogs: filtering, rewriting, splitting and merging.
Read more.
In blazing speed we will cover the most important features on MYSQL Cluster 7.0: online add node, multi-threading of the data node and a bunch of other features that pushes the limits of MySQL Cluster even further.
A demo will be made showing how to add a node.
Read more.
The combination of MySQL and Hadoop opens up new doors for innovation that weren't possible before. Hadoop allows for Massive Parallel Processing but falls short of offering the speed, features and advantages of a relational database such as MySQL. For data intensive startups with massive data processing requirements, a combination of Hadoop and MySQL may be the best solution.
Read more.
This presentation provides a look into the future of the entire MySQL product line - the MySQL Server, MySQL Enterprise, and Management Tools with an update also being given on community and partner storage engines, high-availability solutions, data warehousing offerings, and much more.
Read more.
Do you have a hard time getting an overview of where replication is moving? Are you wondering what is going on in the community and inside the replication team? If these questions are on your mind, then you have to visit this panel discussion with some of the foremost developers and consultants on replication technology and hear what they have to say about the future of replication.
Read more.
Q4M (http://q4m.31tools.com) is a high-performance message queue that works as a pluggable storage engine of MySQL, used by Mixi (Japan's largest SNS provider) and Cybozu Labs (for running Pathtraq, one of the nation's largest web access stats service), etc. The presentation will cover from the design principles of Q4M, to how it is used to modularize, stabilize, and extend the web services.
Read more.
Beginners to MySQL often start monitoring their systems manually but quickly realize the need to automate. When the new MySQL DBA is also new to shell scripting, the task of automating becomes even more daunting. This presentation introduces the Bash shell, illustrates how it can communicate with MySQL and with the outside world, and gives practical examples of these scripts.
Read more.
The talk will describe the goals and design of Maria, the new transactional storage engine for MySQL. It will cover the goals of Maria Storage Engine, overall design, on-disk data formats, Multi-Version Concurrency Control in Maria, BLOB handling, row locking and lock escalation, roadmap (current and future).
Read more.
The goal of this session is to introduce users to new standard conforming and engine-neutral implementation of foreign keys, which is being developed for 6.1 version of server. The session will describe capabilities of this new implementation (including limitations for different engines), give a glance at its performance and provide comparison with current InnoDB-specific implementation.
Read more.
Insights from the developers behind MySQL Partitioning.
How is partitioning implemented, how does it work in the server and with the storage engines? What solutions can it be a part of and what problems does it introduce?
We present a new partitioning type: Column list, range partitioning on any column type. And give the status of the current development.
Read more.
Perl stored procedures provide greater flexibility than the standard SQL stored procedures. For many users, they can provide performance and connectivity which is not available from the built in SQL implementation, where many users have to resort to writing UDFs.
Read more.
We are working on improving the performance and reliability of MySQL and InnoDB. We will describe each of the patches we have released, and how they are useful.
Read more.
Looking at sharding your environment? This is the real-world example of sharding our databases using Spockproxy, a sharding-only version of the MySQL Proxy. Layout, sharding, and loading data; problems and limitations of working within shards; and how to get around these problems. The problems and solution we've come across are largely applicable to every kind of sharded environment.
Read more.
Writing a custom engine can seem intimidating and creating a generic engine can be. This presentation will show how to refine the requirements to a manageable subset. We will discuss the problem addressed, the approach chosen, storage engine design and API required to implement the design. We will talk about lessons learned implementing the storage engine to improve flexibility and performance.
Read more.
ZFS offers many leading-edge features, including automatic protection against silent data corruption, immense capacity, and vastly simplified administration. But how well does it perform with MySQL? This session explores MySQL performance with ZFS compared to
alternative file system implementations. The performance implications of ZFS compression and other features are also examined.
Read more.
This presentation describes InnoDB on-disk file formats, the new file format management, as well as InnoDB source code structure.
Read more.
Dormando's Proxy for MySQL (DPM for short) is a community lead, BSD licensed, alternative to the official MySQL Proxy. It is not a fork, and has its own ideals. Learn what it can do, and find out how you can help!
Read more.
Every database conference has to have some sort of loon standing up telling everyone that the main thing everyone has that ties them all together is total crap. This time, I'd like that loon to be me! So bring rotten fruits to throw.
Read more.
How does the database server use memory? Where? What are the scaling implications of how we allocate, use and free memory in the database server? Can we scale to many CPU cores effectively? Do alternate malloc libraries really help? Why? What does MySQL do? What does Drizzle do (and what have we changed?). These questions (and more) will be answered in this session.
Read more.
The memcached Functions for MySQL are User Defined Functions (UDFs) that give you the power to interact with both MySQL and memcached in one place, giving you the ability to have read-through or write-through caching using a number of tricks, all without having to have caching logic in the application. Learn from Patrick Galbraith how to take advantage of these great new UDFs!
Read more.
You can run MySQL on a standard server, but there can be benefits to running MySQL within a virtualized environment. You can take advantage of the isolation it provides, or the performance gains possible by running multiple MySQL instances on one large server. This session will show you the benefits and potential issues of running MySQL in a virtualized environment.
Read more.
This session demonstrates how partitioning will often reduce overall performance but also demonstrates the operational benefits, such as much faster table optimization.
Read more.
In this session we present OpenLDAP/back-ndb which gives an LDAP interface to MySQL Cluster. The LDAP interface on Cluster offers some nice ways of scaling out, as well fantastic performance, and we discuss how this is done. Moreover, it is possible to simultaneously access the LDAP data using e.g SQL!
A short demo will be given.
Read more.
The Spider Storage Engine creates table-links from local databases to remote databases. To supports XA transaction and table partitioning itself, the Spider also created for the database shardings.
Spider Storage Engine is being offered to the public by GPL.
http://spiderformysql.com
Read more.