Personal schedule for Kathy Mazur Worden
Download or
subscribe to Kathy Mazur Worden's
schedule.
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).
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.
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.
Read more.
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.
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.
Binlogs are essential for the MySQL Replication. MySQL Proxy can unleash the full power of binlogs: filtering, rewriting, splitting and merging.
Read more.
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.
Read more.
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.
Read more.
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.
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.
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.
Read more.
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.
Read more.
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.
Read more.