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 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 118 Next 30 Older Entries

Displaying posts with tag: ha (reset)

MySQL now provides support for DRBD
Employee +5 Vote Up -0Vote Down

Oracle has announced that it now provides support for DRBD with MySQL – this means a single point of support for the entire MySQL/DRBD/Pacemaker/Corosync/Linux stack! As part of this, we’ve released a new white paper which steps you through everything you need to do to configure this High Availability stack (http://www.mysql.com/why-mysql/white-papers/mysql_wp_drbd.php). The white paper provides a step-by-step guide to installing, configuring, provisioning and testing the complete MySQL and DRBD stack, including:

  • MySQL Database
  • DRBD kernel module and userland utilities
  • Pacemaker and Corosync cluster messaging and management processes
  • Oracle Linux operating system

DRBD is an extremely popular way of adding a layer of High

  [Read more...]
Replication and auto-failover made easy with MySQL Utilities
Employee +3 Vote Up -1Vote Down

If you’re a user of MySQL Workbench then you may have noticed a pocket knife icon appear in the top right hand corner – click on that and a terminal opens which gives you access to the MySQL utilities. In this post I’m focussing on the replication utilities but you can also refer to the full MySQL Utilities documentation.

What I’ll step through is how to uses these utilities to:

  • Set up replication from a single master to multiple slaves
  • Automatically detect the failure of the master and promote one of the slaves to be the new master
  • Introduce the old master back into the topology as a new slave and
  [Read more...]
MySQL Connect 8 Days Away - Replication Sessions
Employee_Team +3 Vote Up -0Vote Down

Following on from my post about MySQL Cluster sessions at the forthcoming Connect conference, its now the turn of MySQL Replication - another technology at the heart of scaling and high availability for MySQL.

Unless you've only just returned from a 6-month alien abduction, you will know that MySQL 5.6 includes the largest set of replication enhancements ever packaged into a single new release:

- Global Transaction IDs + HA utilities for self-healing cluster..(yes both automatic failover and manual switchover available!)

- Crash-safe slaves and binlog

- Binlog Group Commit and Multi-Threaded Slaves for high

  [Read more...]
Automated MySQL Master Failover
+1 Vote Up -0Vote Down
After the GitHub MySQL Failover incident a lot of blogs/people have explained that fully automated failover might not be the most optimal solution.

Fully automated failover is indeed dangerous, and should  be avoided if possible. But a complete manual failover is also dangerous. A fully automated manually triggered failover is probably a better solution.

A synchronous replication solution is also not a complete solution. A split-brain situation is a good example of a failure which could happen. Of course most clusters have all kinds of safe guard to prevent that, but unfortunately also safe guards can fail.

Every failover/cluster should be considered broken unless:
  • You've tested the failover scripts and procedures
  • You've tested the failover scripts and procedures under normal load
  • You've tested the failover scripts







  •   [Read more...]
    MySQL Cluster to InnoDB Replication Howto
    +6 Vote Up -0Vote Down

    In this blog post I will show you how to setup a replication from MySQL Cluster  (ndbcluster) to a regular MySQL Server (InnoDB). If you want to understand the concepts, check out part 7 of our free MySQL Cluster training.

    First of all we start with a MySQL Cluster looking like this, and what we want to do is to setup replication server to the Reporting Server (InnoDB slave).



    0 0 1 125 713 Severalnines AB 5 1 837 14.0 Normal 0 false false false EN-US JA X-NONE






      [Read more...]
    MySQL 5.6 Replication: FAQ
    Employee_Team +2 Vote Up -0Vote Down
    0 0 1 1207 6881 Homework 57 16 8072 14.0 Normal 0 false false false EN-GB JA X-NONE

    On Wednesday May 16th, we ran a webinar to provide an overview of all of the new replication features and enhancements that are previewed in the MySQL 5.6 Development Release – including Global Transaction IDs, auto-failover

      [Read more...]
    Meet the MySQL Experts Podcast: MySQL Replication Global Transaction Identifiers & HA Utilities
    Employee_Team +3 Vote Up -0Vote Down
    0 0 1 223 1273 Homework 10 2 1494 14.0 Normal 0 false false false EN-US JA X-NONE

    In the latest episode of our “Meet The MySQL Experts” podcast, Luis Soares, Engineering Manager of MySQL

      [Read more...]
    Upcoming webinar: MySQL 5.6 Replication – For Next Generation of Web and Cloud Services
    Employee +5 Vote Up -0Vote Down

    MySQL 5.6 Replication - Global Transaction IDs

    On Wednesday (16th May 2012), Mat Keep and I will be presenting the new replication features that are previewed as part of the latest MySQL 5.6 Development Release. If you’d like to attend then register here (http://mysql.com/news-and-events/web-seminars/display-711.html" target="_blank).

    MySQL 5.6 delivers new replication capabilities which we will discuss in the webinar:

    • High performance with Multi-Threaded Slaves and
      [Read more...]
    Running multiple MySQL instances in parallel
    +0 Vote Up -0Vote Down

    I know, I haven’t been posting much lately. 5.5 upgrades got postponed due to the new storage platform needing my immediate attention and being a speaker at the Percona Live conference in April also needs a lot of attention.

    One of the things I want to try out is running multiple MySQL instances on the same machine. The concept remained in the back of my mind ever since I attended Ryan Thiessen’s presentation on the MySQL conference 2011 but we never actually got a proper usecase for it. Well, with the new storage platform it would be really beneficial so an excellent use case to try it out! So what have I been

      [Read more...]
    The Full Monty – Version 2
    +0 Vote Up -0Vote Down

    Installing MySQL on CentOS 6.2 with PaceMaker, MHA and more

    When I work with High Availability software, I’m reminded of the maze in the original computer adventure game “You are Lost in a maze of twisty-turny passages all alike…”.

    If you search the web for HA programs you will find many well maintained projects all related that refer each other. The goal of this document is to give you with a step by step guide to a production worthy MySQL system. It should provide at least 99.999% access to your data and be able to scale read requests as you grow.

    I have chosen these programs and utilities because they are free (as in beer) and each has enterprise support available. (When you make the money to pay for it.) If you start with this MySQL platform you will

      [Read more...]
    The State of High Availability
    +0 Vote Up -0Vote Down
    Searching for the Holly GrailFor months I have been writing and rewriting an blog post called “The Full Monty”. It’s a kind of how to build complete production system from scratch. I’m still not done. Maybe I’m fullish thinking I can build a one type fits all database server. But that’s not the problem. I’ve found myself chasing the Holly Grail of HA and replication.I’ve build many virtual clusters with all the HA / replication package I could find. I’ve tried DRBD, Heartbeat,  Multi  [Read more...]
    MySQL Cluster training Jan 24 - 26 in DC
    +2 Vote Up -0Vote Down

    We still have a few seats left for our MySQL Cluster training in Washington DC January 24 - 26. If you're interested in learning about MySQL Cluster, the architecture, how to install it, administer it and troubleshoot it this is the course for you. The course will also cover replication and optimization and we will also discuss the exciting new features coming in version 7.2 of MySQL Cluster. For more information about the course contents visit http://www.skysql.com/services/training/courses/administering-mysql-cluster and to sign up to the course go to http://www.skysql.com/services/training/schedule/administering-mysql-cluster-1.

    See you there!

     

    What’s new in MySQL 5.6 Replication – free webinar
    Employee +6 Vote Up -0Vote Down

    Global Transaction IDs - simplifying replication management

    There will be a webinar this Wednesday where you can get the latest information on all of the great new content that has been included in the MySQL 5.6 Development Releases as well as some features that are still being developed. As always, the webinar is free but you need to register here (http://www.mysql.com/news-and-events/web-seminars/display-677.html" target="_blank) in advance. Even if you can’t attend the live event it’s worth registering so that you get sent the replay.

    Some of the topics

      [Read more...]
    MySQL HA Solutions – webinar replay
    Employee +1 Vote Up -0Vote Down

    If you were unable to attend the live webinar (or you want to go back and listen to it again) then it’s now available to view on-line here.

    Databases are the center of today’s web and enterprise applications, storing and protecting an organization’s most valuable assets and supporting business-critical applications. Just minutes of downtime can result in significant lost revenue and dissatisfied customers. Ensuring database highly availability is therefore a top priority for any organization. Tune into this webcast to learn more.

    The session discusses:

      [Read more...]
    Replication stars
    +3 Vote Up -0Vote Down
    Working with replication, you come across many topologies, some of them sound and established, some of them less so, and some of them still in the realm of the hopeless wishes. I have been working with replication for almost 10 years now, and my wish list grew quite big during this time. In the last 12 months, though, while working at Continuent, some of the topologies that I wanted to work with have moved from the cloud of wishful thinking to the firm land of things that happen. My quest for star replication starts with the most common topology. One master, many slaves.

    Fig 1. Master/Slave topology

      [Read more...]
    Have you ever heard about “Read Masters” in MySQL??? Enterprise ready SchoonerSQL provides it.
    +0 Vote Up -8Vote Down

    Typical MySQL environment involves one Master receiving writes and multiple slaves to scale the reads.The “slave” term has been used in MySQL because the Slave servers have to perform every task in copying from the Master binlog, then updating their relay logs and finally committing to the Slave databases. The Master plays no role in replication here other than storing the replication events in the binlog.
    With this kind of Master- Slave set up, there are several limitations-
    -       Slave lag-       Stale or old data-       Data loss-       Manual failover which is error-prone and time consuming
    In SchoonerSQL, there is no concept of “Slaves” inside synchronous cluster. We refer to it as "Read Masters"



      [Read more...]
    MySQL Cluster 7.2 (DMR2): NoSQL, Key/Value, Memcached
    Employee_Team +0 Vote Up -0Vote Down
    0 0 1 977 5569 Homework 46 13 6533 14.0 Normal 0 false false false EN-US JA X-NONE

    70x Higher Performance, Cross Data Center Scalability and New NoSQL Interface

    Its been an exciting week for all involved with MySQL Cluster, with the announcement of the

      [Read more...]
    MySQL Cluster 7.2 (DMR2): NoSQL, Key/Value, Memcached
    Employee_Team +1 Vote Up -0Vote Down
    0 0 1 977 5569 Homework 46 13 6533 14.0 Normal 0 false false false EN-US JA X-NONE

    70x Higher Performance, Cross Data Center Scalability and New NoSQL Interface

    Its been an exciting week for all involved with MySQL Cluster, with the announcement of the

      [Read more...]
    Synchronously Replicating Databases Across Data Centers – Are you Insane?
    Employee_Team +0 Vote Up -0Vote Down
     

    Well actually….no. The second Development Milestone Release of MySQL Cluster 7.2 introduces support for what we call “Multi-Site Clustering”. In this post, I’ll provide an overview of this new capability, and considerations you need to make when considering it as a deployment option to scale geographically dispersed database services.

    You can read more about MySQL Cluster 7.2.1 in the article posted on the MySQL Developer Zone

    MySQL Cluster has long offered Geographic Replication, distributing clusters to remote data centers to reduce the affects of geographic latency by pushing data closer to the user, as well as providing a capability for

      [Read more...]
    Synchronously Replicating Databases Across Data Centers – Are you Insane?
    Employee_Team +4 Vote Up -0Vote Down
     

    Well actually….no. The second Development Milestone Release of MySQL Cluster 7.2 introduces support for what we call “Multi-Site Clustering”. In this post, I’ll provide an overview of this new capability, and considerations you need to make when considering it as a deployment option to scale geographically dispersed database services.

    You can read more about MySQL Cluster 7.2.1 in the article posted on the MySQL Developer Zone

    MySQL Cluster has long offered Geographic Replication, distributing clusters to remote data centers to reduce the affects of geographic latency by pushing data closer to the user, as well as providing a capability for disaster

      [Read more...]
    MySQL HA Solutions: New Guide Available
    Employee_Team +0 Vote Up -0Vote Down
    0 0 1 271 1547 Homework 12 3 1815 14.0 Normal 0 false false false EN-US JA X-NONE

    Databases are the center of today’s web, enterprise and embedded applications, storing and protecting an organization’s most valuable assets and supporting business-critical applications. Just minutes

      [Read more...]
    MySQL HA Solutions: New Guide Available
    Employee_Team +5 Vote Up -0Vote Down
    0 0 1 271 1547 Homework 12 3 1815 14.0 Normal 0 false false false EN-US JA X-NONE

    Databases are the center of today’s web, enterprise and embedded applications, storing and protecting an organization’s most valuable assets and supporting business-critical applications. Just minutes

      [Read more...]
    SkySQL adds MySQL Cluster training to the offering
    +1 Vote Up -0Vote Down
    Very soon after SkySQL Ab was created, we added an Advanced MySQL Cluster course to our training offering. This addition was made as a customer who was already quite experienced with MySQL cluster wanted training. This course was, however, deemed to be too complex and with too much pre-requisites to add to our public offering so it was left as a special treat for customers who had deep cluster knowledge. We decided that we would instead create a more general purpose MySQL Cluster course with less prerequisite knowledge required as soon as possible.
    Many months have passed and a lot of other courses have been created since, but we now finally release our version of a general purpose MySQL Cluster training course, called Administering MySQL Cluster. As the name suggests this 3-day course
      [Read more...]
    Oracle Enhances MySQL Manageability on Windows
    Employee_Team +2 Vote Up -0Vote Down

    Windows is a major development and deployment platform for MySQL. A few months ago, we held our first MySQL Online Forum, dedicated to MySQL on Windows. We outlined then why MySQL was a great fit for the Windows environment, and what were the upcoming milestones to make MySQL even better on the Microsoft platform.

    We’re now pleased to announce that two important milestones have been completed:

    1. The New MySQL Installer for Windows is GA

    The MySQL Installer for Windows radically simplifies the installation process for all MySQL users on the Windows platform.

      [Read more...]
    Oracle Enhances MySQL Manageability on Windows
    Employee_Team +0 Vote Up -0Vote Down

    Windows is a major development and deployment platform for MySQL. A few months ago, we held our first MySQL Online Forum, dedicated to MySQL on Windows. We outlined then why MySQL was a great fit for the Windows environment, and what were the upcoming milestones to make MySQL even better on the Microsoft platform.

    We’re now pleased to announce that two important milestones have been completed:

    1. The New MySQL Installer for Windows is GA

    The MySQL Installer for Windows radically simplifies the installation process for all MySQL users on the Windows

      [Read more...]
    MySQL with Windows Server 2008 R2 Failover Clustering
    Employee +6 Vote Up -0Vote Down

    Windows Server 2008 R2 Failover Clustering

    Oracle has announced support for running MySQL on Windows Server Failover Clustering (WSFC); with so many people developing and deploying MySQL on Windows, this offers a great option to add High Availability to MySQL deployments if you don’t want to go as far as deploying MySQL Cluster.

    This post will give a brief overview of how to set things up but for all of the gory details a new white paper MySQL with Windows Server 2008 R2 Failover Clustering

      [Read more...]
    London 18th October: Oracle Technology Network MySQL Developer Day
    Employee +5 Vote Up -0Vote Down

    I will be presenting on MySQL Cluster and MySQL Replication at the Oracle Technical Network MySQL Developer day in London on Tuesday, 18 October 2011 (8:30 AM – 4:00 PM). It’s free but you need to register here while there are still places (attendance has been extremely high at other locations).

    The MySQL Developer Day is a one-stop shop for you to

      [Read more...]
    My sessions at Oracle OpenWorld 2011
    Employee +6 Vote Up -0Vote Down

    Slight adjustment to some of the times + added the MySQL community reception (read  vodka!). Oracle OpenWorld (San Francisco) starts on Sunday 2nd October (including some MySQL community sessions) through Thursday 6th October. MySQL has a lot of sessions this year as well as 3 demo booths.

    This year I’m going to be involved in 3 public sessions – if you’re attending, please come along and say hello!

    • Getting the Most Out of MySQL on Windows – 13:15 on Tuesday (Marriott Marquis – Golden Gate C2)
    • Building Highly Available and Scalable Real-Time
      [Read more...]
    LRU follow up
    +0 Vote Up -0Vote Down

    Due to one of the machines being configured a little bit too close to the edge we had to restart it to downsize its innodb_buffer_pool_size a little bit. We tested the innodb_lru_dump_restore directive with this machine. Results were very promising: it wrote the dump every 5 minutes (we set the variable to 300 seconds) and after MySQL had restarted it reloaded the dump.

    However: since MySQL is already started fully before it even starts to load the LRU dump it means MySQL is already available to the outside world. This means in a HA environment it would already be going to perform poorly due to the torrent of queries coming in. This means either the loading of the LRU dump needs to be done up front by a change in Percona Server or we need to alter MMM not to do anything with the server untill it has loaded the LRU dump.

    Challenges, challenges…


    Tagged:
      [Read more...]
    The Full Monty – Scientfic Linux 6.1, drbd, PaceMaker, MySQL, Tunsten Replication and more
    +0 Vote Up -0Vote Down

    PART 1 – This will be a multi part post.

    THIS DOCUMENT IS BEING UPDATED – PLEASE WATCH FOR CHANGES!

    After years of supporting MySQL, for many different companies, I’ve seen this story played out again and again.
    The company:

    • chooses a Database Management System (MySQL)
    • installs the DBMS on a computer with other processes
    • writes many programs to access the data (Without concern on how the queries are written.)
    • moves DBMS to a computer of its own and writes more programs
    • buy bigger computer to run the DBMS and writes more programs
    • tires of DBMS response times and outages caused by developers working on production systems and hires a Database Administrator to fix the mess

    This is a step by step description of  how I


      [Read more...]
    Previous 30 Newer Entries Showing entries 31 to 60 of 118 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.