systemctl start mysql --wsrep-new-cluster -> unknown option "--wsrep-new-cluster"

[frank.n...@gmail.com]

Hi @all,

last weekend I tried to configured a galera cluster using mysql 5.7 respectively mariadb 10.1 at some ubuntu-hosts 16.04.

wsrep should be included into mysql respectively mariadb so no dedicated wsrep-package should be necessary.

Always when I wanted to start the mysql-deamon I got the message that --wsrep-new-cluster is an unknown option.

I have no clue what is wrong.

When I comment all wsrep-parameter then mysql starts well.

/usr/lib/libgalera_smm.so  is available.

The setting within /etc/mysql/my.cnf are:

!includedir /etc/mysql/conf.d/

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/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_on=ON

wsrep_provider=/usr/lib/libgalera_smm.so

wsrep_provider_options="gcache.size=300M; gcache.page_size=300M"

wsrep_cluster_name="myGalera"

wsrep_cluster_address="gcomm://192.168.31.10,192.168.31.20,192.168.31.40"

wsrep_node_name=u-1

wsrep_node_address="192.168.31.10"

wsrep_sst_method=rsync

[mysql_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

Does anyone has a hint?

Thanks a lot

Frank

[Jörg Brühe]

Hi Frank!

On 06.06.2017 15:35, frank.n...@gmail.com wrote:
> Hi @all,
>
> last weekend I tried to configured a galera cluster using mysql 5.7
> respectively mariadb 10.1 at some ubuntu-hosts 16.04.
> wsrep should be included into mysql respectively mariadb so no dedicated
> wsrep-package should be necessary.
>
> Always when I wanted to start the mysql-deamon I got the message
> that --wsrep-new-cluster is an unknown option.

Nobody will be able to help you until you give the exact name(s) of the
relevant package(s) installed, and a verbatim copy/paste of the start
call you issued and the error message you got.

>
> [[...]]


Regards,
Jörg Brühe

--
Joerg Bruehe, Senior MySQL Support Engineer, joerg....@fromdual.com
FromDual GmbH, Rebenweg 6, CH - 8610 Uster; phone +41 44 500 58 26
Geschäftsführer: Oliver Sennhauser
Handelsregister-Eintrag: CH-020.4.044.539-3

[frank.n...@gmail.com]

Hi Jörg,

...thank you for your quick reply.

What I had figured out yesterday is that with mariadb version 10.1 an additional command should be executed ( /usr/bin/galera_new_cluster ).

This command replaces the option --wsrep-new-cluster from the systemctl start mysql command.

After executing "/usr/bin/galera_new_cluster" and "systemctl start mysql" everything was working fine :-)

Thank you again,

best regards

Frank