Page MenuHomePhabricator

Access to *.labsdb servers needed for the wikidataconcepts project/instance
Closed, ResolvedPublic

Description

Hi,

we need access to MariaDB replicas for Labs project: wikidataconcepts, from instance: wikidataconcepts; requesting this in line with: https://wikitech.wikimedia.org/wiki/Help:Tool_Labs/Database: "The *.labsdb servers should be directly accessible from other Labs instances as well (these are provided in DNS), but there is no automatic creation of database credential files."

One question: does the staging database gets replicated on *.labsdb servers? I am fetching some data from production (stat1003) and I need to be able to access them from the wikidataconcepts Labs instance somehow.

Thanks a lot!

Regards,

Goran S. Milovanovic
Data Analyst, WMDE

Event Timeline

GoranSMilovanovic created this task.
bd808 added a subscriber: Aklapper.

we need access to MariaDB replicas for Labs project: wikidataconcepts, from instance: wikidataconcepts; requesting this in line with: https://wikitech.wikimedia.org/wiki/Help:Tool_Labs/Database: "The *.labsdb servers should be directly accessible from other Labs instances as well (these are provided in DNS), but there is no automatic creation of database credential files."

You can find the credential file in your user space on the tools project, or in the tool space in a tool on tools (after using the become command). The file is named replica.my.cnf
From a labs project you can then do something like the following to connect to the enwiki replica.

mysql -u <USERNAME> -p -h enwiki.labsdb

One question: does the staging database gets replicated on *.labsdb servers? I am fetching some data from production (stat1003) and I need to be able to access them from the wikidataconcepts Labs instance somehow.

No, the staging database contained within the production analytics cluster is not replicated anywhere as it could contain all sorts of data.

Thanks @Addshore already done (@bd808 provided the same suggestions on IRC).