Revision 96b635d9
| b/README.admin | ||
|---|---|---|
| 5 | 5 |
step-by-step Synnefo deployment instructions. |
| 6 | 6 |
|
| 7 | 7 |
|
| 8 |
Database |
|
| 9 |
======== |
|
| 10 |
|
|
| 11 |
MySQL: manage.py dbshell seems to ignore the setting of 'init_command' |
|
| 12 |
in settings.DATABASES |
|
| 13 |
|
|
| 8 | 14 |
Reconciliation mechanism |
| 9 | 15 |
======================== |
| 10 | 16 |
|
| b/README.deploy | ||
|---|---|---|
| 200 | 200 |
|
| 201 | 201 |
transaction-isolation = READ-COMMITTED |
| 202 | 202 |
|
| 203 |
in the [mysql] section of /etc/mysql/my.cnf. |
|
| 203 |
in the [mysqld] section of /etc/mysql/my.cnf.
|
|
| 204 | 204 |
|
| 205 |
Alternatively, make sure the following code fragment stays enabled |
|
| 206 |
in settings.d/10-database.conf: |
|
| 207 |
|
|
| 208 |
if DATABASES['default']['ENGINE'].endswith('mysql'):
|
|
| 209 |
DATABASES['default']['OPTIONS'] = {
|
|
| 210 |
'init_command': 'SET storage_engine=INNODB; ' + |
|
| 211 |
'SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED', |
|
| 212 |
} |
|
| 213 |
|
|
| 205 | 214 |
* PostgreSQL |
| 206 | 215 |
You need to install the PostgreSQL binaries: |
| 207 | 216 |
* Ubuntu - Debian |
| b/settings.d/10-database.conf | ||
|---|---|---|
| 23 | 23 |
|
| 24 | 24 |
if DATABASES['default']['ENGINE'].endswith('mysql'):
|
| 25 | 25 |
DATABASES['default']['OPTIONS'] = {
|
| 26 |
'init_command': 'SET storage_engine=INNODB', |
|
| 26 |
'init_command': 'SET storage_engine=INNODB; ' + |
|
| 27 |
'SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED', |
|
| 27 | 28 |
} |
Also available in: Unified diff