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

Reply via email to