Asher has uploaded a new change for review.
https://gerrit.wikimedia.org/r/68602
Change subject: labsdb: set innodb_locks_unsafe_for_binlog for s4-5, set high
slave_transaction_retries for all shards
......................................................................
labsdb: set innodb_locks_unsafe_for_binlog for s4-5, set high
slave_transaction_retries for all shards
Change-Id: Ia1724e62f4a9ca8d711dc03487f99edfc4390ed7
---
M manifests/site.pp
1 file changed, 9 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/puppet
refs/changes/02/68602/1
diff --git a/manifests/site.pp b/manifests/site.pp
index 1e12496..144e38d 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -1231,6 +1231,7 @@
'ram' => "151G",
'innodb_locks_unsafe_for_binlog' => true,
'repl_ignore_dbs' => 'mysql',
+ 'slave_transaction_retries' => 100000,
'read_only' => 0,
},
}
@@ -1246,20 +1247,25 @@
'ram' => "48G",
'innodb_locks_unsafe_for_binlog' => true,
'repl_ignore_dbs' => 'mysql',
+ 'slave_transaction_retries' => 100000,
'read_only' => 0,
},
's4' => {
'port' => 3307,
'innodb_log_file_size' => "2000M",
'ram' => "48G",
+ 'innodb_locks_unsafe_for_binlog' => true,
'repl_ignore_dbs' => 'mysql',
+ 'slave_transaction_retries' => 100000,
'read_only' => 0,
},
's5' => {
'port' => 3308,
'innodb_log_file_size' => "1000M",
'ram' => "48G",
+ 'innodb_locks_unsafe_for_binlog' => true,
'repl_ignore_dbs' => 'mysql',
+ 'slave_transaction_retries' => 100000,
'read_only' => 0,
},
}
@@ -1275,6 +1281,7 @@
'ram' => "48G",
'innodb_locks_unsafe_for_binlog' => true,
'repl_ignore_dbs' => 'mysql',
+ 'slave_transaction_retries' => 100000,
'read_only' => 0,
},
's6' => {
@@ -1283,6 +1290,7 @@
'ram' => "48G",
'innodb_locks_unsafe_for_binlog' => true,
'repl_ignore_dbs' => 'mysql',
+ 'slave_transaction_retries' => 100000,
'read_only' => 0,
},
's7' => {
@@ -1291,6 +1299,7 @@
'ram' => "48G",
'innodb_locks_unsafe_for_binlog' => true,
'repl_ignore_dbs' => 'mysql',
+ 'slave_transaction_retries' => 100000,
'read_only' => 0,
},
}
--
To view, visit https://gerrit.wikimedia.org/r/68602
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ia1724e62f4a9ca8d711dc03487f99edfc4390ed7
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Asher <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
