We are moving the script that creates the new r/o users on the wikireplicas (for toolforge + paws), and we have to duplicate all the grants on (we can clean up the old ones once the migration is finished).
The new machines (more than one for high availability) are:
- cloudcontrol1005.wikimedia.org (208.80.154.85)
- cloudcontrol1006.wikimedia.org (208.80.154.149)
- cloudcontrol1007.wikimedia.org (208.80.155.104)
The current grants are:
mysql:labsdbadmin@clouddb1020.eqiad.wmnet [(none)]> show grants; +-----------------------------------------------------------------------------------------------------------------------------------------------------+ | Grants for labsdbadmin@10.64.37.19 | +-----------------------------------------------------------------------------------------------------------------------------------------------------+ | GRANT `labsdbuser` TO `labsdbadmin`@`10.64.37.19` WITH ADMIN OPTION | | GRANT SUPER, CREATE USER ON *.* TO `labsdbadmin`@`10.64.37.19` IDENTIFIED BY PASSWORD 'somethingsomethingsomethingsomethingsomet' WITH GRANT OPTION | | GRANT SELECT, INSERT, UPDATE ON `mysql`.* TO `labsdbadmin`@`10.64.37.19` | | GRANT SELECT, SHOW VIEW ON `%wik%`.* TO `labsdbadmin`@`10.64.37.19` | | GRANT SELECT, SHOW VIEW ON `%_p`.* TO `labsdbadmin`@`10.64.37.19` WITH GRANT OPTION | +-----------------------------------------------------------------------------------------------------------------------------------------------------+
And the instances we need access to are:
clouddb1013.eqiad.wmnet:3311 clouddb1013.eqiad.wmnet:3313 clouddb1014.eqiad.wmnet:3312 clouddb1014.eqiad.wmnet:3317 clouddb1015.eqiad.wmnet:3314 clouddb1015.eqiad.wmnet:3316 clouddb1016.eqiad.wmnet:3315 clouddb1016.eqiad.wmnet:3318 clouddb1017.eqiad.wmnet:3311 clouddb1017.eqiad.wmnet:3313 clouddb1018.eqiad.wmnet:3312 clouddb1018.eqiad.wmnet:3317 clouddb1019.eqiad.wmnet:3314 clouddb1019.eqiad.wmnet:3316 clouddb1020.eqiad.wmnet:3315 clouddb1020.eqiad.wmnet:3318 clouddb1021.eqiad.wmnet:3311 clouddb1021.eqiad.wmnet:3312 clouddb1021.eqiad.wmnet:3313 clouddb1021.eqiad.wmnet:3314 clouddb1021.eqiad.wmnet:3315 clouddb1021.eqiad.wmnet:3316 clouddb1021.eqiad.wmnet:3317 clouddb1021.eqiad.wmnet:3318
Thanks!