[client]
user            = skysql
password        = skyvodka
port            = 5012
socket          = /tmp/mysql_sandbox5012.sock

[mysqld]
read_only=on

sync_binlog                     = 1
thread_handling=pool-of-threads
extra-port=5112
extra-max-connections=10

# semisync
plugin-load="semisync_master.so;semisync_slave.so;spider=ha_spider.so;spider_alloc_mem=ha_spider.so"
rpl_semi_sync_master=ON
rpl_semi_sync_slave=ON
loose_rpl_semi_sync_master_enabled=ON
loose_rpl_semi_sync_slave_enabled=ON
slave-parallel-threads        = 6
slave-parallel-mode=optimistic
log_slave_updates
sync_binlog=1

log_bin
binlog_format=ROW
skip_name_resolv

#test.replicate_do_table=tata.test
#test.replicate-rewrite-db=test->tata
#replicate-same-server-id
net_write_timeout = 300
net_read_timeout = 300
collation-server = utf8_general_ci
init_connect='SET NAMES utf8'
character-set-server = utf8
#skip-character-set-client-handshake


user                            = root
port                            = 5012
socket                          = /tmp/mysql_sandbox5012.sock
basedir                         = /usr/local/mysql
datadir                         = /var/lib/skysql/db-78b9ef72/data
tmpdir                          = /var/lib/skysql/db-78b9ef72/tmp
pid-file                        = /var/lib/skysql/db-78b9ef72/data/mysql_sandbox5012.pid
#log-slow-queries               = /var/lib/skysql/db-78b9ef72/data/msandbox-slow.log
#log                            = /var/lib/skysql/db-78b9ef72/data/msandbox.log
#
# additional options passed through 'my_clause'
#
server-id=5012
#
# additional options from /usr/local/skysql/ncc/etc/spider.template
#

performance_schema = 0
innodb_autoinc_lock_mode = 2
innodb_stats_on_metadata = 0
innodb_buffer_pool_instances = 1
innodb_flush_method = O_DIRECT
innodb_log_file_size = 1G
innodb_log_files_in_group=8
innodb_buffer_pool_size = 1G
innodb_additional_mem_pool_size = 16M
innodb_log_buffer_size = 512M
innodb_max_dirty_pages_pct = 30
innodb_file_per_table
innodb_doublewrite = 1
innodb_flush_log_at_trx_commit = 1
innodb_adaptive_hash_index = 0
innodb_write_io_threads = 16
innodb_flush_neighbors = 0
innodb_thread_concurrency = 0
innodb_defragment = 1
innodb_open_files = 16384
innodb_purge_threads = 8
innodb_buffer_pool_populate=0
innodb_change_buffering=none
innodb_concurrency_tickets =5000
innodb_io_capacity=20000
innodb_io_capacity_max=40000


back_log=128
max_connections = 1024
table_open_cache = 2048
table_definition_cache = 2048
max_allowed_packet = 16M
binlog_cache_size = 1M
max_heap_table_size = 64M
thread_cache_size = 128
query_cache_size = 0
query_cache_limit = 2M
ft_min_word_len = 4
thread_stack = 192K
tmp_table_size = 512K
expire_logs_days=7
sort_buffer_size =  512K
join_buffer_size =  2M
key_buffer_size = 256M
key_cache_block_size=4K
#spider_use_handler=0


spider_bgs_mode=1
spider_casual_read=1
#spider_bgs_mode
#  Mode of background search.
#  -1 : The table parameter is adopted.
#   0 : Background search is disabled.
#   1 : Background search is used if search with no lock.
#   2 : Background search is used if search with no lock or shared lock.
#   3 : Background search is used regardless of the lock.
#  The default value is -1

#spider_bka_mode=1
#spider_bka_engine=myisam
optimizer_switch="engine_condition_pushdown=on"
loose_spider_conn_recycle_mode=1
# ++spider_conn_recycle_mode
#  It behaves in that case though the connection is recycled as for the spider
#  storage engine when the transaction is completed.
#  0 : Disconnect.
#  1 : It recycles by all sessions.
#  2 : It recycles in the same session.
#  The default value is 0



#spider_use_hs_read=1
#spider_use_hs_write=1

loose_spider_reset_sql_alloc=0
#spider_use_pushdown_udf=1


spider_crd_mode=1

# spider_crd_bg_mode
#  Mode of cardinality confirmation at background.
#  (Only when crd_mode is 1 or 2 and crd_interval is bigger than 0,
#  it is effective.)
#  -1 : The table parameter is adopted.
#   0 : Background confirmation is disabled.
#   1 : Background confirmation is enabled.
#  The default value is -1

spider_crd_interval=4
# spider_crd_interval
#  Interval of cardinality confirmation.(second)
# (Only when crd_mode is 1 or 2, it is effective.)
#  Spider always get the newest information from remote servers, if this
# parameter is set to 0.
#  -1        : The table parameter is adopted.
#  0 or more : Interval of cardinality confirmation.
#  The default value is -1

spider_crd_bg_mode=1
# spider_crd_mode
#  Mode of cardinality confirmation.
#  -1,0 : The table parameter is adopted.
#   1   : The show command is used.
#   2   : The information schema is used.
#   3   : The explain is used.
#  The default value is -1

spider_crd_sync=0
# spider_crd_sync
#  Cardinality synchronization in partitioned table.
#  -1 : The table parameter is adopted.
#   0 : No synchronization.
#   1 : Cardinality is synchronized when opening a table.
#       Then no synchronization.
#   2 : Synchronization.
#  The default value is -1

# spider_crd_type
#  Type of cardinality calculation.
#  (Only when crd_mode is 1 or 2, it is effective.)
#  -1 : The table parameter is adopted.
#   0 : The crd_weight is used as a fixed value.
#   1 : The crd_weight is used as an addition value.
#   2 : The crd_weight is used as a multiplication value.
#  The default value is -1

spider_sync_trx_isolation=0
#++ spider_sync_trx_isolation
#  Local transaction isolation level synchronous existence to remote server.
#   0 : It doesn't synchronize.
#   1 : It synchronizes.
#  The default value is 1


spider_sync_autocommit=0
# spider_sync_autocommit
#  Local autocommit synchronous existence to remote server.
#   0 : It doesn't synchronize.
#   1 : It synchronizes.
#  The default value is 1


# spider_semi_trx
#  Mode that executes transaction during one SQL execution for autocommit=1.
#  (Only when spider_sync_autocommit is 1, it is effective.)
#   0 : OFF
#   1 : ON
#  The default value is 1

# spider_semi_trx_isolation
#  The consistency set during one SQL execution is used.
#  (Only when spider_sync_trx_isolation is 1, it is effective.)
#  -1 : OFF
#   0 : READ UNCOMMITTED
#   1 : READ COMMITTED
#   2 : REPEATABLE READ
#   3 : SERIALIZABLE
#  The default value is -1


spider_support_xa
#spider_support_xa
#  Support xa transaction by spider.
#  internal_xa is available in spider_support_xa=0.




# spider_internal_xa
#  Option to switch usual transaction to xa transaction internally.
#  0 : It doesn't switch.
#  1 : It switches.
#  The default value is 0
#  The rule of internal xa id is the following.
#  gtrid:MySQL's thread id
#  bqual:MySQL's server id
#  formatID:1
#  Please set different server id in the all MySQL instances for generating
#  different xa id.


# spider_split_read=?
# spider_split_read
#  When SQL(SELECT) internally issued to a remote server is executed, it is a
#  number of records in which division is acquired as for the execution result.
#  -1        : The table parameter is adopted.
#  0 or more : Number of records.
#  The default value is -1

#spider_quick_mode=0
#spider_quick_mode
#  The retrieval result from a remote server is acquired by acquisition
#  one by one.
#  -1 : The table parameter is adopted.
#   0 : It acquires it collectively.
#   1 : Acquisition one by one.If it discontinues once, and it will need
#       it later, it retrieves it again when there is interrupt on the way.
#   2 : Acquisition one by one.Interrupt is waited for until end of getting
#       result when there is interrupt on the way.
#  The default value is -1


# spider_local_lock_table
#  Remote server transmission when lock tables is executed at local.
#   0 : Transmits.
#   1 : Don't transmit.
#  The default value is 0

# spider_lock_exchange
#  Lock in share mode is converted in lock tables read and for update is
#  converted into lock tables write.
#  (Only when semi_table_lock of the table parameter is one, it is effective.)
#  0 : It doesn't convert it.
#  1 : It converts it.
#  The default value is 0
#
#
spider_sts_sync=0
spider_remote_sql_log_off=1
spider_remote_autocommit=1
spider_direct_dup_insert=1

loose_handlersocket_port=                20000
loose_handlersocket_port_wr=             20001
loose_handlersocket_threads=             2
loose_handlersocket_threads_wr=          1
loose_handlersocket_support_merge_table= 0
loose_handlersocket_direct_update_mode=  0
loose_handlersocket_unlimited_boundary=  65536
loose_handlersocket_bulk_insert=         0
loose_handlersocket_bulk_insert_timeout= 0
loose_handlersocket_general_log=         1
loose_handlersocket_timeout=             30
loose_handlersocket_close_table_interval=2