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 123 Next 30 Older Entries

Displaying posts with tag: ha (reset)

MySQL 5.6 Replication Webinar
Employee +3 Vote Up -0Vote Down

Update – the recording of this webinar is now available here.

This Wednesday (27th March) Mat Keep and I will be presenting a free, live webinar on MySQL 5.6 Replication. You need to register here (http://www.mysql.com/news-and-events/web-seminars/mysql-5-6-replication-enabling-next-generation-of-web-mobile-social-and-cloud-services/" target="_blank) ahead of the webinar – worth doing even if you can’t attend as you’ll then be sent a link to the replay when it’s available. We’ll also have some of the key MySQL replication developers

  [Read more...]
MySQL 5.6 Replication: New Resources for Database Scaling and HA
Employee_Team +8 Vote Up -0Vote Down
MySQL 5.6 reached GA (General Availability) today and is packed with a wealth of new features and capabilities.  Exciting stuff!
MySQL 5.6 also introduces the largest set of enhancements to replication ever delivered in a single release, including: - 5x higher performance to improve consistency across a cluster and reduce the risks of data loss in the event of a master failing - Self-healing clusters with automatic failover and recovery from outages or planned maintenance - Assured data integrity with checksums implemented across the replication workflow - DevOps automation
Of course, getting started with all of these enhancements can be a challenge - whether you are new to MySQL replication or an experienced user. So two new Guides are available to help take advantage of

  [Read more...]
Deep Dive into GTIDs and MySQL 5.6 - What, Why and How
Employee_Team +6 Vote Up -0Vote Down

Global Transaction Identifiers (GTIDs) are one of the key replication enhancements in MySQL 5.6. GTIDs make it simple to track and compare replication across a master - slave topology. This enables:

- Much simpler recovery from failures of the master,

- Introduces great flexibility in the provisioning and on-going management of multi-tier or ring (circular) replication topologies.

A new on-demand MySQL 5.6 GTID webinar (http://www.mysql.com/news-and-events/web-seminars/mysql-replication-simplifying-scaling-and-ha-with-gtids/) delivered by the replication engineering team is now available, providing deep insight into the design and implementation of GTIDs, and how they enable users to simplify MySQL scaling and HA. The webinar covers:

- Concepts: What is

  [Read more...]
Overwhelming response from the MySQL community in Barcelona
+4 Vote Up -0Vote Down

Within hours of my post about meeting the MySQL community in Barcelona, we got several offers to help, and within one day, an event was created and agreed upon.

Thanks!

Today the event was posted at Evenbrite. It will take place on Tuesday, November 13th, at 7pm. It will be a one hour talk about State of the art in MySQL high availability and replication, followed by one hour of Q&A, networking, beer, and snacks.

Registration is necessary, because the seats are limited. If you want to attend, you should register as soon as possible!

New Options for MySQL High Availability
Employee_Team +2 Vote Up -0Vote Down

Data is the currency of today’s web, mobile, social, enterprise and cloud applications. Ensuring data is always available is a top priority for any organization – minutes of downtime will result in significant loss of revenue and reputation.

There is not a “one size fits all” approach to delivering High Availability (HA). Unique application attributes, business requirements, operational capabilities and legacy infrastructure can all influence HA technology selection. And then technology is only one element in delivering HA – “People and Processes” are just as critical as the technology itself.

For this reason, MySQL Enterprise Edition (http://www.mysql.com/products/enterprise/) is available supporting a range of HA solutions, fully certified and supported by Oracle. MySQL Enterprise HA

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