Changes between Version 14 and Version 15 of InstallationGuidelines/MySQL
- Timestamp:
- 06/29/10 14:45:40 (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
InstallationGuidelines/MySQL
v14 v15 4 4 ==== Notes ==== 5 5 1. The databases directory contains what web2py knows about your database 6 2. You need to set Migrate=True in {{{models/00_db.py}}} before you update the code and switch back to Migrate=False later on. 7 3. In case of database mismatches - check the databases directory for the appropriate table ( cat the file ) and change accordingly. 6 2. You need to set deployment_settings.base.migrate=True in {{{models/000_config.py}}} before you update the code and switch back to deployment_settings.base.migrate=False later on. 7 3. In case of database mismatches - check the databases directory for the appropriate .table file and change accordingly. 8 9 === Install MySQL === 10 {{{ 11 apt-get install mysql-server 12 }}} 13 14 === Install phpMyAdmin === 15 optional, but highly recommended for easier GUI-based administration 16 {{{ 17 apt-get install phpmyadmin 18 }}} 8 19 9 20 === Install Python support for MySQL === … … 29 40 30 41 === Configure Eden === 31 Suggest to use connection pools to reuse connections in {{{models/00_db.py}}}: 32 {{{ 33 db=SQLDB('mysql://user:mypassword@hostname/sahana',pools=20) 34 }}} 42 Connection pools allow connections to be reused. 43 44 The number used is defined in {{{models/000_config.py}}} 35 45 36 46 ==== How many pools? ==== … … 53 63 * http://www.debiantutorials.net/mysql-database-replication-masterslave/ 54 64 * http://www.howtoforge.com/how-to-repair-mysql-replication 65 55 66 ==== On Master: ==== 56 67 {{{