Comment 3 for bug 899849

Great job Nick! Charm is now in the official charm repo as 'lp:charm/limesurvey'

Tested with haproxy and 2 units, seems to work alright, siege w/ the default settings revealed problems, but I think they are probably due to our not-so-tuned haproxy settings.

Transactions: 3887 hits
Availability: 98.73 %
Elapsed time: 514.67 secs
Data transferred: 7.29 MB
Response time: 1.47 secs
Transaction rate: 7.55 trans/sec
Throughput: 0.01 MB/sec
Concurrency: 11.11
Successful transactions: 3887
Failed transactions: 50
Longest transaction: 11.61
Shortest transaction: 0.30

My admin session would occasionally require re-authing, I don't know if thats by design or a weirdness in the app. Anyway, it worked great. I am going to open a bug to have the database table type to InnoDB, but I'm not going to fix that as I'd like for somebody to test it and make sure limesurvey works ok with it. One woudl need to change $databasetabletype in config.php to 'InnoDB'.

./config-defaults.php:$databasetabletype = 'myISAM'; // Storage engine mysql should use when creating survey results tables and token tables (if mysql is used). Default is myISAM.

Thanks again Nick!!