Comments (5)
During my testing I found out that the latest release of percona doesn't support wsrep_urls
parameter. It need to be replaced with wsrep_cluster_address
in wsrep.cnf
. There are some more enhancement w.r.t to xtrabackup settings in the new release. I will provide a PR after testing is complete.
from chef-bach.
For reference, the error one sees will be akin to the following on the slave MySQL instance's /var/lib/mysql/$(hostname).err
:
2014-11-28 21:53:33 15077 [Note] WSREP: Service thread queue flushed.
2014-11-28 21:53:33 15077 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not ma
tch group state UUID (dff6f979-776f-11e4-8483-070d8ff82f5c): 1 (Operation not permitted)
at galera/src/replicator_str.cpp:prepare_for_IST():456. IST will be unavailable.
...
2014-11-28 21:53:49 15077 [Note] WSREP: Member 0.0 (bcpc-vm1) synced with group.
WSREP_SST: [ERROR] xtrabackup process ended without creating '/var/lib/mysql//xtrabackup_galera_info' (20141128 21:53:49.483)
WSREP_SST: [INFO] Contents of datadir (20141128 21:53:49.490)
WSREP_SST: [INFO] -rw-rw---- 1 mysql mysql 8656 Nov 28 21:34 /var/lib/mysql//graphite/account_mygraph.frm
from chef-bach.
I just made a bunch of commits to BCPC to migrate to using wsrep_cluster_address
that might be helpful:
- bloomberg/chef-bcpc@ec6ec426b23dec87cc6d9480af700a43869803c3
- bloomberg/chef-bcpc@196862af8e66e7368b236747a259d070543c578b
- bloomberg/chef-bcpc@16243cd72683d8aaef654e936d7b2d705a07426c
from chef-bach.
Changing wsrep_sst_method
to use xtrabackup-v2
seem to bring up the mysql cluster. Raised PR #42 for that and noticed the (early morning!!) update from @pchandra which includes this change.
@cbaenziger , if we are cherry picking the commits from chef-bcpc, we can close the new PR or I can add the additional changes into it.
from chef-bach.
Thanks @pchandra for providing changes for this issue. I have merged your changes into PR #43 with a slight difference in the method name that we use to get all the MySQL nodes. I did test the replication on all MySQL instances and it works fine.
from chef-bach.
Related Issues (20)
- Remove HBase StochasticLoadBalancer property overrides
- wait-for-hosts loops forever until the user manually connects to serial consoles HOT 1
- Zookeeper Znodes Continually Growing
- 2.6.5 repos broken
- Update Chef-Server 12 Permissions HOT 2
- mysql service should bind to the floating ip rather than management ip
- leftover test file prevents code from running HOT 3
- Schema upgrade needs to be manually fixed on clusters that were init'd before 1.2.1000 HOT 3
- MySQL via the VIP broken in master HOT 3
- cluster-assign-roles fails with Net:SSH:HostKeyMismatch when rebuilding cluster HOT 4
- Master broken looking for missing recipe bcpc-hadoop::hdfs_web HOT 2
- Master fails to populate node[:bcpc][:hadoop][:hs_hosts] HOT 2
- HDFSDU adds lots of extra execution time to chef runs HOT 1
- Automatic iPXE booting from Cobbler HOT 2
- configure_kerberos usage and using HOT 3
- Master broken for testing simultaneous clusters HOT 1
- Extend BACH web page to cover more services HOT 1
- Update site xml with Generated value HOT 1
- HDFSDU compiles every chef run on the bootstrap
- increase hive audit logging
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from chef-bach.