Database

If you are ready to deploy a Django site, start by creating a database…

Create

Note

Make sure the Salt pillar is configured correctly for the site. You need to include the database password and a folder containing the database settings.

For details, see Site - Configuration

For MySQL:

ssh the.server.ip.address
sudo -i
mysql
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '';

For details, see:

• MySQL Error: : ‘Access denied for user ‘root’@’localhost’

• Allow linux root user mysql root access without password

To create a database for a site:

cd fabric
fab create-db domain:www.hatherleigh.info

# if your would like to use a Postgres table space name
fab domain:www.hatherleigh.info create-db:cbs

To create a workflow database for a site:

fab domain:www.hatherleigh.info create-db-workflow

You are now ready to Deploy your site…

Drop/Delete

To drop a database, you will need to append the current date and time e.g:

fab domain:www.hatherleigh.info drop_db:02/02/2015-16:54

To drop a database role:

fab domain:www.hatherleigh.info drop_db_role

Note

This command should fail if the role is in use.

Maintenance

• Backup

• Restore