您好,登錄后才能下訂單哦!
-----------mysql多實例配置文件
[root@db01/]# cat /data/3307/my.cnf
[client]
port = 3307 #<== 端口號,可修改
socket = /data/3307/mysql.sock
[mysql]
no-auto-rehash
[mysqld]
user = mysql #<== 所屬用戶,根據(jù)實際情況而定
port = 3307 #<== 端口號,可修改
socket = /data/3307/mysql.sock #<== 指定socket文件位置
basedir = /application/mysql #<== 安裝程序目錄
datadir = /data/3307/data #<== mysql數(shù)據(jù)文件目錄
open_files_limit = 1024 #<== 文件描述符限制
back_log = 600 #<== 系統(tǒng)預(yù)處理等待隊列連接數(shù)量
max_connections = 800 #<== 最大連接數(shù)
max_connect_errors = 3000 #<== 最大錯誤數(shù)
table_cache = 614 #<== 表緩存
external-locking = FALSE #<== 外部鎖
max_allowed_packet =8M #<== 最大允許的包大小
sort_buffer_size = 1M #<== 排序緩沖大小
join_buffer_size = 1M #<== 連接緩沖大小
thread_cache_size = 100 #<== 線程緩存數(shù)量
thread_concurrency = 2 #<== 線程并發(fā)量
query_cache_size = 2M #<== 請求緩存大小
query_cache_limit = 1M #<== 請求緩存限制大小
query_cache_min_res_unit = 2k #<== 請求緩存最小保留單元大小
#default_table_type = InnoDB
thread_stack = 192K #<== 線程數(shù)大小
#transaction_isolation = READ-COMMITTED
tmp_table_size = 2M #<== 臨時表大小
max_heap_table_size = 2M #<== 最大堆表大小
#long_query_time = 1 #<== 長請求時間1s
#log_long_format
#log-error = /data/3307/error.log #<== 錯誤日志
#log-slow-queries = /data/3307/slow.log #<== man查詢?nèi)罩?/span>
pid-file = /data/3307/mysql.pid #<== pid文件位置
#log-bin = /data/3307/mysql-bin #<== binlog開啟及位置
relay-log = /data/3307/relay-bin #<== relaylog開啟及位置
relay-log-info-file = /data/3307/relay-log.info #<== reloylog信息文件
binlog_cache_size = 1M #<== binlog緩存大小
max_binlog_cache_size = 1M #<== 最大binlog緩存大小
max_binlog_size = 2M
expire_logs_days = 7
key_buffer_size = 16M
read_buffer_size = 1M
read_rnd_buffer_size = 1M
bulk_insert_buffer_size = 1M
#myisam_sort_buffer_size = 1M
#myisam_max_sort_file_size = 10G
#myisam_max_extra_sort_file_size = 10G
#myisam_repair_threads = 1
#myisam_recover
lower_case_table_names = 1 #<== 忽略表名大小寫
skip-name-resolve #<== 跳過名稱解析
slave-skip-errors = 1032,1062 #<== 主從同步,從庫錯誤忽略代碼列表
replicate-ignore-db=mysql #<== 復(fù)制忽略數(shù)據(jù)庫:mysql
server-id = 3 #<== 設(shè)置server-id 主從復(fù)制不能一樣
innodb_additional_mem_pool_size = 4M
innodb_buffer_pool_size = 32M
innodb_data_file_path =ibdata1:128M:autoextend
innodb_file_io_threads = 4
innodb_thread_concurrency = 8
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 2M
innodb_log_file_size = 4M
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 120
innodb_file_per_table = 0
[mysqldump]
quick
max_allowed_packet = 2M
[mysqld_safe]
log-error=/data/3307/mysql_3307.err #<== 日志文件
pid-file=/data/3307/mysqld.pid
------------------------------------------------------------------------------------------------------------------------------------
-----------mysql多實例啟動文件
[root@db01/]# cat /data/3308/mysql
#!/bin/sh
################################################
#this scripts iscreated by tudou at 2016-06-09
#tudou QQ:1097857032 1+1=3
#blog:https://blog.51cto.com/user_index.php?action=addblog_new
################################################
#init
port=3307
mysql_user="root"
mysql_pwd="123456" #<== 設(shè)定的密碼
CmdPath="/application/mysql/bin"
mysql_sock="/data/${port}/mysql.sock" #<== 進入多實例數(shù)據(jù)庫需要mysql.sock
#startup function
function_start_mysql()
{
if [ ! -e "$mysql_sock" ];then
printf "Starting MySQL...\n"
/bin/sh ${CmdPath}/mysqld_safe--defaults-file=/data/${port}/my.cnf 2>&1 > /dev/null &
else
printf "MySQL is running...\n"
exit
fi
}
#stop function
function_stop_mysql()
{
if [ ! -e "$mysql_sock" ];then
printf "MySQL is stopped...\n"
exit
else
printf "Stoping MySQL...\n"
${CmdPath}/mysqladmin -u ${mysql_user}-p${mysql_pwd} -S /data/${port}/mysql.sock shutdown
fi
}
#restart function
function_restart_mysql()
{
printf "Restarting MySQL...\n"
function_stop_mysql
sleep 2
function_start_mysql
}
case $1 in
start)
function_start_mysql
;;
stop)
function_stop_mysql
;;
restart)
function_restart_mysql
;;
*)
printf "Usage: /data/${port}/mysql{start|stop|restart}\n"
esac
######################################################################################
-----------通過以上配置啟動mysql數(shù)據(jù)庫后生成的文件如下:
mysql-bin.000001 #<== mysql數(shù)據(jù)庫的操作日志(加密)
mysql-bin.index #<== mysql數(shù)據(jù)庫操作日志的索引文件
mysqld.pid #<== 3307數(shù)據(jù)庫的進程號文件
mysql_3307.err #<== 3307的錯誤日志·文件
mysql.sock #<== 啟動服務(wù)的套接字文件
注意:當(dāng)數(shù)據(jù)強制關(guān)機會導(dǎo)致狀態(tài)顯示啟動,實際并沒有運行的狀態(tài),遇見此種狀態(tài)將mysql.sock文件改革名字,然后重新啟動數(shù)據(jù)庫即可,它會生成新的mysql.sock文件
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進行舉報,并提供相關(guān)證據(jù),一經(jīng)查實,將立刻刪除涉嫌侵權(quán)內(nèi)容。