{"id":1534,"date":"2011-10-02T00:20:43","date_gmt":"2011-10-01T15:20:43","guid":{"rendered":"http:\/\/blog.isnext.net\/issy\/?p=1534"},"modified":"2011-10-02T00:21:51","modified_gmt":"2011-10-01T15:21:51","slug":"scientific-linux-5-7%e3%81%a7mysqld%e8%a4%87%e6%95%b0%e8%b5%b7%e5%8b%95%e8%a8%ad%e5%ae%9a","status":"publish","type":"post","link":"https:\/\/blog.isnext.net\/issy\/archives\/1534","title":{"rendered":"Scientific Linux 5.7\u3067mysqld\u8907\u6570\u8d77\u52d5\u8a2d\u5b9a"},"content":{"rendered":"

\u25a0Scientific Linux 5.7\u3067mysqld\u8907\u6570\u8d77\u52d5\u8a2d\u5b9a<\/strong>
\n\u3000\u57fa\u672c\u306fCentOS5\u7cfb\u3068\u540c\u3058\u306a\u306e\u3060\u304c\u3001\u7701\u7565\u3067\u304d\u306a\u3044\u624b\u9806\u304c\u3042\u308a\u305d\u306e\u307e\u307e\u3067\u306fmysqld_multi\u304c\u8d77\u52d5\u3067\u304d\u306a\u304b\u3063\u305f\u305f\u3081\u3001\u6539\u3081\u3066\u66f8\u3044\u3066\u304a\u304f\u3002CentOS\u3088\u308a\u3082\u81ea\u52d5\u3067\u51e6\u7406\u3057\u3066\u3082\u3089\u3048\u308b\u90e8\u5206\u304c\u5c11\u306a\u3044\u306e\u3067\u6ce8\u610f\u3002<\/p>\n

\uff11\uff09\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u3092\u7de8\u96c6\u3059\u308b<\/strong>
\n# cat \/etc\/my.cnf<\/p>\n

[client]
\n#password = your_password
\nport = 13306
\nsocket = \/var\/lib\/mysql1\/mysql.sock
\ndefault-character-set=utf8<\/p>\n

[mysqld_multi]
\nmysqld = \/usr\/bin\/mysqld_safe
\nmysqladmin = \/usr\/bin\/mysqladmin
\nuser = root
\npassword = rootpasswd<\/p>\n

# The MySQL server
\n[mysqld1]
\nport = 13306
\nsocket = \/var\/lib\/mysql1\/mysql.sock
\npid-file = \/var\/lib\/mysql1\/host.pid
\ndatadir = \/var\/lib\/mysql1\/
\nskip-locking
\nkey_buffer = 96M
\nmax_allowed_packet = 3M
\ntable_cache = 128
\nsort_buffer_size = 1M
\nread_buffer_size = 1M
\nread_rnd_buffer_size = 4M
\nmyisam_sort_buffer_size = 64M
\nthread_cache_size = 8
\nquery_cache_size= 16M
\n# Try number of CPU\u2019s*2 for thread_concurrency
\nthread_concurrency = 8
\ndefault-character-set=utf8
\ncharacter_set_server=utf8
\nskip-federated
\nlog-bin=mysql-bin<\/p>\n

[mysqld2]
\nport = 13307
\nsocket = \/var\/lib\/mysql2\/mysql.sock2
\npid-file = \/var\/lib\/mysql2\/host.pid2
\ndatadir = \/var\/lib\/mysql2\/
\nskip-locking
\nkey_buffer = 96M
\nmax_allowed_packet = 3M
\ntable_cache = 128
\nsort_buffer_size = 1M
\nread_buffer_size = 1M
\nread_rnd_buffer_size = 4M
\nmyisam_sort_buffer_size = 64M
\nthread_cache_size = 8
\nquery_cache_size= 16M
\n# Try number of CPU\u2019s*2 for thread_concurrency
\nthread_concurrency = 8
\ndefault-character-set=utf8
\ncharacter_set_server=utf8
\nskip-federated
\nlog-bin=mysql-bin<\/p>\n

[mysqldump]
\nquick
\nmax_allowed_packet = 16M<\/p>\n

[mysql]
\nno-auto-rehash<\/p>\n

[isamchk]
\nkey_buffer = 128M
\nsort_buffer_size = 128M
\nread_buffer = 2M
\nwrite_buffer = 2M<\/p>\n

[myisamchk]
\nkey_buffer = 128M
\nsort_buffer_size = 128M
\nread_buffer = 2M
\nwrite_buffer = 2M<\/p>\n

[mysqlhotcopy]
\ninteractive-timeout<\/p>\n

\uff12\uff09mysqld_multi\u3067\u8d77\u52d5\u3067\u304d\u308b\u3088\u3046\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5404datadir\u3067\u884c\u3046<\/strong>
\n#\/usr\/bin\/mysql_install_db –user=mysql –datadir=\/var\/lib\/mysql1\/
\n#\/usr\/bin\/mysql_install_db –user=mysql –datadir=\/var\/lib\/mysql2\/<\/p>\n

\uff13\uff09\u5404mysqld\u3092\u8d77\u52d5\u3057\u30d1\u30b9\u30ef\u30fc\u30c9\u8a2d\u5b9a\u3092\u884c\u3046<\/strong>
\n# mysqld_multi start 1
\n# mysql –socket=\/var\/lib\/mysql1\/mysql.sock -u root
\nmysql> set password = password(‘rootpasswd’);
\nmysql> quit
\n# mysqld_multi stop 1
\n# mysqld_multi start 2
\n# mysql –socket=\/var\/lib\/mysql2\/mysql.sock -u root
\nmysql> set password = password(‘rootpasswd’);
\nmysql> quit
\n# mysqld_multi stop 2<\/p>\n

\uff14)\u8d77\u52d5\u78ba\u8a8d\u3092\u884c\u3046<\/strong>
\n# mysqld_multi start
\n# mysqld_multi stop<\/p>\n

\u25a0php\u95a2\u9023\u306e\u8a2d\u5b9a\u65b9\u6cd5<\/strong>
\nphp\u30a2\u30d7\u30ea\u306econfig.php\u3067\u306e\u8a2d\u5b9a\u4f8b
\n\u2018hostspec\u2019 => \u2018localhost:13306\u2032,
\n\u3000\u6a19\u6e96socket\u3067\u306a\u3044\u5834\u5408\u306b\u306f
\n\u2018hostspec\u2019 => \u2018localhost:\/var\/lib\/mysql2\/mysql.sock2\u2032,<\/p>\n

\u30c7\u30d5\u30a9\u30eb\u30c8\u306f\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u7b49\u3082\u8003\u616e\u3057\u3066clients\u4ed63306\u3067\u904b\u7528\u304c\u671b\u307e\u3057\u3044<\/p>\n

\u25a0\u8d77\u52d5script\u3092\u8a2d\u7f6e\u3059\u308b<\/strong>
\n\u8d77\u52d5\u7528\u306b \/etc\/init.d\/\u306b\u4ee5\u4e0b\u306escript\u3092\u914d\u7f6e<\/p>\n

# vi \/etc\/init.d\/mysqld_multi
\n—\u3053\u3053\u304b\u3089
\n# cat \/etc\/init.d\/mysqld_multi
\n#!\/bin\/sh
\n# Mysql daemon start\/stop script.
\n#
\n# Usually this is put in \/etc\/init.d (at least on machines SYSV R4
\n# based systems) and linked to \/etc\/rc3.d\/S99mysql and \/etc\/rc0.d\/S01mysql.
\n# When this is done the mysql server will be started when the machine is started
\n# and shut down when the systems goes down.
\n# Comments to support chkconfig on RedHat Linux
\n# chkconfig: 2345 90 90
\n# description: A very fast and reliable SQL database engine.
\n# The following variables are only set for letting mysql.server find things
\n# if you want to affect other MySQL variables, you should make your changes
\n# in the \/etc\/my.cnf or other configuration files
\nMYSQLDIR=\/usr
\nPATH=\/sbin:\/usr\/sbin:\/bin:\/usr\/bin:\/usr\/local\/bin:$MYSQLDIR\/bin
\nexport PATH
\n# See how we were called.
\ncase \u201c$1\u2033 in
\nstart)
\necho -n \u201cStarting mysqld: \u201c
\n$MYSQLDIR\/bin\/mysqld_multi start 1,2
\necho
\n;;
\nstop)
\necho -n \u201cShutting down mysqld: \u201c
\n$MYSQLDIR\/bin\/mysqld_multi stop 1,2
\necho
\n;;
\nstatus)
\n$MYSQLDIR\/bin\/mysqld_multi report 1,2
\n;;
\nrestart)
\n$0 stop
\n$0 start
\n;;
\n*)
\necho \u201cUsage: $0 {start|stop|restart|status}\u201d
\nexit 1
\nesac
\nexit 0
\n–\u3053\u3053\u307e\u3067<\/p>\n

\u4f5c\u6210\u3057\u305f\u3089\u5b9f\u884c\u6a29\u9650\u3092\u4e0e\u3048\u308b
\n# chmod +x \/etc\/init.d\/mysqld_multi<\/p>\n

\u5b9f\u884c\u53ef\u80fd\u304b\u52d5\u4f5c\u78ba\u8a8d\u3092\u3059\u308b
\n# service mysqld_multi start
\n# service mysqld_multi stop<\/p>\n

\u25a0\u81ea\u52d5\u8d77\u52d5\u6642\u306e\u8a2d\u5b9a\u3092\u8ffd\u52a0<\/strong>
\n\u5143\u3005\u306emysqld\u306f\u30aa\u30d5\u306b\u3001mysqld_multi\u3092\u30aa\u30f3\u306b
\nmysqld_multi \u306f\u30ea\u30b9\u30c8\u306b\u306a\u3044\u306e\u3067\u8ffd\u52a0\u3059\u308b<\/p>\n

# chkconfig mysqld off
\n# chkconfig –add mysqld_multi
\n# chkconfig mysqld_multi on<\/p>\n

#ntsysv\u3000\u3067\u78ba\u8a8d<\/p>\n","protected":false},"excerpt":{"rendered":"

\u25a0Scientific Linux 5.7\u3067mysqld\u8907\u6570\u8d77\u52d5\u8a2d\u5b9a \u3000\u57fa\u672c\u306fCentOS5\u7cfb\u3068\u540c\u3058\u306a\u306e\u3060\u304c\u3001\u7701\u7565\u3067\u304d\u306a\u3044\u624b\u9806\u304c\u3042\u308a\u305d\u306e\u307e\u307e\u3067\u306fmysqld_multi\u304c\u8d77\u52d5\u3067\u304d\u306a\u304b\u3063\u305f\u305f\u3081\u3001\u6539\u3081\u3066\u66f8\u3044\u3066\u304a\u304f\u3002CentO … Continue reading “Scientific Linux 5.7\u3067mysqld\u8907\u6570\u8d77\u52d5\u8a2d\u5b9a”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[24,123],"class_list":["post-1534","post","type-post","status-publish","format-standard","hentry","category-linux","tag-mysql","tag-scientific"],"_links":{"self":[{"href":"https:\/\/blog.isnext.net\/issy\/wp-json\/wp\/v2\/posts\/1534","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.isnext.net\/issy\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.isnext.net\/issy\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.isnext.net\/issy\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.isnext.net\/issy\/wp-json\/wp\/v2\/comments?post=1534"}],"version-history":[{"count":3,"href":"https:\/\/blog.isnext.net\/issy\/wp-json\/wp\/v2\/posts\/1534\/revisions"}],"predecessor-version":[{"id":1536,"href":"https:\/\/blog.isnext.net\/issy\/wp-json\/wp\/v2\/posts\/1534\/revisions\/1536"}],"wp:attachment":[{"href":"https:\/\/blog.isnext.net\/issy\/wp-json\/wp\/v2\/media?parent=1534"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.isnext.net\/issy\/wp-json\/wp\/v2\/categories?post=1534"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.isnext.net\/issy\/wp-json\/wp\/v2\/tags?post=1534"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}