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 15

Displaying posts with tag: MySQL HA (reset)

MaxScale 0.7.0 Overview and Highlights
+1 Vote Up -0Vote Down

MaxScale 0.7.0 was recently released (it is the 4th alpha, with the beta on the near horizon), and is available for download here.

The release contains a number of new enhancements as well as 8 bugs fixes.


  • Galera Support: Enhanced support for Galera cluster to allow Galera to be used as a High Available Cluster with no write contention between the nodes. MaxScale will control access to a Galera Cluster such that one node is designated as the master node to which all write operations will be sent. Read operations will be sent to any of the remaining nodes that are part of the cluster. Should the currently elected master node fail MaxScale will automatically promote one of the remaining nodes to become the new master node.
  • Multiple Slave
  •   [Read more...]
    MaxScale 0.6.0 Overview and Highlights
    +1 Vote Up -0Vote Down

    MaxScale 0.6.0 was recently released (it is the 3rd alpha, with the beta on the near horizon), and is available for download here.

    The particular release only contains 2 great additions and 2 important fixes (and note development continues with the 1.0 (GA) features, but these have not been put into this alpha version).

    Important Additions:

  • A feature-complete read/write splitting module, i.e. read and write operations are now balanced in a smarter way to master or slave servers.
  • New client-based features, such as a version string that provides compatibility with the major connectors, the ability to connect through the root user and the use of the Unix socket when MaxScale is co-located with a client application on the same server.
  • Important Bug

      [Read more...]
    Third party solutions for master-master replication in MySQL
    +0 Vote Up -0Vote Down
    Two of the more popular solutions are  MySQL Master HA and Percona Replication Manager. MySQL Master HA MHA is based on a set of Perl scripts that monitors for replication and server health. When a failover scenario will happen, it Continue reading →   [Read more...]
    DNSaaS application MySQL HA solution with Percona XtraDB Cluster (Galera)
    +2 Vote Up -0Vote Down
    I haven't written in a while. Some of the reason is that life has been incredibly busy with two young children. The other reason is that I've been busy at work with my team developing HP Cloud DNS, a service that runs in the cloud, as do the various other applications within the Platform as a Service group that I am part of. After a period of rapid development and deployment, Cloud DNS recently went into private beta . The ability to build an cloud application such as this was primarily that I have a great team (Kiall Mac Innes, Simon McCartney and a great product manger Josh Barry) as well as having chosen the right tools and software solutions. For the deployment side of things, Chef, despite frustrations that I have had before getting my mind around it, was a solution that I knew would make it so we could deploy anywhere, as well as being  [Read more...]
    MySQL®-Vorträge ab morgen bei der DOAG 2012 Konferenz + Ausstellung
    +1 Vote Up -2Vote Down

    Codership, SkySQL und weitere Top-Experten rund um das Thema ‘MySQL Datenbanken” in Nürnberg versammelt

    Unser Kollege Ralf Gebhardt ist dieses Jahr mit einem Vortrag zum Thema ‘Hochverfügbarkeitslösungen für die MySQL Datenbank’ auf der DOAG Konferenz zu hören und zu sehen. Weitere Interessante Themen sind z.B. ein Vortrag von Coderships Seppo Jaakola zu ‘Galera Cluster - synchronous multi-master replication for MySQL’.

    Wir freuen uns auf Ihren Besuch beim MySQL-Stream der DOAG 2012 Konferenz!

    read more

    MySQL cloud database deployments via online configurator - free AWS trial
    +1 Vote Up -2Vote Down

    SkySQL™ Cloud Data Suite now comes with 4 nodes system on AWS

    Plus: AWS tips & tricks, updated administration console, new video tour & more

    As with all new open source software products, updates are a continuous process and we’ve been busy since the launch of the SkySQL™ Cloud Data Suitelast September! Here is a snapshot of the latest developments with our Cloud Data Suite, a collection of software components that provides a highly available database solution in a cloud environment, based on MySQL & MariaDB, deployable in the Amazon Cloud, i.e. AWS.

    read more

    MySQL HA reloaded by Ivan Zoratti
    +1 Vote Up -0Vote Down

    MySQL HA reloaded – old tricks and cool new tools to guarantee high availability to your MySQL Servers by Ivan Zoratti of SkySQL. This talk is a little longer, so check out: HA Reloaded – many ways to provide High Availability. The slides are already online.

    Questions to ask: which level of high availability do I need? Do I require no loss of data? Do I need failover or is switchover enough? Can I provide a reasonable service when a component is down? Remember, five nine’s high availability also means a lot of infrastructure costs.

    Other things to clarify: availability vs scalability. HA costs. HA for your entire architecture, not just for your database servers. Review your SLAs.

      [Read more...]
    HA Reloaded – Many ways to provide High Availability
    +2 Vote Up -0Vote Down

    High Availability is one of the hottest topics for MySQL DBAs. As a matter of fact, when we (SkySQL) are called by users and customers, the top two questions for our PS team are:

  • How can I make my MySQL database scalable?
  • How can I make my MySQL database highly available
  • Since MySQL is the most used online database, these two questions are totally appropriate. Although the two concepts walk together, they should not be confused.

    We refer to scalability when we define that a system must sustain a specific workload, measured in different ways – response time, latency, transactions or operations per second to name few, or a combination of them. So, we define the level of scalability we want to achieve and we design a system that can scale to that level.

    We refer to high availability when we define

      [Read more...]
    Multi-master and read slaves using Severalnines
    +1 Vote Up -0Vote Down
    This blog post shows how you can use the Severalnines Configurator for MySQL Replication to deploy a Multi-master replication setup, and install ClusterControl.
    You can also watch videos showing what is described below or read an even more detailed tutorial.

    When the deployment is finished you have a set of tools to manage and monitor replication, as well as to add new slaves, and to perform

      [Read more...]
    Setting up Multi-master and read slaves using Severalnines
    +0 Vote Up -0Vote Down

    Read the detailed replication tutorial instead.

    This tutorial shows how you can use the Severalnines Configurator for MySQL Replication to deploy a Multi-master replication setup, and install ClusterControl.

    When the deployment is finished you have a set of tools to manage and monitor replication, as well as to add new slaves, and to perform failover.
    You can choose:

      [Read more...]
    3-Steps to Deploying Mission Critical Web & Telecoms Services
    Employee_Team +3 Vote Up -0Vote Down
    There are multiple architectures that can be used to achieve highly available database services, each differentiated by the levels of uptime they offer.  These architectures can be grouped into three main categories:
    - Data Replication
    - Clustered & Virtualized Systems
    - Shared-Nothing, Geographically-Replicated Clusters

    As illustrated in the figure below, each of these architectures offers progressively higher levels of uptime, which must be balanced against potentially greater levels of cost and complexity each incurs. 

    Simply deploying a high availability architecture is not a guarantee of actually delivering HA.  In fact, a poorly implemented and maintained shared-nothing cluster could easily deliver lower levels of availability than a simple data replication solution.


      [Read more...]
    High Availability & Clustering at MySQL Sunday
    Employee_Team +4 Vote Up -0Vote Down
    UPDATE: New room assignments for the MySQL Cluster and Replication Enhancements sessions

    With the MySQL Sunday event at Oracle Open World rapidly approaching, and registrations to the event 10x higher than originally forecast, I thought it would be a good time to highlight sessions that are specifically addressing MySQL high availability, including MySQL Cluster (http://www.mysql.com/products/database/cluster/) .

    You can see details and logistics of all of the sessions here

      [Read more...]
    Linux Open Administration Days 2010
    +0 Vote Up -0Vote Down

    So about 4 monts ago there was the crazy idea to start a new FOSS event in Belgium targeted at sysadmins.

    What started out as an event for local people to meet local people with some local speakers actually ended up being a small local event with some top international speakers on onfiguration mananagement and system administration mixed with a bunch of good local ones !

    I had the honour to open the conference with an extremely short version of the Devops talk I gave earlier last year.. extremely short as I knew that over the course of the weekend the topic would reoccur a lot.

    We had the first european talk on Chef, by Joshua Timberman, and we had Puppet talks amongst by Dan Bode from Puppetlabs and CFengine talks , devops was a frequently dropped word,

      [Read more...]
    HA MySQL, write scaling using Cluster to non-cluster replication
    +5 Vote Up -0Vote Down
    There are various setups and solutions to solve the problem of having redundant mysql masters and scaling writes on them. MySQL Cluster can be an alternative. Here is why and how:
    • No need to worry about DRBD failover and recovery times
    • No need to worry about potential data loss when failover from active master to standby master (has all binlog really been replicated over from the failed master?)
    • Writes go to any mysql server connected to the Cluster - thus writes are easy to scale
      The data nodes will then send the committed writes to every mysql server with --log-bin enabled.

      [Read more...]
    MySQL HA – Let’s take a look at Sequoia
    +0 Vote Up -0Vote Down
    MySQL HA: 1. Desirable – most of the time, 2. Needed – often enough, 3. Available – there are some good options out there. Typical solutions consist of: Heartbeat with DRBD on Linux. Although HB was introduced to Linux, it can be used on Solaris, FreeBSD and others without the DRBD but with other solutions. Sun Cluster, Veritas (commercial), MySQL Proxy (still in [...]
    Showing entries 1 to 15

    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.