/
2. Create Google Cloud SQL Instance
- Select the SQL menu option in the sliding menu pane on left to create a new MySQL db.
- Click on "Create instance" option.
- Click on "Choose MySQL".
- Set a instance ID such as
streammanager-db
. - Set a root password (you can let GCP generate the password).
- Database version: Select MySQL 8.0.
- Select the region where you reserved the static IP for the stream manager. For high-availability, select "Multiple Zones" (recommended for production environments).
- Click and expand
Configuration options
. - Select a machine type, storage type according to estimated usage load.
- Under
Set Connectivity
, make surePublic IP
is selected. Below it click on+Add Networks
and add the stream manager IP address. Note: You might also want to add your IP address to be able to manage the stream manager database. - Leave the other options to default settings.
- Under
Set maintenance schedule
, select an appropriate time for possible maintainence. Select a day which falls outside your streaming schedule. - Press "Create" button to create the instance.