Feature #17544
Updated by Morton Jonuschat almost 9 years ago
I've create a Patch (just a proof-of-concept) to Cluster the Select Statements from Typo3. You can enter in localconf.php multiple slave servers. This servers will be selected by rand(0, [amount of slave servers]). I add a "dead File" to disable a slave server (in case of emergency or planned downtime). This file must be remove by hand from admin. It's possible to create this deadFile by hand (in case "out-of-sync" of the slave db servers). In the backend, the normal master server will be used. Proof-of-Concept ---- $TYPO3_CONF_VARS['SYS']['slave_db_handler'][] = array( 'typo3_db' => 'db', 'typo3_db_host' => 'slave01', 'typo3_db_password' => 'geheim', 'typo3_db_username' => 'user', 'dead_file' => 'typo3conf/slave01_db_dead' ); $TYPO3_CONF_VARS['SYS']['slave_db_handler'][] = array( 'typo3_db' => 'db', 'typo3_db_host' => 'slave02', 'typo3_db_password' => 'geheim', 'typo3_db_username' => 'user', 'dead_file' => 'typo3conf/slave02_db_dead' ); ---- (issue imported from #M6180)