** ¤Ï¤¸¤á¤Ë [#rbdd7ee3]
- web¥µ¡¼¥Ð¡¼·´¤¬¤¢¤ê¡¢¤½¤³¤«¤éÀܳ¤µ¤ì¤ëDB¥µ¡¼¥Ð¡¼ÍÑ¥¤¥ó¥¹¥¿¥ó¥¹¤òºîÀ®¤¹¤ë¼ê½ç¤Ë¤Ä¤¤¤Æ¥á¥â
- ºÇ½ªÅª¤Ë¤Ï¥ì¥×¥ê¥±¡¼¥·¥ç¥ó¤ËÂбþ¤·¡¢¥Þ¥¹¥¿¡¼¤ÏEBS¤Ë¤·¤¿¤¤¤±¤É¡¢¤È¤ê¤¢¤¨¤ºÎ©¤Á¾å¤²¤Þ¤Ç¡£
** ¥»¥¥å¥ê¥Æ¥£¥°¥ë¡¼¥×¤òºîÀ® [#wdf0c62c]
- ¥»¥¥å¥ê¥Æ¥£¥°¥ë¡¼¥×¤È¤Ï¥Õ¥¡¥¤¥¢¥¦¥©¡¼¥ë¤Îµö²ÄÀßÄê¤Î½¸¤Þ¤ê
- Web¥µ¡¼¥Ð¡¼¤È¤«DB¥µ¡¼¥Ð¡¼¤È¤«¡¢Æ±¤¸¥»¥¥å¥ê¥Æ¥£¥Ý¥ê¥·¡¼¤Î¤â¤Î¤´¤È¤Ë¡¢¥»¥¥å¥ê¥Æ¥£¥°¥ë¡¼¥×¤òºî¤ê¡¢¥¤¥ó¥¹¥¿¥ó¥¹¤Ë¤½¤Î¥»¥¥å¥ê¥Æ¥£¥°¥ë¡¼¥×¤ò³ä¤êÅö¤Æ¤ë
- ¡Öxxxxx¡×¤È¤¤¤¦¥µ¥¤¥È¤ÎDB¥µ¡¼¥Ð¡¼ÍÑ¥»¥¥å¥ê¥Æ¥£¥°¥ë¡¼¥×¤òºîÀ®
ec2-add-group xxxxx-db -d 'db-server for xxxxx'
GROUP xxxxx-db db-server for xxxxx
- ³«È¯´Ä¶¤«¤é¤Î¤ßxxxxx-web¤Ë22È֥ݡ¼¥È¤òµö²Ä
ec2-authorize xxxxx-db -P tcp -p 22 -s 11.22.33.44/32
- Web¥µ¡¼¥Ð¡¼¤«¤é3306¥Ý¡¼¥È¤Ø¤Îµö²Ä¡£Web¥µ¡¼¥Ð¡¼¤Î¥»¥¥å¥ê¥Æ¥£¥°¥ë¡¼¥×¤¬¡Öxxxx-web¡×¤Ç¥æ¡¼¥¶¡¼ID¤¬¡Ö123456789¡×¤Ç¤¢¤ë¤ÈÁÛÄê¡£¥æ¡¼¥¶¡¼ID¤Ï¡¢¡Öec2-describe-group¡×¤Ç³Îǧ¤Ç¤¤ë
ec2-authorize xxxxx-db -P tcp -p 3306 -o xxxxx-web -u 123456789
** ¥¤¥ó¥¹¥¿¥ó¥¹¤ÎΩ¤Á¾å¤² [#a5d45102]
- ¤¤¤Ä¤â»È¤Ã¤Æ¤¤¤ë¡¢http://alestic.com/ ¤Î ¡ÖUbuntu 8.04 Hardy¡×¤Î¡Öserver
32-bit¡×¤ò»È¤¦
ec2-run-instances ami-0772946e -g xxxxx-db --availability-zone us-east-1a -k keyname
- ssh¤Ç¥í¥°¥¤¥ó
ssh -i ~/.ssh/xxxxx.id Ω¤Á¾å¤¬¤Ã¤¿¥¤¥ó¥¹¥¿¥ó¥¹¤Î¥Û¥¹¥È̾
- ¤È¤ê¤¢¤¨¤º apt-update¤¹¤ë
# apt_update
** senna ¥¤¥ó¥¹¥È¡¼¥ë [#ub05c11d]
- mecab¤À¤Î¤Ê¤ó¤À¤Î¤ò¤¤¤ì¤ë
# apt-get install gcc g++ libmecab-dev libncurses5-dev mecab mecab-ipadic
- senna¤ò¤¤¤ì¤ë
cd /usr/local/src/
wget http://jaist.dl.sourceforge.jp/senna/33763/senna-1.1.4.tar.gz
tar xvzf senna-1.1.4.tar.gz
cd senna-1.1.4
configure --prefix=/usr
make
make install
** tritonn¤Î¥¤¥ó¥¹¥È¡¼¥ë [#n533e568]
- tritonn¤Î¥¤¥ó¥¹¥È¡¼¥ë
cd /usr/local/src/
wget http://jaist.dl.sourceforge.jp/tritonn/36449/tritonn-1.0.12-mysql-5.0.67.tar.gz
tar xzf tritonn-1.0.12-mysql-5.0.67.tar.gz
cd tritonn-1.0.12-mysql-5.0.67
./configure \
--with-senna \
--with-mecab \
--enable-assembler \
--with-charset=utf8 \
--with-unix-socket-path=/var/lib/mysql/mysql.sock \
--with-extra-charsets=binary,utf8,cp932,eucjpms,ujis,ucs2,latin1,sjis \
--enable-thread-safe-client
make
make install
- mysql¥¢¥«¥¦¥ó¥È¤ÎºîÀ®
groupadd mysql
useradd -g mysql -s /bin/false -d /home/mysql mysql
- mysql.sock ÍѤÈmysql¤ÎdataÍѤΥǥ£¥ì¥¯¥È¥ê¤ÎºîÀ®
install -d -o mysql -g mysql -m 2755 /var/lib/mysql
install -d -o mysql -g mysql -m 2750 /var/lib/mysql/data
- mysql_install_db¤Î¼Â¹Ô
./scripts/mysql_install_db --user=mysql --datadir=/var/lib/mysql/data/
- my.cnf¤ÎºîÀ®
cp support-files/my-large.cnf /etc/my.cnf
- /etc/init.d/mysql ¤ÎºîÀ®
cp support-files/mysql.server /etc/init.d/mysql
- °Ê²¼¤òÄɵ
[mysqld]
basedir=/usr/local
datadir=/var/lib/mysql/data
- ¼Â¹Ô¸¢¸Â¤òÍ¿¤¨¤ë
chmod 755 /etc/init.d/mysql
- sysv-rc-conf¤ò¤¤¤ì¤Æ¼«Æ°µ¡Æ°¤òÀßÄꤹ¤ë
apt-get install sysv-rc-conf
sysv-rc-conf mysql on
** Web¥µ¡¼¥Ð¡¼¤«¤é¤ÎÀܳ¤òµö²Ä¤¹¤ë [#bbe06dd5]
- db¤òºî¤ë
mysql> create database foo;
- mysql¤Îgrant¤Ç
- mysql¤Îgrant¤Ç¡£firewall¤ÇÀ©¸æ¤·¤Æ¤¤¤ë¤Î¤ÇÀܳ¸µ¤Ï»ØÄꤷ¤Ê¤¤¡£(Web¥µ¡¼¥Ð¡¼¤ÎIP¥¢¥É¥ì¥¹¤Ê¤É¤ÏưŪ¤ËÊѤï¤ë¤Î¤Ç)
mysql> GRANT ALL PRIVILEGES ON foo.* TO foo identified by 'bar';
#blikifooter(»ÖÅÄ¡¢ÀÆÆ£)