Technology computers-hardware

How to Cache Across Multiple Servers

By Technology Last updated Tuesday, May/14/2024

1). Locate the database cache connection initialization in your code, for example:

define('DBHOSTSERVER', 'dbmaster');

define('DBUSER', 'username');

define('DBPASS', 'password');

$DB_SLAVES = array('dbslaveserver1','dbslaveserver2','dbslaveserver3');
2). Locate the current database that is being used for caching by executing the following code:

$db->conn_write = mysql_pconnect(DBHOSTSERVER, DBUSER, DBPASS);

mysql_select_db(DBNAME, $db->conn_write);
3). Pick the slave databases to distribute the caching by using the following code:

$idx = time () $ count($dbslaveserver1, dbslaveserver2, dbslaveserver3);

$slave = $dbslaveserver1, dbslaveserver2, dbslaveserver3($idx);

$db->conn_read = mysql_pconnect($slave, DBUSER, DBPASS);

mysql_select_db($dbslaveserver1, dbslaveserver2, dbslaveserver3, $db->conn_read);

Breaking news and analysis from VeryPages. Politics, world news, photos, video, tech reviews, health, science and entertainment news.