Preparations
- add these lines to the /system/config.php file to emulate master-slave configuration (set actual database connection settings):
$_CONFIG['Databases'] = array( array( 'DBHost' => 'localhost', 'DBUser' => 'user', 'DBUserPassword' => 'pass', 'DBLoad' => 1, 'DBMaxLag' => 15, ), );
- replace SELECT ... in the ListSQLs property of the l unit config with aSELECT and save changes
- replace SELECT ... in the ListSQLs property of the search-log unit config with aSELECT and save changes
Test Plan
- go to Front-End (homepage)
- confirm, that an SQL error happened
- go to Admin Console
- go to the Logs & Reports → System Log section
- confirm, that:
- a record, for just happened on the Front-End, SQL error was created
- log message starts with [Server #1] , which means 2nd server = slave
- go to Logs & Reports → Search Log section
- confirm, that:
- a record, for just happened on the Front-End, SQL error was created
- log message doesn't start with [Server #...] text (where ... is server index), which means 1nd server = master