maria-discuss team mailing list archive

[Guillaume Lefranc <guillaume@xxxxxxxxxxxx>]

Hi Niklaas,

in MariaDB 10.1, Galera replicator needs to be explicitely enabled. Try
adding this to your configuration file:

wsrep_on=ON

Kind regards
GL

Le jeu. 2 juin 2016 à 08:56, Niklaas Baudet von Gersdorff <stdin@xxxxxxxxxx>
a écrit :

> Hello,
>
> I'm trying to setup a galera cluster on FreeBSD. I followed the
> instructions on [1] but every time I issue
>
>     SHOW STATUS LIKE 'wsrep_cluster_size';
>
> I get
>
>     +--------------------+-------+
>     | Variable_name      | Value |
>     +--------------------+-------+
>     | wsrep_cluster_size | 0     |
>     +--------------------+-------+
>     1 row in set (0.00 sec)
>
> So, the cluster is not working. This is the configuration of the node
> that I want to set as primary:
>
> -----------------------------------8<-----------------------------------
>
> [mysqld]
> datadir=/var/db/mysql
> socket=/tmp/mysql.sock
> user=mysql
> binlog_format=ROW
> bind-address=0.0.0.0
> default_storage_engine=innodb
> innodb_autoinc_lock_mode=2
> innodb_flush_log_at_trx_commit=0
> innodb_buffer_pool_size=122M
> wsrep_provider=/usr/local/lib/libgalera_smm.so
> wsrep_provider_options="gcache.size=300M; gcache.page_size=300M"
> wsrep_cluster_name="klaas_cluster"
> wsrep_cluster_address="gcomm://"
> #wsrep_cluster_address="gcomm://10.1.7.1,10.1.7.2,10.3.7.1"
> wsrep_sst_method=rsync
>
> [mysql]
> wsrep_cluster_name=klaas_cluster
> wsrep_cluster_address="gcomm://10.1.7.1,10.1.7.2,10.3.7.1"
> wsrep_node_name=box-hlm-01
> wsrep_node_address="10.1.7.1"
>
> [mysql_safe]
> log-error=/var/log/mysqld.log
> pid-file=/var/run/mysqld/mysqld.pid
>
> ----------------------------------->8-----------------------------------
>
> On the other two nodes the configuration is the same, except (1) only
> the second `wsrep_cluster_address` exists; (2) `wsrep_node_address`
> differs, obviously.
>
> Instead of using an "empty" `wsrep_cluster_address` I also tried setting
>
>     mysql_args="--wsrep-new-cluster"
>
> in /etc/rc.conf without getting the desired result. The logs lack any
> relevant warnings or errors:
>
> -----------------------------------8<-----------------------------------
>
> 160602 07:59:44 mysqld_safe mysqld from pid file
> /var/db/mysql/mariadb1.box-hlm-01.klaas.pid ended
> 160602 08:00:34 mysqld_safe Starting mysqld daemon with databases from
> /var/db/mysql
> 2016-06-02  8:00:34 34426872832 [Note] /usr/local/libexec/mysqld (mysqld
> 10.1.13-MariaDB) starting as process 22580 ...
> 2016-06-02  8:00:34 34426872832 [Warning] You need to use --log-bin to
> make --binlog-format work.
> 2016-06-02  8:00:34 34426872832 [Note] InnoDB: Using mutexes to ref count
> buffer pool pages
> 2016-06-02  8:00:34 34426872832 [Note] InnoDB: The InnoDB memory heap is
> disabled
> 2016-06-02  8:00:34 34426872832 [Note] InnoDB: Mutexes and rw_locks use
> GCC atomic builtins
> 2016-06-02  8:00:34 34426872832 [Note] InnoDB: Memory barrier is not used
> 2016-06-02  8:00:34 34426872832 [Note] InnoDB: Compressed tables use zlib
> 1.2.8
> 2016-06-02  8:00:34 34426872832 [Note] InnoDB: Using SSE crc32 instructions
> 2016-06-02  8:00:34 34426872832 [Note] InnoDB: Initializing buffer pool,
> size = 122.0M
> 2016-06-02  8:00:34 34426872832 [Note] InnoDB: Completed initialization of
> buffer pool
> 2016-06-02  8:00:34 34426872832 [Note] InnoDB: Highest supported file
> format is Barracuda.
> 2016-06-02  8:00:34 34426872832 [Note] InnoDB: 128 rollback segment(s) are
> active.
> 2016-06-02  8:00:34 34426872832 [Note] InnoDB: Waiting for purge to start
> 2016-06-02  8:00:34 34426872832 [Note] InnoDB:  Percona XtraDB (
> http://www.percona.com) 5.6.28-76.1 started; log sequence number 1616955
> 2016-06-02  8:00:34 34426872832 [Note] Plugin 'FEEDBACK' is disabled.
> 2016-06-02  8:00:34 34426899456 [Note] InnoDB: Dumping buffer pool(s) not
> yet started
> 2016-06-02  8:00:34 34426872832 [Note] Server socket created on IP:
> '0.0.0.0'.
> 2016-06-02  8:00:34 34426872832 [Note] /usr/local/libexec/mysqld: ready
> for connections.
> Version: '10.1.13-MariaDB'  socket: '/tmp/mysql.sock'  port: 3306
> FreeBSD Ports
>
> ----------------------------------->8-----------------------------------
>
> Any help is very much appreciated.
>
>     Niklaas
>
> 1: http://galeracluster.com/documentation-webpages/index.html
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>