747900 - buildbot-ro-vip.db.scl3.mozilla.com/buildbot seems to be stale

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Chris AtLee [:catlee]]

I'm trying to run some queries against the buildbot database via buildbot-ro-vip.db.scl3.mozilla.com and it looks like it's only got data up to April 9th.

Comment 1

[Sheeri Cabral [:sheeri]]

The buildbot-ro vip points to one server, 10.22.70.201, which is buildbot2.db.scl3.mozilla.com - so I believe those VIPs were set up with the idea that when you switched over from the b1 databases to the buildbot cluster, all you'd have to do is change the db host in the config from the b1 VIP to the buildbot cluster VIP.

Here are the b1 VIPs:
b1-rw-db-vip.db.scl3.mozilla.com
b1-ro-db-vip.db.scl3.mozilla.com

Here are the buildbot VIPs:
buildbot-rw-vip.db.scl3.mozilla.com
buildbot-ro-vip.db.scl3.mozilla.com

So there are 2 options:

0) Leave the VIPs as-is, change the app to use the b1 VIPs until the migration happens.

1) Change the VIPs so that buildbot points to the b1 databases for now, and during the migration, change the VIPs again.

I can change VIPs, so there's not too much extra coordination if you go with option #1.

Comment 2

[Sheeri Cabral [:sheeri]]

it was a replication thang, I have fixed this now.