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