[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql server-id=1 #replicate-same-server-id=0 log-bin=newcrmdb1-bin #binlog_do_db=crmdb binlog_do_db=newcrmdb binlog-ignore-db=mysql,test #replicate_do_db=crmdb #replicate_do_db=newcrmdb #auto-increment-increment = 3 #auto-increment-offset = 1 #log-slave-updates skip_name_resolve #master-host = 192.168.0.203 #master-user = replication #master-password = rplpassword #master-port = 3306 innodb_flush_log_at_trx_commit=0 innodb_flush_method=O_DIRECT sync_binlog=0 slave-skip-errors = 1062 back_log = 75 # skip-innodb max_connections = 500 #thread_stack= 150M key_buffer = 256M key_buffer_size = 256M myisam_sort_buffer_size = 16M join_buffer_size = 16M read_buffer_size = 8M sort_buffer_size = 8M table_cache = 4800 table_definition_cache = 4800 thread_cache_size = 128 interactive_timeout=1000 wait_timeout = 100 connect_timeout = 60 tmp_table_size = 2048M max_heap_table_size = 2048M max_allowed_packet = 64M #max_connect_errors = 10000 read_rnd_buffer_size = 8M bulk_insert_buffer_size = 8M query_cache_size = 256M query_cache_limit = 4M query_cache_type = 1 query_prealloc_size = 65536 query_alloc_block_size = 131072 default-storage-engine = InnoDB innodb_buffer_pool_size = 25G innodb_log_file_size = 1G innodb_lock_wait_timeout = 120 innodb_use_sys_malloc = 0 #innodb_adaptive_checkpoint=reflex expire_logs_days=7 #long_query_time = 1 #log-slow-queries = /var/log/mysql-slow-query.log # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). #old_passwords=1 # Disabling symbolic-links is recommended to prevent assorted security risks; # to do so, uncomment this line: # symbolic-links=0 [client] user=root pass=NiusnEYrkAbiab7