I would like to know as well as I'm still running PgSQL locally and want to move that to one of my MySQL clusters running Percona.
As far as I know it should not be any problem, have you tested it already ? Thanks, Matt Op zondag 2 april 2017 15:40:30 UTC+2 schreef Lang, Jason: > > Hey All, > > > > Is anyone running Foreman with Galera? I’ve had my lab environment > (1.13.3) running on a 3 node MariaDB 10.1 Galera cluster for the past few > weeks and haven’t noticed any issues thus far. I haven’t seen anything in > the way of “official/listed” support, and reading into Galera, there > “should” be no issues other than if Foreman didn’t support innodb, or used > tables without keys. I’ve also googled a bit and found a few threads that > seemed to indicate “it should work” and “let us know if it doesn’t” but > they are older posts at this point. > > > > That begs my question, is anyone using it? Long-term? Any issues, gotchas? > Most importantly, is there any reason I shouldn’t use it in my production > environment? Our foreman environment currently has ~8600 servers reporting > in which translates to quite a few DB calls during normal operation. We’ve > been using mysql’s built in replication until now – but are looking to > upgrade to using Galera if possible for better seamless ha/failover between > our 3 datacenters. > > > > Finally, if it’s a bad idea, I’m definitely open to suggestions/advice on > an HA/load balanced database solution that might be better suited for > Foreman? > > > > Thanks for any and all feedback, advice, and suggestions > > > > ~Jason Lang > > The information contained in this message may be privileged, confidential > and protected from disclosure. If the reader of this message is not the > intended recipient, or an employee or agent responsible for delivering this > message to the intended recipient, you are hereby notified that any > dissemination, distribution or copying of this communication is strictly > prohibited. If you have received this communication in error, please notify > your representative immediately and delete this message from your computer. > Thank you. > -- You received this message because you are subscribed to the Google Groups "Foreman users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/foreman-users. For more options, visit https://groups.google.com/d/optout.
