mysqlÊý¾ÝË«Ïòͬ²½
2.»·¾³ËµÃ÷
2.1 Ó²¼þ»·¾³(Á½Ì¨»úÆ÷µÄÓ²¼þ»·¾³Ïàͬ)
CPU
Inter(R) Pentium(R) Dual CPU E5200 @2.50GHz
ÄÚ´æ´óС
384MB
Ó²ÅÌ´óС
8GB
ÆäËü˵Ã÷
±¾»úÆ÷ΪÐéÄâ»ú£¬ÆäÓÐÁ½¿éÍø¿¨£¬Ò»¶ÔÍø¿¨Ö±Á¬£¬Ò»¶Ô½ÓÈë½»»»»ú
CPU
Inter(R) Pentium(R) Dual CPU E5200 @2.50GHz
ÄÚ´æ´óС
384MB
Ó²ÅÌ´óС
8GB
ÆäËü˵Ã÷
±¾»úÆ÷ΪÐéÄâ»ú£¬ÆäÓÐÁ½¿éÍø¿¨£¬Ò»¶ÔÍø¿¨Ö±Á¬£¬Ò»¶Ô½ÓÈë½»»»»ú
2.2 Èí¼þ»·¾³(Á½Ì¨»úÆ÷µÄÈí¼þ»·¾³Ïàͬ)
ϵͳ
Server 2003 Enterprise Edition
Java»·¾³
jdk1.6.0
webƽ̨
apache-tomcat-5.0
Êý¾Ý¿â
MySQL Server 5.0
ldapÊý¾Ý¿â
Sun ONE Directory Server 5.2
haÈí¼þ
À¶¿ÆÌ©´ï¿Æ¼¼Pluswell
2.3 ÍøÂç»·¾³
Ö÷»úÃû
ha001
IPµØÖ·
192.168.0.188
×ÓÍøÑÚÂë
255.255.255.0
Íø¹Ø
192.168.0.1
DNS
192.168.0.1
¹«ÓÃÐéÄâIP
192.168.0.187
IPµØÖ·02
192.168.8.188
×ÓÍøÑÚÂë02
255.255.255.0
Ö÷»úÃû
ha002
IPµØÖ·
192.168.0.189
×ÓÍøÑÚÂë
255.255.255.0
Íø¹Ø
192.168.0.1
DNS
192.168.0.1
¹«ÓÃÐéÄâIP
192.168.0.187
IPµØÖ·02
192.168.8.189
×ÓÍøÑÚÂë02
255.255.255.0
3 mysqlÊý¾Ýͬ²½ÊµÏÖÔÀí£º
¼´¶Áд²Ù×÷ÔÚÁ½Ì¨·þÎñÆ÷ÉϽøÐУ¬Ã¿Ì¨·þÎñÆ÷¼´Ö÷Ò²ÊÇ´Ó¡£µ±ÆäÖеÄÈκÎһ̨·þÎñÆ÷ÊÕµ½²Ù×÷ÇëÇóʱ£¬Æä½øÐÐÏàÓ¦µÄÊý¾Ý±ä»¯£¬²¢°Ñ±ä»¯µÄÊý¾Ý¸´ÖƵ½Áíһ̨·þÎñÆ÷ÖС£
4 Êý¾Ýͬ²½ÊµÏÖ
4.1 mysqlÊý¾ÝË«Ïòͬ²½
4.1.1 ÅäÖ÷þÎñÆ÷ha001
Ø ³õʼ·þÎñÆ÷
ͨ¹ýmysql¹¤¾ßÁ¬½Ó·þÎñÆ÷ha001ºó£¬Ð½¨Á½¸öÊý¾Ý¿âaudit£¬idm¡£µ¼Èë³õʼ»¯Êý¾Ý¿âÎļþ£¬Íê³ÉÊý¾Ý¿âµÄ³õʼ»¯
Ø ¸øÓû§ÊÚȨ
´Ó¿ªÊ¼²Ëµ¥Öдò¿ªmysql5µÄÃüÁîÐУ¬ÊäÈëÕýÈ·µÄÃÜÂ룬½øÈëmysql¿ØÖÆÌ¨ÃüÁîÐÐģʽºó£¬ÊäÈëÈçÏÂÃüÁ
#ÊÚȨÀ´×Ô192.168.0.189µÄbackupÓû§ÓµÓжÔËùÓпâµÄ¸´ÖÆÊý¾ÝµÄȨÏÞ£¬¸ÃÓû§µÄÃÜÂëÉèΪ123456
GRANT REPLICATION SLAVE ON *.* TO 'backup'@'192.168.0.189' IDENTIFIED BY '123456';
#Ë¢ÐÂȨÏÞÉèÖÃ
FLUSH PRIVILEGES ;
Ø ÐÞ¸ÄÅäÖÃÎļþ
ÐÞ¸ÄÖ÷Ŀ¼ÖеÄmy.infÎļþ£¬ÔÚmysqldÏÂÃæ¼ÓÈëÈçÏÂÄÚÈÝ
server-id = 1
log-bin=mysql-bin
binlog-d
Ïà¹ØÎĵµ£º
×î½üÓöµ½Ò»¸öÐèÇóÒªÔÚlinuxÏÂÓÃjava µ÷ÓÃmysql¿Í»§¶ËÔ¶³ÌµÇ½mysql·þÎñÆ÷£¬´Ó¿Í»§¶Ë»úÆ÷µ¼Èëmysql½Å±¾£¬´Ómysql·þÎñÆ÷¶Ëµ¼³ö±íÖеÄÊý¾Ý¡£ÒÔÏÂÊÇÓõ½µÄÖ÷Òª·½·¨£º
Java ´úÂë
/**
* µ¼ÈëÊý¾Ý
* @param ½Å±¾µÄµØÖ·ºÍÃû³Æ
* @return ÊÇ·ñ³É¹¦&nb ......
mysql±àÂëӦעÒâµÄ»·½Ú£º
Õ⼸¸ö»·½Ú±àÂ붼ͳһÁË£¬Ò»°ã²»»á³öÏÖÂÒÂë¡£BTW:
¿ÉÒÔÓÃSET NAMES xÁÙʱÉèÖÃmysql±àÂ룺
Ï൱ÓÚ
SET character_set_client = x;
SET character_set_results = x;
SET character_set_connection = x;
È磺
mysql_query("SET NAMES 'gb2312'") or die("Query failed : " . mysql_er ......
1¡¢ÓÃMySQLDriverCSÁ¬½ÓMySQLÊý¾Ý¿â
ÏÈÏÂÔØºÍ°²×°MySQLDriverCS£¬µØ
Ö·£º
http://sourceforge.net/projects/mysqldrivercs/
ÔÚ°²×°Îļþ¼ÐÏÂÃæÕÒµ½
MySQLDriver.dll
£¬È»ºó½«
MySQLDriver.dll
Ìí¼ÓÒýÓõ½ÏîÄ¿ÖÐ
×¢£ºÎÒÏÂÔØµÄÊǰ汾ÊÇ
MySQLDriverCS-n-EasyQueryTools-4.0.1-DotNet2.0.exe
using
S ......
1.¶Á³ö·½Ê½
DataReaderºÍDataSet¶¼¿ÉÒÔʵÏÖ¶ÔÊý¾Ý¿âÊý¾ÝµÄ²éѯ·µ»Ø£¬µ«Ç°ÕßÖ»ÄÜÌṩ¿ìËٵIJéѯ·½Ê½£¬ºóÕß»¹¿ÉÒÔʵÏÖ¶ÔÊý¾ÝµÄÌí¼Ó¡¢Ð޸ġ¢É¾³ý¹¦ÄÜ¡£
£¨1£©DataReader·½Ê½¶ÁÈ¡£º
string sConnString = "server=localhost;User Id=root;password=root;Persist Security Info=True;database=db_user";
MySqlConnection myC ......
1. Êý¾Ý¿âµÄ²¿Êð
£¨1£©Èí¼þµÄ°²×°
A. MySql——±ØÐë°²×°ÔÚCÅÌÏ£¬·ñÔò°²×°mysql-connector-net-6.2.2ºóÎÞÕýÈ·ÅäÖÃ
B. mysql-connector-net-6.2.2——½«MySql.Data.dll·ÅÔÚBinÎļþ¼ÐÏÂ
£¨2£©Êý¾Ý¿âµÄµ¼³öµ¼Èë
MySQL-FrontµÄ"Áí´æÎª"¹¦ÄÜ¿ÉÒÔ½«Êý¾Ý¿âµ¼³öΪ.sqlÎļþ£¬È»ºóÔÙͨ¹ýËüÖ±½Óµ¼Èë.sqlÎļþ¿ ......