Personal schedule for Kathy Mazur Worden
subscribe to Kathy Mazur Worden's
A hands-on MySQL Cluster tutorial. We'll be using the latest MySQL Cluster version and we'll be installing and using it on your laptop. All hands on, so you really learn (it's not just a long talk).
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.
InnoDB has always had unique features to maximize performance and protect the integrity of your data. As hardware has evolved, InnoDB has been enhanced to take full advantage of modern multi-core, large memory platforms. Come learn about the special design features of InnoDB and the performance- and reliability-enhancing features recently introduced in the InnoDB Plugin.
The InnoDB storage engine has been modified to use memcached as a level 2 cache, the InnoDB buffer pool being the level 1. Important reduction of the disk load and performance boost has been observed. This opens a new way of scaling out MySQL.
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
Binlogs are essential for the MySQL Replication. MySQL Proxy can unleash the full power of binlogs: filtering, rewriting, splitting and merging.
This is a query optimization troubleshooting roadmap, presented by one of the MySQL optimizer developers. First, we'll give an overview of available query execution strategies and how they are (or aren't) shown in the EXPLAIN output. Second, we'll show how one can find out what the optimizer got wrong. Third, we'll discuss what means one can use to make the optimizer pick the right query plan.
Location: Ballroom E
Audience level: Novice
With the volume of data exploding and the need for business insight more critical then ever, a new breed of open source solutions delivers the simple-but-sophisticated analytics an enterprise needs to make fact-based decisions and compete more effectively.
There is a lot of buzz about Memcached and MySQL 5.1 and what it can do for your website. But how exactly do you go about setting it all up and write your code to make use of memcached? In this session, Adam Donnison will take you step by step through implementing memcached using real world examples in PHP from the MySQL.com website infrastructure.
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.
This hands-on session will show you how to change your MySQL server to enable SSL. You will see the steps involved to create an SSL certificate and enable users to connect securely. With SSL you can allow a user to connect unsecurely, connect unsecurely or securely, and you can also require a user to only connect securely.
Have you ever had Innodb database corrupted or have deleted data
accidentally and want it back ? This session will go through various
approaches you can use to get most of your data back using MySQL build
in features as well as third party open source tool.
mysqlnd, also known as MySQL native driver for PHP, is the new way of connecting from PHP to MySQL. It's a superior substitute to libmysql. mysqlnd is "native" to PHP, in means that it uses the infrastructure provided by PHP.
In this session I will show why mysqlnd is better than libmysql, in the PHP world - performance, better resources utilization, quicker bug-fixing cycle and others.