| 1 |
robbat2 14/07/30 06:26:21 |
| 2 |
|
| 3 |
Added: my.cnf-5.5 |
| 4 |
Log: |
| 5 |
Bring MariaDB-Galera from the overlay into the tree. Thanks to the great work of Brian Evans <grknight@g.o>. |
| 6 |
|
| 7 |
(Portage version: 2.2.10/cvs/Linux x86_64, unsigned Manifest commit) |
| 8 |
|
| 9 |
Revision Changes Path |
| 10 |
1.1 dev-db/mariadb-galera/files/my.cnf-5.5 |
| 11 |
|
| 12 |
file : http://sources.gentoo.org/viewvc.cgi/gentoo-x86/dev-db/mariadb-galera/files/my.cnf-5.5?rev=1.1&view=markup |
| 13 |
plain: http://sources.gentoo.org/viewvc.cgi/gentoo-x86/dev-db/mariadb-galera/files/my.cnf-5.5?rev=1.1&content-type=text/plain |
| 14 |
|
| 15 |
Index: my.cnf-5.5 |
| 16 |
=================================================================== |
| 17 |
# @GENTOO_PORTAGE_EPREFIX@/etc/mysql/my.cnf: The global mysql configuration file. |
| 18 |
# $Header: /var/cvsroot/gentoo-x86/dev-db/mariadb-galera/files/my.cnf-5.5,v 1.1 2014/07/30 06:26:21 robbat2 Exp $ |
| 19 |
|
| 20 |
# The following options will be passed to all MySQL clients |
| 21 |
[client] |
| 22 |
#password = your_password |
| 23 |
port = 3306 |
| 24 |
socket = @GENTOO_PORTAGE_EPREFIX@/var/run/mysqld/mysqld.sock |
| 25 |
|
| 26 |
[mysql] |
| 27 |
character-sets-dir=@GENTOO_PORTAGE_EPREFIX@/usr/share/mysql/charsets |
| 28 |
default-character-set=utf8 |
| 29 |
|
| 30 |
[mysqladmin] |
| 31 |
character-sets-dir=@GENTOO_PORTAGE_EPREFIX@/usr/share/mysql/charsets |
| 32 |
default-character-set=utf8 |
| 33 |
|
| 34 |
[mysqlcheck] |
| 35 |
character-sets-dir=@GENTOO_PORTAGE_EPREFIX@/usr/share/mysql/charsets |
| 36 |
default-character-set=utf8 |
| 37 |
|
| 38 |
[mysqldump] |
| 39 |
character-sets-dir=@GENTOO_PORTAGE_EPREFIX@/usr/share/mysql/charsets |
| 40 |
default-character-set=utf8 |
| 41 |
|
| 42 |
[mysqlimport] |
| 43 |
character-sets-dir=@GENTOO_PORTAGE_EPREFIX@/usr/share/mysql/charsets |
| 44 |
default-character-set=utf8 |
| 45 |
|
| 46 |
[mysqlshow] |
| 47 |
character-sets-dir=@GENTOO_PORTAGE_EPREFIX@/usr/share/mysql/charsets |
| 48 |
default-character-set=utf8 |
| 49 |
|
| 50 |
[myisamchk] |
| 51 |
character-sets-dir=@GENTOO_PORTAGE_EPREFIX@/usr/share/mysql/charsets |
| 52 |
|
| 53 |
[myisampack] |
| 54 |
character-sets-dir=@GENTOO_PORTAGE_EPREFIX@/usr/share/mysql/charsets |
| 55 |
|
| 56 |
# use [safe_mysqld] with mysql-3 |
| 57 |
[mysqld_safe] |
| 58 |
err-log = @GENTOO_PORTAGE_EPREFIX@/var/log/mysql/mysql.err |
| 59 |
|
| 60 |
# add a section [mysqld-4.1] or [mysqld-5.0] for specific configurations |
| 61 |
[mysqld] |
| 62 |
character-set-server = utf8 |
| 63 |
user = mysql |
| 64 |
port = 3306 |
| 65 |
socket = @GENTOO_PORTAGE_EPREFIX@/var/run/mysqld/mysqld.sock |
| 66 |
pid-file = @GENTOO_PORTAGE_EPREFIX@/var/run/mysqld/mysqld.pid |
| 67 |
log-error = @GENTOO_PORTAGE_EPREFIX@/var/log/mysql/mysqld.err |
| 68 |
basedir = @GENTOO_PORTAGE_EPREFIX@/usr |
| 69 |
datadir = @DATADIR@ |
| 70 |
skip-external-locking |
| 71 |
key_buffer_size = 16M |
| 72 |
max_allowed_packet = 1M |
| 73 |
table_open_cache = 64 |
| 74 |
sort_buffer_size = 512K |
| 75 |
net_buffer_length = 8K |
| 76 |
read_buffer_size = 256K |
| 77 |
read_rnd_buffer_size = 512K |
| 78 |
myisam_sort_buffer_size = 8M |
| 79 |
lc_messages_dir = @GENTOO_PORTAGE_EPREFIX@/usr/share/mysql |
| 80 |
#Set this to your desired error message language |
| 81 |
lc_messages = en_US |
| 82 |
|
| 83 |
log-bin |
| 84 |
server-id = 1 |
| 85 |
|
| 86 |
# point the following paths to different dedicated disks |
| 87 |
tmpdir = @GENTOO_PORTAGE_EPREFIX@/tmp/ |
| 88 |
#log-update = @GENTOO_PORTAGE_EPREFIX@/path-to-dedicated-directory/hostname |
| 89 |
|
| 90 |
# you need the debug USE flag enabled to use the following directives, |
| 91 |
# if needed, uncomment them, start the server and issue |
| 92 |
# #tail -f @GENTOO_PORTAGE_EPREFIX@/tmp/mysqld.sql @GENTOO_PORTAGE_EPREFIX@/tmp/mysqld.trace |
| 93 |
# this will show you *exactly* what's happening in your server ;) |
| 94 |
|
| 95 |
#log = @GENTOO_PORTAGE_EPREFIX@/tmp/mysqld.sql |
| 96 |
#gdb |
| 97 |
#debug = d:t:i:o,/tmp/mysqld.trace |
| 98 |
#one-thread |
| 99 |
|
| 100 |
# the following is the InnoDB configuration |
| 101 |
# if you wish to disable innodb instead |
| 102 |
# uncomment just the next line |
| 103 |
#skip-innodb |
| 104 |
# |
| 105 |
# the rest of the innodb config follows: |
| 106 |
# don't eat too much memory, we're trying to be safe on 64Mb boxes |
| 107 |
# you might want to bump this up a bit on boxes with more RAM |
| 108 |
innodb_buffer_pool_size = 16M |
| 109 |
# this is the default, increase it if you have lots of tables |
| 110 |
innodb_additional_mem_pool_size = 2M |
| 111 |
# |
| 112 |
# i'd like to use @GENTOO_PORTAGE_EPREFIX@/var/lib/mysql/innodb, but that is seen as a database :-( |
| 113 |
# and upstream wants things to be under @GENTOO_PORTAGE_EPREFIX@/var/lib/mysql/, so that's the route |
| 114 |
# we have to take for the moment |
| 115 |
#innodb_data_home_dir = @GENTOO_PORTAGE_EPREFIX@/var/lib/mysql/ |
| 116 |
#innodb_log_arch_dir = @GENTOO_PORTAGE_EPREFIX@/var/lib/mysql/ |
| 117 |
#innodb_log_group_home_dir = @GENTOO_PORTAGE_EPREFIX@/var/lib/mysql/ |
| 118 |
# you may wish to change this size to be more suitable for your system |
| 119 |
# the max is there to avoid run-away growth on your machine |
| 120 |
innodb_data_file_path = ibdata1:10M:autoextend:max:128M |
| 121 |
# we keep this at around 25% of of innodb_buffer_pool_size |
| 122 |
# sensible values range from 1MB to (1/innodb_log_files_in_group*innodb_buffer_pool_size) |
| 123 |
innodb_log_file_size = 5M |
| 124 |
# this is the default, increase it if you have very large transactions going on |
| 125 |
innodb_log_buffer_size = 8M |
| 126 |
# this is the default and won't hurt you |
| 127 |
# you shouldn't need to tweak it |
| 128 |
innodb_log_files_in_group=2 |
| 129 |
# see the innodb config docs, the other options are not always safe |
| 130 |
innodb_flush_log_at_trx_commit = 1 |
| 131 |
innodb_lock_wait_timeout = 50 |
| 132 |
innodb_file_per_table |
| 133 |
|
| 134 |
# Uncomment this to get FEDERATED engine support |
| 135 |
#plugin-load=federated=ha_federated.so |
| 136 |
loose-federated |
| 137 |
|
| 138 |
# These settings are required for Galera clustering |
| 139 |
#mysql settings |
| 140 |
binlog_format=ROW |
| 141 |
default-storage-engine=innodb |
| 142 |
innodb_autoinc_lock_mode=2 |
| 143 |
query_cache_size=0 |
| 144 |
query_cache_type=0 |
| 145 |
bind-address=0.0.0.0 |
| 146 |
# Uncomment this section to activate Galera clustering |
| 147 |
#wsrep_provider=@GENTOO_PORTAGE_EPREFIX@/usr/lib/galera/libgalera_smm.so |
| 148 |
# You should change this name to something meaningful |
| 149 |
#wsrep_cluster_name="my_wsrep_cluster" |
| 150 |
# List all nodes of the cluster including this one |
| 151 |
#wsrep_cluster_address="gcomm://172.16.8.5,172.16.8.6,172.16.8.4" |
| 152 |
#wsrep_sst_method=rsync |
| 153 |
|
| 154 |
[mysqldump] |
| 155 |
quick |
| 156 |
max_allowed_packet = 16M |
| 157 |
|
| 158 |
[mysql] |
| 159 |
# uncomment the next directive if you are not familiar with SQL |
| 160 |
#safe-updates |
| 161 |
|
| 162 |
[isamchk] |
| 163 |
key_buffer_size = 20M |
| 164 |
sort_buffer_size = 20M |
| 165 |
read_buffer = 2M |
| 166 |
write_buffer = 2M |
| 167 |
|
| 168 |
[myisamchk] |
| 169 |
key_buffer_size = 20M |
| 170 |
sort_buffer_size = 20M |
| 171 |
read_buffer_size = 2M |
| 172 |
write_buffer_size = 2M |
| 173 |
|
| 174 |
[mysqlhotcopy] |
| 175 |
interactive-timeout |
Archives