Patch by mark. diffs (202 lines):
diff -r 277c1fddfc30 -r 20896fd992eb configs/mysql/dfw-db-a01.cnf --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/configs/mysql/dfw-db-a01.cnf Thu Apr 30 21:46:02 2009 +0000 @@ -0,0 +1,21 @@ +[mysqld] +bind-address = 10.176.71.86 + +server-id = 3 +log_bin = /var/lib/mysql-binlogs/dfw-db-a01-bin.log +relay_log = /var/lib/mysql/dfw-db-a01-relay-bin +max_binlog_size = 1G +expire_logs_days = 30 + +log-slave-updates + +log_slow_queries = /var/log/mysql/mysql-slow.log +long_query_time = 2 +#log-queries-not-using-indexes + +# general purpose tuning +max_connections = 1024 +table_cache = 1024 + +# innodb tuning +innodb_buffer_pool_size = 3200M diff -r 277c1fddfc30 -r 20896fd992eb configs/mysql/dfw-db-a02.cnf --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/configs/mysql/dfw-db-a02.cnf Thu Apr 30 21:46:02 2009 +0000 @@ -0,0 +1,21 @@ +[mysqld] +bind-address = 10.176.71.88 + +server-id = 4 +log_bin = /var/lib/mysql-binlogs/dfw-db-a02-bin.log +relay_log = /var/lib/mysql/dfw-db-a02-relay-bin +max_binlog_size = 1G +expire_logs_days = 30 + +log-slave-updates + +log_slow_queries = /var/log/mysql/mysql-slow.log +long_query_time = 2 +#log-queries-not-using-indexes + +# general purpose tuning +max_connections = 1024 +table_cache = 1024 + +# innodb tuning +innodb_buffer_pool_size = 3200M diff -r 277c1fddfc30 -r 20896fd992eb configs/mysql/dfw-db-b01.cnf --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/configs/mysql/dfw-db-b01.cnf Thu Apr 30 21:46:02 2009 +0000 @@ -0,0 +1,21 @@ +[mysqld] +bind-address = 10.176.71.89 + +server-id = 5 +log_bin = /var/lib/mysql-binlogs/dfw-db-b01-bin.log +relay_log = /var/lib/mysql/dfw-db-b01-relay-bin +max_binlog_size = 1G +expire_logs_days = 30 + +log-slave-updates + +log_slow_queries = /var/log/mysql/mysql-slow.log +long_query_time = 2 +#log-queries-not-using-indexes + +# general purpose tuning +max_connections = 1024 +table_cache = 1024 + +# innodb tuning +innodb_buffer_pool_size = 3200M diff -r 277c1fddfc30 -r 20896fd992eb configs/mysql/dfw-db-b02.cnf --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/configs/mysql/dfw-db-b02.cnf Thu Apr 30 21:46:02 2009 +0000 @@ -0,0 +1,21 @@ +[mysqld] +bind-address = 10.176.71.90 + +server-id = 6 +log_bin = /var/lib/mysql-binlogs/dfw-db-b02-bin.log +relay_log = /var/lib/mysql/dfw-db-b02-relay-bin +max_binlog_size = 1G +expire_logs_days = 30 + +log-slave-updates + +log_slow_queries = /var/log/mysql/mysql-slow.log +long_query_time = 2 +#log-queries-not-using-indexes + +# general purpose tuning +max_connections = 1024 +table_cache = 1024 + +# innodb tuning +innodb_buffer_pool_size = 3200M diff -r 277c1fddfc30 -r 20896fd992eb configs/mysql/dfw-db-c01.cnf --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/configs/mysql/dfw-db-c01.cnf Thu Apr 30 21:46:02 2009 +0000 @@ -0,0 +1,21 @@ +[mysqld] +bind-address = 10.176.74.51 + +server-id = 7 +log_bin = /var/lib/mysql-binlogs/dfw-db-c01-bin.log +relay_log = /var/lib/mysql/dfw-db-c01-relay-bin +max_binlog_size = 1G +expire_logs_days = 30 + +log-slave-updates + +log_slow_queries = /var/log/mysql/mysql-slow.log +long_query_time = 2 +#log-queries-not-using-indexes + +# general purpose tuning +max_connections = 1024 +table_cache = 1024 + +# innodb tuning +innodb_buffer_pool_size = 3200M diff -r 277c1fddfc30 -r 20896fd992eb configs/mysql/dfw-db-c02.cnf --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/configs/mysql/dfw-db-c02.cnf Thu Apr 30 21:46:02 2009 +0000 @@ -0,0 +1,21 @@ +[mysqld] +bind-address = 10.176.74.52 + +server-id = 8 +log_bin = /var/lib/mysql-binlogs/dfw-db-c02-bin.log +relay_log = /var/lib/mysql/dfw-db-c02-relay-bin +max_binlog_size = 1G +expire_logs_days = 30 + +log-slave-updates + +log_slow_queries = /var/log/mysql/mysql-slow.log +long_query_time = 2 +#log-queries-not-using-indexes + +# general purpose tuning +max_connections = 1024 +table_cache = 1024 + +# innodb tuning +innodb_buffer_pool_size = 3200M diff -r 277c1fddfc30 -r 20896fd992eb configs/mysql/dfw-db01.cnf --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/configs/mysql/dfw-db01.cnf Thu Apr 30 21:46:02 2009 +0000 @@ -0,0 +1,22 @@ +[mysqld] +bind-address = 10.176.64.134 + +server-id = 1 +log_bin = /var/lib/mysql-binlogs/dfw-db01-bin.log +relay_log = /var/lib/mysql/dfw-db01-relay-bin +max_binlog_size = 1G +expire_logs_days = 30 + +log-slave-updates + +log_slow_queries = /var/log/mysql/mysql-slow.log +long_query_time = 2 +#log-queries-not-using-indexes + +# general purpose tuning +max_connections = 1024 +table_cache = 1024 + +# innodb tuning +innodb_buffer_pool_size = 3200M + diff -r 277c1fddfc30 -r 20896fd992eb configs/mysql/dfw-db02.cnf --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/configs/mysql/dfw-db02.cnf Thu Apr 30 21:46:02 2009 +0000 @@ -0,0 +1,22 @@ +[mysqld] +bind-address = 10.176.64.135 + +server-id = 3 +log_bin = /var/lib/mysql-binlogs/dfw-db02-bin.log +relay_log = /var/lib/mysql/dfw-db02-relay-bin +max_binlog_size = 1G +expire_logs_days = 30 + +log-slave-updates + +log_slow_queries = /var/log/mysql/mysql-slow.log +long_query_time = 2 +#log-queries-not-using-indexes + +# general purpose tuning +max_connections = 1024 +table_cache = 1024 + +# innodb tuning +innodb_buffer_pool_size = 3200M + _______________________________________________ dw-changelog mailing list [email protected] http://lists.dwscoalition.org/mailman/listinfo/dw-changelog
