Thanks - ping us once the database is actually created.
Note for the DBAs, if this is done before - T172514 gets merged, we need to apply the ALTERs to this wiki.

Hmm. I though you had to check previously, I mean, before the DB is created if there's enough disk space, etc.? In any case, we'll notify you again after the DB is created too.

In T173027#3558381, @MarcoAurelio wrote:

Hmm. I though you had to check previously, I mean, before the DB is created if there's enough disk space, etc.? In any case, we'll notify you again after the DB is created too.

No. If the wiki is public, the only thing we need to do is, once the DB is created, sanitize the tables on the sanitarium+labs hosts. Once that is done, cloud-services-team generates the views and all that.
You can go ahead and create it in production and let us know.

Okie dockie :)

Everything is set up already I think. We just need a sysadmin willing to do it and a deployment window.

@Marostegui Wiki creation is happening now.

In T173027#3631300, @MarcoAurelio wrote:

@Marostegui Wiki creation is happening now.

I can see it is already created on the master. I will check the triggers and all that for sanitarium hosts

Mentioned in SAL (#wikimedia-operations) [2017-09-25T11:39:47Z] <marostegui> Run redact_sanitarium for hiwikivoyage on db1095 - T173027

I have run redact_sanitarium on db1095 and I can see that the user, revision and recentchanges tables have been sanitized correctly.
I am running the check_private data on labsdb1009 to see if there is something reported there.

Once that is fine, I will give the green light to cloud-services-team to create the views.

The report finished on labsdb1009 and I can see the new users are being sanitized correctly on all hosts.
I will wait for the report to finish on labsdb1001 before handling it to cloud team

All good on labsdb1001 as well.
cloud-services-team feel free to create the views

Thanks!

Mentioned in SAL (#wikimedia-operations) [2017-09-28T05:43:46Z] <marostegui> Run maintain-views on labsdb1001, labsdb1003, labsdb1009, labsdb1010, labsdb1011 for hiwikivoyage - T173027

I performed the other steps from https://wikitech.wikimedia.org/wiki/Add_a_wiki#Cloud_Services :

• /usr/local/sbin/maintain-meta_p --databases hiwikivoyage [--mysql-socket /tmp/mysql.sock]
• /usr/local/sbin/wikireplica_dns --aliases --shard s3