EXT: QForms¶

Database configuration¶

In this example you have a MySQL architecture ('db' section) with 1 master host that will be the target of your data modification queries. This Master host its the default TYPO3 database host (array('host'=>$t ypo_db_host,'port'=>3306,'user'=>$typo_db_username,'pass'=>''))

you could add more hosts if you have a multimaster MySQL.

Also you have 2 slaves (replications slaves) MySQL hosts: the default TYPO3 host and other '192.168.1.56'. This second server could be elected 3 times more than the first one. The slaves servers will be the targets of SELECT queries

VERY IMORTANT: databasename have to be same in all database servers.

Memcached configuration¶

The configuration of server works in the same way as in database servers.

I you set 'defaultTryMemcached'=>TRUEthen all of your SELECT queries will try to use memcached at less you add a flag to your exec_SELECTqueryto avoid it.

Now the exec_SELECTqueryhave this signature: exec_SELECTquery($selec t_fields,$from_table,$where_clause,$groupBy='',$orderBy='',$limit=' ',$tryMemcached='')to give more control to developers.

If you set $tryMemcached=FALSEthen query wont be stored in memcached.

If you set $tryMemcached=TRUEthen query will be stored in memcached.

If you dont set $tryMemcachedthe deault action 'defaultTryMemcached'=>TRUEits considered

/**********************************************************************************

* TYPO3 SCLABLE EXTENSION CONFIGURATION

* BEGIN

*********************************** *********************************** ************/

$t3p_scalable_conf=array(

'db'=>array(

'readAttempts'=>1, // attemps if connection fails

'writeAttempts'=>1, // attemps if connection fails

'write'=>array(

array('host'=>$typo_db_host,'port'=>3306,'user'=>$typo_db_username ,'pass'=>''),

),

'read'=>array(

array('host'=>$typo_db_host,'port'=>3306,'user'=>$typo_db_username ,'pass'=>''),

array('host'=>'192.168.1.56','port'=>3306,'user'=>'root','pass'=>'','w eight'=>3),

),

),

'memcached'=>array(

'keyPrefix'=>'myDomain-', // key prefix to avooid key collisions

'objectTimeout'=>300, //Objects timeout (seconds) in cache

'queryGenerationTime' => 5, //max (aprox) query generation time in seconds

'compressed'=>MEMCACHE_COMPRESSED, // use memcached compression

'connectionAttempts'=>1, // attemps if connection fails

'enabled'=>TRUE,

'defaultTryMemcached'=>TRUE,

'firstLocalhost'=>TRUE, // should I try first in 'localhost' memcached server?

'servers'=>array(

array('host'=>'localhost','port'=>11211),

array('host'=>'192.168.1.5','port'=>1100,'weight'=>2),

),

),

);

$TYPO3_CONF_VARS['SYS']['no_pconnect']=1;

/**********************************************************************************

* TYPO3 SCLABLE EXTENSION CONFIGURATION

* END

*********************************** *********************************** ************/