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

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




      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.




            nirbhay_c Nirbhay Choubey (Inactive)
            elenst Elena Stepanova
            1 Vote for this issue
            4 Start watching this issue



              Git Integration

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