Skip to content

Add all databases to reindex job

Sergio Pena Filgueira requested to merge isergiopena/dotstatsuite-core-data-access:sp_reindex into develop

dotstatsuite-core-transfer#715

This PR has not been tested with real production data, I will be able to do so in the next weeks months when our BDAs finish a migration. In the meantime is an RFC on how this container works.

I ran into several issues trying to run the DevOps database container on an AWS RDS MySQL server.

  • RDS creates extra databases that cannot be modified by the 000-script
  • RDS does have limited capabilities for managing jobs using SSMS, the 0003-script wasn't overwriting the old job so I modified it to recreate it on every run, same for the schedule.
  • In the README it says that the script has to be run only once by MS SQL instance, but as far I could understand the reindex was only being launched for the current database skipping other databases in the same server. I've modified the script to add one step for every database on the server following the same logic on 000-script. So the logic is to create the SP on the target database and run a Scheduled job that has one step for every dotstat database on the server.

Any comments or insights on this will be really appreciated.

Thank you!

Edited by Jens Dossé

Merge request reports