[Maria-discuss] Galera cluster will not bootstrap with SST set to use TLS

2021-04-23 Thread lejeczek
Hi Guys. I wonder if anybody sees the same or similar issues which I do experience with SST, or maybe could try to reproduce it simply by: [sst] tkey = /etc/my.cnf.d/certs/sst/sst.key tcert = /etc/my.cnf.d/certs/sst/sst.crt Yes, by having SST to use TLS. If I do have those two params in my

[Maria-discuss] Galera Cluster Behind NAT

2020-07-15 Thread battossai
Hi, Kindly need help regarding setting up MariaDB Galera Cluster between 2 datacenter. I think i have problem that IST transfer is trying to connect to ip private only, in fact this server behind router. I have DNAT ip public to tcp 4568 to that server, but the donor still want connected to ip

[Maria-discuss] Galera cluster for databases replication over three servers

2017-07-11 Thread Martin LEUSCH
Hi, I'm setting up a new mail infrastructure withe 3 servers running Debian Jessie, data can be read or write from these 3 servers at any time. I chosed Galera with with MariaDB 10.2 to share databases between servers for services like AMAVIS, dovecot, ... I had a lot of errors in my logs (almost

Re: [Maria-discuss] Galera Cluster on FreeBSD

2016-06-02 Thread Brian Evans
On 6/2/2016 2:48 PM, Niklaas Baudet von Gersdorff wrote: > Brian Evans [2016-06-02 09:04 -0400] : > >> This is https://jira.mariadb.org/browse/MDEV-9757 > Oh, no. That's a pity. I eventually wanted to switch from MySQL. I'll > subscribe to the bug report. Thanks for linking to it! > > Niklaas

Re: [Maria-discuss] Galera Cluster on FreeBSD

2016-06-02 Thread Niklaas Baudet von Gersdorff
Brian Evans [2016-06-02 09:04 -0400] : > This is https://jira.mariadb.org/browse/MDEV-9757 Oh, no. That's a pity. I eventually wanted to switch from MySQL. I'll subscribe to the bug report. Thanks for linking to it! Niklaas ___ Mailing list:

Re: [Maria-discuss] Galera Cluster on FreeBSD

2016-06-02 Thread Brian Evans
On 6/2/2016 8:50 AM, Niklaas Baudet von Gersdorff wrote: > > 160602 14:32:22 [ERROR] mysqld got signal 6 ; > This could be because you hit a bug. It is also possible that this binary > or one of the libraries it was linked against is corrupt, improperly built, > or misconfigured. This error can

Re: [Maria-discuss] Galera Cluster on FreeBSD

2016-06-02 Thread Niklaas Baudet von Gersdorff
Guillaume Lefranc [2016-06-02 08:05 +] : > in MariaDB 10.1, Galera replicator needs to be explicitely enabled. Try > adding this to your configuration file: > > wsrep_on=ON Great, thanks for mentioning that! Unfortunately though, I end up with an error and MariaDB fails to start. I have the

Re: [Maria-discuss] Galera Cluster: Cluster Blocked, when one node down?

2015-12-14 Thread Jamie Gibbard
port, but ready for action! -Original Message- From: Maria-discuss [mailto:maria-discuss-bounces+jamie.gibbard=netnames@lists.launchpad.net] On Behalf Of Benoit Panizzon Sent: 14 December 2015 08:31 To: MariaDB discuss Subject: [Maria-discuss] Galera Cluster: Cluster Blocked, when

Re: [Maria-discuss] Galera Cluster: Cluster Blocked, when one node down?

2015-12-14 Thread Guillaume Lefranc
cuss [mailto:maria-discuss-bounces+jamie.gibbard= > netnames@lists.launchpad.net] On Behalf Of Benoit Panizzon > Sent: 14 December 2015 08:31 > To: MariaDB discuss > Subject: [Maria-discuss] Galera Cluster: Cluster Blocked, when one node > down? > > Hello > > We use M

[Maria-discuss] Galera Cluster: Cluster Blocked, when one node down?

2015-12-14 Thread Benoit Panizzon
Hello We use MariaDB Galera Cluster for our email service platform. We decided to use Galera to create a high availability platform. After a year of operation, we start to relaize, that somehow Galera Failures seem to be the most common cause for outages we had in the past. So I wonder if

[Maria-discuss] Galera cluster as slave: Duplicate entry errors

2014-09-05 Thread Otto Berger
Hi all, i'm new to this list :) My setup: MySQL Server 5.5.37 - Replication - Galera 10 Cluster (currently 2 nodes) The old MySQL Master is receiving inserts to a table with a auto_increment field (primary key). The Galera Cluster is configured as classic slave to the master. From time to

Re: [Maria-discuss] Galera cluster as slave: Duplicate entry errors

2014-09-05 Thread Otto Berger
Hmm, maybe an idea by myself on the cause: the initial sync to galera was done as followed: - dump on the (locked) master - inserted the dumps on a galera node - started replication (change master to...) with the saved state of the master I've read somewhere that galera handles the

[Maria-discuss] Galera Cluster: Do we need binlogs? How to limit the space used by binlogs?

2014-08-07 Thread Benoit Panizzon
Hello We have quite a busy MariaDB operating in a Galera cluster. The Size of the database is not that large, about 2GB. We get several GB of Binlogs per day as we get a lot of transactions (busy mailserver with Bayes DB and a lot of timestamps being updated) I have set: expire_logs_days

Re: [Maria-discuss] Galera Cluster: Do we need binlogs? How to limit the space used by binlogs?

2014-08-07 Thread Pim Rupert (Lemonbit)
Hello Benoit, On 07 Aug 2014, at 10:50, Benoit Panizzon benoit.paniz...@imp.ch wrote: We have quite a busy MariaDB operating in a Galera cluster. The Size of the database is not that large, about 2GB. We get several GB of Binlogs per day as we get a lot of transactions (busy mailserver with

Re: [Maria-discuss] Galera cluster with asynchronous slave

2014-07-04 Thread Johnny Antonsen
On 04. juli 2014 10:44, erkan yanar wrote: Ahoi Johnny, Ahoi there :) On Thu, Jul 03, 2014 at 02:16:26PM +0200, Johnny Antonsen wrote: Got fatal error 1236 from master when reading data from binary log: 'Error: connecting slave requested to start from GTID 3-1-422, which is not in the

Re: [Maria-discuss] Galera cluster with asynchronous slave

2014-07-04 Thread erkan yanar
On Fri, Jul 04, 2014 at 02:56:56PM +0200, Johnny Antonsen wrote: On 04. juli 2014 10:44, erkan yanar wrote: Ahoi Johnny, Ahoi there :) On Thu, Jul 03, 2014 at 02:16:26PM +0200, Johnny Antonsen wrote: Got fatal error 1236 from master when reading data from binary log: 'Error: connecting

[Maria-discuss] Galera cluster with asynchronous slave

2014-07-03 Thread Johnny Antonsen
Hi! First off let show you what we are trying to achieve: Galera Cluster: MariaDBNode1 - HAProxy - keepalived - MariaDBNode2 - HAProxy - keepalived - MariaDB Slave node with GTID MariaDBNode3 - HAProxy - keepalived - I'm currently working on a high-availability project where we want to use

Re: [Maria-discuss] Galera cluster

2013-09-20 Thread Jan Lindström
Hi, hummm nice, after the merge... will 10.0 have galera code? or still a different branch? 2013/9/19 Sergei Golubchik s...@mariadb.org Hi, Roberto! On Sep 19, Roberto Spadim wrote:

Re: [Maria-discuss] Galera cluster

2013-09-19 Thread Sergei Golubchik
Hi, Roberto! On Sep 19, Roberto Spadim wrote: Hi guys, the galera cluster code is inside default mariadb-10.0.4 code? or there's a different branch for galera cluster? Different branch. There is mariadb-5.5-galera tree. It was merged into 10.0, but as far as I know, the merge is not quite

[Maria-discuss] Galera cluster

2013-09-19 Thread Roberto Spadim
Hi guys, the galera cluster code is inside default mariadb-10.0.4 code? or there's a different branch for galera cluster? -- Roberto Spadim ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net

Re: [Maria-discuss] Galera cluster

2013-09-19 Thread Roberto Spadim
hummm nice, after the merge... will 10.0 have galera code? or still a different branch? 2013/9/19 Sergei Golubchik s...@mariadb.org Hi, Roberto! On Sep 19, Roberto Spadim wrote: Hi guys, the galera cluster code is inside default mariadb-10.0.4 code? or there's a different branch for