[ndbd]
ndb-connectstring=mgmt1.domainname

[mysql-cluster]
ndb-connectstring=mgmt1.domainname

[ndb_mgmd]
config-file=/var/lib/mysql-cluster/mgmt1/config.ini

[mysqld]
#ndbcluster
datadir=/var/lib/mysql
tmpdir=/var/lib/mysql-cluster/tmp
ndb-connectstring=mgmt1.domainname
innodb_file_per_table

# mysql tuning
# see http://www.databasejournal.com/features/mysql/article.php/3367871
# see http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html

# set key_buffer higher than total size of indexed data.
# calculate total size of indicies with
# find /var/lib/mysql -name *.MYI -exec du  {} \; | cut -f1 | perl -e 'my $total=0; while(<STDIN>) { $total += $_ } print $total/1024 . "M"';

set-variable = key_buffer=1024M              # 25-50% of ram size, keep all indicies in ram
set-variable = table_cache=256               # how many open tables to keep in table cache
set-variable = query_cache_type=1            # enable query cache
set-variable = query_cache_size=128M         # improve speed by caching more queries
set-variable = query_cache_limit=8M          # do not cache queries that are larger than this
set-variable = read_buffer_size=128M         # speed up large SELECT's
set-variable = thread_cache=8                # improve non-persistent connections
set-variable = thread_concurrency=10         # increase number of threads
set-variable = sort_buffer=16M               # for myisamchk sorting
set-variable = myisam_sort_buffer_size=512M  # speed up big table repairs.
set-variable = interactive_timeout=3600      # kill stale connections
set-variable = wait_timeout=3600             # lower wait timeout
set-variable = max_connect_errors=10000      # do not refuse connections due to too many errors
set-variable = max_allowed_packet=1M         # allow large packet sizes


[client]
user=root
socket=/tmp/mysql.sock
host=127.0.0.1
port=3306