In case you missed this......
MySQL Server 5.6.8 RC was announced today.
MySQL Server 5.6.8 (Release Candidate) is a new version of the world's most popular open source database.
Please download and test it out. Oracle is eager for any feedback that you might have on this release.
This is not necessarily going to be a comprehensive post, but I learned somethings about MySQL SSL today that I thought would be worth sharing.
I was setting up a PRM install for a customer and one of the requirements was SSL replication. In this particular case, I had setup PRM first, and then was working to get the other requirements configured. I knew from experience that it was best to ensure SSL was working properly from the command line first before trying to get replication to use it via PRM’s automation that does the CHANGE MASTER for you. Eliminate the variables.
The customer provided me with the CA cert, the private key, and the …
[Read more]It has been a little while since I have had the time to sit and write again and I can admit that I quite miss it. From a community standpoint, myself and the intern team have been really busy with getting the new websites in place. We also have alot plans for some really awesome projects being planned with some other open source companies like Akiban, as well as some Social Media contests. Recently though, I have been handling a fair amount of requests dealing with common issues, ranging from simple connections to permission issues. As a general rule, approaching these issues, there is a common few steps that are taken to help eliminate where the issue lies.
On Unix/Linux:
Come Find the Answer Launching a next-gen app? You need a next-gen database. But figuring out which one is no walk-in-the-park. Tune in next Tuesday to a webinar where Matt Aslett, research manager for data management and analytics at 451 Research, Doron Levari, ScaleBase’s CTO, and I will discuss:
The increasingly complex and ever-changing database market The benefits and [...] Read More
MySQL:’s new visual EXPLAIN provides a graphical representation of what the optimizer plans to run your code. Compare to CLI version below.
Optimizing MySQL Queries is often wrongly viewed by many DBAs as a ‘dark art’. For years we have been pre-pending EXPLAIN to SELECT statements in hopes of looking into the entrails of our offered code in hopes that the query optimizer deities looked whit favor on our efforts. But with MySQL 5.6 and the latest versions of MySQL Workbench, we have now entered into the age of an EXPLAIN that works with more than just SELECT statements and the ability to see graphically what is happening to our queries in the optimizer. Take a look at the two screen captures in this post and compare them. The query used is a very simple two table join from the good ol’ World database. …
[Read more]Read the original article at Cloud DBA and Management Interview
What does a cloud computing expert need to know? This is the last of a three part guide to interviewing for a cloud operations position. You can find them here – part one Operations Interview and part two Deployment Interview. Here’s my guide to do just that. 1. Database administration experience Although in some shops [...]
For more articles like these go to Sean Hull's Scalable Startups
Related posts:
[Read more]Today and tomorrow I am at CodeConnexx - An Open Source Technology and Life Conference. There are some great talks...the first talk this morning is Secrets and Success in the Style of GLEE - a bunch of songs and how they relate to being successful. By Jennifer Marsman of Microsoft.
Taylor Swift, "Speak Now" - be vocal, if you have an idea, do not be shy about it. In an interview, "don't stop talking" - meaning show them your passion - but don't force it, of course. Ask lots of questions, do not make assumptions. And if you get stuck in a problem, you can reason your way through it by talking out log.
Bonnie Raitt - "Let's Give Them Something To Talk About". Communicate! Let your manager know what's going on and what you are doing. "Give them stories to tell about you" - and good ones too! Trip reports if you go on a trip, summary status e-mails, one-on-one meetings, etc.
Aretha Franklin - "Respect". At the end of the day, …
[Read more]Congratulations to the co-founder of MySQL AB & SkySQL Board Member We’re proud to have David on our team
I was honored to be asked to be a member of the committee for the “big” MySQL conference: Percona Live MySQL Conference and Expo 2013 in Santa Clara, CA. Personally, I’ve been attending this conference for 6 or 7 years and missing it only when my wife was pregnant with a due date in April (we have two children with April birthdays).
To me there was always a bit of mystery around conference talk selection committees, and this is the first public conference I’ve performed these duties for. I’m not writing this post representing the entire committee, just as a member trying to let people in on what we get up to in general and where we’re at now. Perhaps a few questions have crossed your mind:
Who is on the committee?
Our Chair is Shlomi Noach. Also on the committee apart from myself is Roland Bouman, Ronald …
[Read more]
Today and tomorrow I am at CodeConnexx – An Open Source
Technology and Life Conference. There are some great talks…the
first talk this morning is Secrets and Success in the Style of
GLEE – a bunch of songs and how they relate to being successful.
By Jennifer Marsman of Microsoft.
Taylor Swift, “Speak Now” – be vocal, if you have an idea, do not
be shy about it. In an interview, “don’t stop talking” – meaning
show them your passion – but don’t force it, of course. Ask lots
of questions, do not make assumptions. And if you get stuck in a
problem, you can reason your way through it by talking out
log.
Bonnie Raitt – “Let’s Give Them Something To Talk About”.
Communicate! Let your manager know what’s going on and what you
are doing. “Give them stories to tell about you” – and good ones
too! Trip reports if you go on a trip, summary status e-mails,
one-on-one meetings, etc.
Aretha Franklin – …
