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 19

Displaying posts with tag: Galera cluster (reset)

9 Tips for Going in Production with Galera Cluster for MySQL
+0 Vote Up -0Vote Down
August 25, 2014 By Severalnines

Are you going in production with Galera Cluster for MySQL? Here are 9 tips to consider before going live. These are applicable to all 3 Galera versions (Codership, Percona XtraDB Cluster and MariaDB Galera Cluster). 

 

1. Galera strengths and weaknesses

 

There are multiple types of replication and cluster technologies for MySQL, make sure you understand how Galera works so you set the right expectations.

  [Read more...]
Automation & Management of MariaDB Galera Clusters: New European Webinars with SkySQL - The MariaDB Company
+0 Vote Up -0Vote Down
August 21, 2014 By Severalnines

MariaDB Galera Cluster involves more effort and resource to administer than standalone MariaDB systems. If you would like to learn how to better manage your MariaDB cluster, then this webinar series is for you. 

 

We will give you practical advice on how to introduce clusters into your MariaDB / MySQL  environment, automate deployment and make it easier for operational staff to manage and monitor the cluster using ClusterControl.

 

Language, Date & Time: 

 

English - Tuesday, September 30th @ 11am CEST:

  [Read more...]
Abdel-Mawla Gharieb: Galera Cluster VS PXC VS MariaDB Galera Cluster - Benchmarking
+2 Vote Up -0Vote Down

It is not clear for many MySQL users that Percona XtraDB Cluster (PXC) and MariaDB Galera Cluster depend on the same Galera library i.e used in Galera Cluster for MySQL which is provided by Codership team:

  • Galera Cluster: MySQL Server (by Oracle) + Galera library.
  • Percona XtraDB Cluster: Percona Server + Galera library.
  • MariaDB Galera Cluster: MariaDB Server + Galera library.

But the question is, are there any performance differences between the three of them ?

Let's

  [Read more...]
We’d love to go to Paris for the OpenStack Summit - please vote for our talks!
+0 Vote Up -0Vote Down
August 6, 2014 By Severalnines

 

Well over a thousand sessions have been submitted for the OpenStack Summit and two of them includes our good selves! We’ve submitted two talks with partners of ours: 

 

… and would love it if the talks were included in the final agenda. For that to happen, we need a few

  [Read more...]
MariaDB: Selective binary logs events
+0 Vote Up -0Vote Down

In the first post in a series on MariaDB features we find interesting, we begin with selectively skipping replication of binlog events. This feature is available on MariaDB 5.5 and 10.

By default when using MySQL’s standard replication, all events are logged in the binary log and those binary log events are replicated to all slaves (it’s possible to filter out some schema). But with this feature, it’s also possible to bypass some events to be replicated on the slave(s) even if they are written in the binary log. Having those event in the binary logs is always useful for point-in-time recovery.

Indeed, usually when we need to not replicate an

  [Read more...]
A schema change inconsistency with Galera Cluster for MySQL
+0 Vote Up -0Vote Down

I recently worked on a case where one node of a Galera cluster had its schema desynchronized with the other nodes. And that was although Total Order Isolation method was in effect to perform the schema changes. Let’s see what happened.

Background

For those of you who are not familiar with how Galera can perform schema changes, here is a short recap:

  • Two methods are available depending on the value of the wsrep_OSU_method setting. Both have benefits and drawbacks, it is not the main topic of this post.
  • With TOI (Total Order Isolation), a DDL statement is performed at the same point in the replication flow on all nodes, giving strong guarantees that the schema is always identical on all nodes.
  • With RSU (Rolling Schema Upgrade), a DDL statement is not replicated to the other nodes.
  [Read more...]
MariaDB Galera Cluster 10 is now stable (GA)
+5 Vote Up -1Vote Down

A much awaited release from the MariaDB project is now stable (GA) – MariaDB Galera Cluster 10.0.12. This is a complete merge of MariaDB 10.0.12 and Galera Cluster, with additional features and bug fixes. This gives you the entire power of Galera Cluster as well as the benefits of all the MariaDB 10 features

This is the fourth release in the 10.0 Galera Cluster series, and for more changes, please review the

  [Read more...]
New Webinar on July 9th: How To Set Up SQL Load Balancing with HAProxy
+1 Vote Up -0Vote Down
June 17, 2014 By Severalnines

 

We continuously see great interest in MySQL load balancing and HAProxy, so we thought it was about time we organised a live webinar on the topic!

 

As most of your will know, database clusters and load balancing go hand in hand. 

 

Once your data is distributed and replicated across multiple database nodes, a load balancing mechanism helps distribute database requests, and gives applications a single database endpoint to connect to. 

 

Instance failures or

  [Read more...]
Webinar Replay, Slides & Q&A: Introducing ClusterControl 1.2.6 - Managing your MySQL, MariaDB & MongoDB Clusters
+0 Vote Up -0Vote Down
May 19, 2014 By Severalnines

 

Thanks to everyone who attended and participated last week’s joint webinar on ClusterControl 1.2.6! We had great questions from participants (thank you), most of which are transcribed below with our answers to them.

 

If you missed the sessions or would like to watch the webinar again & browse through the slides, they are now available online.

 

Webinar topics discussed: 

  • Database Infrastructure Lifecycle
  • Deploy, Monitor, Manage,
  [Read more...]
New Release Webinar on May 13th: Introducing ClusterControl 1.2.6 - Live Demo
+0 Vote Up -0Vote Down
May 7, 2014 By Severalnines

 

Following the release of ClusterControl 1.2.6 a couple of weeks ago, we are now looking forward to demonstrating this latest version of the product on Tuesday next week, May 13th.

 

This release contains key new features (along with performance improvements and bug fixes), which we will be demonstrating live during the webinar. 

 

Highlights include:

  • Centralized
  [Read more...]
Abdel-Mawla Gharieb: Setting the right GCache size in Galera Cluster
+0 Vote Up -0Vote Down

One of our customers had a question related to the right value of Galera Cache size (gcache.size) in Galera Cluster for MySQL which I would like to share with you.

The question was: My maintenance window takes 4 hours for my 5TB DB. How can I avoid an SST ?!

Basically, having too small GCache size will lead to SST (Snapshot State Transfer) instead of IST (Incremental State Transfer), thus we can avoid the SST by setting the GCache to the appropriate value.

To check the current value of the GCache size:

mysql> SHOW GLOBAL VARIABLES LIKE 'wsrep_provider_options'\G Variable_name: wsrep_provider_options Value: base_host = 192.168.1.12; . . . gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; . . .

The value


  [Read more...]
9 Reasons For Attending The Percona Live MySQL Conference & Expo 2014
+0 Vote Up -0Vote Down
March 28, 2014 By Severalnines

 

Percona Live MySQL Conference & Expo - March 31st to April 4th

The Severalnines Team Will Be Onsite at Booth 418 - Come Say Hello!

 

 

If you’re still thinking about whether or not you should be attending the Percona Live MySQL Conference & Expo that starts on Monday 31st of March, here are 9 reasons (we are Severalnines after all) on why we’ll be there. May these help you positively in

  [Read more...]
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...]
    Webinar Replay & Slides: Migrating to MySQL, MariaDB Galera and/or Percona XtraDB Cluster
    +0 Vote Up -0Vote Down
    March 13, 2014 By Severalnines

    Thanks to everyone who attended this week’s webinar; if you missed the sessions or would like to watch the webinar again & browse through the slides, they are now available online.

     

    Special thanks to Seppo Jaakola, CEO at Codership, the creators of Galera Cluster, and to Johan Andersson, CTO at Severalnines, for their presentations and the live demo.

     

    Webinar topics discussed: 

    • Application use cases for Galera
    • Schema design
    • Events and Triggers
    • Query design
    • Migrating the schema
    • Loading initial data into the
      [Read more...]
    Webinar: Migrating to MySQL, MariaDB Galera and/or Percona XtraDB Cluster
    +0 Vote Up -0Vote Down
    February 13, 2014 By Severalnines

     

    Galera is slowly but surely establishing itself as a credible replacement for traditional MySQL master-slave architectures. 

    The benefits are clear - a true multi-master InnoDB setup with built-in fail-over, potentially across data centers. 

    But how do you migrate? Does the schema or application change? What are the limitations? Can migration be done online, without service interruption? What are the potential risks, and how to address those?

     

    Webinar: Migrating to MySQL, MariaDB Galera and/or Percona XtraDB Cluster

     

    Tuesday, March

      [Read more...]
    Webinar Replay & Slides: Repair & Recovery for Your MySQL, MariaDB & MongoDB / TokuMX Clusters
    +0 Vote Up -0Vote Down
    January 23, 2014 By Severalnines

     

    Thanks to everyone who attended this week’s webinar; if you missed the sessions or would like to watch the webinar again and browse through the slides, they are now available online.

     

    Special thanks to Seppo Jaakola from Codership, the creators of Galera Cluster, for walking us through the various scenarios of Galera recovery. 

     

    Webinar topics discussed: 

    • Redundancy models for Galera, NDB and MongoDB / TokuMX
    • Failover & Recovery (Automatic vs Manual)
      [Read more...]
    Webinar Replay & Slides: Galera Cluster Best Practices - Zero Downtime Schema Changes
    +4 Vote Up -0Vote Down
    December 5, 2013 By Severalnines

     

    Thanks to everyone who attended yesterday’s webinar; if you missed the sessions or would like to watch the webinar again & browse through the slides, they are now available online.

     

    Thanks again to our speaker, Seppo Jaakola from Codership, the creators of Galera Cluster, for this in-depth talk on Galera Cluster Best Practices - Zero Downtime Schema

      [Read more...]
    Please test the MariaDB Galera Cluster Release Candidate
    +7 Vote Up -0Vote Down

    We released the release candidate for MariaDB Galera Cluster on 21st December 2012, not traditionally the best time to make a release. We want to make this a GA release soon and we also want to ensure its well tested. Download it. Read the release notes. Give us feedback/report bugs.  Blog about it too!

    Log Buffer #299, A Carnival of the Vanities for DBAs
    +0 Vote Up -0Vote Down
    Screenings, shows, premieres and parties. Where the stars have been spotted this week? No not on the red carpet in LA, but in this Log Buffer Edition. In Log Buffer #299, stars of Oracle, SQL Server and MySQL are twinkling. Get mesmerized!!! Oracle: Pythian’s very own Marc Fielding is revealing the hints behind the Automatic...
    Showing entries 1 to 19

    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.