# cat \/etc\/my.cnf<\/p>\n
[client]
\n#password = your_password
\nport = 3306
\nsocket = \/var\/lib\/mysql\/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\/mysql\/mysql.sock
\npid-file = \/var\/lib\/mysql\/host.pid
\ndatadir = \/var\/lib\/mysql\/
\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’s*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’s*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
# mysqld_multi start
\n# mysqld_multi stop<\/p>\n
php\u30a2\u30d7\u30ea\u306econfig.php\u3067\u306e\u8a2d\u5b9a\u4f8b<\/p>\n
‘hostspec’ => ‘localhost:13306’,
\n\u3000\u6a19\u6e96socket\u3067\u306a\u3044\u5834\u5408\u306b\u306f
\n ‘hostspec’ => ‘localhost:\/var\/lib\/mysql2\/mysql.sock2’,<\/p>\n
\u30c7\u30d5\u30a9\u30eb\u30c8\u306f\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u7b49\u3082\u8003\u616e\u3057\u3066clients\u4ed63306\u3067\u904b\u7528<\/p>\n
\u8d77\u52d5\u7528\u306b \/etc\/init.d\/\u306b\u4ee5\u4e0b\u306escript\u3092\u914d\u7f6e<\/p>\n
# cat \/etc\/init.d\/mysqld_multi
\n#!\/bin\/sh<\/p>\n
# Mysql daemon start\/stop script.
\n#<\/p>\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.<\/p>\n
# Comments to support chkconfig on RedHat Linux
\n# chkconfig: 2345 90 90
\n# description: A very fast and reliable SQL database engine.<\/p>\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<\/p>\n
MYSQLDIR=\/usr
\nPATH=\/sbin:\/usr\/sbin:\/bin:\/usr\/bin:\/usr\/local\/bin:$MYSQLDIR\/bin
\nexport PATH<\/p>\n
# See how we were called.
\ncase “$1” in
\nstart)
\necho -n “Starting mysqld: ”
\n$MYSQLDIR\/bin\/mysqld_multi start 1,2
\necho
\n;;
\nstop)
\necho -n “Shutting down mysqld: ”
\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 “Usage: $0 {start|stop|restart|status}”
\nexit 1
\nesac<\/p>\n
exit 0<\/p>\n
\u8d77\u52d5\u6642\u306e\u8a2d\u5b9a\u3092\u8ffd\u52a0
\n\u5143\u3005\u306emysqld\u306f\u30aa\u30d5\u306b\u3001mysqld_multi\u3092\u30aa\u30f3\u306b<\/p>\n
# checkconfig mysqld off
\n# checkconfig mysqld_multi on<\/p>\n
#ntsysv\u3000\u3067\u78ba\u8a8d<\/p>\n","protected":false},"excerpt":{"rendered":"