Database Deployment

Jump to bottom

Ophir Katz edited this page Jun 23, 2018 · 3 revisions

The Cognitivity database is deployed in Azure.

In order to deploy the database:

Create an Azure service called "Azure Database for MySQL". Guide here.
Connect to the database from a bash shell:

mysql --host fully-qualified-server-name> --user server-admin-login-name>@server-name -p

Enter the password, found in the Azure's resource credential page.
Copy the database file's content to the mysql session in the shell.
This will create the databases and the tables within it.

This process need to happen after every change to the database in development.

Note! Every change will cause all the data in the database to be erased, so try to minimize the number of changes to the database in production.