- 1Âæ¤Îubuntu¾å¤Ç3306,3307¤È2¤Ä¤ÎMySQL¥¤¥ó¥¹¥¿¥ó¥¹¤òµ¯Æ°¤¹¤ë
- 1Âæ¤ò¥Þ¥¹¥¿¡¼¡¢1Âæ¤ò¥¹¥ì¡¼¥Ö¤Ë¤·¤Æ¡¢ÀßÄê¤ò»î¤·¤Æ¤ß¤ë
** 1Âæ¤Îubuntu¾å¤Ç3306,3307¤È2¤Ä¤ÎMySQL¥¤¥ó¥¹¥¿¥ó¥¹¤òµ¯Æ°¤¹¤ë [#wb60df25]
- /etc/init.d/mysql-3307 ¤È¤¤¤¦¤Î¤òÍÑ°Õ¤·¤Æ¤³¤ì¤Ç¡¢µ¯Æ°¡¢Ää»ß¤µ¤»¤¿¤¤
- /etc/mysql/my-3307.cnf ¤È¤¤¤¦¤Î¤òÍÑ°Õ¤·¤Æ¤³¤Ã¤Á¤Ë3307¤ÎÀßÄê¤ò½ñ¤¤¿¤¤
- 3307¥Ý¡¼¥ÈÍÑdatadir¤Ï¡¢/var/lib/mysql-3307 ¤È¤·¤¿¤¤
- mysql¤òÍî¤È¤¹
- 3307ÍÑdatadir¤ò3306ÍѤ«¤é¥³¥Ô¡¼¤·¤ÆÍÑ°Õ¤¹¤ë
sudo cp -a /var/lib/mysql /var/lib/mysql-3307
/etc/init.d/mysql stop
- /etc/init.d/mysql ¤ò¥³¥Ô¡¼¤·¤Æ /etc/init.d/mysql-3307¤òÍÑ°Õ
- ¼¡¤Î²Õ½ê¤ò½¤Àµ
$ diff /etc/init.d/mysql /etc/init.d/mysql-3307
25,26c25,26
< CONF=/etc/mysql/my.cnf
< MYADMIN="/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf"
---
> CONF=/etc/mysql/my-3307.cnf
> MYADMIN="/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian-3307.cnf"
29c29
< ERR_LOGGER="logger -p daemon.err -t /etc/init.d/mysql -i"
---
> ERR_LOGGER="logger -p daemon.err -t /etc/init.d/mysql-3307 -i"
54,56c54,56
< if [ ! -r /etc/mysql/my.cnf ]; then
< log_warning_msg "$0: WARNING: /etc/mysql/my.cnf cannot be read. See README.Debian.gz"
< echo "WARNING: /etc/mysql/my.cnf cannot be read. See README.Debian.gz" | $ERR_LOGGER
---
> if [ ! -r /etc/mysql/my-3307.cnf ]; then
> log_warning_msg "$0: WARNING: /etc/mysql/my-3307.cnf cannot be read. See README.Debian.gz"
> echo "WARNING: /etc/mysql/my-3307.cnf cannot be read. See README.Debian.gz" | $ERR_LOGGER
60c60
< datadir=`mysqld_get_param datadir`
---
> datadir=/var/lib/mysql-3307
78c78
< pidfile=`mysqld_get_param pid-file`
---
> pidfile=/var/run/mysqld/mysqld-3307.pid
105c105
< /usr/bin/mysqld_safe > /dev/null 2>&1 &
---
> /usr/bin/mysqld_safe --defaults-file=${CONF} > /dev/null 2>&1 &
115c115
< output=$(/etc/mysql/debian-start)
---
> output=$(/etc/mysql/debian-start-3307)
- /etc/mysql/my.cnf¤ò¥³¥Ô¡¼¤·¤Æ/etc/mysql/my-3307.cnf¤òºîÀ®
- ¼¡¤Î¤è¤¦¤Ë½¤Àµ
20,21c20,21
< port = 3306
< socket = /var/run/mysqld/mysqld.sock
---
> port = 3307
> socket = /var/run/mysqld/mysqld-3307.sock
28c28,30
< socket = /var/run/mysqld/mysqld.sock
---
> port = 3307
> socket = /var/run/mysqld/mysqld-3307.sock
> datadir = /var/lib/mysql-3307
43,45c45,47
< pid-file = /var/run/mysqld/mysqld.pid
< socket = /var/run/mysqld/mysqld.sock
< port = 3306
---
> pid-file = /var/run/mysqld/mysqld-3307.pid
> socket = /var/run/mysqld/mysqld-3307.sock
> port = 3307
47c49
< datadir = /var/lib/mysql
---
> datadir = /var/lib/mysql-3307
- /etc/mysql/debian.cnf¤ò¥³¥Ô¡¼¤·¤Æ/etc/mysql/debian-3307.cnf¤òºîÀ®¡£¼¡¤Î²Õ½ê¤ò½¤Àµ
6c6,7
< socket = /var/run/mysqld/mysqld.sock
---
> port = 3307
> socket = /var/run/mysqld/mysqld-3307.sock
10c11,12
< socket = /var/run/mysqld/mysqld.sock
---
> port = 3307
> socket = /var/run/mysqld/mysqld-3307.sock
11a14
> datadir = /var/lib/mysql-3307
- /etc/mysql/debian-start¤ò¥³¥Ô¡¼¤·¤Æ/etc/mysql/debian-start-3307 ¤òºîÀ®¡£¼¡¤Î²Õ½ê¤ò½¤Àµ
10,13c10,13
< MYSQL="/usr/bin/mysql --defaults-file=/etc/mysql/debian.cnf"
< MYADMIN="/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf"
< MYUPGRADE="/usr/bin/mysql_upgrade --defaults-extra-file=/etc/mysql/debian.cnf"
< MYCHECK="/usr/bin/mysqlcheck --defaults-file=/etc/mysql/debian.cnf"
---
> MYSQL="/usr/bin/mysql --defaults-file=/etc/mysql/debian-3307.cnf"
> MYADMIN="/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian-3307.cnf"
> MYUPGRADE="/usr/bin/mysql_upgrade --defaults-extra-file=/etc/mysql/debian-3307.cnf"
> MYCHECK="/usr/bin/mysqlcheck --defaults-file=/etc/mysql/debian-3307.cnf"
- 3307¤òµ¯Æ°¡¢Ää»ß¤·¤Æ¤ß¤ë
/etc/init.d/mysql-3307 start
/etc/init.d/mysql-3307 stop
- 3306¤âµ¯Æ°¡¢Ää»ß¤·¤Æ¤ß¤ë
/etc/init.d/mysql start
/etc/init.d/mysql stop
** 1Âæ¤ò¥Þ¥¹¥¿¡¼¡¢1Âæ¤ò¥¹¥ì¡¼¥Ö¤Ë¤·¤Æ¡¢ÀßÄê¤ò»î¤·¤Æ¤ß¤ë [#eebef45f]
- ¤¢¤È¤Ç½ñ¤¯
#blikifooter(»ÖÅÄ)