Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 30 of 107 Next 30 Older Entries

Displaying posts with tag: Database Management (reset)

Howto automate MySQL slow query analysis with amazon RDS
+0 Vote Up -0Vote Down
If you’ve used relational databases for more than ten minutes, I hope you’ve heard of slow queries. Those are those pesky little gremlins that are slowing down your startup, and preventing scalability you so desperately need. Luckily there’s a solution. What I’ve found is if I send a report to developers every week, it keeps […]
E-commerce – Uptime and Web apps are the keys
+0 Vote Up -0Vote Down

Since 2011 e-commerce has grown from $856,000,000.00 to closing out 2013 at more than $1,248,000,000,000.00 in global revenues, a nearly 41% growth rate over a two year span. The forecast for 2014  is targeted at $1,500,000,000,000.00, another 20% increase is gross revenues (see chart below). With trillions of dollars in play year on year now, and astounding revenue growth rates still ahead, it is critical that any e-commerce site be diligently monitoring not just their website uptime, but more importantly their Web applications. Obviously it is critical that your customers be able to get to your website, but if it doesn’t build fast and complete client requests and transactions even faster then

  [Read more...]
Connect to MySQL in the Amazon Public Cloud
+0 Vote Up -0Vote Down
Troubleshooting MySQL on Amazon can be a real test of patience. There are quite a few different things to watch out for in terms of connectivity & networking. Sometimes a checklist can help. Join 16,000 others and follow Sean Hull on twitter @hullsean. Here’s my exhaustive list of things that can block you. 1. Be […]
Are SQL Databases Dead?
+1 Vote Up -0Vote Down
I like the image of this city of Mesa Verde. It’s fascinating to see how ancient cities were built, especially as an inhabitant of one of the worlds largest cities today, New York. I’m a long time relational database guy. I worked at scores of dot-coms in the 90′s as an old-guard Oracle DBA, and […]
5 great things about Markus Winand’s book SQL Performance Explained
+0 Vote Up -0Vote Down
Join 12,100 others and follow Sean Hull on twitter @hullsean. 1. Covers databases broadly You may not have noticed, but there’s a whole spectrum of relational databases on offer. Of course in the database world, most get infatuated with one, and that becomes their bread & butter before long. Their life, their passion, their devotion. […]
Why Oracle won’t kill MySQL
+1 Vote Up -0Vote Down
Join 15,000 others and follow Sean Hull on twitter @hullsean. 1. MySQL does not compete with Oracle It’s a myth that MySQL somehow poses a threat to Oracle. Oracle’s customers tend to be large enterprises running apps like e-business suite. These are certified to run on Oracle, and further they sit close to finance. MySQL […]
3 Simple Patterns for Tighter MySQL Code
+0 Vote Up -0Vote Down

Join 8000 others and follow Sean Hull on twitter @hullsean. SQL is derided by many and for good reason. It’s key to scalability yet terribly difficult to write good code. Here’s a few quick tips to write tighter queries in MySQL 1. Get rid of those Subqueries! Subqueries are a standard part of SQL, unfortunately […]

The post 3 Simple Patterns for Tighter MySQL Code appeared first on Scalable Startups.

MySQL Subquery Optimization
+0 Vote Up -0Vote Down
Join 7000 others and follow Sean Hull on twitter @hullsean. MySQL’s optimizer can do a lot of things, but subqueries are not always handled well. Take a look at the IN subquery below. If you see the DEPENDENT SUBQUERY in your explain plan, you may want to take a second look. This will run slow [...]
3 Ways to Optimize for Paging in MySQL
+0 Vote Up -0Vote Down
Join 6100 others and follow Sean Hull on twitter @hullsean. Lots and lots of web applications need to page through information. From customer records, to the albums in your itunes collection. So as web developers and architects, it’s important that we do all this efficiently. Start by looking at how you’re fetching information from your [...]
MySQL for Devs, DBAs and Debutantes
+0 Vote Up -2Vote Down
Join 6500 others and follow Sean Hull on twitter @hullsean. I just received my copy of the 5th Edition of Paul DuBois’ MySQL tomb. Weighing in at 1153 pages, it’s a solid text, with a very thorough introduction to the topic of administering MySQL databases. Buy the book here: MySQL 5th Edition by Paul Dubois [...]
How to Optimize MySQL UNION For High Speed
+0 Vote Up -1Vote Down
Join 6100 others and follow Sean Hull on twitter @hullsean. There are two ways to speedup UNIONs in a MySQL database. First use UNION ALL if at all possible, and second try to push down your conditions. [mytweetlinks] 1. UNION ALL is much faster than UNION How does a UNION work? Imagine you have two [...]
The Most Important AWS Feature for Performance and Scalability
+0 Vote Up -3Vote Down
Join 6100 others and follow Sean Hull on twitter @hullsean. The Foundation of Speed All servers use disk to store files. Operating system libraries, webserver & application code, and most importantly databases all use disk constantly. So disk speed is crucial to server speed. [mytweetlinks] [quote] Disk speed is crucial for MySQL databases. It has [...]
No tools to reconcile MySQL with two masters
+0 Vote Up -0Vote Down
Here’s the last nail in the coffin. We hope this convinces you not to write to multiple masters with MySQL replication. Reason 10 – No tools to reconcile inconsistent masters For all the endless reasons we’ve already outlined MySQL replication is prone to failure. We know it’s going to happen, you now know too. When [...]
Temp tables can break replication
+0 Vote Up -0Vote Down
If you’re not convinced yet that writing to dual masters is a bad idea, we have a couple more reasons. 9. Temp tables break replication after restart MySQL’s replication is sensitive to temporary tables. You shouldn’t use them. If your queries create them to work against, and a node crashes, the temp tables will be [...]
Crashed nodes corrupt your MySQL cluster
+0 Vote Up -0Vote Down

Read the original article at Crashed nodes corrupt your MySQL cluster

Writing to two masters is like walking around with a loaded shotgun. Eventually one of your instances will fail and when it does, replications position & synchronization information could easily become corrupt! Reason 8 – Crashed nodes cause big problems MySQL instances, unfortunately can crash. When that happens, they don’t always sync the replication position [...]

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

Related posts:
  • MySQL Cluster In The Cloud – Managers Guide
  •   [Read more...]
    Transaction isolation breaks when writing two masters
    +0 Vote Up -0Vote Down

    Read the original article at Transaction isolation breaks when writing two masters

    Continuing our discussion of multi-master replication, we hit on five more reasons why writing to two masters aka active-active replication is very dangerous. Click through to the end for multi-master solutions that work with MySQL. Reason 6 – You lose transaction isolation This may sound like a theoretical point to some. But hopefully we can [...]

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

    Related posts:
  • MySQL needs single master to check data integrity
  •   [Read more...]
    Active-active replication reduces operational flexibility
    +0 Vote Up -0Vote Down

    Read the original article at Active-active replication reduces operational flexibility

    Among the myriad data integrity and corruption risks associated with active-active replication, you also lose out on configurability and operational flexibility. Reason 7 – Can’t add nodes easily The often touted solution to use auto_increment_increment and auto_increment_offset fixes you to a given setup forever. You can set it up with a discrete two nodes, all [...]

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

    Related posts:
  • 10 reaons active-active is hard and how to solve it
  •   [Read more...]
    How to make MySQL multi-master work for you
    +0 Vote Up -0Vote Down

    Read the original article at How to make MySQL multi-master work for you

    Coming soon! Want more? Grab our Scalable Startups monthly for more tips and special content. Here’s a sample Related posts:Transaction isolation breaks when writing two masters MySQL requires an authoritative master to build slaves MySQL needs single master to check data integrity A master isn’t born but made Why does MySQL replication fail?

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

    Related posts:
  • Transaction isolation breaks when writing two masters
  •   [Read more...]
    MySQL needs single master to check data integrity
    +0 Vote Up -0Vote Down

    Read the original article at MySQL needs single master to check data integrity

    MySQL slaves can drift out of sync. Many of our clients are surprised to find some data differences in their replication topology, once we do some checking and sniffing around. Such checks require a single reliable or authoritative master to compare against. Click through to the end for multi-master solutions that work with MySQL. Reason [...]

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

    Related posts:
  • MySQL requires an authoritative master to build slaves
  •   [Read more...]
    MySQL requires an authoritative master to build slaves
    +0 Vote Up -0Vote Down

    Read the original article at MySQL requires an authoritative master to build slaves

    In MySQL database operations, you often need to rebuild slaves. They fail for a lot of different reasons, fall out of sync or crash. When this happens you may find you need to reclone and start fresh. This is normally done by finding your authoritative master database, and doing a hotbackup. Click through to the [...]

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

    Related posts:
  • Limitations of MySQL row-based replication
  • Why does MySQL replication
  •   [Read more...]
    Limitations of MySQL row-based replication
    +0 Vote Up -0Vote Down

    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:
  • Why does MySQL replication fail?
  • 5
  •   [Read more...]
    10 reaons active-active is hard and how to solve it
    +0 Vote Up -0Vote Down

    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:
  • Why does MySQL replication fail?
  •   [Read more...]
    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:
  • 5 Ways to fortify MySQL replication
  • Easy MySQL replication with
  •   [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:
  • Why you should attend Percona Live 2012
  • Hacking Job Search – Three Meaty Ideas
  • 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:
  • Oracle DBA Interview Questions
  • Cloud Operations Interview
  •   [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:
  • 5 Ways to Boost MySQL Scalability
  • 5 Ways to fortify MySQL replication
  •   [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:
  • 5 Ways to Avoid EC2 Outages
  • 7 Ways to Troubleshoot MySQL
  •   [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:
  • Ten things to remember about MySQL backups
  • Easy MySQL replication with hotbackups
  •   [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:
  • Migrating MySQL to Oracle Guide
  • MySQL Cluster In The Cloud – Managers Guide
  •   [Read more...]
    Showing entries 1 to 30 of 107 Next 30 Older Entries

    Planet MySQL © 1995, 2014, 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.