Changes between Version 22 and Version 23 of InstallationGuidelines/MySQL

Timestamp:

09/06/10 08:12:25 (14 years ago)

Author:

Fran Boon

Comment:

Reorganise

InstallationGuidelines/MySQL

@@ -1 @@
-== Installation on MySQL ==
+[[TOC]]
+= MySQL =
 Replacing the simple SQLite database with MySQL allows greater scalability
 
-==== Notes ====
+== Notes ==
  1. The databases directory contains what web2py knows about your database
  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.
  3. In case of database mismatches - check the databases directory for the appropriate .table file and change accordingly.
 
-=== Install MySQL ===
+== Installation ==
 {{{
 apt-get install mysql-server
@@ -53 +54 @@
 }}}
 
-=== MySQL optimisation ===
+== Optimisation ==
 For Production instances, give the MySQL database plenty of RAM:
 {{{
@@ -69 +70 @@
 ALTER TABLE `pr_person` ADD INDEX ( `first_name` );
 }}}
-=== MySQL Replication ===
+
+== Troubleshooting ==
+Can view the list of exoesnive queries using: ''tbc''
+
+== Replication ==
 In order to have a backup instance, configure replication from the Master node to a Backup node:
  * http://www.debiantutorials.net/mysql-database-replication-masterslave/
  * http://www.howtoforge.com/how-to-repair-mysql-replication
 
-==== On Master: ====
+=== On Master: ===
 {{{
 pico /etc/mysql/my.cnf
@@ -91 +96 @@
 Read log filename & position for configuring the slave (see below).
 
-==== On Slave: ====
+=== On Slave: ===
 {{{
 pico /etc/mysql/my.cnf
@@ -115 +120 @@
 }}}
 
-==== IP Failover ====
+=== IP Failover ===
 Can configure the slave to adopt the same IP as the master using a Heartbeat:
  * http://www.srg.cs.hku.hk/srg/html/cprobe/ha/GettingStarted.html