Changes between Initial Version and Version 1 of InstallationGuidelines/MySQL

Timestamp:

01/14/10 16:32:35 (15 years ago)

Author:

Fran Boon

Comment:

--

InstallationGuidelines/MySQL

@@ +1 @@
+== Installation on MySQL ==
+Replacing the simple SQLite database with MySQL allows greater scalability
+
+Create the database 1st:
+{{{
+mysqladmin --user=root -p create sahana
+mysql -p
+ GRANT USAGE ON mysql.sahana TO 'sahana'@'localhost' IDENTIFIED BY 'mypassword';
+}}}
+
+Suggest to use connection pools to reuse connections in {{{models/00_db.py}}}:
+{{{
+db=SQLDB('mysql://user:password@hostname/sahana',pools=20)
+}}}
+
+How many pools?
+{{{
+whatever you choose it always starts with one and grows with the
+number of concurrent requests up to the value of pools (the max number
+of concurrent pools). So pools should be the max number of concurrent
+requests you expect. That is the max value of:
+<number of requests/second> / <average time per request in seconcds> 
+}}}
+
+----
+InstallationGuidelines