I finally got off my lazy ass and wrote up abstracts for some of my upcoming talks. Here's the scoop on the MySQL Conference and the PHP Conference (both in April). I'll hit the OSCON ones in a few days (or weeks?). So far they haven't nagged me yet, but I'm sure they will. :-)

MySQL Conference -- San Jose, CA

At the 2003 MySQL Conference, I'll be giving a 2-hour talk on Thursday (April 10th) at 10am that's listed as "Using MySQL Replication in Large Scales" Here's the abstract I've submitted:

Replication provides a great mechanism for scaling MySQL beyond a single machine and even across vast distances. It can also be used to provide a "hot spare" server which can be used in the event that the primary server fails.
In this session, we'll look at how MySQL replication works and how to configure it. How is replication in MySQL 4.0 different than in the previous releases? nnn
We'll also cover common problems and solutions. Why does replication fail? How can you monitor and detect when replication fails? What's the best way to add one more new slaves to an existing replication setup? Which replication topology makes the most sense for a given application?
Finally, we'll discuss hardware and software solutions that can be combined with replication to provide load-balancing and high-availability.

Then on Saturday (April 12th) at 4pm, I'll be giving a 2-hour talk titled "Optimizing MySQL" Here's the abstract for that one.

As the load on a MySQL server increases, its performance may degrade if it has not been properly tuned to handle the load. A default installation of MySQL performs well for many applications, but it generally will not perform efficiently under stress.
In this presentation we'll discuss many of the tunable parameters in MySQL's configuration file (my.cnf), how to read MySQL's performance counters, and various optimizations which can be used to improve the performance and efficiency of MySQL servers--often with dramatic results. We'll also examine MySQL's various table types as well as hardware solutions to performance problems.

This conference is really gonna be cool. Check out the schedule to see for yourself. The only thing that bothers me is that there are other talks that I want to attend while I'm presenting. And even when I'm not, there are some tough choices. During many of the time slots, I want to attend at least two of them.

Good for the conference. Bad for me.

PHP Conference -- New York, NY

At PHPCon East 2003, I'll be giving a 75 minute talk titled "PHP & MySQL Performance Tuning" Here's that abstract.

They're they dynamic duo of LAMP. Fast, easy to use, wildly popular, and extensible. But what happens when your MySQL-backed PHP application starts to slow down? Where do you look? What tools will help identify bottlenecks? What techniques can help to avoid performance problems with PHP & MySQL?
In this session, we'll take a whirlwind tour of MySQL performance viewed thru the lens of PHP (and Apache). In doing so, we'll discuss and illustrate answers to all of those questions.

I'm looking forward to the conference and visiting NYC for the first time. That's right, I've never been there. I'll probably stay a few extra days to hang out with Derek and Kasia.

That reminds me. Flight reservations. Hotel reservations. Ugh. More stuff to do.

Oh, and I should probably alert the boss to the fact that I'll be out a bit in April. Better sooner than later.

Posted by jzawodn at March 17, 2003 12:04 AM

Reader Comments
# Dan Isaacs said:

Sounds like you need a Conference Tivo, so that you can time shift the presentations.

on March 17, 2003 06:23 AM
# kasia said:

Wish I could attend the actual conference.. I bet I could learn quite a bit.. you'll just have to fill me in on it later. Dinner's on me :)

(not literally, get your minds out of the gutter).

on March 17, 2003 07:17 AM
# anon said:

Quick question: Are you just as comfortable deploying a MySQL 4.x gamma version in a production environment as you are deploying a MySQL 3.23.x version in a production environment?

on March 17, 2003 01:47 PM
# anon said:

Guess my anon question was answered today. MySQL released 4.0.12 and called it production. Sweet.

on March 18, 2003 11:04 PM
# Zak Greant said:

Seven of the sessions being given by MySQL developers are being presented twice during the conference. I just have not yet put the extra info up on the schedule page yet. :) Should go up tomorrow though. :)

on March 25, 2003 02:55 AM
Disclaimer: The opinions expressed here are mine and mine alone. My current, past, or previous employers are not responsible for what I write here, the comments left by others, or the photos I may share. If you have questions, please contact me. Also, I am not a journalist or reporter. Don't "pitch" me.


Privacy: I do not share or publish the email addresses or IP addresses of anyone posting a comment here without consent. However, I do reserve the right to remove comments that are spammy, off-topic, or otherwise unsuitable based on my comment policy. In a few cases, I may leave spammy comments but remove any URLs they contain.