Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7752

There is no bootstrap command option for MariaDB Galera Cluster in CentOS 7

Details

    Description

      After installing MariaDB Galera from YUM repo, could not find bootstrap command option for starting cluster:

      [root@node1 ~]# systemctl start mysql --wsrep_new_cluster
      systemctl: unrecognized option '--wsrep_new_cluster'

      As with PXC:

      [root@node1 ~]# systemctl start mysql@bootstrap.service
      Failed to issue method call: Unit mysql@bootstrap.service failed to load: No such file or directory.
       
      [root@node1 ~]# systemctl bootstrap mysql.service
      Unknown operation 'bootstrap'.

      Attachments

        Issue Links

          Activity

            sirotopr sirotopr added a comment -

            I'm facing the same bug with Debian packages for version 10.0.21 from MariaDB repo.

            It gets a bit worse because

            sudo service mysql start --wsrep_new_cluster

            fails silently. Unlike systemctl, there is no error output. Thus the user might think, as I did, that everything is going fine.

            sirotopr sirotopr added a comment - I'm facing the same bug with Debian packages for version 10.0.21 from MariaDB repo. It gets a bit worse because sudo service mysql start --wsrep_new_cluster fails silently. Unlike systemctl, there is no error output. Thus the user might think, as I did, that everything is going fine.
            slankes Sven Lankes added a comment -

            As a workaround this works for me:

            [root@galera01 mysql]# systemctl set-environment MYSQLD_OPTS="--wsrep-new-cluster"
            [root@galera01 mysql]# systemctl start mariadb
            [root@galera01 mysql]# systemctl unset-environment MYSQLD_OPTS

            slankes Sven Lankes added a comment - As a workaround this works for me: [root@galera01 mysql]# systemctl set-environment MYSQLD_OPTS="--wsrep-new-cluster" [root@galera01 mysql]# systemctl start mariadb [root@galera01 mysql]# systemctl unset-environment MYSQLD_OPTS
            danblack Daniel Black added a comment -

            So MDEV-9007 is the 10.1 fix. nirbhay_c should a backport of the same user interface and scripts be done?

            danblack Daniel Black added a comment - So MDEV-9007 is the 10.1 fix. nirbhay_c should a backport of the same user interface and scripts be done?
            nirbhay_c Nirbhay Choubey (Inactive) added a comment - - edited

            danblack : I think the following commit (merged from mysql-wsrep) should fix this issue in 5.5/10.0 :
            https://github.com/MariaDB/server/commit/fd1b2e486a9a81ffb5416e7a0a0d85d15598c77c

            nirbhay_c Nirbhay Choubey (Inactive) added a comment - - edited danblack : I think the following commit (merged from mysql-wsrep) should fix this issue in 5.5/10.0 : https://github.com/MariaDB/server/commit/fd1b2e486a9a81ffb5416e7a0a0d85d15598c77c

            In 10.0.22-galera, any of the following commands can be used to bootstrap :

            • sudo service mysql bootstrap
            • sudo service mysql start --wsrep-new-cluster
            nirbhay_c Nirbhay Choubey (Inactive) added a comment - In 10.0.22-galera, any of the following commands can be used to bootstrap : sudo service mysql bootstrap sudo service mysql start --wsrep-new-cluster

            People

              nirbhay_c Nirbhay Choubey (Inactive)
              shahriyar_r Shahriyar Rzayev
              Votes:
              4 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.