search

eklinger-UofA / PerfectArchOrthotics

Code for PerfectArchOrthotics website
http://perfectarchorthotics-eklinger.rhcloud.com/
0 stars 1 forks source link

Move DB backend to its own gear on openshift #10

Closed eklinger-UofA closed 10 years ago

eklinger-UofA commented 10 years ago

Set up a mysql DB on openshift as another gear, this will be used to hold all the DB contents (can get large quick) and this will be the gear we will start expanding storage on.

eklinger-UofA commented 10 years ago

I have moved the DB from sqlite (only usable really in development to using mysql running on its own gear.

All the gear info are below: Adding mysql-5.5 to application 'PerfectArchOrthotics' ... done

mysql-5.5 (MySQL 5.5)

Gears: Located with python-2.7 Connection URL: mysql://$OPENSHIFT_MYSQL_DB_HOST:$OPENSHIFT_MYSQL_DB_PORT/ Database Name: perfectarchorthotics Password: CcikLZzpSqI2 Username: adminHIydFsr

MySQL 5.5 database added. Please make note of these credentials:

   Root User: adminHIydFsr

Root Password: CcikLZzpSqI2 Database Name: perfectarchorthotics

Connection URL: mysql://$OPENSHIFT_MYSQL_DB_HOST:$OPENSHIFT_MYSQL_DB_PORT/

You can manage your new MySQL database by also embedding phpmyadmin. The phpmyadmin username and password will be the same as the MySQL credentials above.

Next TODO item is to get this things ready for production by adding south to my django project