Pythian at MySQL Conference 2010

Posted in: Technical Track

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:

MySQL Configuration Options and Files: Basic MySQL Variables (Part 1)

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.
Read more.

Which continues on at 1:30 with Part Deux

MySQL Configuration Options and Files: Intermediate MySQL Variables (Part 2)

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:

Better Database Debugging for Shorter Downtimes

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.
Read more.

Wednesday, April 14

Start the day off right at 10:00 am

Our very own Sheeri Cabral will be delivering her community keynote:

Under New Management – Next Steps for the Community

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”.
Read more.

At 4:25pm, head back over to Ballroom A

And attend Sheeri’s

Time Zones and MySQL

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?
Read more.

And, to end a great day, at 5:15 Focus on Security in Ballroom E

As Pythian’s Danil Zburivsky presents:

Security Around MySQL

… 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 [email protected] 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.
Read more.

Thursday, April 15

At 11:55 you’ll need to choose….

Our Danil Zburivsky presents:

Continual Replication Synch

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.

Read more.

Or try Paul Vallee, Pythian’s founder, in Ballroom A as he reviews:

Worst Practices of IT Outsourcing

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.

Read more.

And at 2pm, be sure to mosey to Ballroom A

and catch our last session, Sheeri Cabral’s very valuable

Find Query Problems Proactively With Query Reviews

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.
Read more.

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.




Want to talk with an expert? Schedule a call with our team to get the conversation started.

About the Author

As Pythian’s Chief Executive Officer, Paul leads this center of excellence for expert, outsourced technical services for companies whose systems are directly tied to revenue growth and business success. His passion and foresight for using data and technology to drive business success has helped Pythian become a high-growth global company with over 400 employees and offices in North America, Europe, and Asia. Paul, who started his career as a data scientist, founded Pythian when he was 25 years old. In addition to driving the business, Paul is a vocal proponent of diversity in the workplace, human rights, and economic empowerment. He supports his commitment through Pythian’s hiring and retention practices, his role as board member for the Basic Income Canada Network, and as a supporter of women in technology.

1 Comment. Leave new

Gearing Up for MySQLConf 2010 | The Pythian Blog
April 8, 2010 3:01 pm

[…] speaking this year. This post would have been way too long to list them, so we’ve created a separate listing here. As a special side note, we’ll be giving away copies of The MySQL Administrator’s Bible […]


Leave a Reply

Your email address will not be published. Required fields are marked *