CentOS安装MySQL多实例服务器.docx
- 文档编号:10955112
- 上传时间:2023-02-23
- 格式:DOCX
- 页数:23
- 大小:18.55KB
CentOS安装MySQL多实例服务器.docx
《CentOS安装MySQL多实例服务器.docx》由会员分享,可在线阅读,更多相关《CentOS安装MySQL多实例服务器.docx(23页珍藏版)》请在冰豆网上搜索。
CentOS安装MySQL多实例服务器
操作系统:
CentOS5.6x86_64
硬件环境:
CPU:
Intel(R)Xeon(R)CPUE5620@2.40GHz
内存:
32G
硬盘:
300G*210K
软件环境:
gccversion4.1.220080704(RedHat4.1.2-50)
mysql5.1.59.tar.gz
libunwind-1.0.tar.gz
google-perftools-1.8.3.tar.gz
上述软件假设存放在目录/root/soft下
实验目的:
在CentOS下安装MySQL并实现多实例数据库服务器及innodb-plugin应用
步骤:
#创建日志和运行目录
mkdir-p/opt/logs/opt/run
chmod777/opt/run
#添加组和用户
groupaddmysql
useradd-gmysql-s/sbin/nologinmysql
#安装libunwind
tarzxflibunwind-1.0.tar.gz
cdlibunwind-1.0
autoreconf-fi
CHOST="x86_64-redhat-linux"\
CFLAGS="-O3-fPIC-fomit-frame-pointer\
-pipe-march=nocona-mfpmath=sse-m128bit-long-double\
-mmmx-msse-msse2-maccumulate-outgoing-args-m64\
-ftree-loop-linear-fprefetch-loop-arrays-fno-omit-frame-pointer\
-freg-struct-return-fgcse-sm-fgcse-las-frename-registers\
-fforce-addr-fivopts-ftree-vectorize-ftracer-frename-registers\
-minline-all-stringops-fbranch-target-load-optimize2"CXXFLAGS="${CFLAGS}"./configure
make&&makeinstall
#安装google-perftools
tarzxfgoogle-perftools-1.8.3.tar.gz
cdgoogle-perftools-1.8.3
CHOST="x86_64-redhat-linux"\
CFLAGS="-O3-fomit-frame-pointer-pipe-march=nocona\
-mfpmath=sse-m128bit-long-double-mmmx-msse-msse2\
-maccumulate-outgoing-args-m64-ftree-loop-linear\
-fprefetch-loop-arrays-fno-omit-frame-pointer\
-freg-struct-return-fgcse-sm-fgcse-las\
-fforce-addr-fivopts-ftree-vectorize-ftracer\
-frename-registers-minline-all-stringops\
-fbranch-target-load-optimize2"\
CXXFLAGS="${CFLAGS}-DTCMALLOC_LARGE_PAGES"\
./configure\
--disable-heap-checker\
--disable-debugalloc\
--enable-frame-pointers
make&&makeinstall
echo"/usr/local/lib">/etc/ld.so.conf.d/usr_local_lib.conf
echo"/usr/lib">>/etc/ld.so.conf.d/usr_local_lib.conf
echo"/usr/lib64">>/etc/ld.so.conf.d/usr_local_lib.conf
echo"/usr/local/lib64">>/etc/ld.so.conf.d/usr_local_lib.conf
/sbin/ldconfig
#安装MySQL
tarzxfmysql-5.1.59.tar.gz
cdmysql-5.1.59
CXX=gccCHOST="x86_64-redhat-linux"、
CFLAGS="-O3-fomit-frame-pointer-pipe-march=nocona-mfpmath=sse\
-m128bit-long-double-mmmx-msse-msse2-maccumulate-outgoing-args\
-m64-ftree-loop-linear-fprefetch-loop-arrays\
-freg-struct-return-fgcse-sm-fgcse-las-fforce-addr\
-fivopts-ftree-vectorize-ftracer-frename-registers\
-minline-all-stringops-fno-exceptions-fno-omit-frame-pointer\
-fbranch-target-load-optimize2"CXXFLAGS="${CFLAGS}"\
LDFLAGS="-lrt-lunwind-ltcmalloc_minimal-lstdc++"\
./configure\
--prefix=/opt/mysql\
--with-server-suffix=-greenshore\
--with-mysqld-user=mysql\
--with-plugins=federated,partition,innodb_plugin,myisam\
--with-charset=utf8\
--with-collation=utf8_general_ci\
--with-extra-charsets=gbk,utf8,ascii\
--with-big-tables\
--with-fast-mutexes\
--with-zlib-dir=bundled\
--with-readline\
--with-pthread\
--enable-assembler\
--enable-profiling\
--enable-local-infile\
--enable-thread-safe-client\
--without-embedded-server\
--without-geometry\
--without-debug\
--without-ndb-binlog
--without-ndb-debug
make&&makeinstall
#创建数据库数据存放目录
mkdir/opt/mysql/var
#添加mysql的目录到系统环境变量
echo"exportPATH=$PATH:
/opt/mysql/bin">>/etc/profile
source/etc/profile//让环境变量生效
echo"/opt/mysql/lib/mysql">>/etc/ld.so.conf
/sbin/ldconfig
ln-s/opt/mysql/lib/mysql/usr/lib64/mysql创建库链接
ln-s/opt/mysql/include/mysql/usr/include/mysql创建库链接
#创建mysql多实例启动脚本
vim/etc/init.d/rc.mysqlmulti
脚本内容:
#!
/bin/sh
#
#Asimplestartupscriptformysqld_multibyTimSmithandJaniTolonen.
#Thisscriptassumesthatffileexistseitherin/etc/for
#/root/fandhasgroups[mysqld_multi]and[mysqldN].Seethe
#mysqld_multidocumentationfordetailedinstructions.
#
#Thisscriptcanbeusedas/etc/init.d/mysql.server
#
#CommentstosupportchkconfigonRedHatLinux
#chkconfig:
23456436
#description:
AveryfastandreliableSQLdatabaseengine.
#
#Version1.0
#
basedir=/opt/mysql
bindir=/opt/mysql/bin
user=mysql
iftest-x$bindir/mysqld_multi
then
mysqld_multi="$bindir/mysqld_multi";
else
echo"Can'texecute$bindir/mysqld_multifromdir$basedir";
exit;
fi
case"$1"in
'start')
"$mysqld_multi"--defaults-extra-file=/etc/fstart$2
;;
'stop')
"$mysqld_multi"--defaults-extra-file=/etc/fstop$2
;;
'report')
"$mysqld_multi"--defaults-extra-file=/etc/freport$2
;;
'restart')
"$mysqld_multi"--defaults-extra-file=/etc/fstop$2
"$mysqld_multi"--defaults-extra-file=/etc/fstart$2
;;
*)
echo"Usage:
$0{start|stop|report|restart}">&2
;;
esac
#编辑/etc/f
vim/etc/f
输入一下内容
[mysqld_multi]
mysqld=/opt/mysql/bin/mysqld_safe
mysqladmin=/opt/mysql/bin/mysqladmin
user=root
password=VxAyENUSlAqWY2YTZx6G
[mysqld0001]
bind-address=10.2.1.6
default-storage-engine=innodb
character-set-server=utf8
collation-server=utf8_general_ci
lower_case_table_names=1
basedir=/opt/mysql
datadir=/opt/mysql/var/0001
ft_min_word_len=4
user=mysql
##File
back_log=500
open-files-limit=102400
open-files=4096
port=3301
socket=/tmp/mysql0001.sock
pid-file=/opt/run/mysql0001.pid
skip-external-locking
skip-name-resolve
##Logging
log_error=/opt/mysql/var/0001/mysql-error.err
log_warnings
log_bin=/opt/mysql/var/0001/mysql-bin
expire_logs_days=2
#log-slow-queries=/opt/mysql/var/0001/slowquery.log
#long_query_time=1
max_binlog_size=512M#maxsizeforbinlogbeforerolling
binlog_format=mixed
##Per-ThreadBuffers*(max_connections)=totalper-threadmemusage
thread_stack=256K#default:
32bit:
192K,64bit:
256K
sort_buffer_size=8M#default:
2M,largermaycauseperfissues
read_buffer_size=2M#default:
128K,changeinincrementsof4K
read_rnd_buffer_size=16M#default:
256K
join_buffer_size=8M#default:
128K
binlog_cache_size=64K#default:
32K,sizeofbuffertoholdTXqueries
##QueryCache
query_cache_size=64M#globalbuffer
query_cache_limit=2M#maxqueryresultsizetoputincache
##Connections
max_connections=4000#multiplierformemoryusageviaper-threadbuffers
max_connect_errors=100#default:
10
concurrent_insert=2#default:
1,2:
enableinsertforallinstances
connect_timeout=30
max_allowed_packet=64M#maxsizeofincomingdatatoallow
net_buffer_length=1024K
##DefaultTableSettings
sql_mode=NO_AUTO_CREATE_USER
##TableandTMPsettings
max_heap_table_size=1G
bulk_insert_buffer_size=1G
tmp_table_size=1G
tmpdir=/dev/shm
##Tablecachesettings
table_cache=2048
table_open_cache=2048
##Threadsettings
thread_concurrency=32
thread_cache_size=100
##MyISAMSpecificoptions
key_buffer_size=256M
bulk_insert_buffer_size=64M
myisam_sort_buffer_size=128M
myisam_max_sort_file_size=2G
myisam_repair_threads=1
myisam_recover
#***INNODBSpecificoptions***
ignore-builtin-innodb
plugin-load=innodb=ha_innodb_plugin.so;innodb_trx=ha_innodb_plugin.so;innodb_locks=ha_innodb_plugin.so;innodb_lock_waits=ha_innodb_plugin.so;innodb_cmp=ha_innodb_plugin.so;innodb_cmp_reset=ha_innodb_plugin.so;innodb_cmpmem=ha_innodb_plugin.so;innodb_cmpmem_reset=ha_innodb_plugin.so
innodb_io_capacity=400
innodb_write_io_threads=16
innodb_read_io_threads=16
innodb_data_file_path=ibdata1:
128M;ibdata2:
10M:
autoextend
innodb_log_file_size=512M
innodb_log_files_in_group=4
innodb_buffer_pool_size=4G
innodb_additional_mem_pool_size=16M
innodb_status_file=1
innodb_file_per_table=1
innodb_flush_log_at_trx_commit=2
innodb_table_locks=0
innodb_log_buffer_size=128M
innodb_lock_wait_timeout=60
innodb_thread_concurrency=32
innodb_commit_concurrency=8
innodb_flush_method=O_DIRECT
innodb_support_xa=0
skip-innodb-doublewrite
##Binlogsyncsettings
sync_binlog=0
##TXIsolation
transaction-isolation=REPEATABLE-READ
[mysqld0002]
bind-address=10.2.1.6
default-storage-engine=innodb
character-set-server=utf8
collation-server=utf8_general_ci
lower_case_table_names=1
basedir=/opt/mysql
datadir=/opt/mysql/var/0002
ft_min_word_len=4
user=mysql
##File
back_log=500
open-files-limit=102400
open-files=4096
port=3302
socket=/tmp/mysql0002.sock
pid-file=/opt/run/mysql0002.pid
skip-external-locking
skip-name-resolve
##Logging
log_error=/opt/mysql/var/0002/mysql-error.err
log_warnings
log_bin=/opt/mysql/var/0002/mysql-bin
expire_logs_days=2
#log-slow-queries=/opt/mysql/var/0002/slowquery.log
#long_query_time=1
max_binlog_size=512M#maxsizeforbinlogbeforerolling
binlog_format=mixed
##Per-ThreadBuffers*(max_connections)=totalper-threadmemusage
thread_stack=256K#default:
32bit:
192K,64bit:
256K
sort_buffer_size=8M#default:
2M,largermaycauseperfissues
read_buffer_size=2M#default:
128K,changeinincrementsof4K
read_rnd_buffer_size=16M#default:
256K
join_buffer_size=8M#default:
128K
binlog_cache_size=64K#default:
32K,sizeofbuffertoholdTXqueries
##QueryCache
query_cache_size=64M#globalbuffer
query_cache_limit=2M#maxqueryresultsizetoputincache
##Connections
max_connections=4000#multiplierformemoryusageviaper-threadbuffers
max_connect_errors=100#default:
10
concurrent_insert=2#default:
1,2:
enableinsertforallinstances
connect_timeout=30
max_allowed_packet=64M#maxsizeofincomingdatatoallow
net_buffer_length=1024K
##DefaultTableSettings
sql_mode=NO_AUTO_CREATE_USER
##TableandTMPsettings
max_heap_table_size=1G
bulk_insert_buffer_size=1G
tmp_table_size=1G
tmpdir=/dev/shm
##Tablecachesettings
table_cache=2048
table_open_cache=2048
##Threadsettings
thread_concurrency=32
thread_cache_size=100
##MyISAMSpecificoptions
key_buffer_size=256M
bu
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- CentOS 安装 MySQL 实例 服务器