[MediaWiki-commits] [Gerrit] operations/puppet[production]: tools.my.cnf.erb: Ignore memory tables for s51290

2017-11-15 Thread Marostegui (Code Review)
Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/391517 )

Change subject: tools.my.cnf.erb: Ignore memory tables for s51290
..


tools.my.cnf.erb: Ignore memory tables for s51290

The user s51290__dpl_p keeps creating new memory tables with the prefix
"i_" and "u_" and they keep getting full, and being recreated, so there
is no way to avoid breaking replication but ignoring them on
replication.

Bug: T180560
Change-Id: I9464f32e33e87515ee8aee13ecafa5264387d5fd
---
M modules/role/templates/mariadb/mysqld_config/tools.my.cnf.erb
1 file changed, 2 insertions(+), 4 deletions(-)

Approvals:
  Marostegui: Looks good to me, approved
  jenkins-bot: Verified



diff --git a/modules/role/templates/mariadb/mysqld_config/tools.my.cnf.erb 
b/modules/role/templates/mariadb/mysqld_config/tools.my.cnf.erb
index c3f4e87..70fb890 100644
--- a/modules/role/templates/mariadb/mysqld_config/tools.my.cnf.erb
+++ b/modules/role/templates/mariadb/mysqld_config/tools.my.cnf.erb
@@ -67,10 +67,8 @@
 replicate_wild_ignore_table= s51071\_\_templatetiger\_p.%
 replicate_wild_ignore_table= s52721\_\_pagecount\_stats\_p.%
 # T180560
-replicate_wild_ignore_table= s51290__dpl_p.i_orphan_candidates
-replicate_wild_ignore_table= s51290__dpl_p.i_psub
-replicate_wild_ignore_table= s51290__dpl_p.i_redirects
-replicate_wild_ignore_table= s51290__dpl_p.u_pagelinks
+replicate_wild_ignore_table= s51290__dpl_p.u\_%
+replicate_wild_ignore_table= s51290__dpl_p.i\_%
 
 table_open_cache   = 5000
 table_definition_cache = 4000

-- 
To view, visit https://gerrit.wikimedia.org/r/391517
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: merged
Gerrit-Change-Id: I9464f32e33e87515ee8aee13ecafa5264387d5fd
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Marostegui 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits


[MediaWiki-commits] [Gerrit] operations/puppet[production]: tools.my.cnf.erb: Ignore memory tables for s51290

2017-11-15 Thread Marostegui (Code Review)
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/391517 )

Change subject: tools.my.cnf.erb: Ignore memory tables for s51290
..

tools.my.cnf.erb: Ignore memory tables for s51290

The user s51290__dpl_p keeps creating new memory tables with the prefix
"i_" and "u_" and they keep getting full, and being recreated, so there
is no way to avoid breaking replication but ignoring them on
replication.

Bug: T180560
Change-Id: I9464f32e33e87515ee8aee13ecafa5264387d5fd
---
M modules/role/templates/mariadb/mysqld_config/tools.my.cnf.erb
1 file changed, 2 insertions(+), 4 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/17/391517/1

diff --git a/modules/role/templates/mariadb/mysqld_config/tools.my.cnf.erb 
b/modules/role/templates/mariadb/mysqld_config/tools.my.cnf.erb
index c3f4e87..70fb890 100644
--- a/modules/role/templates/mariadb/mysqld_config/tools.my.cnf.erb
+++ b/modules/role/templates/mariadb/mysqld_config/tools.my.cnf.erb
@@ -67,10 +67,8 @@
 replicate_wild_ignore_table= s51071\_\_templatetiger\_p.%
 replicate_wild_ignore_table= s52721\_\_pagecount\_stats\_p.%
 # T180560
-replicate_wild_ignore_table= s51290__dpl_p.i_orphan_candidates
-replicate_wild_ignore_table= s51290__dpl_p.i_psub
-replicate_wild_ignore_table= s51290__dpl_p.i_redirects
-replicate_wild_ignore_table= s51290__dpl_p.u_pagelinks
+replicate_wild_ignore_table= s51290__dpl_p.u\_%
+replicate_wild_ignore_table= s51290__dpl_p.i\_%
 
 table_open_cache   = 5000
 table_definition_cache = 4000

-- 
To view, visit https://gerrit.wikimedia.org/r/391517
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: I9464f32e33e87515ee8aee13ecafa5264387d5fd
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits