Re: [Maria-discuss] rsync timeout?

Hi, On Tue, Nov 8, 2016 at 2:22 PM, l vic wrote: > Is it possible to increase rsync timeout? I checked > http://galeracluster.com/documentation-webpages/galeraparameters.html > but couldn't find corresponding parameters... > Currently, there is no way to configure rsync timeout other than editi

Re: [Maria-discuss] rsync failure?

ode1)(SYNCED) as donor. In my installation, I have used wsrep_node_name to assign names to the nodes. Best, Nirbhay > Thank you > > On Tue, Nov 8, 2016 at 11:04 AM, Nirbhay Choubey > wrote: > >> >> >> On Tue, Nov 8, 2016 at 10:50 AM, l vic wrote: &

Re: [Maria-discuss] rsync failure?

On Tue, Nov 8, 2016 at 10:50 AM, l vic wrote: > Have the rsync failure (see the trace below): > > 2016-11-08 15:17:34 139959897945856 [ERROR] WSREP: Failed to read 'ready > ' from: wsrep_sst_rsync --role 'joiner' --address 'node3.frame.mesos' > --datadir '/var/lib/mysql/' --parent '114' '' > R

Re: [Maria-discuss] wsrep-node-name vs. wsrep-node-address?

Hi, On Tue, Oct 25, 2016 at 10:26 AM, l vic wrote: > > Do I need to use "--wsrep-node-name" option with dns names to identify the > node in Galera cluster instead of "wsrep-node-address", or is the > "--wsrep-node-address=" supposed to work? > You should set wsrep-node-address. wsrep-node-name,

Re: [Maria-discuss] eviction in information_schema?

On Fri, Sep 30, 2016 at 11:00 AM, l vic wrote: > Does it mean "either/or", e.g. does it mean GLOBAL_STATUS table wouldn't > be updated if i use --wsrep-notify-cmd option? > For example, would WSREP_CLUSTER_SIZE be still updated after new node join > if I use --wsrep-notify-cmd option? > Yes, wsr

Re: [Maria-discuss] wsrep problem with dns names

On Tue, Oct 18, 2016 at 4:28 PM, l vic wrote: > I am trying to use dns hostnames vs. ip addresses in mariadb container > configuration: > --wsrep-cluster-address=gcomm://node1.cluster1.mesos,node2. > cluster1.mesos.. > --wsrep_node_address=node1.cluster1.mesos > --wsrep-new-cluster > .. > but i s

Re: [Maria-discuss] __转发：failed_to_connect_mariadb_at_addition_node_in_MariaDB_galera_cluster

ransfer. You can also use --wsrep-debug=ON to collect more details on both the nodes. Thanks, Nirbhay > > ---- > > > - 原始邮件 - > 发件人：Nirbhay Choubey > 收件人：zh1...@sina.com > 抄送人：maria-discuss , "yan-jack.chen

Re: [Maria-discuss] 转发：failed to connect mariadb at addition node in MariaDB galera cluster

Hi, On Thu, Sep 1, 2016 at 11:08 PM, 西门吹牛 wrote: > Hi, > I deployed two MariaDB galera version in two nodes to build cluster. But > I can’t connect MariaDB in second node as seems the port is not created by > MariaDB because looks like it is stuck somehow. > Version: mysqld 10.1.17-MariaDB-d

Re: [Maria-discuss] geo replication?

Among other settings, you can make use of WAN segments (gmcast.segment), outlined here : http://galeracluster.com/2015/07/geo-distributed-database-clusters-with-galera/ HTH - Nirbhay On Tue, Aug 23, 2016 at 10:38 AM, l vic wrote: > Thanks for the link but it seems to deal with "traditional"

Re: [Maria-discuss] Query the list of dynamic variables

On Thu, Aug 18, 2016 at 3:55 PM, Игорь Пашев wrote: > If there are way to query the list of dynamic variables, e. i. > variables that can be changed globally without restarting the server? > In 10.1, you can try I_S.system_variables, something like : SELECT VARIABLE_NAME FROM INFORMATION_SCHEMA

Re: [Maria-discuss] MariaDB 10.1.14 failure to initiate SST after RSU schema upgrade

Hi Mark, On Wed, Jul 20, 2016 at 10:38 AM, Mark Wadham wrote: > Hi, > > We have a repeatable failure to initiate IST with MariaDB 10.1.14 after > performing a schema upgrade on a single node in RSU mode. The error > condition is when there is a delete query in the format: > > delete from where

Re: [Maria-discuss] MariaDB 10.1.14 with galera results in Signal 11

-linux-gnueabihf/6.1.1/crtendS.o > /usr/lib/gcc/armv7l-unknown-linux-gnueabihf/6.1.1/../../../crtn.o > > So as it stands I can't get a "debug build" built. > > I have a further question: How do I tell scons that I want to build a > debug version of the galera shared library

Re: [Maria-discuss] MariaDB 10.1.14 with galera results in Signal 11

Hi Bill, The stack trace isn't useful. Did you build the server too? Could you try repeating this on a debug build? I would also advise you to file a bug at jira.mariadb.org. Best, Nirbhay On Wed, May 25, 2016 at 6:29 PM, Bill Mair wrote: > A new install and instance crashes when I try to star

Re: [Maria-discuss] How to translate between MariaDB 5.5 and 10.X

Hi Marco, On Thu, Jan 28, 2016 at 3:33 PM, Marco Nicosia wrote: > Hi! > > I noticed that wsrep_load_data_splitting has been introduced as a > configuration variable. Cool! I had missed this. > > I can see that a fix for it was shipped in MariaDB 10.0.23 >

Re: [Maria-discuss] MariaDB init.d Script Probable Bug in wait_for_ready()

Hi Joy! On Fri, Dec 25, 2015 at 6:33 AM, Joy Bhattacherjee < joy.bhattacher...@gmail.com> wrote: .. cut .. > This is reflected in my configuration as: > > *[mysqld]* > *datadir = /datadrive/galera/mysql * > *socket = /datadrive/galera/mysql/mysql.sock * > > You also need to set socket for your

Re: [Maria-discuss] enforce_storage_engine galera cluster

| ++ 1 row in set (0.00 sec) Do you get different results? Or your's is a different scenario altogether? Best, Nirbhay > > > On 21/12/2015 18:41, Nirbhay Choubey wrote: > > Hi! > > On Mon, Dec 21, 2015 at 12:23 PM, Michele Tota > wrote: > >>

Re: [Maria-discuss] enforce_storage_engine galera cluster

Hi! On Mon, Dec 21, 2015 at 12:23 PM, Michele Tota wrote: > Hi, > we have a problem using enforce_storage_engine variable set to InnoDB. > We have three servers in cluster (multi masters). > When we issue create table with engine=MyISAM the engine is correctly > enforced to InnoDB only on the no

Re: [Maria-discuss] Replication to galera cluster

On Tue, Nov 17, 2015 at 11:57 AM, Igor Mazur wrote: > Hi, > > I've tried to setup replication from production MariaDB (lets name proddb) > to a data warehouse on Galera cluster (dw1, dw2 and dwarbitrator - last is > a node with garb). > > Made master-slave link between proddb and dw1. And on dw1

Re: [Maria-discuss] MariaDB 10.0.22 now available

Hi Marco! MariaDB Galera 10.0.22 should be released in a couple of days. -- Nirbhay On Mon, Nov 16, 2015 at 1:32 PM, Marco Nicosia wrote: > Just a quick ping on this, as it is relevant to our work schedule. We have > traditionally depended on the combined 10.0 plus Galera releases. If > they'r

Re: [Maria-discuss] MariaDB version string in initial handshake

Hi! On Fri, Oct 16, 2015 at 8:12 PM, Felipe Gasper wrote: > Hi all, > > I’m seeing a version string like this from the server in the > initial handshake: > > 5.5.5-10.1.16-MariaDB > > Why does MariaDB negotiate with a different-format version string > than MySQL? Is this document

Re: [Maria-discuss] Mariadb galera cluster ipv6

Hi! On Sat, Oct 10, 2015 at 7:32 PM, Bertrand Caplet wrote: > Hey guys, > I trying to get up running a galera cluster with IPv6 > But right know, it's not working. > IPv6 isn't fully supported yet in Galera cluster. Galera library: https://github.com/codership/galera/issues/338 https://github.

Re: [Maria-discuss] writing plugin with .net language (C#)

Hello, On Sun, Oct 4, 2015 at 9:05 AM, Guillaume Lefranc < guillaume.lefr...@mariadb.com> wrote: > Hi Roberto, > > you could have a try at it with Golang, it can wrap C code easily > https://golang.org/cmd/cgo/ > > Though with Go1.5 its now possible, uninstalling the plugins still leads to segfau

Re: [Maria-discuss] Mariadb 10.1.6, total cluster recovery - gvwstate.dat

Hi Max, On Thu, Aug 13, 2015 at 7:17 AM, Max Zulio wrote: > Hi, > > I am using a Mariadb 10.1.6 three node cluster with wsrep. There is a > gvwstate.dat file created in /var/lib/mysql, but in the log file when > restarting the nodes I see: [Warning] WSREP: access file(gvwstate.dat) > failed(No s

Re: [Maria-discuss] Can't connect to local MySQL server through socket

On Wed, Jun 24, 2015 at 9:30 AM, Sylvain Raybaud < sylvain.rayb...@green-communications.fr> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 24/06/2015 15:11, Guillaume Lefranc wrote: > > Sylvain, > > > > On Wed, Jun 24, 2015 at 3:06 PM, Sylvain Raybaud > > >

Re: [Maria-discuss] garb: unrecognized service

Hi, On Tue, Apr 21, 2015 at 5:41 AM, Umarzuki Mochlis wrote: > $ sudo service garb start > garb: unrecognized service > > After I installed galera-3, the above error appeared when I tried to > start garb service. > >From 3.9, garbd has moved to galera-arbitrator-3 package. Best, Nirbhay > OS

Re: [Maria-discuss] mariadb-galera-server : Depends: mariadb-galera-server-10.0 (= 10.0.17+maria-1~trusty) but it is not going to be installed

Hi! On Fri, Mar 27, 2015 at 5:07 AM, Umarzuki Mochlis wrote: > Hi, > > Error as title happened when I'm following > > http://www.severalnines.com/blog/howto-offline-upgrade-galera-cluster-mysql-56-or-mariadb-10 > to upgrade from 5.5 to 10.0 > > Repos > > /etc/apt/sources.list.d/MariaDB.list > de

Re: [Maria-discuss] MariaDB 10.0.16 now available

So, you should be good. By the way, we have not yet released galera-25.3.9 packages, planning to release them in upcoming MariaDB Galera cluster release. Best, Nirbhay > > Thanks, > > Raina and Lyle > Cloud Foundry Services Team > > On Tue, Feb 3, 2015 at 3:15 PM, Nirbhay Chou

Re: [Maria-discuss] R: Re: Switch from rsync to xtrabackup

Hello, On Wed, Feb 18, 2015 at 3:40 AM, absolutely_f...@libero.it < absolutely_f...@libero.it> wrote: > > Hi, > thank you for your reply. > What is the correct order for this step? > For example: > > 1) shutdown node 1 > 2) change config to xtrabackup-v2 on node 1 > 3) restart node 1? > 4) shutd

Re: [Maria-discuss] Switch from rsync to xtrabackup

Hi! On Tue, Feb 17, 2015 at 6:07 AM, absolutely_f...@libero.it < absolutely_f...@libero.it> wrote: > Hi, > I am using two nodes (Debian 7.8 64bit) with MariaDB > (mariadb-galera-server 5.5.41) and garbd on a third node. > > > Now I'm using rsync method, I would like to switch to xtrabackup to avo

Re: [Maria-discuss] MariaDB 10.0.16 now available

Hi! On Tue, Feb 3, 2015 at 5:25 PM, Raina Masand < cf-core-services-...@pivotal.io> wrote: > Hello, > > We are looking to use Galera 25.3.9 with our MariaDB cluster, which claims > to improve the stability of communication between nodes in the event of > network flakiness. Do you know if it will

Re: [Maria-discuss] Password Complexity Plugin

Hi Adam, On Thu, Jan 22, 2015 at 5:03 PM, Adam Scott wrote: > Hi, > > I noticed MySQL 5.6 has a validate_password plugin. Since it's > open-source, can we add it to MariaDB 5.5. Or is that bad form, a hot > potato, etc.? > > We need the features of this plugin in our environment, and the PAM >

Re: [Maria-discuss] pid file could not be found

Hi Sandro, On Fri, Nov 14, 2014 at 3:48 AM, Roth, Sandro < sandro.r...@zurich-airport.com> wrote: > Hi there > > > > I’m having a weird problem after a fresh installation of RHEL6 and MariaDB: > > > > [root@server ~]# yum install MariaDB-10.1.1-centos6-x86_64-server.rpm > MariaDB-10.1.1-centos6-

Re: [Maria-discuss] Dots in filenames of configuration files - !includedir weirdness

Hi! On Fri, Oct 24, 2014 at 6:54 AM, Geoff Montee wrote: > I've noticed some strange behavior that might be a bug in the current > implementation of the !includedir directive for my.cnf files. I wanted to > get the opinion of the MariaDB community on whether this is working as > intended before

Re: [Maria-discuss] Possible? upgrading gallera cluster without service interruption

Hi! On Tue, Sep 30, 2014 at 8:42 AM, Benoit Panizzon wrote: > Hello > > We would like to upgrade from 5.5.33a+maria-1~saucy to > 5.5.39+maria-1~saucy on > a running cluster without service interruption. > > So we took down one node, upgraded and restarted that instance... > > It fails to connect

Re: [Maria-discuss] MariaDB Cluster wont start

Hello, On Mon, Sep 29, 2014 at 5:10 PM, Carlos Raúl Laguna wrote: > You were right > > This is the complete logs when i tray to start mariadb in the second node. > I do not see anything unusual in the logs. -- Nirbhay > > > Sep 29 17:03:32 baruwAdb3 mysqld_safe: Starting mysqld daemon with >

Re: [Maria-discuss] MariaDB Cluster wont start

0) does not > match group state UUID (0c63fe44-47fe-11e4-8d91-d3636a34c2fc): 1 (Operation > not permitted)* > at galera/src/replicator_str.cpp:prepare_for_IST():447. IST will be > unavailable. > 140929 16:24:44 [Note] WSREP: Member 1.0 (baruwadb3) requested state > transfer

Re: [Maria-discuss] MariaDB Cluster wont start

Hi, On Mon, Sep 29, 2014 at 1:11 PM, Carlos Raúl Laguna wrote: > I have a 3node galera-mariadb10 cluster working without issues until > today in ubuntu 14.04, all node stop, all i can grasp from mysqld is this: > The provided log seem to be incomplete? I do not see any error that would have ca