Comments (6)
You're right, and yet the centos7.pp in examples seems to work for me under vagrant, which is a bit strange. Thanks for pointing this out.
from puppet-galera.
Hmm, this is spooky. I've been running this module for several weeks without issue, then yesterday I ran puppet against the "$galera_master" and the node went ahead and bootstrapped itself due to exactly this problem. Yikes.
It's a nasty bug as it left me with the remaining nodes in one cluster and one node in a new cluster. The cluster is frontended by haproxy and this continued to healthcheck all nodes successfully. The next result was that one in N queries was against a bad database!
ylockerman's workaround looks pretty solid, but does take significantly longer to timeout than 'nc -z'. It may be preferable to use something like tcping?
from puppet-galera.
Yep gonna change it to nmap or tcping I think.
from puppet-galera.
I looked into using nmap when I was writing my workaround. The issue I ran into is that nmap (and tcping) is not installed by default in Centos. Thus, if you use it, it seems like the package will need to be installed manually.
from puppet-galera.
Requiring packages isn't a big problem as long as they're in the standard repos or epel at least. I think nmap is in the base ones so that's probably better.
from puppet-galera.
@mf-lit you raise a good point as well - the timeouts (and maybe retries) probably need to be configurable so that a second of packet loss doesn't result in a bad bootstrap.
How's this to address the nc issue?
from puppet-galera.
Related Issues (20)
- creating databases using ::mysql:server HOT 2
- Add support for Percona XtraDB Cluster 8.0 HOT 2
- Module is unable to wait for cluster to sync HOT 3
- Ineffective use of ensure_resource for packages HOT 5
- Add support for Codership on MySQL 8.0
- Calls nmap with ip:port tuples instead of IP addresses HOT 3
- Doubt over Debian workaround HOT 2
- nmap command for checking cluster has wrong parameters (fix included) HOT 1
- broken /root/.my.cnf HOT 1
- mariadb repo conflict on el8 HOT 1
- Impossible to create my.cnf without enabling status check HOT 1
- Debian 11 support is broken HOT 3
- Not possible to unset default variables HOT 1
- puppetlabs-mysql v13.2.0 incompatible with default value of galera::package_ensure
- Wrong folder Rights with RH 8.6 and mariadb HOT 1
- Depcrated Function in use
- Module breaks with certain "root_password"s due to not being shell-escaped HOT 1
- binlog_format drop from default data breaks Galera-Node service restart HOT 2
- MariaDB 11.x is currently unsupported
- Percona XtraDB 8.0 on Ubuntu 24.04 is unsupported
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 puppet-galera.