wiseengineering / crispy-worker Goto Github PK

As here we have https://github.com/melnychukvitaliy/mysql-migrate Percona helper to run migrations we need something like that in worker.

The main idea of this component is to listen commands from crispy-api and be able to make the following actions:

• run migration
• communicate with API during migration run

Let's start to init simple TS based worker with the ability to run Percona tool
as a second step we will split runner and worker

As we have workers that communicate with crispy-api for the following reasons:

• API sends a request when we need to run the migration
• Worker sends to API what the current status of migration

We need to describe it in details what kind of requests we need from API, and how crispy-cli will be used here.
Initially, the idea was to have a lot different workers to run migrations in different servers and have runners installed there.
But we need crispy-cli as migration runner and migrations schema parser.
We would like to run particular crispy-cli command when we receive some command from API.

As a result here, should be:

• detailed schema how crispy-cli whould be installed here
• the main purpose of service
• what we need from API
• what we give to API

one from cases how we can use this service is to have all set of runners installed here along with crispy-cli.

we need to provide Dockerfile where we will install

• proper nodejs version
• percona toolkit
• mysql runner
• crispy-cli

also, we need to provide the ability to mount users migrations directory to give the ability run migrations locally and avoid web, api usage

As the final step, we need CI configuration to build this image automatically