Versions Compared

Version Old Version 6 New Version Current
Changes made by

Alex

Alex

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. add $_CONFIG['Database']['LoadBalancing'] = '1'; to /system/config.php file

  2. create /system/db_servers.php file with following content: 

    Code Block
    <?php 

$_CONFIG['Databases'] = Array ( 
    Array ( 
        'DBHost' => 'slave.host1', 
        'DBUser' => 'slave.user1', 
        'DBUserPassword' => 'slave.user.password1', 
        'DBLoad' => 1, 
    ), 
    Array ( 
        'DBHost' => 'slave.host2', 
        'DBUser' => 'slave.user2', 
        'DBUserPassword' => 'slave.user.password2', 
        'DBLoad' => 1, 
        'DBMaxLag' => 15, // optional, slave replication delay in seconds 
        'DBMaxThreads' => 100, // optional, when slave thread count is above 
this number, then it won't be used 
    ), 
);

  3. only Slave Servers are listed in file above, since database server defined in /system/config.php is considered as Master Server for backwards compatibility. 

...