MySQL Master/Slave Server ¼ÜÉè
»·¾³£ºÁ½Ì¨·þÎñÆ÷IP:192.168.30.57\192.168.30.58
1¡¢ÏÂÔØmysql-5.0.86-linux-i686-glibc23.tar.gz µ½http://dev.mysql.com/downloads/mysql/5.0.html#linuxÏÂÔØ
2¡¢½âѹ tar -zxvf
mysql-5.0.86-linux-i686-glibc23.tar.gz
3¡¢´´½¨Á´½Ó ln -s
mysql-5.0.86-linux-i686-glibc23
mysql
4¡¢½øÈëmysql
Ŀ¼Ï cd mysql
5£ºÐ½¨ mysql Óû§×é
groupadd mysql
6£ºÐ½¨ mysqlÓû§²¢ÊôÓÚmysqlÓû§×é
useradd -g mysql mysql
7£ºÖ´Ðа²×°½Å±¾£º
scripts/mysql_install_db --user=mysql
8£º¸Ä±äÊô×é (×¢ÒâСÊýµã)
chown -R root . (×¢ÒâСÊýµã)
9£º¸Ä±äÊý¾ÝÊô×é
chown -R mysql data
10£ºÊäÈëÃüÁî chgrp -R mysql . (×¢ÒâСÊýµã)
11¡¢¿½±´ÅäÖÃÎļþ cp supports-files/my-lagre.cnf /etc/my.cnf
12¡¢Æô¶¯mysql
bin/mysqld_safe -user=root &
13¡¢µÇ¼ bin/mysql
-uroot -p
Ò»¡¢Master Server ·½Ãæ
A.É趨 Server-id
Ê×ÏÈÒªÉ趨 server-id¡£»ù±¾ÉÏûÓÐʲôÌرðµÄÏÞÖÆ£¬Ö»Òª Master ºÍ Slave µÄ server-id ²»Ò»Ñù¼´¿É£¬µ«ÆäÖµ±ØÐèΪ
1 ÖÁ 2^32-1 Ö®¼ä¡£
[mysqld]
server-id=1
B.¿ªÆô Binary Log
ÐÞ¸Ä MySQL Server µÄϵͳÉ趨µµ£¬ÔÚ [mysqld] Ï·½¼ÓÉÏ log-bin=mysql-bin£¬ÀýÈ磺
ÒýÓÃ:
[mysqld]
log-bin=mysql-bin
MySQL µÄ Binary Log »á½«ËùÓжÔì¶×ÊÁÏ¿âµÄÐ޸IJÙ×÷È«²¿¼Ç¼ÆðÀ´£¬¶ø Slave Óë Master
Ö®¼ä½øÐÐ×ÊÁÏͬ²½µÄ·½Ê½ºÜ¼òµ¥£¬¾ÍÊÇ Slave »á°Ñ Master Server µÄ Binary Log ÄùýÀ´Ö´ÐУ¬Ò²¾ÍÊÇ˵ Slave
Server »á "ÖØ×ö" ÔÚ Master Server ÉÏ·¢ÉúµÄ¸÷ÖÖÐ޸IJÙ×÷¡£Òò´Ë Master Server Îð±ØÒª¿ªÆô Binary
Log ¹¦ÄÜ£¬·ñÔò Master/Slave ¼Ü¹¹ÎÞ·¨ÔË×÷¡£
C.É趨 Replication Slave ȨÏÞ
ÎÒÃDZØÐëÒªÔÚ Master Server ÉÏ×öÉ趨£¬Èà Slave ¾ßÓпÉÒÔ´Ó Master Server ÉÏ Copy ×ÊÁϵÄȨÏÞ(ÕýʽµÄ˵·¨Îª Replication Slave Priviledges)£¬ËùÐèʹÓõÄÖ¸ÁîÈçÏ£º
ÒýÓÃ:
GRANT REPLICATION SLAVE ON *.* TO 'slave1'@'192.168.30.58'
IDENTIFIED BY '123456';
Òâ˼Ϊ£º
ÔÊÐí 192.168.30.58 Õâ¸ö IP ʹÓà slave1 Õʺţ¬À´½øÐÐ×ÊÁÏͬ²½(Replication)¡£
slave1 Õâ¸öÕʺŵÄÃÜÂëΪ 123456¡£
´ËʱÄú¿ÉÒÔ´Ó Slave Server(192.168.30.58) ʹÓà mysql client program ½øÐÐÑéÖ¤£¬¿´ÊÇ·ñÓÐÕý
Ïà¹ØÎĵµ£º
MYSQL ÐÞ¸ÄrootÃÜÂëÃüÁî
cmdÏÂÇл»µ½ mysql °²×°Ä¿Â¼
Àý
d:/mysql/bin
Ç°Ì᣺mysqlÓû§rootÃÜÂëΪ¿Õ.
ÊäÈë mysql -u root mysql
mysql> ״̬ÏÂÊäÈë update user set password=password('ÐÂÃÜÂë') where user='root';
»ØÏÔ
Query OK, 0 rows affected (0.00 sec)
Rows matched: 2 Changed: 0 Warnings: 0
......
1.ʲôÊÇUDF? UDF(user-defined function)ÊÇmysqlΪÓû§ÌṩµÄ×Ô¶¨Ò庯ÊýµÄÀ©Õ¹½Ó¿Ú¡£Ëü±¾ÖÊÉϺÍmysqlÌṩµÄmax¡¢minºÍcountµÈº¯ÊýÀàËÆ¡£ 2.UDF¿ÉÒÔ×öʲô? UDFÊÇ×Ô¶¨Ò庯Êý£¬ËùÒÔËüÄÜ×öʲôÍêÈ«È¡¾öÓÚÄãµÄʵÏÖ¡£UDF¿ÉÒÔÔÚÆÕͨµÄsql¡¢triggerÒÔ¼°store procedure±»µ÷ÓᣠÈç¹û×Ô¶¨ÒåÒ»¸ötcp_send(ip,port,msg)µ ......
TIMESTAMPÁÐÀàÐÍÌṩһÖÖÀàÐÍ£¬Äã¿ÉÒÔʹÓÃËü×Ô¶¯µØÓõ±Ç°µÄÈÕÆÚºÍʱ¼ä±ê¼ÇINSERT»òUPDATEµÄ²Ù×÷¡£Èç¹ûÄãÓжà¸öTIMESTAMPÁУ¬Ö»ÓеÚÒ»¸ö×Ô¶¯¸üС£
×Ô¶¯¸üеÚÒ»¸öTIMESTAMPÁÐÔÚÏÂÁÐÈκÎÌõ¼þÏ·¢Éú£º
ÁÐûÓÐÃ÷È·µØÔÚÒ»¸öINSERT»òLOAD DATA INFILEÓï¾äÖÐÖ¸¶¨¡£
ÁÐûÓÐÃ÷È·µØÔÚÒ ......
MySQL ÃüÁîÐÐ
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö² ......
¡¾Ç°Ìá¡¿
winxpsp3
mysql5.1
¡¾²½Öè¡¿
1.½øÈëMySQL Command Line Client;
2.ÃüÁ
mysql> show variables like 'character%';
+--------------------------+---------------------------------------------------------+
| Variable_name | ......