I have have been receiving a lot of questions about the new MySQL 5.6 DBA exam. Sadly I can not answer a lot of the questions until after my exam in early November. However I do know some good things about the new exams.
First — No True or False questions. Oracle has set the standards on that policy and I had to update the ol’ 5.0 exams to make certain there the T/F questions were removed. Why is this important? Don’t you have a fifty/fifty chance on T/F questions? The trouble is that some of these questions were a wee bit tricky and needed parsing plus a full understanding of the subject to get them right. For fairness, it is easy to do without the T/F questions.
Second — No more pick up to N answers. Once again, for fairness.
Third — One exam for the certification. In the past the costs, not just financial, of setting up the second exam and studying for it turned off many candidates.
So what am I studying? MySQL 5.6 Database Administrator is a list of the items on the exam.
Under Architecture, that page lists the following
- Use MySQL client programs to interface with the MySQL Server interactively and in batch
- Describe how MySQL uses disk and memory resources
- List and describe key characteristics of standard MySQL storage engines including InnoDB, NDB, MyISAM, MEMORY, FEDERATED
Let’s take the first bullet point. How does one find the MySQL client programs? The are listed in the MySQL Manaual at http://dev.mysql.com/doc/refman/5.6/en/programs-client.html. So spend some time with mysql, mysqladmin, mysqlcheck, mysqldump, mysqlshow, mysqlimport, and mysqlslap. Read the man pages AND use the commands.
So one bullet point down, 21 to go!
Zendcon is a difficult conference if you work in an exhibit hall booth. At other shows, attendees ask general questions about MySql or how Oracle is guiding products. Zendcon is much more pointed. When is 5.7 multisource relication going to be available? How does Visual Explain work? How can I make sure replication goes back to semi-sync after going async? It is a great show but the level of questions are a notch or two higher than most other shows.
Proving this it is the show for in-depth technical information, MySql Connect finished with a bang. Six different two hour plus deep dive tutorials were offered and all had very good attendence. Many of the attendee were seasoned Oracle DBAs eager to gorge at this buffet of technical knowledge.
The crowd for Ligaya Trumele’s Getting Started
with MySql was packed with
Oracle DBAs who were amazed at the simplicity of the MySql architecture once they figured out the concept of multiple storage engines.
Luis Soares had a tutorial that was everything you ever wanted to know about 5.6 replication plus a look multi source that will be in 5.7. His discussion on how and when binlogs are written and the impact if that timing on replication was intense, detailed, and worth the price of the show itself.
Finishing a mentally overload day, I listened to Bernd Ocklin on MySql Cluster 7.3 and this product has really changed in the past few years. I highly recommend that you grab his slide deck on how Cluster partitions data.
Today is Tutorial Day at MySQL Connect 2013 and yesterday was a blur. The Replication Road Map session started my day and it covered the long term development goals for MySQL Replication as well as more information on the Fabric sharding tool. Joro presented an amazing session on new security features along with some great tips for DBAs. Sadly I had to miss the other sessions as there was a meeting of the MySQL Storage Engine Partners (thanks to all the attendees) and the Oracle User Groups. Like many of you, I will be spending time going through presentations online to catch up on the session I missed.
And please let us have any feedback on MySQL Connect 2013 that you may have as we are already looking at the 2014 show.
Day one of MySQL Connect day 1 was a great day of technical information.
Tomas gave another stunning keynote that covered 5.6, 5.7 and covered new innovations like the Fabric sharding software.
I sat in on a hands-on session to learn the tricks of how to run explain on another process.
Davi from Linkedin gave an amazing talk on InnoDB internals that I missed due to being in a great session on Fabric.
The evening reception was a great chance to see old friends, make new ones, and enjoy the MySQL Community.
MySQL DBA and Developer Certification Exams are now in beta! Besides covering the new material in MySQL 5.6, you now have to pass one exam to earn the certification where previously you needed to pass two exams. Signup at Pearson Vue and reserve your exam. Testing will start in October.
The exams for older certifications will not be available after October 31st and the Certification Paths for DBA 5.0, Developer 5.0, Cluster DBA 5.1, and Associate will end at the end of the year. Those certifications are still valid once earned forever. For more details.
Learn MySQL in a virtual self-study group for free with MySQL Marinate. The Boston MySQL Users Group is continuing this popular series where you cover a chapter a week in O’Reilly’s Learning MySQL, upload your homework, and learn MySQL. If you have co-workers or friends looking to add MySQL to their skill set, please let them know.
A very special MySQL DBA Class will be held October 14th at Oracle Headquarters. The MySQL DBA Training On Demand Class (5.5 version) is currently the 8th best delivering TOD at Oracle in terms of student numbers and the MySQL DBA 5.6 course has been consistently been in the top 40 out of 1000s of titles at Oracle since the beginning of this financial year. But this class will on version 5.6 and seats are available!
What is TOD? It is where you follow video delivery of event at your own pace, and schedule access to course environment lab exercises at your own convenience. An instructor is available to answer any questions you have online. This class will be where the TOD materials are recorded. TODs are important for the MySQL area because this flexible, no travel method of training works well for community users. TOD recordings are only done at HQ and Students will not be inconvenienced by the fact that the instructor’s delivery is recorded.
Besides TODs you can find In-Class events – where you travel to a training center and Live-Virtual events – where you attend a live event from your own desk via phone/Webex with remote access to lab environment.
For more on MySQL Training
Last may I wrote about Reestablishing a MySQL Tradition where we used to have shirts just for those who contributed code to MySQL. Unfortunately that tradition was not kept during various transitions. But Antony Curtis
This is Antony Curtis in the original Community Contributor shirt
impressed me at a conference with his shirt and so the Community Team started the process of getting shirts for our contributors. Today I am proud to announce the first shirt has been ordered and in the post to Antony.
So if you have contributed to MySQL, have an OCA on file, AND are going to be at MySQL Connect — please let me know your size so I can present it to you September 21st or 22nd and thank you for your work on MySQL.
The MySQL Community Team has one and a half new members! Welcome back Morgan Tocker who many of you may remember from MySQL Training. And welcome Jara Jr, Lenka Kasparova’s son, whom mom informs us is ‘really sweet’.
I am speaking today at Djangocon, Dallas PHP on Tuesday the 10th, and then next weekend at Ohio Linuxfest.