蝉知门户系统迁移到SAE平台-数据库读写分离

    SAE平台MySQL支持支持读写分离(主从数据库),zentaophp框架也支持主从数据库,所以实现时只需将从数据库的相关配置在config内写上。使用PDO连接数据库时需要使用一些数据,需对slaveDB进行初始化。


   installed    = true;	
$config->debug        = true;	
$config->requestType  = 'GET';
$config->slaveDB->host= SAE_MYSQL_HOST_S;
$config->db->host     = SAE_MYSQL_HOST_M;	
$config->db->port     = SAE_MYSQL_PORT;	
$config->db->name     = SAE_MYSQL_DB;	
$config->db->user     = SAE_MYSQL_USER;	
$config->db->password = SAE_MYSQL_PASS;		
$config->db->prefix   = 'eps';	
$config->db->checkCentOS = false;

$config->sae->storage->domain = 'chanz';

/* slaveDB Database settings. */
$config->slaveDB = new stdclass();          
$config->slaveDB->persistant  = false;               // Persistant connection or not.
$config->slaveDB->driver      = 'mysql';             // The driver of pdo, only mysql yet.
$config->slaveDB->encoding    = 'UTF8';              // The encoding of the database.
$config->slaveDB->strictMode  = false;               // Turn off the strict mode.
$config->slaveDB->port        = $config->db->port;
$config->slaveDB->name        = $config->db->name;
$config->slaveDB->user        = $config->db->user;
$config->slaveDB->password    = $config->db->password;
$config->slaveDB->checkCentOS = $config->db->checkCentOS;
$config->slaveDB->prefix      = $config->db->prefix; 


修改install配置文件生成部分相关代码。


   content = <<
   
    installed    = true;	
\$config->debug        = false;	
\$config->requestType  = ''{$this->post->requestType}'';
\$config->slaveDB->host= SAE_MYSQL_HOST_S;
\$config->db->host     = SAE_MYSQL_HOST_M;	
\$config->db->port     = SAE_MYSQL_PORT;	
\$config->db->name     = SAE_MYSQL_DB;	
\$config->db->user     = SAE_MYSQL_USER;	
\$config->db->password = SAE_MYSQL_PASS;		
\$config->db->prefix   = '{$this->post->dbPrefix}';	
\$config->db->checkCentOS = false;

\$config->sae->storage->domain = '{$this->post->storageDomain}';

/* slaveDB Database settings. */
\$config->slaveDB = new stdclass();          
\$config->slaveDB->persistant  = false;               // Persistant connection or not.
\$config->slaveDB->driver      = 'mysql';             // The driver of pdo, only mysql yet.
\$config->slaveDB->encoding    = 'UTF8';              // The encoding of the database.
\$config->slaveDB->strictMode  = false;               // Turn off the strict mode.
\$config->slaveDB->port        = $config->db->port;
\$config->slaveDB->name        = $config->db->name;
\$config->slaveDB->user        = $config->db->user;
\$config->slaveDB->password    = $config->db->password;
\$config->slaveDB->checkCentOS = $config->db->checkCentOS;
\$config->slaveDB->prefix      = $config->db->prefix; 
EOT;
}
?>

   

  • 0
    点赞
  • 0
    收藏
  • 打赏
    打赏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
©️2022 CSDN 皮肤主题:大白 设计师:CSDN官方博客 返回首页
评论

打赏作者

chujilu1991

你的鼓励将是我创作的最大动力

¥2 ¥4 ¥6 ¥10 ¥20
输入1-500的整数
余额支付 (余额:-- )
扫码支付
扫码支付:¥2
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、C币套餐、付费专栏及课程。

余额充值