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 9

Displaying posts with tag: Galera cluster (reset)

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 9

    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.