Creating a Tenant Database

What is a Tenant Database?

• A tenant database is when a single instance, or a few instances, of a software application, serves multiple users. 

What problem does having a tenant database solve?

• Having a tenant database allows you to isolate different groupings of data without having to create multiple projects. This will allow you to cache student data on your database while still accessing Admin+. This will also let you run custom queries on your student’s data. You can create multiple tenant databases, but currently, you can only run one alongside Admin+. 

Where to add your tenant database?

• Once you have successfully created and tested your database, you can connect it to Admin+

Creating and testing your connection:

• You need to create your database before you try to connect the tenant database to Admin+.
• This database will need a MySQL database.
  • We recommend that you create your database in Google Cloud Platform, but you can use any software that allows public secure access.
• Before you try to connect your database to Admin+, make sure that you can connect to it.
  • We recommend that you use a tool like MySQL workbench.

To get started

1. Go to Account.
2. Click the Settings icon in the config box.
3. Select Add.
   1. In the pop-up box, input the settings to connect to your database to Admin+.
4. Input values:
   1. Host - IP address of where your database is located.
   2. Port - port address of database.
   3. User - username for the user who has access to the database.
   4. User-Password - password for the user.

Note: If the project is in Google Cloud Platform, you will need to include your socket path. Otherwise, include your SSL information.

Updated June12, 2023