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 Thoughts on Upcoming MySQL 5.6 Defaults
During Oracle Open World 2012 and the parallel MySQL Connect conference, the new 5.6 version was announced. It’s only release candidate right now, but that means the GA release is just around the corner. With that James Day has posted changes to various of the new parameter defaults. Many of them you may not run [...]
For more articles like these go to Sean Hull's Scalable Startups
Related posts:
[Read more]Read the original article at 10 ways I avoid trouble in database operations
1. Avoid destructive commands From time to time I’m working with new recruits and bringing them up to speed in operations. The first thing I emphasize is care with destructive commands. What do I mean here? Well there are all sorts of them. SQL commands such as DROP table & DROP database. But also TRUNCATE [...]
For more articles like these go to Sean Hull's Scalable Startups
Related posts:
[Read more]Read the original article at Why you should attend Percona Live 2012
What I loved about Percona Live 2011 Last year I was excited to go to Percona Live for the first time in NYC. I arrived just in time to hear Harrison Fisk from Facebook speak about some of the awesome tweaks they’re running with MySQL there. It’s not everyday that you get to hear from [...]
For more articles like these go to Sean Hull's Scalable Startups
No related posts.
Read the original article at 5 Things You Overlooked with MySQL Dumps
1. Point In Time Recovery If you’ve never done point in time recovery, it’s time to take a second look. With a standard mysqldump you restore your database to the time when the backup happened. Only do them once a day, then you can lose as much as 24 hours of data. Enter point-in-time recovery, [...]
For more articles like these go to Sean Hull's Scalable Startups
Related posts:
[Read more]Read the original article at Oracle DBAs… You Know You Want MySQL!
If you’re an Oracle DBA or developer and considering migrating an application over to MySQL you probably have a lot of questions. Here’s a five minute summary of what you should know. Looking to hire a top flight MySQL DBA? Check out our MySQL interview guide. What is truly delicious o a command line that’s [...]
For more articles like these go to Sean Hull's Scalable Startups
Related posts:
[Read more]Read the original article at Accidental DBA’s Guide to MySQL Management
So you’ve been tasked with managing the MySQL databases in your environment, but you’re not sure where to start. Here’s the quick & dirty guide. Oh yeah, and for those who love our stuff, take a look to your right. See that subscribe button? Grab our newsletter!
1. Installation
The “yum” tool is your friend. If you’re using debian, you’ll use apt-get but it’s very similar. You can do a “yum list” to see what packages are available. We prefer to use the Percona distribution of MySQL. It’s fully compatible with stock MySQL distribution, but usually a bit ahead in terms of tweak and fixes. Also if you’re …
[Read more]Read the original article at RDS or MySQL – Ten Use Cases
Amazon’s Relational Database Service is based on MySQL under the hood. So many colleagues and clients ask me – should I go with RDS or MySQL? As with every technology question, the answer is – it depends.
Here are some scenarios to help you decide.
A: This setup is common if you’re using Amazon’s VPC or Virtual Private Cloud. With a router dropped into your datacenter, VPC allows you to extend and spinup virtual instances from Amazon as if they’re sitting in your own existing datacenter. Great stuff, but you won’t be able to replicate from your existing master MySQL instance to cloud Amazon RDS instances. To do that, roll your own with MySQL 5.5 or Percona …
[Read more]Read the original article at Best of Guide – Highlights of Our Popular Content
We cherry pick the top 5 most popular posts of various topics we’ve covered in recent months.
We use a broad brush to highlight the biggest no-nos in web application scalability.
5 Ways to Boost Scalability for MySQLWe dig into scalability, steering to the richest areas to focus on.
8 Best Practices for Deploying MySQL Databases on Amazon EC2MySQL on Amazon EC2, the what, how …
[Read more]Read the original article at Ten things to remember about MySQL backups
Hot backups are an excellent way to backup MySQL. They can run without blocking your application, and save tons on restore time. Percona’s xtrabackup tool is a great way to do this. We wrote a how-to on using xtrabackup for hotbackups.
Use Logical BackupsJust because we love hot backups using xtrabackup doesn’t mean mysqldump isn’t useful. Want to load data into Amazon RDS? Want to isolate and load only one schema, or just one table? All these great uses make mysqldump indispensable. Use it in …
[Read more]