MySQL Master/SlaveÊý¾Ý¿â¶Áд²Ù×÷Àà
Êý¾Ý¿â²Ù×÷ÀࣺDBCommon.class.php
//---------------------------------------------------------------------
// MySQL Master/SlaveÊý¾Ý¿â¶Áд²Ù×÷Àà
//
// ¿ª·¢×÷Õß: heiyeluren
// °æ±¾ÀúÊ·:
// 2006-09-20 »ù±¾µ¥Êý¾Ý¿â²Ù×÷¹¦ÄÜ, 25 ¸ö½Ó¿Ú
// 2007-07-30 Ö§³Öµ¥Master/¶àSlaveÊý¾Ý¿â²Ù×÷£¬29¸ö½Ó¿Ú
// 2008-09-07 ÐÞÕýÁËÉÏÒ»°æ±¾µÄ²¿·ÖBug
// 2009-11-17 ÔÚMaster/SlaveÀàµÄ»ù´¡ÉÏÔö¼ÓÁËÇ¿»¯µ¥Ö÷»ú²Ù×÷£¬
// Ôö¼ÓÁ˲¿·Ö¼ò½à²Ù×÷½Ó¿ÚºÍµ÷ÊÔ½Ó¿Ú£¬ÓÅ»¯Á˲¿·Ö´úÂ룬
// ±¾°æ±¾¹²42¸ö½Ó¿Ú
// Ó¦ÓÃÏîÄ¿: Y!NCP, Y!SNS, TM MiniSite//
// ¹¦ÄÜÃèÊö£º×Ô¶¯Ö§³ÖMaster/Slave ¶Á/д ·ÖÀë²Ù×÷£¬Ö§³Ö¶àSlaveÖ÷»ú
//
//-----------------------------------------------------------------------
/**
* ³£Á¿¶¨Òå
*/
define("_DB_INSERT", 1);
define("_DB_UPDATE", 2);
/**
* DB Common class
*
* ÃèÊö£ºÄܹ»·Ö±ð´¦Àíһ̨Masterд²Ù×÷£¬¶ą̀Slave¶Á²Ù×÷
*/
class DBCommon
{
/**
* Êý¾Ý¿âÅäÖÃÐÅÏ¢
*/
var $wdbConf = array();
var $rdbConf = array();
/**
* MasterÊý¾Ý¿âÁ¬½Ó
*/
var $wdbConn = null;
/**
* SlaveÊý¾Ý¿âÁ¬½Ó
*/
var $rdbConn = array();
/**
* µ±Ç°²Ù×÷µÄÊý¾Ý¿âÁ´½Ó
*/
var $currConn = null;
/**
* ÊÇ·ñÖ»ÓÐһ̨MasterÊý¾Ý¿â·þÎñÆ÷
*/
var $singleHost = true;
/**
* Êý¾Ý¿â½á¹û
*/
var $dbResult;
/**
* Êý¾Ý¿â²éѯ½á¹û¼¯
*/
var $dbRecord;
/**
* SQLÓï¾ä
*/
var $dbSql;
/**
* Êý¾Ý¿â±àÂë
*/
var $dbCharset = "UTF8";
/**
* Êý¾Ý¿â°æ±¾
*/
var $dbVersion = "5.0";
/**
* ³õʼ»¯µÄʱºòÊÇ·ñÒªÁ¬½Óµ½Êý¾Ý¿â
*/
var $isInitConn = false;
Ïà¹ØÎĵµ£º
mysqlÎļþµ¼ÈëÂÒÂëÎÊÌâµÄ½â¾ö£º
1 ÃüÁî²ì¿´×Ö·ûÉèÖá£
mysql> show variables like "%char%";
2 ½«²»ÊÇutf-8µÄ¶¼¸Ä³Éutf8¡£Ö»ÓÐfilesystem²»±ä;
| Variable_name | Value
&nb ......
mysql Êý¾Ý¿âĬÈϵÄÁ¬½ÓÖ»ÄÜÔÚ±¾»úÁ¬½Ó£¬Ô¶³ÌÁ¬½Ó±ØÐëÊÚȨ¡£
´úÂë: ȫѡ
¡¡GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%'IDENTIFIED
BY 'mypassword' WITH GRANT
OPTION;Èç¹ûÄãÏëÔÊÐíÓû§myuser´ÓipΪ192.168.1.6µÄÖ÷»úÁ¬½Óµ½mysql·þÎñÆ÷£¬²¢Ê¹ÓÃ
mypassword×÷ΪÃÜÂë
´úÂë: GRANT ALL PR ......
Class.forName("com.mySQL.jdbc.Driver");
String strUrl="jdbc:mysql://localhost:3306/stu?useUnicode=true&characterEncoding=GB2312";
String strUser="nuey";
String strPassword="password";
Connection conn=DriverManager.getCon ......
Ö®ËùÒÔдÕâÆª²©¿Í£¬ÊÇÒòΪǰ¼¸Ìì²ÅÅöµ½ÁËÕâôһ¸öÎÊÌ⣬ÒÔǰ»¹²»ÖªµÀmysqlÓÐÕâôһ¸öÎÊÌâ¡£
ÎÒÃǵÄϵͳʹÓÃÁËstruts+hibernate£¬Êý¾Ý¿âʹÓõÄÊÇmysql£¬×Ö·û¼¯Í³Ò»Îªutf-8¡£
±¾À´ÒѾÍê³ÉÁË£¬µ«ÊÇϵͳʹÓõÄʱºò£¬·¢ÏÖ²é³öÀ´µÄÈËÃûûÓÐ˳Ðò£¬±¾À´ÒÔΪºÜ¼òµ¥£¬ÔÚ²éѯµÄʱºò£¬Ö¸¶¨°´ÕÕnameÅÅÐò¾Í¿ÉÒÔÁË£¬Æñ֪ʵ¼ÊÒ»×ö²Å·¢Ï ......