Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 40 of 115 10 Older Entries

Displaying posts with tag: Database Management (reset)

Why does MySQL replication fail?
+0 Vote Up -0Vote Down

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:

  [Read more...]
Don’t Miss Percona Live 2013
+0 Vote Up -0Vote Down

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:

  [Read more...]
Cloud DBA and Management Interview
+1 Vote Up -0Vote Down

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...]
Thoughts on Upcoming MySQL 5.6 Defaults
+0 Vote Up -0Vote Down

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...]
10 ways I avoid trouble in database operations
+0 Vote Up -1Vote Down

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...]
Why you should attend Percona Live 2012
+1 Vote Up -1Vote Down

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
+1 Vote Up -1Vote Down

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...]
Oracle DBAs… You Know You Want MySQL!
+1 Vote Up -1Vote Down

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...]
Accidental DBA’s Guide to MySQL Management
+0 Vote Up -1Vote Down

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 …

  [Read more...]
RDS or MySQL – Ten Use Cases
+0 Vote Up -0Vote Down

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.

  1. I’m replicating into Amazon from a physical datacenter

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 …

  [Read more...]
10 Newer Entries Showing entries 31 to 40 of 115 10 Older Entries

Planet MySQL © 1995, 2016, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.