fuel-library/deployment/puppet/galera
Sergii Golovatiuk 989a64693a Enable xtrabackup methods for Galera SST
- Enable xtrabackup as SST method for Galera
- Turn off perfomance_schema on
- Remove old openssl packet
- Slightly decrease RAM for innodb_buffer_pool_size
- Set 1M buffer for send/recieve socket for socat to
  speed up SST between nodes

Change-Id: I9b0b5eee6deab366324f1f808e32f64e290b444e
Implements: bp/galera-improvements
Closes-Bug: 1354479
2014-08-21 15:07:21 +00:00
..
files/ocf Monitor Galera loss quorum condition 2014-08-12 15:53:59 +00:00
lib/facter Tune mysql and galera backend settings on scale 2014-03-19 14:36:03 +02:00
manifests Enable xtrabackup methods for Galera SST 2014-08-21 15:07:21 +00:00
spec Refactor Galera module 2014-07-22 07:41:45 +00:00
templates Enable xtrabackup methods for Galera SST 2014-08-21 15:07:21 +00:00
.gitignore Allow metadata.json 2013-01-10 15:18:41 +04:00
.project cleaning up galera manifests: docs and obsolete code 2013-06-28 18:15:40 +04:00
Gemfile Refactor Galera module 2014-07-22 07:41:45 +00:00
Modulefile Refactor Galera module 2014-07-22 07:41:45 +00:00
README Initial commit 2012-09-07 17:38:58 -07:00
Rakefile Refactor Galera module 2014-07-22 07:41:45 +00:00

README

This is a good start to play around with the galera multi-master mysql synchronous replication (http://www.codership.com/products/mysql_galera)

HOWTO:

 * play around (add a database and data, chaos-monkey nodes etc.)


WARNING

Change the mysql root password in production and limit access to galera cluster members!

TODO

 * naming: master -> donor
 * put a load balancer in front of the cluster
 * make cluster "masterless"

nodes.pp

# nodes
$cluster_name = 'wsrep_galera_cluster'

node /mysql-db-01/ {
    class { 'galera' :
        cluster_name => $cluster_name
    }
}

node /mysql-db-0([2-9])/ {
    $master_ip = '172.18.67.254'
    class { 'galera' :
        cluster_name => $cluster_name,
        master_ip    => $master_ip
    }
}