一台机器搭建两个MySQL实例配置文件

来源:互联网 发布:java 多线程并发 应用 编辑:程序博客网 时间:2024/06/04 17:58
[mysqld_multi]mysqld = /mysql/app/mysql/bin/mysqld_safemysqladmin = /mysql/app/mysql/bin/mysqladminuser = root[mysqld1]socket = /tmp/mysql_3301.sockport = 3301pid-file = /usr/local/percona-mysql/mysql_3301/data/mysql_3301.piddatadir = /usr/local/percona-mysql/mysql_3301/data/user = mysqlserver-id = 100log-bin=mysql-binmax_connections=1024innodb_thread_concurrency=8binlog_format=rowinnodb_flush_log_at_trx_commit=2sync_binlog=1innodb_flush_method=O_DIRECTinnodb_buffer_pool_size=1024Minnodb_log_file_size=256Mmax_allowed_packet=16Mmax_heap_table_size=256Mtmp_table_size=256Mmax_user_connections=512wait_timeout=31536000interactive_timeout=31536000sort_buffer_size=32mread_buffer_size=32mtable_open_cache=1024join_buffer_size=32mlower_case_table_names=1log-slow-queries = /tmp/slowquery1.loglong_query_time = 1log_queries_not_using_indexesquery_cache_size = 256Mquery_cache_type = 1log_slave_updates = 1[mysqld2]socket = /tmp/mysql_3302.sockport = 3302pid-file = /usr/local/percona-mysql/mysql_3302/data/mysql_3301.piddatadir = /usr/local/percona-mysql/mysql_3302/data/user = mysqlserver-id = 200log-bin=mysql-binmax_connections=1024innodb_thread_concurrency=8binlog_format=rowinnodb_flush_log_at_trx_commit=2sync_binlog=1innodb_flush_method=O_DIRECTinnodb_buffer_pool_size=1024Minnodb_log_file_size=256Mmax_allowed_packet=16Mmax_heap_table_size=256Mtmp_table_size=256Mmax_user_connections=512wait_timeout=31536000interactive_timeout=31536000sort_buffer_size=32mread_buffer_size=32mtable_open_cache=1024join_buffer_size=32mlower_case_table_names=1log-slow-queries = /tmp/slowquery1.loglong_query_time = 1log_queries_not_using_indexesquery_cache_size = 256Mquery_cache_type = 1log_slave_updates = 1


原创粉丝点击