via GIPHY Amazon releases a new database offering every other day. It sure isn’t easy to keep up. Join 35,000 others and follow Sean Hull on twitter @hullsean. Let’s say you’re hiring a devops & you want to suss out their database knowledge? Or you’re hiring a professional services firm or freelance consultant. Whatever the … Continue reading How to interview an amazon database expert →
10 Older Entries »
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.
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]
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]
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]
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.
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.
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]
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.
Wordpress.com has about 70 million tables, and tens of thousands of blogs. Large amount of tables, serve for easy sharding - …[Read more]
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.
10 Older Entries »