Where are the Scheduler Service Instances located?

Products

• VMware Tanzu Application Service for VMs

Issue/Introduction

When you create scheduler service instance you don't see any application being deployed or a VM being created. Where are Scheduler Service Instances located?

Environment

Product Version: 2.13

Resolution

The Scheduler Broker is an application deployed to org system and space scheduler but when you create a service instance you don't see any app being deployed or a vm being created. This is expected, Once the Scheduler service broker receives a create request it creates entry on the Scheduler Database which were configured on the tile . 

These are the tables used by Scheduler Service Broker

You can check the database service the broker is using:
 

$cf target -o system -s scheduler
$cf services
Getting service instances in org system / space scheduler as admin...

name                     offering   plan       bound apps         last operation     broker                   upgrade available
scheduler-broker-mysql   p.mysql    db-small   scheduler-broker   create succeeded   dedicated-mysql-broker   no
scheduler-mysql          p.mysql    db-small   scheduler          create succeeded   dedicated-mysql-broker   no

If you are using MySQL for VMs tile, you can connect to the service using these steps to connect to scheduler-broker-mysql database service.

Scheduler service instances info are kept in the service_instance_db;

mysql> use service_instance_db;
Database changed
mysql> show tables;
+-------------------------------+
| Tables_in_service_instance_db |
+-------------------------------+
| gorp_migrations |
| service_bindings |
| service_instances |
+-------------------------------+
3 rows in set (0.00 sec)

Each service_instance has an entry on the service_instances table

mysql> select * from service_instances;
+--------------------------------------+--------------------------------------+--------------------------------------+--------------------------------------+---------------------+---------------------+
| guid | space_guid | organization_guid | plan_id | created_at | updated_at |
+--------------------------------------+--------------------------------------+--------------------------------------+--------------------------------------+---------------------+---------------------+
| b39c816f-0500-4c06-a1ef-cb8ceb961684 | 93668fa4-ad33-4248-bf82-42f16de018b0 | 21716359-9fa3-4990-b02b-e071d393247b | 5a8113c1-08f7-4f68-9272-d1bbed9d509b | 2023-09-19 03:17:31 | 2023-09-19 03:17:31 |
+--------------------------------------+--------------------------------------+--------------------------------------+--------------------------------------+---------------------+---------------------+