Events/Boston2010/Sessions
From OpenSQLCamp
The sessions will be chosen in an un-conference style on the day of the event, but session topics should be posted here to give other people an idea of what to expect. If you would like to lead a session, please describe it here. This may be a more formal presentation with slides, or possibly just leading a group discussion on a hot topic. Also feel free to toss ideas out to the mailing list to get feedback in case you are not sure. We want to encourage people from all levels to lead sessions, share your thoughts!
How to add a proposed session
Copy and paste the "Title - Presenter" template just under this text and put the name of the title and presenter(s) in the heading, and the description in the body.
Title - Presenter
Description goes here; just a few sentences to illustrate the idea.
Checking MySQL's replication sync with Ma'atkit tools - Sheeri Cabral
The theory has been around since an article by Baron Schwartz in October 2008. Sheeri Cabral tackled this daunting task for clients of the Pythian Group and found a few surprises -- from options that don't work as they are supposed to, to learning that a lot more data was in sync than originally guessed. Sheeri will lead folks through the theory of setting up continual replication sync, and the actual process, including the important aspects to be aware of when doing this on your own systems.
mysqltuner 2.0: What the next generation can do - Sheeri Cabral
mysqltuner 2.0 is a launchpad project that can do a lot more than the original mysqltuner. Through a simple config file, you can choose what to check, what thresholds are problematic, and even what to print out if a threshold is met. Gathering metrics is made very easy by mysqltuner's simple model where a string is matched to status/system variables and replaced with the value -- mysqltuner can be easily extended to use other sources for data, including SHOW ENGINE INNODB STATUS). You also control how often to run mysqltuner, which makes mysqltuner great for a one-time sanity check of performance variables, or for frequently collecting metrics.
Running TPC-H-Like Queries in a Massively Parallel NOSQL Engine -Bradley C. Kuszmaul
I've been working on a massively-parallel NoSQL database. I hope to be ready to talk about what it takes to run TPC-H-like queries. (This is a research project at Tokutek, and is not currently on any product roadmap.)
Ideas with no concrete presenter:
What is different about the Percona build? (no presenter)
Would like to see a presentation on what is different in the Percona build so I can assess if I want/need to use it.
Feature overview of the Percona Server - Matt Yonkovit
A review of the current features that exist in XtraDB and the Percona Server. Analysing topics like: How do these differ from the stock MySQL builds? How these can be used now to solve current problems? Which features are the most compelling and widely used? Can these be used to solve the energy crisis? and more.
Database Tuning for fun and fame - Matt Yonkovit
Who does not love to tune their databases? Isn't it what we all dream of every night? Let's talk about some of the tricks and techniques Percona uses on their consulting assignments that assist customers in reaching their goals. These are techniques and best practices you can use in your day to day tasks to ensure smooth database operations. High level topics include:
* Goal oriented optimization * tools of the trade ( i.e. maatkit, cacti, etc ) * Hardware and OS tuning * Problems and pitfalls to avoid
Scale out or Scale up - Matt Yonkovit
For years in the tech industry a war has been brewing between those who favor scaling out and those who prefer scaling up. Looking back on commercial database offerings over the past 10-15 years you can see the industry trending both ways over and over again... Over the years technologies like clusters, virtulization, and replication to giant smp servers, multi-core boxes, etc have forced the technology train to loop back and fourth between scale out and scale up solutions. How is this all playing out today? And how does this effect the database landscape of the future? Much work has gone into exploring and expanding multi-core performance and enabling database's like MySQL to scale-up... but this direction has also lead to the growth of external scale-out solutions like Cassandra, MongoDB, etc. All this has happened before and will happen again, so lets try and understand the trend and way the pro's and con's of scaling up vs scaling out.
