Marostegui added a comment.
In T219145#5084305 <https://phabricator.wikimedia.org/T219145#5084305>, @alaa_wmde wrote: > @Marostegui thanks for your update! > > Postponing until the new master is up and running is very unlikely to be the adjustment we would go for. > > The more likely one would be to change to migration plan 2 (take from bonfire slides <https://docs.google.com/presentation/d/1FbaD4sv7vMZICD7NJfW3tp2CqtosigB0dNeWbtztpKo/edit#slide=id.g5069c67ff2_0_344>): I don't have access to that. Just requested it. > **on write**: write to new schema and delete from old one > **on read** read from both schemas > when old wb_terms is empty, read only from new schema and drop wb_terms table eventually > > This plan will actually not require extra space (not significant increase at least) and will result in reducing the total space usage over time. You've got any estimations on how much it would require? > It is hard to estimate the footprint of this plan on performance, which is likely to be a little higher than the original one. If I can think of a way to estimate I will share some numbers soon. This would be useful to know if you can come with some figures. I assume it is possible to stop the migration right away if we see performance issues and then resume once we are on a better shape (ie: we discover the performance degradation is an issue and we decide to fully wait for the new master), right? TASK DETAIL https://phabricator.wikimedia.org/T219145 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: alaa_wmde, Marostegui Cc: jcrespo, Marostegui, JeroenDeDauw, Addshore, Ladsgroup, Aklapper, alaa_wmde, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
