mysql´æ´¢¹ý³Ì£¬Óα꣬ÊÂÎï
drop procedure if exists pro_rep_shadow_rs;
delimiter |
----------------------------------
-- rep_shadow_rs
-- ÓÃÀ´´¦ÀíÐÅÏ¢µÄÔö¼Ó£¬¸üкÍɾ³ý
-- ÿ´ÎÖ»¸üÐÂÉÏ´ÎÒÔÀ´Ã»ÓÐ×ö¹ýµÄÊý¾Ý
-- ¸ù¾Ý²»Í¬µÄ±ê־λ
-- ÐèÒªÒ»¸öÊä³öµÄ²ÎÊý£¬
-- Èç¹û·µ»ØÎª0£¬Ôòµ÷ÓÃʧ°Ü£¬ÊÂÎñ»Ø¹ö
-- Èç¹û·µ»ØÎª1£¬µ÷Óóɹ¦£¬ÊÂÎñÌá½»
--
-- ²âÊÔ·½·¨
-- call pro_rep_shadow_rs(@rtn);
-- select @rtn;
----------------------------------
create procedure pro_rep_shadow_rs(out rtn int)
begin
-- ÉùÃ÷±äÁ¿£¬ËùÓеÄÉùÃ÷±ØÐëÔÚ·ÇÉùÃ÷µÄÓï¾äÇ°Ãæ
declare iLast_rep_sync_id int default -1;
declare iMax_rep_sync_id int default -1;
-- Èç¹û³öÏÖÒì³££¬»ò×Ô¶¯´¦Àí²¢rollback,µ«²»ÔÙ֪ͨµ÷Ó÷½ÁË
-- Èç¹ûÏ£ÍûÓ¦ÓûñµÃÒì³££¬ÐèÒª½«ÏÂÃæÕâÒ»¾ä£¬ÒÔ¼°Æô¶¯ÊÂÎñºÍÌá½»ÊÂÎñµÄÓï¾äÈ«²¿È¥µô
declare exit handler for sqlexception rollback;
-- ²éÕÒÉÏÒ»´ÎµÄ
select eid into iLast_rep_sync_id from rep_de_proc_log where tbl='rep_shadow_rs';
-- Èç¹û²»´æÔÚ£¬ÔòÔö¼ÓÒ»ÐÐ
if iLast_rep_sync_id=-1 then
insert into rep_de_proc_log(rid,eid,tbl) values(0,0,'rep_shadow_rs');
set iLast_rep_sync_id = 0;
end if;
-- ÏÂÒ»¸öÊý×Ö
set iLast_rep_sync_id=iLast_rep_sync_id+1;
-- ÉèÖÃĬÈϵķµ»ØÖµÎª0£ºÊ§°Ü
set rtn=0;
-- Æô¶¯ÊÂÎñ
start transaction;
-- ²éÕÒ×î´ó±àºÅ
select max(rep_sync_id) into iMax_rep_sync_id from rep_shadow_rs;
-- ÓÐÐÂÊý¾Ý
if iMax_rep_sync_id>=iLast_rep_sync_id then
-- µ÷ÓÃ
call pro_rep_shadow_rs_do(iLast_rep_sync_id,iMax_rep_sync_id);
-- ¸üÐÂÈÕÖ¾
update rep_de_proc_log set rid=iLast_rep_sync_id,eid=iMax_rep_sync_id where tbl='rep_shadow_rs';
end if;
-- ÔËÐÐûÓÐÒì³££¬Ìá½»ÊÂÎñ
commit;
-- ÉèÖ÷µ»ØÖµÎª1
set rtn=1;
end;
|
delimiter ;
drop procedure if exists pro_rep_shadow_rs_do;
delimiter
Ïà¹ØÎĵµ£º
ÔÚSentOS 5ÖУº
>>yum install mysql
°²×°Íê±Ïºó£¬
>>mysql
error:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'(2)";
½ñÌì·þÎñÆ÷Óöµ½ÁËÒ»¸öºÜÊìϤµÄÎÊÌâ
ÊäÈë
#mysql -u root -p
ERROR 2002 (HY000):Can't connect to local MySQL server
  ......
1¡¢ÏÔʾÊý¾Ý¿âÁÐ±í£º
show databases;
¸Õ¿ªÊ¼Ê±²ÅÁ½¸öÊý¾Ý¿â£ºmysqlºÍtest¡£mysql¿âºÜÖØÒªËüÀïÃæÓÐMYSQLµÄϵͳÐÅÏ¢£¬ÎÒÃǸÄÃÜÂëºÍÐÂÔöÓû§£¬Êµ¼ÊÉϾÍÊÇÓÃÕâ¸ö¿â½øÐвÙ×÷¡£
2¡¢ÏÔʾ¿âÖеÄÊý¾Ý±í£º
use mysql£» //´ò¿ª¿â
show tables;
3¡¢ÏÔʾÊý¾Ý±íµÄ½á¹¹£ ......
±ÏÒµÉè¼ÆµÄ³ÌÐòÖ÷Ìå±àºÃÁË£¬ÔËÐÐÉÙÁ¿Êý¾ÝûÓÐÈκÎÎÊÌ⣬һµ©Êý¾ÝÁ¿Ôö¼Óµ½22w£¬ÔËÐÐʱ¼ä¾Í³¤µÃÁîÈË·¢Ö¸¡£µ¼Ê¦½¨Ò飬³ÌÐòÖо¡¿ÉÄܵؼõÉÙÓëÊý¾Ý¿â½»»¥µÄ´ÎÊý£¬¾¡¿ÉÄܵذѹ¤×÷¶ª¸øÊý¾Ý¿âÍê³É¡£ÔÚÕâһ˼ÏëµÄÖ¸µ¼Ï£¬ÎÒÈýÌì´ó·ùÐ޸ijÌÐò£¬²¿·Ö´úÂ뼸ºõÊÇ·ÐÂÁËÒ»±é¡£×ܵÄÀ´Ëµ£¬ÔËÐÐʱ¼äȷʵµÃµ½ÁË ......
×î½üÓöµ½Ò»¸öÐèÇóÒªÔÚlinuxÏÂÓÃjava µ÷ÓÃmysql¿Í»§¶ËÔ¶³ÌµÇ½mysql·þÎñÆ÷£¬´Ó¿Í»§¶Ë»úÆ÷µ¼Èëmysql½Å±¾£¬´Ómysql·þÎñÆ÷¶Ëµ¼³ö±íÖеÄÊý¾Ý¡£ÒÔÏÂÊÇÓõ½µÄÖ÷Òª·½·¨£º
Java ´úÂë
/**
* µ¼ÈëÊý¾Ý
* @param ½Å±¾µÄµØÖ·ºÍÃû³Æ
* @return ÊÇ·ñ³É¹¦&nb ......
¹ØÓÚMySQL±íÉè¼ÆÓ¦¸Ã×¢ÒâµÄÎÊÌâ(×öÁ˵ãÐÞ¸Ä)
¹Ø
ÓÚÉè¼Æ±íʱӦ¸Ã×¢ÒâµÄÎÊÌâ
ÈçÓдíÎó»¶Ó´ó¼ÒÖ¸³ö¡£Õâ
¶Îʱ¼äÔÚ¼ÒÀ×öÁ˵ãÐÞÕý¡£
1
¡¢É÷ÖØÑ¡Ôñ±íÃû¡£
ÓÐ
Á½ÖÖÑ¡Ôñ£º
°´ÕÕ ......