当前位置:数据库 > SQLServer >>

CakePHP: tips on ssl, mysql load balance, mas

1. CakePHP Master/Slave
  *) add default(slave as for query) setting in database.php, and master for saving
  *) define a new replicate behavior
  <?php

    class ReplicationBehavior extends ModelBehavior {
   
         public function beforeSave($Model) {
          $Model->useDbConfig = master;
         }
       
         public function afterSave($Model) {
          $Model->useDbConfig = default;
         }
       
         public function setServer($Model, $server) {
          $Model->__backupConfig = $Model->useDbConfig;
          $Model->useDbConfig = $server;
         }
       
         public function afterFind($Model) {
          if (!empty($Model->__backupConfig)) {
           $this->useDbConfig = $Model->__backupConfig;
          }
          $Model->__backupConfig = null;
         }
        
         public function save($data = null, $validate = true, $whitelist = array()) {
              $this->Replication->beforeSave($this);
              return parent::save($data, $validate, $whitelist);
         }
   
    }
   
    ?>
    *) set $actAs to have replicate behavior in your base app model
        $actAs = array(Replicate);
   
    *) call the setServer method in your controller to determine which database you want to use for instant query after save
                if ($this->Deal->saveAll($this->data, array(validate=>first))) {
          $this->Deal->setServer(master);
                    $deal = $this->Deal->find(first,array(
                        conditions => array(slug => $this->data[Deal][slug]),
                        fields => array(id)
                    ));
                   
2. how to use xhprof (a php benchmark tool developed by facebook)
http://techportal.ibuildings.com/2009/12/01/profiling-with-xhprof/

3. MySQL load-balancing
mysql-load-balancing-proxy-trafficscript">http://www.zeus.com/community/articles/building-mysql-load-balancing-proxy-trafficscript

4. ssl
consolidate secure operations to single domain: https://lang.secure.jigocity.com
keep track of referer links in http header
redirect back to the original referer when done

 

补充:Web开发 , php ,
Oracle
MySQL
Access
SQLServer
DB2
Excel
SQLite
SYBASE
Postgres
如果你遇到数据库难题:
请访问www.zzzyk.com 试试
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,