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

More user-friendly cnf files in MariaDB-Galera rpm/deb packages

    XMLWordPrintable

    Details

      Description

      MariaDB-Galera requires some minimal configuration to start a node. When we install it over an existing MariaDB/MySQL cnf file, conflicts between the required and existing configuration are understandable. However, if we install our own cnf files (e.g. upon a new clean installation), it would be nice to provide them with the required options or at least with suggestions (in comments).

      1. bind-address in deb packages: do NOT set it in MariaDB-Galera cnf files since it won't work anyway;

      2. According to Codership wiki page, the following options are required:
      wsrep_provider # as said before, it could be added as a comment
      wsrep_cluster_address # also could be added as a comment, with an example of a value
      binlog_format=ROW # can be set in cnf
      default_storage_engine=InnoDB # can be set in cnf (not necessarily, since it's InnoDB anyway)
      innodb_autoinc_lock_mode=2 # can be set in cnf
      innodb_locks_unsafe_for_binlog=1 # can be set in cnf

      And the following is optional:

      innodb_flush_log_at_trx_commit=2 - it could be added as a comment

      3. If we are able to detect where we installed the library and add the real value to the config file (wsrep_provider) on fly, it would be even better, but I suppose it's unrealistic and/or error-prone.

        Attachments

          Activity

            People

            Assignee:
            nirbhay_c Nirbhay Choubey (Inactive)
            Reporter:
            elenst Elena Stepanova
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: