wiki:InstallationGuidelines/MySQL

Version 3 (modified by Fran Boon, 12 years ago) ( diff )

Python support

Installation on MySQL

Replacing the simple SQLite database with MySQL allows greater scalability

Install Python support for MySQL:

apt-get install python-mysqldb

or

wget http://downloads.sourceforge.net/project/mysql-python/mysql-python-test/1.2.3c1/MySQL-python-1.2.3c1.tar.gz
tar zxvf MySQL-python-1.2.3c1.tar.gz
cd MySQL-python-1.2.3c1
python setup.py install

Create the database 1st:

mysqladmin --user=root -p create sahana
mysql -p
 GRANT USAGE ON 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

Note: See TracWiki for help on using the wiki.