怎么使用nginx充當mysql的負載均衡器

./configure?--prefix=/data/apps/nginx?--with-http_stub_status_module?--with-http_ssl_module?--with-http_realip_module?--with-http_image_filter_module?--with-stream

stream{ include?/data/apps/nginx/conf/stream/*.conf; }

server?{ listen?3307;?#注意端口不能跟mysql監聽的一樣 proxy_pass?db; } upstream?db?{ server?127.0.0.1:3306; server?192.168.233.1:3306; }

#其實就是new?mysqli的時候只需改端口號與nginx反向代理設置的端口號一樣就可以了 $mysqli?=?new?mysqli('127.0.0.1','root','root','test',3307);

<?php class mysqlclass { private static $obj = null; //mysqlclass對象 public $host; public $database; public $user; public $pwd; public $port; public $mysqli = null; //禁止對象被克隆 private function __clone(){} //禁止外部實例化 private function __construct($host="127.0.0.1",$database="test",$user="root",$pwd="root",$port="3307") { $this->host?=?$host; $this-&gt;database?=?$database; $this-&gt;user?=?$user; $this-&gt;pwd?=?$pwd; $this-&gt;port?=?$port; $this-&gt;mysqli?=?$this-&gt;db_connect(); } //獲取mysqli連接 private?function?db_connect() { $mysqli?=?new?mysqli($this-&gt;host,$this-&gt;user,$this-&gt;pwd,$this-&gt;database,$this-&gt;port); if($mysqli-&gt;connect_errno) { printf("connect?failed:?%sn",?$mysqli-&gt;connect_errno); exit(); } $mysqli-&gt;query("set?names?utf8?"); return?$mysqli; } //獲取db實例 public?static?function?get_db() { if(self::$obj?===?null) { self::$obj?=?new?self(); } return?self::$obj; } public?function?db_query($sql) { $result?=?$this-&gt;mysqli-&gt;query($sql); $arr?=?[]; while?($row?=?$result-&gt;fetch_assoc())?{ $arr[]?=?$row; } $result-&gt;close(); $this-&gt;mysqli-&gt;close(); return?$arr; } public?function?db_insert() { } public?function?db_update() { } public?function?__destruct()?{ $this-&gt;mysqli-&gt;close(); } } $db?=?mysqlclass::get_db(); $r?=?$db-&gt;db_query("show?tables"); var_dump($r);