maria-discuss team mailing list archive

["Pim Rupert (Lemonbit)" <pim@xxxxxxxxxxxx>]

Hi Tim,

> On 11 Nov 2014, at 14:40, Tim Callaghan <tmcallaghan@xxxxxxxxx> wrote:
> 
> Working with 10.1.1 this morning and wondering why I'm seeing so many WSREP messages in my logs as well as in the server's banner.
> 
> 141111  7:54:05 [Note] WSREP: Read nil XID from storage engines, skipping position init
> 141111  7:54:05 [Note] WSREP: wsrep_load(): loading provider library 'none'
> 141111  7:54:05 [Note] WSREP: Service disconnected.
> 141111  7:54:06 [Note] WSREP: Some threads may fail to exit.
> 
> 141111 07:54:08 mysqld_safe WSREP: Running position recovery with --log_error='/home/tcallaghan/data/dbtest/mariadb-10.1.1-linux-x86_64/data/wsrep_recovery.mQ04vo'
> 
> [...]
> 
> MariaDB [(none)]> show variables like 'wsrep%';
> +---------------------------------+-----------------------------------------+
> | Variable_name                   | Value                                   |
> +---------------------------------+-----------------------------------------+
> | wsrep_provider                  | none                                    |
> | wsrep_provider_options          |                                         |

It seems that you have not set the wsrep_provider in your server configuration. This is a mandatory setting. Most likely you will not have a working cluster right now.

More information about setting up MariaDB Galera Cluster: 
  https://mariadb.com/kb/en/mariadb/documentation/replication/galera/getting-started-with-mariadb-galera-cluster/

Example configuration of wsrep_provider settings from /etc/my.cnf.d/server.cnf:
  wsrep_provider=/usr/lib64/galera/libgalera_smm.so '

Of course, you will need to have galera installed, which is available via the MariaDB yum and apt channels:
  https://downloads.mariadb.org/mariadb/repositories/ 

Kind regards,

Pim Rupert