锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟� (mysqli, mysql, 锟斤拷 PDO_MYSQL) 使锟斤拷, 锟斤拷锟角讹拷锟角伙拷锟斤拷 mysqlnd library 锟斤拷锟斤拷锟侥★拷 PECL/mysqlnd_ms 锟斤拷锟斤拷锟� mysqlnd library 锟斤拷一锟斤拷锟斤拷, 锟斤拷锟斤拷锟斤拷锟侥憋拷锟斤拷些锟斤拷展锟斤拷 API 锟斤拷锟斤拷锟斤拷为锟斤拷
锟斤拷 MySQL 锟斤拷锟接打开碉拷时锟津，诧拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷募锟斤拷懈锟斤拷锟斤拷陆锟斤拷瓒ㄆワ拷锟� host 锟斤拷锟斤拷锟斤拷 锟斤拷锟界，锟斤拷锟斤拷锟斤拷锟斤拷募锟斤拷锟街革拷锟� myapp锟斤拷锟斤拷么锟斤拷锟斤拷使锟斤拷 myapp 锟斤拷为 host 锟斤拷 MySQL 锟斤拷锟接★拷
Example #1 锟斤拷锟街革拷锟斤拷锟斤拷锟斤拷锟斤拷募锟� (mysqlnd_ms_plugin.ini)
{
"myapp": {
"master": {
"master_0": {
"host": "localhost",
"socket": "\/tmp\/mysql.sock"
}
},
"slave": {
"slave_0": {
"host": "192.168.2.27",
"port": "3306"
}
}
}
}
Example #2 锟斤拷锟斤拷一锟斤拷锟斤拷锟截撅拷锟斤拷锟斤拷锟斤拷
<?php
/* 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟� myapp 锟斤拷锟斤拷一锟斤拷锟斤拷锟截撅拷锟斤拷锟斤拷锟斤拷锟� */
$mysqli = new mysqli("myapp", "username", "password", "database");
$pdo = new PDO('mysql:host=myapp;dbname=database', 'username', 'password');
$mysql = mysql_connect("myapp", "username", "password");
?>
锟斤拷锟斤拷锟斤拷锟斤拷臃锟斤拷锟斤拷歉锟斤拷鼐锟斤拷夥绞斤拷摹锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷只锟斤拷锟斤拷询锟斤拷 192.168.2.27 锟剿匡拷 3306锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟叫诧拷询锟斤拷锟斤拷锟斤拷锟酵革拷 localhost 指锟斤拷锟斤拷 master 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 Linux 锟借备锟叫ｏ拷 /tmp/mysql.sock 指锟斤拷锟剿憋拷锟斤拷锟斤拷 MySQL 锟斤拷锟斤拷锟斤拷 Windows 系统锟叫斤拷使锟斤拷默锟较碉拷 TCP/IP 通讯锟斤拷 锟斤拷锟斤拷锟绞癸拷锟� username 锟斤拷 password 锟斤拷锟斤拷锟轿猴拷一锟斤拷 锟斤拷 myapp 锟铰斤拷锟斤拷指锟斤拷锟斤拷锟斤拷锟捷库。锟斤拷锟斤拷锟斤拷锟皆后，斤拷选锟斤拷 database 锟借定锟斤拷锟斤拷锟捷匡拷锟斤拷为锟斤拷前锟斤拷锟斤拷锟斤拷锟捷库。
username, password 锟斤拷默锟斤拷锟斤拷锟捷库将锟斤拷锟斤拷锟斤拷锟借定锟斤拷锟斤拷锟捷匡拷锟斤拷锟斤拷统一锟借定锟斤拷 锟斤拷锟戒话说锟斤拷锟斤拷锟斤拷锟斤拷锟叫碉拷锟斤拷锟捷匡拷锟斤拷锟绞癸拷锟酵拷锟斤拷锟斤拷没锟斤拷锟斤拷锟斤拷锟斤拷录锟斤拷 锟斤拷 1.1.0 锟芥本锟皆猴拷锟斤拷锟斤拷锟斤拷平锟斤拷锟斤拷俅锟斤拷冢锟斤拷锟斤拷锟斤拷锟斤拷锟轿猴拷一锟斤拷锟斤拷锟斤拷锟斤拷通锟斤拷 username 锟斤拷 password 锟斤拷锟叫碉拷录锟斤拷权锟借定锟斤拷
锟斤拷锟斤拷诓锟斤拷谋锟斤拷询锟结构锟侥伙拷锟斤拷锟较ｏ拷锟结供 锟斤拷写锟斤拷锟斤拷锟斤拷 锟斤拷锟斤拷姆锟斤拷锟斤拷俣锟� master 锟斤拷 slave 之锟戒并没锟叫很达拷锟斤拷映佟锟�
Example #3 Executing statements
<?php
/* myapp 锟斤拷锟截撅拷锟斤拷锟借定 */
$mysqli = new mysqli("myapp", "username", "password", "database");
if (mysqli_connect_errno())
/* Of course, your error handling is nicer... */
die(sprintf("[%d] %s\n", mysqli_connect_errno(), mysqli_connect_error()));
/* 锟斤拷询锟斤拷锟斤拷 master 锟斤拷锟斤拷锟斤拷 */
if (!$mysqli->query("DROP TABLE IF EXISTS test")) {
printf("[%d] %s\n", $mysqli->errno, $mysqli->error);
}
if (!$mysqli->query("CREATE TABLE test(id INT)")) {
printf("[%d] %s\n", $mysqli->errno, $mysqli->error);
}
if (!$mysqli->query("INSERT INTO test(id) VALUES (1)")) {
printf("[%d] %s\n", $mysqli->errno, $mysqli->error);
}
/* 只锟斤拷锟斤拷询锟斤拷锟斤拷 slave 锟斤拷锟斤拷锟斤拷 */
if (!($res = $mysqli->query("SELECT id FROM test")) {
printf("[%d] %s\n", $mysqli->errno, $mysqli->error);
} else {
$row = $res->fetch_assoc();
$res->close();
printf("Slave returns id = '%s'\n", $row['id'];
}
$mysqli->close();
?>
锟斤拷锟斤拷锟斤拷锟教碉拷锟斤拷锟斤拷锟斤拷锟斤拷冢锟�
Slave returns id = '1'