服务器环境:安装vim/etc/apt/sources.list.d/mariadb.list#添加以下两句debhttp://mirror.yongbok.net/mariadb/repo/5.5/ubuntuprecisemaindeb-srchttp://mirror
服务器环境:
安装
vim /etc/apt/sources.list.d/mariadb.list
# 添加以下两句
deb precise main
deb-src precise main
apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db
apt-get update
apt-get install mariadb-server-5.5
/etc/mysql/my.cnf
多实例配置文件:3306,3307,3308
[mysqld_multi]
mysqld
= /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
user
= root
# 指定用于启动、停止mysql实例的用户
log
= /var/log/mysql/mysqld_multi.log
[client]
port
= 3306
socket
= /var/run/mysql/mysql.sock
default-character-set = utf8
[mysqld3306]
port
= 3306
socket
= /var/run/mysql/mysql.sock
pid-file = /var/run/mysql/mysql.pid
datadir
= /var/lib/mysql/3306
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
default-storage-engine = MyISAM
character-set-server = utf8
skip-name-resolve
collation-server
= utf8_general_ci
log-error
= /var/log/mysql/mysqld-error.log
log-slow-admin-statements
long-query-time
= 3
slow-query-log
slow-query-log-file
= /var/log/mysql/mysqld-slow.log
innodb_buffer_pool_size=1G
innodb_additional_mem_pool_size=20M
max_connections
= 1000
tmpdir
= /tmp/
server-id = 2
log-slave-updates
log-bin
= mysql-bin
binlog_format = mixed
relay_log
= mysql-relay-bin
replicate-do-db
= wordpress
replicate-ignore-db
= mysql
replicate-ignore-db
= information_schema
replicate-ignore-db
= performance_schema
replicate-ignore-db
= test
[mysqldump]
quick
max_allowed_packet = 16M
[mysqld3307]
port
= 3307
socket
= /var/run/mysql/mysql-3307.sock
pid-file = /var/run/mysql/mysql-3307.pid
datadir
= /var/lib/mysql/3307
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
default-storage-engine = MyISAM
character-set-server = utf8
skip-name-resolve
collation-server
= utf8_general_ci
log-error
= /var/log/mysql/mysqld-error-3307.log
log-slow-admin-statements
long-query-time
= 3
slow-query-log
slow-query-log-file
= /var/log/mysql/mysqld-slow-3307.log
innodb_buffer_pool_size=1G
innodb_additional_mem_pool_size=20M
max_connections
= 1000
tmpdir
= /tmp/
server-id = 2
log-slave-updates
log-bin
= mysql-bin
binlog_format = mixed
relay_log
= mysql-relay-bin
replicate-do-db
= futurestar
replicate-do-db
= verywx
replicate-ignore-db
= mysql
replicate-ignore-db
= information_schema
replicate-ignore-db
= performance_schema
replicate-ignore-db
= test
[mysqldump]
quick
max_allowed_packet = 16M
[mysqld3308]
port
= 3308
socket
= /var/run/mysql/mysql-3308.sock
pid-file = /var/run/mysql/mysql-3308.pid
datadir
= /var/lib/mysql/3308
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
default-storage-engine = MyISAM
character-set-server = utf8
skip-name-resolve
collation-server
= utf8_general_ci
log-error
= /var/log/mysql/mysqld-error-3308.log
log-slow-admin-statements
long-query-time
= 3
slow-query-log
slow-query-log-file
= /var/log/mysql/mysqld-slow-3308.log
innodb_buffer_pool_size=1G
innodb_additional_mem_pool_size=20M
max_connections
= 1000
tmpdir
= /tmp/
server-id = 2
log-slave-updates
log-bin
= mysql-bin
binlog_format = mixed
relay_log
= mysql-relay-bin
replicate-do-db
= futurestar
replicate-do-db
= verywx
replicate-ignore-db
= mysql
replicate-ignore-db
= information_schema
replicate-ignore-db
= performance_schema
replicate-ignore-db
= test
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
socket = /var/run/mysql/mysql.sock
auto-rehash
default-character-set = utf8
[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
初始化数据库文件:
mysql_install_db --datadir=/var/lib/mysql/3306 --user=mysql
mysql_install_db --datadir=/var/lib/mysql/3307 --user=mysql
mysql_install_db --datadir=/var/lib/mysql/3308 --user=mysql
启动数据库:
mysqld_multi start 3306
mysqld_multi start 3307
mysqld_multi start 3308
查看启动情况:
netstat -tunlp | grep -E '(3306|3307|3308)'
安装Haporxy
apt-get install haproxy
然后vim etc/default/haproxy
修改 ENABLED=0 -> ENABLED=1 保存。
修改haproxy配置文件:
Stellungnahme:Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn