[Wikidata-bugs] [Maniphest] [Commented On] T162252: Create SQL database and Tables for Cognate extension to be used on Wiktionaries

[Marostegui]

Marostegui added a comment.

Hello,

So I have created the db and the 3 tables in the following production hosts (without replication):

root@neodymium:/home/marostegui/git/software/dbtools# cat x1.hosts
dbstore2001.codfw.wmnet	3306
tempdb2001.codfw.wmnet	3306
db2033.codfw.wmnet	3306
dbstore1001.eqiad.wmnet	3306
dbstore1002.eqiad.wmnet	3306
db1029.eqiad.wmnet	3306
db1031.eqiad.wmnet	3306

The dbstore servers, for the x1 replication thread will need to be modified, if we really think it is necessary to replicate this DB and its data as they have:

Replicate_Wild_Do_Table: flowdb.%,wikishared.%,heartbeat.%



root@neodymium:/home/marostegui/git/software/dbtools# for i in `cat x1.hosts | awk -F " " '{print $1}'`; do echo $i; mysql --skip-ssl -h$i cognate_wiktionary -e "show tables;";done
dbstore2001.codfw.wmnet
+------------------------------+
| Tables_in_cognate_wiktionary |
+------------------------------+
| cognate_pages                |
| cognate_sites                |
| cognate_titles               |
+------------------------------+
tempdb2001.codfw.wmnet
+------------------------------+
| Tables_in_cognate_wiktionary |
+------------------------------+
| cognate_pages                |
| cognate_sites                |
| cognate_titles               |
+------------------------------+
db2033.codfw.wmnet
+------------------------------+
| Tables_in_cognate_wiktionary |
+------------------------------+
| cognate_pages                |
| cognate_sites                |
| cognate_titles               |
+------------------------------+
dbstore1001.eqiad.wmnet
+------------------------------+
| Tables_in_cognate_wiktionary |
+------------------------------+
| cognate_pages                |
| cognate_sites                |
| cognate_titles               |
+------------------------------+
dbstore1002.eqiad.wmnet
+------------------------------+
| Tables_in_cognate_wiktionary |
+------------------------------+
| cognate_pages                |
| cognate_sites                |
| cognate_titles               |
+------------------------------+
db1029.eqiad.wmnet
+------------------------------+
| Tables_in_cognate_wiktionary |
+------------------------------+
| cognate_pages                |
| cognate_sites                |
| cognate_titles               |
+------------------------------+
db1031.eqiad.wmnet
+------------------------------+
| Tables_in_cognate_wiktionary |
+------------------------------+
| cognate_pages                |
| cognate_sites                |
| cognate_titles               |
+------------------------------+

I will discuss with Jaime what to do with dbstore servers and labs and if we really need to do it there, as he mentioned, x1 is not being replicated to labs as well.

If not, I will remove the database and the tables from dbstore1001 and dbstore1002.

Will update the ticket.

TASK DETAIL

https://phabricator.wikimedia.org/T162252

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Marostegui
Cc: Liuxinyu970226, jcrespo, Marostegui, Lydia_Pintscher, Aklapper, Lea_Lacroix_WMDE, Addshore, QZanden, Salgo60, Minhnv-2809, Urbanecm, Izno, Luke081515, Wikidata-bugs, aude, GPHemsley, Darkdadaah, Mbch331, Jay8g, Krenair

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs