Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
acqant
@acqant
how is initial replication setup handled? What if I install the master and make db's first? How does the slave know what the master position is?
Phil Cohen
@phlipper
@acqant you’ll want to make sure to look at the node["percona"]["server"]["replication”] settings, and possibly node["percona"]["server"]["role”]. The master can exist first, as mysql replication is asynchronous. Take a look at the mysql replication docs for more info on that. I hope that helps. feel free to ask more questions if needed
acqant
@acqant
I have it working but I didn't know what logic the slave used for putting master position and master logfile in.
Amit Kashyap
@k8amit
Hi there,
I am trying to do mysql percona replication using chef
I get this warning message
WARN: found a directory data_bags in the cookbook path, but it contains no cookbook files. skipping.
and then Unable to load password for root, mysql,fall back to non-encrypted password
however data_bag "passwords" exists with items mysql and system
Charles C.
@asciifaceman
Just wanted to say I love the percona cookbook.
Phil Cohen
@phlipper
@k8amit sorry I missed this. were you able to resolve your issue?
@asciifaceman thank you very much!
Amit Khare
@adkhare
hey phlipper
can u give the documentation to use the cookbook for percona xtradb cluster?
2015-10-29 18:30:54 3715 [ERROR] WSREP: failed to open gcomm backend connection: 22: Group not defined in URL: pc://10.23.0.42,10.23.0.43,10.23.0.44?gmcast.group=: 22 (Invalid argument)
at gcomm/src/gmcast.cpp:GMCast():102
2015-10-29 18:30:54 3715 [ERROR] WSREP: gcs/src/gcs_core.cpp:gcs_core_open():206: Failed to open backend connection: -22 (Invalid argument)
2015-10-29 18:30:54 3715 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_open():1379: Failed to open channel '' at 'gcomm://10.23.0.42,10.23.0.43,10.23.0.44': -22 (Invalid argument)
2015-10-29 18:30:54 3715 [ERROR] WSREP: gcs connect failed: Invalid argument
2015-10-29 18:30:54 3715 [ERROR] WSREP: wsrep::connect(gcomm://10.23.0.42,10.23.0.43,10.23.0.44) failed: 7
config file:
binlog_format = ROW
wsrep_provider = /usr/lib/libgalera_smm.so
wsrep_provider_options =
wsrep_cluster_address = gcomm://10.23.0.42,10.23.0.43,10.23.0.44
wsrep_slave_threads = 2
wsrep_cluster_name =
wsrep_sst_method = rsync
wsrep_node_name = mysql-xtradb001
wsrep_notify_cmd =
wsrep_sst_receive_address = 10.23.0.42:4444
innodb_locks_unsafe_for_binlog = 0
innodb_adaptive_hash_index = 1
innodb_io_capacity = 2000
innodb_read_io_threads = 6
innodb_write_io_threads = 6
innodb_adaptive_flushing = ON
innodb_autoinc_lock_mode = 2
bind-address = ["10.23.0.42"]