2

I have an existing POD containing a DB. I have a script containing executable queries in that container. I need to schedule the execution of the script. How do I go about doing this?

Daniel
  • 2,355
  • 9
  • 23
  • 30
Srijoni Biswas
  • 83
  • 1
  • 5

2 Answers2

1

OpenShift has a "cronjob" resource type which can schedule a job to run at specific intervals. You can read more about it here.

You can create a custom image which contains the client to connect to your DB and supply it with the credentials mapped as secrets. This can run your executable queries at the interval you've set for the job.

Community
  • 1
  • 1
Badri
  • 2,212
  • 3
  • 25
  • 26
  • Using a shell script how exactly do we connect to a DB in a different POD. Given, I have the servicediscovery.json but don't have/know the exact command to connect. – Srijoni Biswas Jan 10 '19 at 07:21
0

You can have 2 options

1) If your base image comes with crontab simply create a crontab using the usual commands here. If the base image doesn't have the crontab you can add it as in this example.

2) Use the openshift 'Scheduled Jobs' that comes with Kubernetes see here

Essex Boy
  • 7,565
  • 2
  • 21
  • 24