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

Displaying posts with tag: scalability (reset)

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...]
    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...]
    MySQL thread pool and scalability examples
    +2 Vote Up -0Vote Down
    Nice article about SimCity outage and ways to defend databases: http://www.mysqlperformanceblog.com/2013/03/16/simcity-outages-traffic-control-and-thread-pool-for-mysql/

    The graphs showing throughput with and without the thread pool are taken from the benchmark performed by Oracle and taken from here:
    http://www.mysql.com/products/enterprise/scalability.html (http://www.mysql.com/products/enterprise/scalability.html)

    The main take away is this graph (all rights reserved to Oracle, picture original URL (http://www.mysql.com/common/images/enterprise/MySQL_Threadpool_Benchmark_RW.png" target="_blank)):

    Scalability is






      [Read more...]
    MariaDB Galera Cluster is a unique technology worth testing
    +2 Vote Up -0Vote Down

    As alway with new technology there is always different approaches regarding the adoption. You can try to use the bleeding edge features or start with a very standard configuration. My personal advise to new users is to start with the most basic configuration.

    This allow you to get familiar with the fundamentals : - how [...]

    How scalable is your database?
    +1 Vote Up -1Vote Down

    Most of the time, when people say “scalability” they mean any of dozens of things. Most of the time, when I say it I mean exactly one precisely defined thing. However, I don’t claim that’s the only correct use of “scalability.” There is another, in particular, that I think is very important to understand: the inherent limitations of the system. This second one doesn’t have a single mathematical definition, but it’s vital nonetheless.

    I’ll frame the discussion by asking this: how scalable is your database?

    Using the two definitions I like to use the most, I answer the question in this way.

  • Scalability in terms of the Universal Scalability Law is the degree to which you can add more workers (or units of hardware) and get equal
  •   [Read more...]
    Forthcoming webinar: Strategies for scaling MySQL
    +0 Vote Up -0Vote Down

    On February 28 at 1pm EST I’ll be taking part in a webinar, sponsored by ScaleBase, on strategies for scaling MySQL.

    Scalability is one of the primary drivers we’ve seen for database users considering alternatives to traditional relational databases. That could mean adopting an entirely new database for new projects or – more likely for existing applications – looking at various strategies for improving the scalability of an existing database.

    During the webinar I will be joined by Doron Levari and Paul Campaniello, both from ScaleBase, which enables applications to scale without disruption to the existing infrastructure. We’ll be discussing, amongst other things:

    • Scaling-out your MySQL databases
    • New
      [Read more...]
    10 Newer Entries Showing entries 31 to 40 of 187 10 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.