Changes between Version 14 and Version 15 of InstallationGuidelines/MySQL


Ignore:
Timestamp:
06/29/10 14:45:40 (11 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • InstallationGuidelines/MySQL

    v14 v15  
    44==== Notes ====
    55 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{{{
     11apt-get install mysql-server
     12}}}
     13
     14=== Install phpMyAdmin ===
     15optional, but highly recommended for easier GUI-based administration
     16{{{
     17apt-get install phpmyadmin
     18}}}
    819
    920=== Install Python support for MySQL ===
     
    2940
    3041=== 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 }}}
     42Connection pools allow connections to be reused.
     43
     44The number used is defined in {{{models/000_config.py}}}
    3545
    3646==== How many pools? ====
     
    5363 * http://www.debiantutorials.net/mysql-database-replication-masterslave/
    5464 * http://www.howtoforge.com/how-to-repair-mysql-replication
     65
    5566==== On Master: ====
    5667{{{