Project

General

Profile

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)

Back