Changes between Version 22 and Version 23 of InstallationGuidelines/MySQL


Ignore:
Timestamp:
09/06/10 08:12:25 (11 years ago)
Author:
Fran Boon
Comment:

Reorganise

Legend:

Unmodified
Added
Removed
Modified
  • InstallationGuidelines/MySQL

    v22 v23  
    1 == Installation on MySQL ==
     1[[TOC]]
     2= MySQL =
    23Replacing the simple SQLite database with MySQL allows greater scalability
    34
    4 ==== Notes ====
     5== Notes ==
    56 1. The databases directory contains what web2py knows about your database
    67 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.
    78 3. In case of database mismatches - check the databases directory for the appropriate .table file and change accordingly.
    89
    9 === Install MySQL ===
     10== Installation ==
    1011{{{
    1112apt-get install mysql-server
     
    5354}}}
    5455
    55 === MySQL optimisation ===
     56== Optimisation ==
    5657For Production instances, give the MySQL database plenty of RAM:
    5758{{{
     
    6970ALTER TABLE `pr_person` ADD INDEX ( `first_name` );
    7071}}}
    71 === MySQL Replication ===
     72
     73== Troubleshooting ==
     74Can view the list of exoesnive queries using: ''tbc''
     75
     76== Replication ==
    7277In order to have a backup instance, configure replication from the Master node to a Backup node:
    7378 * http://www.debiantutorials.net/mysql-database-replication-masterslave/
    7479 * http://www.howtoforge.com/how-to-repair-mysql-replication
    7580
    76 ==== On Master: ====
     81=== On Master: ===
    7782{{{
    7883pico /etc/mysql/my.cnf
     
    9196Read log filename & position for configuring the slave (see below).
    9297
    93 ==== On Slave: ====
     98=== On Slave: ===
    9499{{{
    95100pico /etc/mysql/my.cnf
     
    115120}}}
    116121
    117 ==== IP Failover ====
     122=== IP Failover ===
    118123Can configure the slave to adopt the same IP as the master using a Heartbeat:
    119124 * http://www.srg.cs.hku.hk/srg/html/cprobe/ha/GettingStarted.html