windows环境下：
安装appserv 工具包。
配置apache的虚拟主机：
Include conf/extra/httpd-vhosts.conf
编辑httpd-vhosts.conf：
NameVirtualHost *:80
DocumentRoot "D:/AppServ/www/"
ServerName youhap
ErrorLog "logs/youhap-error.log"
CustomLog "logs/youhap-access.log" common
DocumentRoot "D:/AppServ/www/mysite/"
ServerName center
ErrorLog "logs/center-error.log"
CustomLog "logs/center-access.log" common
编辑hosts：
127.0.0.1 localhost
127.0.0.1 center
127.0.0.1 youhap
分别保存。
php编码，我使用的是codeigniter这个框架。
下载地址：
mysql主从分离：
mysql主从配置及优化：
-------------Mysql Replication Setup------------
# The MySQL server
[mysqld]
port = 3306
server-id = 1
#log-bin
master-host = 10.99.1.1
master-user = slave
master-password = slave
master-port = 3306
slave-skip-errors = 1050,1007,1051,1062
read-only
socket = /tmp/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
在master执行：
mysql>GRANT FILE ON *.* TO slave@'%' IDENTIFIED BY 'slave';
mysql>GRANT REPLICATION SLAVE ON *.* TO slave@'%' IDENTIFIED BY 'slave';
mysql>flush privileges;
修改slave的my.cnf：
master-host = 10.99.1.1
master-user = slave
master-password = slave
master-port = 3306
server-id = 2
slave-skip-errors = 1050,1007,1051,1062
read-only
启动mysql以后，
在从上执行：slave start;
主从复制成功以后，继续。
一个主master，多个从slave
修改、插入连接master服务器，读取数据从slave上读取。
以下代码已经测试通过。
数据库连接设置：
$active_group = "master";
$active_record = TRUE;
$db['master']['hostname'] = "192.168.1.1";
$db['master']['username'] = "root";
$db['master']['password'] = "******************";
$db['master']['database'] = "dbname";
$db['master']['dbdriver'] = "mysql";
$db['master']['dbprefix'] = "";
$db['master']['pconnect'] = TRUE;
$db['master']['db_debug'] = TRUE;
$db['master']['cache_on'] = FALSE;
$db['master']['cachedir'] = "";
$db['master']['char_set'] = "utf8";
$db['master']['dbcollat'] = "utf8_general_ci";
$db['slave']['hostname'] = "192.168.1.2";
$db['slave']['username'] = "root";
$db['slave']['password'] = "********************";
$db['slave']['database'] = "dbname";
$db['slave']['dbdriver'] = "mysql";
$db['slave']['dbprefix'] = "";
$db['slave']['pconnect'] = TRUE;
$db['slave']['db_debug'] = TRUE;
$db['slave']['cache_on'] = FALSE;
$db['slave']['cachedir'] = "";
$db['slave']['char_set'] = "utf8";
$db['slave']['dbcollat'] = "utf8_general_ci";
?>
这个地方，主从已经分离。但是，如果只有主和从两台服务器的话，如果写数据库的操作所占比例较小的情况下，也可以让主服务器承担一部分查询操作。修改以上的配置：
$rand = mt_rand(1, 10);
/* 只有主从
* 读取数据，主：30%，从70%
* */
if( $rand < 4){
$db['slave']['hostname'] = 'master_ip';
}else{
$db['slave']['hostname'] = 'slave_ip';
}
/* 多个从，随机选择其中之一读取数据
* $slaveGroup = array('slave1_ip' => 1, 'slave2_ip' => 2, 'slave3_ip' => 3);
* $db['slave']['hostname'] = array_rand($slaveGroup, 1);
* */
控制器：
class Replication extends Controller{
private $master;
private $slave;
function Replication(){
parent::Controller();
$this->master = $this->load->database('master', true, true);
$this->slave = $this->load->database('slave', true, true);
}
function index(){
//读写分离技术
$this->master->set('awardName', '2008 olimpic games media');
$this->master->set('awardSubTypeId', 1);
$this->master->set('awardTypeId', 1);
$this->master->insert('awards');
$this->slave->from('t_login');
$query2 = $this->slave->get();
}
function memcache(){
$this->load->library('cache');
$conn = $this->cache->useMemcache('127.0.0.1', 11211);
$this->slave->from('t_login');
$query = $this->slave->get();
$this->cache->save('loginInfo', $query->result(), null, 3600);
var_dump($this->cache->get('loginInfo'));
?>
安装memcached：
下载：
安装：cmd --> memcached.exe -d install
启动：cmd --> memcached.exe -d start
启动成功以后。
在php.ini里面加载memcache.dll
下载：（注意版本，我的php是5.2.6）
解压缩，找到memcache.dll放在ext目录下。
加载：打开php.ini:
extension=php_memcache.dll
重启apache。没有错误表示可以用memcache了。
使用：
$memcache = new Memcache;
$memcache->connect('localhost', 11211) or die ("Could not connect");
$data = $memcache->get('view_data');
$memcache->set('view_data', $data, false, 3600) or die ("Failed to save data at the server");
$memcache->get('view_data');
?>
 |
| 文件: | Cache.zip |
| 大小: | 1KB |
| 下载: | 下载 |
|
继续优化：
使用
eAccelerator，官方主页：
windows版本：
注意版本。
下载好的eAccelerator0952_5.2.6.dll放在php的ext扩展下，打开php.ini:
extension=eAccelerator0952_5.2.6.dlleaccelerator.shm_size="64" ; 20MB per heavy site ?
eaccelerator.cache_dir="D:\AppServ\www\mysite\system\cache"
eaccelerator.enable="1"
eaccelerator.optimizer="1"
eaccelerator.check_mtime="1"
; 0 should be faster but will skip checking the modified date on your cached files eaccelerator.debug="0"
eaccelerator.filter=""
eaccelerator.shm_max="0"
eaccelerator.shm_ttl="0" ;( I have used 3600 = 1 hour)
eaccelerator.shm_prune_period="0" ;( testing 1800)
eaccelerator.shm_only="0" ;(testing 1 this seem noticeably faster?)
eaccelerator.compress="1"
eaccelerator.compress_level="9"
eaccelerator.keys = "shm" ;(testing)
eaccelerator.sessions = "shm" ;(testing)
eaccelerator.content = "shm" ;(testing)
eaccelerator.admin.name="yourusername" ;(upto eAccelerator 0.9.4)
eaccelerator.admin.password="yourpassword" ;(upto eAccelerator 0.9.4
如果还不够快，可以用smarty或者其他的页面缓存。这样你的网站就跟飞一样快。
有人已经测试过了，在这里：
参考文档：
http://devbee.com/opcode_cache_for_dummies
http://blog.zol.com.cn/838/article_837067.html
http://hi.baidu.com/xpiaoxue/blog/item/f87b2aecbb33c534279791ac.html
