Here’s what Pythian is cooking up for MySQL Conference this year.
Monday, April 12
8:30am: Get out of bed lazy bones and head to Ballroom B
… because you’re going to want to attend Sheeri K. Cabral‘s tutorial in two parts:
Unlock all the information the MySQL server can give you! MySQL has many status variables that show how well your environment utilizes its resources. There are many system variables that can be set and changed to tune the server.
Which continues on at 1:30 with Part Deux
Lots more detail on this incredible tutorial at that link above.
And then meet at the lobby of the Hyatt at 6:30pm
… because next up is the MySQLConf Community Dinner. We’ll be walking over to Pedro’s as a group, but if you’d rather meet us there go right ahead, our reservations are for 7pm.
VERY IMPORTANT Please be sure to post a comment to that link if you plan to attend so we can get the head count reasonably close. All the cool kids are going, be sure to come, share, and even set your sense and vision of where MySQL is heading in a fun, social atmosphere.
Tuesday, April 13
At 4:25pm, head on over to Ballroom A
to catch Pythian’s very own Robert Hamel, the leader of our Advanced Consulting Group, as he presents:
Learn how to find your database problems more quickly without special software. Automatically tracking all database changes and keeping a historical record enables you to figure out problems faster, reducing downtime for critical production systems. Existing monitoring systems are very good at detecting actual errors but not very good at telling you what triggered your performance issue.
Wednesday, April 14
Start the day off right at 10:00 am
Our very own Sheeri Cabral will be delivering her community keynote:
Sheeri Cabral knows the MySQL Community. Working for the Pythian Group, she has tapped her co-workers’ knowledge about the Oracle Community. In this brief community keynote, Sheeri maps out the differences between the communities and what we can expect next now that MySQL is “under new management”.
At 4:25pm, head back over to Ballroom A
And attend Sheeri’s
MySQL data types do not support the SQL standard WITH TIME ZONE attribute. How do you store times in MySQL to efficiently show your customers times in their own time zone?
And, to end a great day, at 5:15 Focus on Security in Ballroom E
As Pythian’s Danil Zburivsky presents:
… As a quick update Singer will be going to Australia and must prepare so his talk and content will be presented by Danil Zburivsky instead.
MySQL security usually means strong passwords, proper user@host grants and SSL connectivity. However MySQL does not operate in a void. This talk will focus on how MySQL security can be compromised through the hardware, operating system (using Linux examples), network, and the applications. We will also discuss attack prevention from external and internal sources.
Thursday, April 15
At 11:55 you’ll need to choose….
Our Danil Zburivsky presents:
Replication can get out of sync without warning. If you are using a slave for backup, disaster recovery, or even read-scaling, you want to make sure the slave has the same data as the master.
We will show the procedure we developed to use mk-table-checksum to minimize locking and slave lag that would be caused by locking large tables. We will discuss the problems we have run into with mk-table-checksum and how we have gotten around or fixed the issues—including when a table cannot be split into pieces and false positives generated in the MySQL error log.
Whether you use statement-based replication (the default), row-based replication or the mixed method, you can use mk-table-checksum to ensure your slave is in sync with your master. You can also use it even if your slave is lagging behind your master.
We will also show you how to fix the problems you encounter.
Or try Paul Vallee, Pythian’s founder, in Ballroom A as he reviews:
Outsourcing database infrastructure support currently features at the top of Gartner Group’s hype cycle, on the Peak of Inflated Expectations. Up next is the Trough of Disillusionment. Skip the trough by learning from our experiences, good and bad, to fast-forward straight to the Plateau of Productivity to reap the benefits of an informed decision. This presentation outlines the typical and costly mistakes organizations make when outsourcing their database infrastructure support – a recipe for disaster that guarantees the failure of these initiatives. Learn how to avoid these mistakes by using our best practices for setting the right expectations, establishing proper working communication channels, partnering with your vendor, and more.
And at 2pm, be sure to mosey to Ballroom A
and catch our last session, Sheeri Cabral’s very valuable
Query reviews are a great way to find potentially slow queries before they become a problem. A query review is like a code review, except instead of reviewing code, queries are reviewed. This presentation will show you how to use the Maatkit tool mk-query-digest to create a digest of queries. This digest can be a one-off report, or it can be saved to a database table.
Again, we’ll be tweeting throughout the show:
Or, add Pythian @pythian/tweeters to your twitter lists (or just click that link), I’m sure during the show most of what we’ll be on about will be conf.