Oracle University has added a new course to its training catalog “Introduction to MySQL 5.5″ which is a day-long seminar. The seminar goes into some detail on many aspects of using MySQL and of course pays particular attention to the new features in MySQL 5.5. I’ve reviewed the material and can assure you that there is plenty of it!

Of most relevance to this blog is the overview of MySQL Cluster (which isn’t a big focus of the seminar as Cluster is currently using MySQL 5.1) and MySQL replication – the highest profile 5.5 feature being asynchronous replication which can make sure that zero updates are lost even if the master fails catastrophically.

At the time of writing, neither the on-line and instructor-led sessions have been scheduled and so you should register an interest here. When OU have …

For those that missed it - last week we added training in Frankfurt and London to our website.  This includes our new Operations Training announced in September.

(While in Europe, we'd love to speak at your meetup group on Percona Server and/or MySQL Optimization.  If you're a meetup organizer in London or Paris, please feel free to get in touch.)

Entry posted by Morgan Tocker | …

At LINBIT, we are always eager to extend our partnerships and cooperations with technical consultants, service professionals, and sysadmins. So if you work for a company that might be interested in becoming a LINBIT partner and deliver first-class high availability services in Linux and open source to customers, we are always interested in hearing from you.

At this time in particular, we are looking for partners in the Australia/South Pacific region, so if you work for an outfit that might be a good partnership fit, please drop us a line. I am in Brisbane in January for …

If you live in Australia or New Zealand, and are considering to attend our DRBD Total 4-day class in Brisbane in January, please remember that today (Friday Dec 3) is your last chance to grab your 10% Early Bird discount.

Registrations received today will be eligible for the discount. Starting next week, all registrations are regular price.

Take a look at the course info on our web site. Unsurprisingly, you’ll also find the registration link just there.

I’ll be teaching this class myself, and am very much looking forward to it. See you in Brisbane!

…

Just in case you have’t noticed — this (Southern Hemisphere) summer, we are doing our first 4-day DRBD Total High Availability training class in Australia. Our course will be held in Brisbane, on January 18-21. Yes, that’s the week before linux.conf.au 2011, also held in Brisbane, where we will be presenting too.

DRBD Total is our standard training format giving you maximum insight into the Linux cluster stack. We have offered (and continuously improved) DRBD Total for over 2 years with …

My colleague Aleksandr Kuzminsky will be speaking at WebConf Riga 2010 next month on XtraBackup: Hot Backups and More and Recovery of Lost or Corrupted InnoDB Tables.

WebConf is the first big conference of its kind in the Baltic states (Estonia, Latvia, Lithuania) and we are very happy to be participating.

In addition to Aleksandr's talks, we will also be offering our training courses. You can find out more from the conference website (they will be publishing more information in the next two days).

Entry posted by Morgan Tocker | No comment

Add to: …

Please join us on Tuesday, Sept. 28 for an afternoon of networking and educational opportunities as the IOUG hosts Matt Yonkovit, MySQL expert, for his presentation “MySQL: What You May or May Not Know.”

Tuesday, September 28 | 1:00 p.m. – 5:00 p.m.

Agenda:

1:00 p.m. – 2:00 p.m.
The 5 Minute DBA: A Crash Course to MySQL DBA Troubleshooting and Optimizations

Many people who are charged with running MySQL are not DBAs, rather they are developers, system administrators, network administrators, etc. Typically these people put on a DBA hat only when there is a problem to solve or to deal directly with. These people are called “the 5 minute DBAs,” dealing with databases issues for only a very short time in any given week. This session will give these 5 minute warriors some basic tools and skills in …

I occasionally get in to light arguments healthy discussions with students about whether or not to use Foreign Key constraints on InnoDB tables.  My standard response has always been: “it depends on how much of a tradeoff you are willing to make for performance. In some situations the cost can be considerable”.

.. that’s when they expect me to “come up with some real proof” to show them. I do not disagree with their logic or proof being on their list-of-demands.  I support the use of data to make decisions.

The problem is that MySQL has (traditionally) been lacking the instrumentation required to make these decisions easy.  This is getting better  – here is an example we recently added to our InnoDB course:

 CREATE TABLE parent (
 id INT NOT …

After our hugely successful summer class in Silicon Valley, we have set up a survey to help us determine the location of our Q4 DRBD Total course in the United States. So let us know where you would like to see the next incarnation of the industry’s premier Linux High Availability training!

Our survey just takes a minute to complete. We appreciate your input!

…

Four Perconians (perconites?) will be at OpenSQL Camp in Sankt Augustin, Germany this weekend presenting talks on:

• Recovery of Lost or Corrupted InnoDB Tables
• Keep your MySQL backend online no matter what
• XtraDB -- InnoDB on steroids
• Xtrabackup for MySQL

If you would like to stop by and say hello, we are Aleksandr, Istvan, Morgan and Aurimas (pictures here).

If you can make the (approximate) location, but not the date, we also have training in Frankfurt in three weeks time.

Entry posted by Morgan Tocker | 3 comments

Add to: …