commit: ab665d8ffe03a574e3329708293bcda1cf17074c Author: Brian Evans <grknight <AT> lavabit <DOT> com> AuthorDate: Wed Mar 12 01:31:27 2014 +0000 Commit: Brian Evans <grknight <AT> lavabit <DOT> com> CommitDate: Wed Mar 12 01:31:27 2014 +0000 URL: http://git.overlays.gentoo.org/gitweb/?p=proj/mysql.git;a=commit;h=ab665d8f
[mariadb-galera] Provide a base config and instructions --- dev-db/mariadb-galera/files/my.cnf-5.5 | 30 ++++++++++++++++++------------ eclass/mysql-v2.eclass | 10 ++++++++++ 2 files changed, 28 insertions(+), 12 deletions(-) diff --git a/dev-db/mariadb-galera/files/my.cnf-5.5 b/dev-db/mariadb-galera/files/my.cnf-5.5 index 195ff90..237c97c 100644 --- a/dev-db/mariadb-galera/files/my.cnf-5.5 +++ b/dev-db/mariadb-galera/files/my.cnf-5.5 @@ -64,11 +64,6 @@ lc_messages_dir = @GENTOO_PORTAGE_EPREFIX@/usr/share/mysql #Set this to your desired error message language lc_messages = en_US -# security: -# using "localhost" in connects uses sockets by default -# skip-networking -bind-address = 127.0.0.1 - log-bin server-id = 1 @@ -86,10 +81,6 @@ tmpdir = @GENTOO_PORTAGE_EPREFIX@/tmp/ #debug = d:t:i:o,/tmp/mysqld.trace #one-thread -# uncomment the following directives if you are using BDB tables -#bdb_cache_size = 4M -#bdb_max_lock = 10000 - # the following is the InnoDB configuration # if you wish to disable innodb instead # uncomment just the next line @@ -128,6 +119,22 @@ innodb_file_per_table #plugin-load=federated=ha_federated.so loose-federated +# These settings are required for Galera clustering +#mysql settings +binlog_format=ROW +default-storage-engine=innodb +innodb_autoinc_lock_mode=2 +query_cache_size=0 +query_cache_type=0 +bind-address=0.0.0.0 +# Uncomment this section to activate Galera clustering +#wsrep_provider=@GENTOO_PORTAGE_EPREFIX@/usr/lib/galera/libgalera_smm.so +# You should change this name to something meaningful +#wsrep_cluster_name="my_wsrep_cluster" +# List all nodes of the cluster including this one +#wsrep_cluster_address="gcomm://172.16.8.5,172.16.8.6,172.16.8.4" +#wsrep_sst_method=rsync + [mysqldump] quick max_allowed_packet = 16M @@ -145,9 +152,8 @@ write_buffer = 2M [myisamchk] key_buffer_size = 20M sort_buffer_size = 20M -read_buffer = 2M -write_buffer = 2M +read_buffer_size = 2M +write_buffer_size = 2M [mysqlhotcopy] interactive-timeout - diff --git a/eclass/mysql-v2.eclass b/eclass/mysql-v2.eclass index 1957ec8..b541347 100644 --- a/eclass/mysql-v2.eclass +++ b/eclass/mysql-v2.eclass @@ -600,6 +600,16 @@ mysql-v2_pkg_postinst() { elog "If you are upgrading major versions, you should run the" elog "mysql_upgrade tool." einfo + + if [[ ${PN} == "mariadb-galera" ]] ; then + einfo + elog "Be sure to edit the my.cnf file to activate your cluster settings." + elog "This should be done after running \"emerge --config =${CATEGORY}/${PF}\"" + elog "The first time the cluster is activated, you should add" + elog "--wsrep-new-cluster to the options in /etc/conf.d/mysql for one node." + elog "This option should then be removed for subsequent starts." + einfo + fi fi if use_if_iuse pbxt ; then