So, you are going to Collaborate (or thinking of going) and you saw my blog post about what to go to if you are a beginner with MySQL. But what if you are more experienced with MySQL? There is plenty of content for you too! I have put together this list of what I would recommend to an experienced MySQL DBA at Collaborate. This is not a complete list of all the choices at Collaborate.

Note that several weeks ago Sarah Novotny and I did an OurSQL podcast about Collaborate, including information on how to get $200 off the registration price. The information there is very different from what is in this blog post, so I would recommend listening to the podcast and reading this post.

Collaborate has a Deep Dive …

So, you are going to Collaborate (or thinking of going) and you wonder if, as a MySQL beginner, there will be enough content for you. Or you wonder if there will be too much, and how you will ever decide on what to go to. I have put together this list of what I would recommend to a MySQL Beginner at Collaborate.  The schedule is still being tweaked at this point, so there may be great sessions being added or times may be changed, but I will try to re-post closer to the event.  The most up-to-date schedule is at the Agenda Builder – to see only MySQL content, choose MySQL in the “Product Lines” section.

Note that a few weeks ago Sarah Novotny and I did an OurSQL podcast about Collaborate, including information on how to get $200 off the registration price. The information there is very different from what is in this blog post, so I would recommend …

The OurSQL podcasts will eventually make it into the Blue Gecko blog.  But, in the mean time, I’d like to summarize what Sheeri Cabral and I have been getting up to.  As I mentioned in the OurSQL revival post we are working to bring you a podcast every week about something technical or community related.  Since mid-December, we’ve recorded and published eight podcasts.

OurSQL Episode 26: Zombies!

MySQL 5.5 release and our favorite updates to our favorite database

OurSQL Episode 27: To SQL or No[tto]SQL, …

Today we're announcing Percona Live - a one day event to be held at the Bently Reserve on February 16th in San Francisco.  Live is our way of showcasing some of the awesome work that has been going into MySQL recently - and the theme of this event is Beyond MySQL 5.1.

Our first guest speaker is none other than Jeremy Zawodny.  Jeremy is well known in the MySQL community having been the original author of High Performance MySQL 1st Ed.  He will be presenting on how Craigslist has already upgraded to MySQL 5.5 - and are running on Fusion-io SSDs in production.

Tickets are available for early bird registration at $50.  To signup, or for more information please visit the percona website.

Entry posted by Morgan Tocker | …

I will present on "Testing LAMP Applications" at the O'Reilly MySQL Conference & Expo 2011:

Proper interaction with relational databases is incredibly important in most pieces of software. The importance of this interaction is underscored by the fact that many software architectures have at least one entire layer or system devoted to data persistence and data loading. When dealing with critical data in enterprise level applications it becomes even more important to make sure your data is being stored and retrieved correctly.

As responsible developers, one of our goals should be to test database interaction and test it well. To help achieve …

I’ll be going to foss.in this year, and am totally excited (the last time I spoke there was in 2007 – Paying it Forward: Harnessing the MySQL Contributory Resources – where I talked about moving from BitKeeper to Bazaar, using Launchpad, the MySQL Forge, and more). This time around, I will be giving a talk titled: MariaDB: The new M in LAMP. I feel a little nostalgia, because the MySQL ecosystem has evolved a lot since December 2007.

The database crew is going to be strong there, as we also have Gary Pendergast, my friend from MySQL (now Oracle) giving a talk titled: Tuning MySQL for Performance, Stability and Fail Safety.

We figured we’d have some kind of meetup, either over chai or if we can …

As a follow up of this post I'd like to inform all the readers that the What's New event will be replicated in Rome on Oct, 7.

Join us at this live event to better understand what’s new with MySQL. You will learn more about the current and future state of MySQL, now part of the Oracle family of products. We will also cover Oracle’s investment in MySQL aiming to make it even a better MySQL.

In particular the following topics will be discussed:

• Oracle’s MySQL Strategy
• What’s New for:
  • The MySQL Server
  • MySQL Cluster
  • MySQL Enterprise
  • MySQL Workbench
  …

Join us at this live event in Milan to better understand what’s new with MySQL. You will learn more about the current and future state of MySQL, now part of the Oracle family of products. We will also cover Oracle’s investment in MySQL aiming to make it even a better MySQL.

In particular the following topics will be discussed:

• Oracle’s MySQL Strategy
• What’s New for:
  • The MySQL Server
  • MySQL Cluster
  • MySQL Enterprise
  • MySQL Workbench

Stay tuned because we are organizing a similar event in Rome that will be announced soon. Attendance is free, but you’ll need to register in advance. Seats are limited, …

If you like to keep your ddl backed up in some source management tool like svn or cvs and want to do it individually for stored procedures, events, triggers, tables and such rather than having a single file you can easily do so using the below. You could even include the –skip-dump-date or –skip-comments and use the below to compare ddl daily checking for alterations thus making sure you are aware of any ddl changes done on the database.

user=backup_user
password=`cat ~/.backup_password`
hostname=127.0.0.1
port=3306
dbname=test_db
path=/home/mysql/ddl
date=`date +%Y%m%d`

mysqldump -u$user -p$password -h$hostname -P$port --no-create-info --no-data --no-create-db --skip-opt $dbname > "$path"/"$dbname"_triggers_"$date".sql
mysqldump -u$user -p$password -h$hostname -P$port --routines --skip-triggers --no-create-info --no-data --no-create-db --skip-opt $dbname > …

This time OSI Days is doing special theme around Open Source Databases. Please see their call for paper below. It will be interesting to see how many MySQL papers are being presented there. I am submitting a couple of them. Please spread the word so that we can see an increased MySQL participation there. I think they are sponsoring quite a bit of speaker travel and accommodation.

____________________________

Open Source Databases | OSI Days 2010 is the premier FOSS Databases conference being organised at Asia's largest Open Source Conference - OSI Days 2010. We invite you to come and lead a tutorial / session or participate in Panel Discussions at OSI Days 2010 on a specific Open Source Database. The last date for submitting a proposal is 25th June 2010.

The conference is scheduled for …