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

Displaying posts with tag: Replication (reset)

How to Migrate Your Application to Amazon Virtual Private Cloud without Downtime
+0 Vote Up -0Vote Down
March 27, 2014 By Severalnines

With datacenters being stretched by resource-intensive applications, more and more businesses are outgrowing their existing in-house capacity and having to reconfigure their IT operations. But how do you migrate a busy application to a totally new data center without downtime? How will the application scale in a virtualized cloud environment? And how do you guard against cloud server failures and keep a high level of uptime?

 

 

In this example, we will show you how to migrate a Web application (Wordpress) from a local data center to a AWS VPC. Without downtime even! 

 

Main steps:

      [Read more...]
    MariaDB Eventually Consistent?
    +0 Vote Up -0Vote Down
    Background

    Eventual consistency is a consistency model used in many large distributed databases which requires that all changes to a replicated piece of data eventually reach all affected replicas; conflict resolution is not handled and responsibility is pushed up to the application author in the event of conflicting updates [13].

    Eventual consistency is a specific form of weak consistency; the storage system guarantees that if no new updates are made to the object, eventually all accesses will return the last updated value [14]. If no failures occur, the maximum size of the inconsistency window can be determined based on factors such as communication delays, the load on the system, and the number of replicas involved in the replication scheme [3].

    A few examples of eventually consistent systems:

    • DNS
    • Asynchronous master/slave replication on an RDBMS e.g.
      [Read more...]
    My Favorite MongoDB Replication Feature: Crash Safety
    +0 Vote Up -0Vote Down

    At an extremely high level, replication in MongoDB and MySQL are similar. Both databases have exactly one machine, the primary (or master), that accepts writes from clients. With a single transaction (or atomic operation, in MongoDB’s case), the tables and oplog (or binary log in MySQL) are modified to reflect the change. The log captures what the change is so other secondaries (or slaves) can read the changes and process them, making the slaves identical to the master. (Note that I am NOT talking about multi-master replication.)

    Underneath the covers, their implementations are quite different. And in peeking underneath the covers while developing TokuMX, I learned

      [Read more...]
    Advanced MySQL Replication Architectures and Latest Developments – free webinar
    Employee +1 Vote Up -0Vote Down


    This Thursday (20th March 2014) we’ll be hosted a free webinar covering advanced MySQL Replication topics as well as the latest developments. As always, the webinar is free but you need to register here (http://www.mysql.com/news-and-events/web-seminars/advanced-mysql-replication-architectures-and-latest-developments/" target="_blank) – even if you can’t join live, you’ll then be sent a link to the replay.

    More details on what to expect…

    The biggest Web sites in the


      [Read more...]
    Real-Time Data Loading from MySQL to Hadoop using Tungsten Replicator 3.0 Webinar
    +0 Vote Up -0Vote Down

    To follow-up and describe some of the methods and techniques behind replicating into Hadoop from MySQL in real-time, and how this can be combined into your data workflow, Continuent are running a webinar with me presenting that will go over the details and provide a demo of the data replication process.

    Real-Time Data Loading from MySQL to Hadoop with New Tungsten Replicator 3.0

    Hadoop is an increasingly popular means of analyzing transaction data from MySQL. Up until now mechanisms for moving data between MySQL and Hadoop have been rather limited. The new Continuent Tungsten Replicator 3.0 provides enterprise-quality replication from MySQL to Hadoop. Tungsten Replicator 3.0 is 100% open source, released under a GPL V2 license, and available for download at

      [Read more...]
    No application changes needed: 10 times faster slave with MariaDB 10 parallel replication
    +3 Vote Up -1Vote Down

    Parallel replication is in MariaDB 10.0. I did some benchmarks on the code in 10.0.9. The results are quite good! Here is a graph that shows a 10-times improvement when enabling parallel replication: The graph shows the transaction per second as a function of number of slave worker threads, when the slave is executing events from the master at full speed. The master binlog was generated with sysbench oltp.lua. When the binlog is enabled on the slave and made crash-safe (--sync-binlog=1 --innodb-flush-log-at-trx-commit=1), the slave is about ten times faster at 12 worker threads and above compared to the old single-threaded replication.

    These results are for

      [Read more...]
    The "once and for all" SHOW SLAVE STATUS log files & positions explained
    +1 Vote Up -0Vote Down

    True, GTID is upon us whether via MySQL 5.6 or Tungsten Replicator (and wasn't it in Google Patches since 2009?).

    But some of us are still using standard replication with MySQL 5.5, and the "what's with all these binary log files and positions" question is ever erupting. The output of SHOW SLAVE STATUS confuses people new to it. It confuses me time and again.

    So here's the semi visual guide to interpreting the SHOW SLAVE STATUS.

    About binary logs and relay logs

    A master writes binary logs. These are typically and conventionally called mysql-bin.##### or mysqld-bin.##### (replace ##### with digits).

    A slave connects to its master, and reads entries from the master's binary logs. The slave writes those entries into its own relay logs. These are

      [Read more...]
    Reports exaggerated
    Employee +1 Vote Up -0Vote Down
    I've been letting the blog rest recently, and not so recently as well.  The problem is not a lack of subjects, but a lack of time to do them any justice.  However it is quite sad to see that my last entry was in September 2012, so it is time to post again.

    Of late I have been pondering what I have to say about :
    • Distributed MVCC and write-scaling
    • Different approaches to eventual consistency with replicated RDBMS
    • Various MySQL Cluster related topics
    • Various general rambling and unstructured topics
    However, these will take some time to percolate and calcify.

    In the meantime here are some things I have found interesting recently :






      [Read more...]
    MySQL to Hadoop Step-By-Step
    +0 Vote Up -0Vote Down

    We had a great webinar on Thursday about replicating from MySQL to Hadoop (watch the whole thing). It was great, but one of the questions at the end was ‘is there an easy way to test’.

    Sadly we can’t go giving out convenient ready-to-run downloads of these things because of licensing and and other complexities, so I want to try and make it as simple and straightforward as possible by giving you the directions to complete. I’m going to be point to the Continuent Documentation every now and then so this is not too crowded, but we should get through it pretty easily.

    Major Decisions

    For this to work: 

    • We’ll setup two VMs, one the master
      [Read more...]
    MMUG6: Madrid MySQL Users Group meeting to take place on 20th March 2014
    +1 Vote Up -0Vote Down

    Madrid MySQL Users Group will have its next meeting on 20th March. Details can be found on the group’s Meetup page.

    I will be giving a presentation on MySQL replication hopefully aimed at all levels, but covering some details relevant to larger setups. The meeting will be in Spanish.

    Look forward to seeing you there.

    La próxima reunión de Madrid MySQL Users Group tendrá lugar el jueves 20 de marzo. Se puede encontrar más detalles en la página del grupo.  Ofreceré una presentación sobre replicación de MySQL dirigido a gente de todos los niveles, pero incluirá información relevante a entornos más grandes.  La presentación será en español.

    Espero veros allí.

    10 Newer Entries Showing entries 61 to 70 of 679 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.