# Options for mysqld process: [mysqld] max_connections=1000 # Federated MySQL storage engine federated #performance_schema datadir=/opt/data/mysqld basedir=/usr/local/mysql port=3306 socket=/var/lib/mysql/mysql.sock character-set-server=utf8 default-storage-engine=ndbcluster server-id=21 ndbcluster # run NDB storage engine ndb-connectstring=192.168.100.1,192.168.100.2 ndb-force-send=1 ndb-use-exact-count=0 ndb-extra-logging=1 ndb-autoincrement-prefetch-sz=512 ndb-cluster-connection-pool=1 key_buffer_size=64M #query-cache-type=1 #query_cache_size=64M max_allowed_packet=20M sort_buffer_size=8M read_buffer_size=4M read_rnd_buffer_size=4M memlock sysdate_is_now thread-cache-size=2048 table-open_cache=2048 max_prepared_stmt_count=24576 lower-case-table-names=0 # Timeout interactive_timeout=43200 wait_timeout=43200 connect_timeout=60 skip-name-resolve [mysql_cluster] ndb-connectstring=192.168.100.1,192.168.100.2 # location of management server [client] user = powerdns password = Iwon1$iboxpay