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 – …
I’ve been working on revising my password policy scripts, and in the process,
thought about the privileges required. My first draft added
tables to the mysql system database and leveraged
the root@localhost account. I’m looking to
lock that down for the next iteration. It’s easy to move
the tables and procedures out of the mysql system
database into a new password_policy database, but
what to do about the use of the root account?
Ideally we would use an account that has the minimum privileges necessary to successfully execute the stored procedures. But these aren’t trivial permissions:
Twitter VP of Infrastructure Operations Engineering Mazen
Rawashdeh shared news and numbers yesterday on his blog:
"Last night, the world tuned in to Twitter to share the election results as U.S. voters chose a president and settled many other campaigns. Throughout the day, people sent more than 31 million election-related Tweets (which contained certain key terms and relevant hashtags). And as results rolled in, we tracked the surge in election-related Tweets at 327,452 Tweets per minute (TPM). These numbers reflect the largest election-related Twitter conversation during our 6 years of existence, though they don’t capture the total volume of all Tweets yesterday."
"Last night, Twitter averaged about 9,965 TPS from 8:11pm to 9:11pm PT, with a one-second peak of 15,107 TPS at 8:20pm PT and a one-minute peak of 874,560 TPM. …
[Read more]
Have you ever wondered how MySQL DBAs at other companies manage
their day to day operations? Then join us at the #dbhangops
google hangout. My co-worker is trying to get a mix of DBAs
running mid to large scale deployments to provide an open forum
for people to talk about their experience and learn from others.
We've had several successful hangouts so far, and we're
interested in opening it up to a wider audience.
Our next meetup is TBD, but we're planning on the
following agenda:
Query killing: protecting your DBs
Alerting and Monitoring: what do you monitor and why?
The MySQL Utilities Python Library: use cases, building tools and
automation
My.cnf config tuning: what parameters are important for you and
why?
For more info see Geoff Anderson's blog.
For news …
