Showing entries 1 to 10 of 40
10 Older Entries »
Displaying posts with tag: interview (reset)
How to troubleshoot MySQL replication issues?

In MySQL a big portion of the problems you’re facing is different replication delays so there’s no surprise this is one of the most common interview questions on DBA interviews and I still found people having problems with explaining what they would do in a certain situation. This is why I decided to write a bit about the subject.

1. IO

99% of times the reason is IO. The slave cannot keep up with the amount of writes it gets from the binary logs while in parallel it has to return results of queries as well. In spite of the common belief in MySQL it’s much easier to saturate the disk subsystem (even a raid 10 with 8 SAS disk and cache) than the network.

In this situation all you can do is try to remove some pressure from the slaves.

One way to do this is setting innodb_flush_log_at_trx_commit  to 2 if it used to be 1. Usually this is enough.

[Read more]
Cloud DBA and Management Interview

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:

  1. Oracle DBA Interview Questions
  2. Cloud Operations Interview
[Read more]
Cloud Operations Interview

Read the original article at Cloud Operations Interview

What does a cloud computing expert need to know? How do you hire a cloud computing expert? Competition for operations & DBAs is fierce, so you’ll want to know how to find the best.

If you’re a systems administrator or ops guy, you may want to prepare for an interview for such a position. Meanwhile, if you’re a director of it or operations, a recruiter or manager in HR, you’ll want to have some idea how to find the right candidate.

Here’s my guide to do just that. You may also jump to …

[Read more]
Q&A with Monty by PacktPub

Monty just got interviewed by Packt Publishing in a Q&A format. There’s no way to comment on that article, so I’m wondering if you have any feedback — drop it here.

Also decided to start collecting interviews related to MariaDB on the Knowledgebase. Remember that its open for all to edit, so sign up.

OTN Interview about MySQL

I was interviewed by Justin Kestelyn the OTN Senior Director about MySQL at Oracle Open World this week.

Some highlights of the questions asked:

  • 0:55 Since the close of acquisition has there been any change in direction?
  • 2:23 How have your clients and customers responded to the acquisition?
  • 3:53 You mentioned that Oracle will bring added advantages and could infuse invocation.
  • 5:15 InnoDB and MySQL are now both owned by Oracle. What do you see as the development advantages?
  • 6:47 What were your thoughts on the first MySQL Sunday?
  • 8:58 Forks?
  • 11:04 Contact Details

You can view the Video online or play below.

Paul McCullagh answers your questions about PBXT

Following on from our earlier announcement, Paul McCullagh has responded with the answers to your questions - as well as a few I gathered from other Percona folks, and attendees of OpenSQL Camp. Thank you Paul!

What’s the "ideal" use case for the PBXT engine, and how does it compare in performance?  When would I use PBXT instead of a storage engine like MyISAM, InnoDB or XtraDB?

Unfortunately it is not possible to point to a specific category of applications and say, "PBXT will be better here, so try it".  PBXT is a general purpose transactional storage engine, designed to perform well on a broad range of tasks, much like InnoDB.  However, PBXT's log-based architecture makes performance characteristics different to both MyISAM and InnoDB/XtraDB. Tests show that PBXT's performance is similar to InnoDB but, depending on your database designed and the application, it can be faster.

PBXT is a …

[Read more]
Barry Abrahamson, talks about technicals

While at the MySQL Conference, I caught up with Barry Abrahamson, the systems wrangler/de-facto DBA behind (and all other Automattic properties). Watch the video.

You probably already know that Wordpress itself is built on top of MySQL. And despite everything you might have heard about our (MySQL/Sun’s) new founders, Wordpress is MySQL today, and for the foreseeable future. Anyway, I digress. has about 70 million tables, and tens of thousands of blogs. Large amount of tables, serve for easy sharding - …

[Read more]
Video interview with Jack Adams at #fosdem

This was an interview Jack Adams did with me at the MySQL/OpenSolaris booth at FOSDEM last weekend. Jack adams is an OpenSolaris mascotte, look around on YouTube for more funny interviews with him.

Conversation with Lenz Grimmer

You can read my conversation with Lenz Grimmer or look at other interviews conducted by the MySQL community team. 

Conversation with Lenz Grimmer

You can read my conversation with Lenz Grimmer or look at other interviews conducted by the MySQL community team. 

Showing entries 1 to 10 of 40
10 Older Entries »