Patch (schema already reviewed by Amir): https://gerrit.wikimedia.org/r/c/mediawiki/extensions/OATHAuth/+/873892
Following https://wikitech.wikimedia.org/wiki/Creating_new_tables:
- Should this table be replicated to wiki replicas (does it not contain private data)? oathauth_devices is private. oathauth_types technically is not, although I don't see any value from replicating it without _devices.
- Will you be doing cross-joins with the wiki metadata? Not sure what this means. No cross-wiki joins will be performed.
- Size of the table (number of rows expected). Initially in the same region as the existing oathauth_users table (which is being replaced).
- Expected growth per year (number of rows). See answer to last question.
- Expected amount of queries, both writes and reads (per minute, per hour...per day, any of those are ok). This table is queried with each login attempt with a login attempt where a correct password was provided. This dashboard suggests that happens roughly 100-200 times per second. Writes happens when someone sets up or disables two-factor authentication. Again, these are replacing the existing oathauth_users table with similar query patterns.
- Examples of queries that will be using the table.
- SELECT oad_data,oat_name FROM oathauth_devices JOIN oathauth_types ON ((oat_id = oad_type)) WHERE oad_user = 123456
- The release plan for the feature (are there specific wikis you'd like to test first etc). These tables are shared for all public wikis, so testing on a single wiki is not unfortunately possible.