Showing entries 31 to 40 of 115
« 10 Newer Entries | 10 Older Entries »
Displaying posts with tag: Database Management (reset)
Limitations of MySQL row-based replication

Read the original article at Limitations of MySQL row-based replication

MySQL offers a few different options for how you perform replication. Statement-based has been around a lot longer, and though it has some troublesome characteristics they’re known well and can be managed. What’s more it supports online schema changes with multi-master active-passive setup. We recommend this solution. Row-based replication is newer. It attempts to address [...]

For more articles like these go to Sean Hull's Scalable Startups

Related posts:

  1. Why does MySQL replication fail?
[Read more]
10 reaons active-active is hard and how to solve it

Read the original article at 10 reaons active-active is hard and how to solve it

Multi-master replication provides redundant copies of your most important business assets. What’s more it allows applications to scale out, which is perfect for cloud hosting solutions like Amazon Web Services. But when you decide you need to scale your write capacity, you may be considering active-active setup. This is dangerous, messy and prone to failure. [...]

For more articles like these go to Sean Hull's Scalable Startups

Related posts:

  1. Why does MySQL replication fail?
[Read more]
Why does MySQL replication fail?

Read the original article at Why does MySQL replication fail?

When considering active-active multi-master, you must consider it’s foundation technology. Although MySQL replication is straightforward to setup, it can fail in a myriad of ways. Most of those are known and well understood. We can solve them only if we use the technology in the standard way. Click through to the end for multi-master solutions [...]

For more articles like these go to Sean Hull's Scalable Startups

Related posts:

  1. 5 Ways to fortify MySQL replication
  2. Easy …
[Read more]
Don’t Miss Percona Live 2013

Read the original article at Don’t Miss Percona Live 2013

The biggest event on the MySQL calendar is the yearly Percona Live and it’s just around the corner. This year you’ll be able to pick from a whopping 110 technical sessions by 90 different speakers from companies like Facebook, Amazon, Google and Linkedin. Learn what’s happening at the cutting edge of open source database deployments. [...]

For more articles like these go to Sean Hull's Scalable Startups

Related posts:

  1. Why you should attend Percona Live 2012
  2. Hacking Job …
[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]
Thoughts on Upcoming MySQL 5.6 Defaults

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:

  1. 5 Ways to Boost MySQL Scalability
  2. 5 Ways to fortify MySQL …
[Read more]
10 ways I avoid trouble in database operations

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:

  1. 5 Ways to Avoid EC2 Outages
  2. 7 Ways to Troubleshoot MySQL
[Read more]
Why you should attend Percona Live 2012

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.

5 Things You Overlooked with MySQL Dumps

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:

  1. Ten things to remember about MySQL backups
  2. Easy MySQL replication with …
[Read more]
Oracle DBAs… You Know You Want MySQL!

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:

  1. Migrating MySQL to Oracle Guide
  2. MySQL Cluster In The Cloud – …
[Read more]
Showing entries 31 to 40 of 115
« 10 Newer Entries | 10 Older Entries »