自己经历的mysql cluter配置过程（二）配置文件

自己经历的mysql cluter配置过程

76.my.cnf

#mpleMySQLconfigfileformediumsystems.
#
#Thisisforasystemwithlittlememory(32M-64M)whereMySQLplays
#animportantpart , orsystemsupto128MwhereMySQLisusedtogetherwith
#otherprograms(suchasawebserver)
#
#Youcancopythisfileto
#/etc/my.cnftosetglobaloptions ,
#mysql-data-dir/my.cnftosetserver-specificoptions(inthis
#installationthisdirectoryis/var/lib/mysql)or
#~/.my.cnftosetuser-specificoptions.
#
#Inthisfile , youcanusealllongoptionsthataprogramsupports.
#Ifyouwanttoknowwhichoptionsaprogramsupports , runtheprogram
#withthe " --help " option.

#ThefollowingoptionswillbepassedtoallMySQLclients
[ client ]
#password = your_password
port = 3307
socket = /var/lib/mysql/mysql.sock

#Herefollowsentriesforsomespecificprograms

#TheMySQLserver
[ mysqld ]
datadir = /var/lib/mysql
user = root
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

#datadir = /mysqldata



#Don'tlistenonaTCP/IPportatall.Thiscanbeasecurityenhancement ,
#ifallprocessesthatneedtoconnecttomysqldrunonthesamehost.
#AllinteractionwithmysqldmustbemadeviaUnixsocketsornamedpipes.
#NotethatusingthisoptionwithoutenablingnamedpipesonWindows
#(viathe " enable-named-pipe " option)willrendermysqlduseless!
#
#skip-networking

#ReplicationMasterServer(default)
#binaryloggingisrequiredforreplication
log-bin = mysql-bin

#requireduniqueidbetween 1 and 2 ^ 32 - 1
#defaultsto 1 ifmaster-hostisnotset
#butwillnotfunctionasamasterifomitted
server-id = 1

#ReplicationSlave(commentoutmastersectiontousethis)
#
#Toconfigurethishostasareplicationslave , youcanchoosebetween
#twomethods:
#
# 1 )UsetheCHANGEMASTERTOcommand(fullydescribedinourmanual)-
#thesyntaxis:
#
#CHANGEMASTERTOMASTER_HOST = <host> , MASTER_PORT = <port> ,
#MASTER_USER = <user> , MASTER_PASSWORD = <password> ;
#
#whereyoureplace<host> , <user> , <password>byquotedstringsand
#<port>bythemaster'sportnumber( 3306 bydefault).
#
#Example:
#
#CHANGEMASTERTOMASTER_HOST = ' 125.564.12.1 ' , MASTER_PORT = 3306 ,
#MASTER_USER = 'joe' , MASTER_PASSWORD = 'secret' ;
#
#OR
#
# 2 )Setthevariablesbelow.However , incaseyouchoosethismethod , then
#startreplicationforthefirsttime(evenunsuccessfully , forexample
#ifyoumistypedthepasswordinmaster-passwordandtheslavefailsto
#connect) , theslavewillcreateamaster.infofile , andanylater
#changeinthisfiletothevariables'valuesbelowwillbeignoredand
#overriddenbythecontentofthemaster.infofile , unlessyoushutdown
#theslaveserver , deletemaster.infoandrestarttheslaverserver.
#Forthatreason , youmaywanttoleavethelinesbelowuntouched
#(commented)andinsteaduseCHANGEMASTERTO(seeabove)
#
#requireduniqueidbetween 2 and 2 ^ 32 - 1
#(anddifferentfromthemaster)
#defaultsto 2 ifmaster-hostisset
#butwillnotfunctionasaslaveifomitted
#server-id = 2
#
#Thereplicationmasterforthisslave-required
#master-host = <hostname>
#
#Theusernametheslavewilluseforauthenticationwhenconnecting
#tothemaster-required
#master-user = <username>
#
#Thepasswordtheslavewillauthenticatewithwhenconnectingto
#themaster-required
#master-password = <password>
#
#Theportthemasterislisteningon.
#optional-defaultsto 3306
#master-port = <port>
#
#binarylogging-notrequiredforslaves , butrecommended
#log-bin = mysql-bin

#Pointthefollowingpathstodifferentdedicateddisks
#tmpdir = /tmp/
#log-update = /path-to-dedicated-directory/hostname

#UncommentthefollowingifyouareusingBDBtables
#bdb_cache_size = 4M
#bdb_max_lock = 10000


#UncommentthefollowingifyouareusingInnoDBtables
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
#innodb_log_arch_dir = /var/lib/mysql
#Youcanset.._buffer_pool_sizeupto 50 - 80 %
#ofRAMbutbewareofsettingmemoryusagetoohigh
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
#Set.._log_file_sizeto 25 %ofbufferpoolsize
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50


ndbcluster#runNDBstorageengine
ndb-connectstring = 192.168.1.79 #locationofmanagementserver
[ mysqldump ]
quick
max_allowed_packet = 16M

[ mysql ]
no-auto-rehash
#RemovethenextcommentcharacterifyouarenotfamiliarwithSQL
#safe-updates

[ isamchk ]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[ myisamchk ]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[ mysqlhotcopy ]
interactive-timeout


[ MYSQL_CLUSTER ]
ndb-connectstring = 192.168.1.79 #locationofmanagementserver

16.my.cnf

#ExampleMySQLconfigfileformediumsystems.
#
#Thisisforasystemwithlittlememory(32M-64M)whereMySQLplays
#animportantpart , orsystemsupto128MwhereMySQLisusedtogetherwith
#otherprograms(suchasawebserver)
#
#Youcancopythisfileto
#/etc/my.cnftosetglobaloptions ,
#mysql-data-dir/my.cnftosetserver-specificoptions(inthis
#installationthisdirectoryis/var/lib/mysql)or
#~/.my.cnftosetuser-specificoptions.
#
#Inthisfile , youcanusealllongoptionsthataprogramsupports.
#Ifyouwanttoknowwhichoptionsaprogramsupports , runtheprogram
#withthe " --help " option.

#ThefollowingoptionswillbepassedtoallMySQLclients
[ client ]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock

#Herefollowsentriesforsomespecificprograms

#TheMySQLserver
[ mysqld ]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M


ndbcluster#runNDBstorageengine
ndb-connectstring = 192.168.1.79 #locationofmanagementserver


#Don'tlistenonaTCP/IPportatall.Thiscanbeasecurityenhancement ,
#ifallprocessesthatneedtoconnecttomysqldrunonthesamehost.
#AllinteractionwithmysqldmustbemadeviaUnixsocketsornamedpipes.
#NotethatusingthisoptionwithoutenablingnamedpipesonWindows
#(viathe " enable-named-pipe " option)willrendermysqlduseless!
#
#skip-networking

#ReplicationMasterServer(default)
#binaryloggingisrequiredforreplication
log-bin = mysql-bin

#requireduniqueidbetween 1 and 2 ^ 32 - 1
#defaultsto 1 ifmaster-hostisnotset
#butwillnotfunctionasamasterifomitted
server-id = 1

#ReplicationSlave(commentoutmastersectiontousethis)
#
#Toconfigurethishostasareplicationslave , youcanchoosebetween
#twomethods:
#
# 1 )UsetheCHANGEMASTERTOcommand(fullydescribedinourmanual)-
#thesyntaxis:
#
#CHANGEMASTERTOMASTER_HOST = <host> , MASTER_PORT = <port> ,
#MASTER_USER = <user> , MASTER_PASSWORD = <password> ;
#
#whereyoureplace<host> , <user> , <password>byquotedstringsand
#<port>bythemaster'sportnumber( 3306 bydefault).
#
#Example:
#
#CHANGEMASTERTOMASTER_HOST = ' 125.564.12.1 ' , MASTER_PORT = 3306 ,
#MASTER_USER = 'joe' , MASTER_PASSWORD = 'secret' ;
#
#OR
#
# 2 )Setthevariablesbelow.However , incaseyouchoosethismethod , then
#startreplicationforthefirsttime(evenunsuccessfully , forexample
#ifyoumistypedthepasswordinmaster-passwordandtheslavefailsto
#connect) , theslavewillcreateamaster.infofile , andanylater
#changeinthisfiletothevariables'valuesbelowwillbeignoredand
#overriddenbythecontentofthemaster.infofile , unlessyoushutdown
#theslaveserver , deletemaster.infoandrestarttheslaverserver.
#Forthatreason , youmaywanttoleavethelinesbelowuntouched
#(commented)andinsteaduseCHANGEMASTERTO(seeabove)
#
#requireduniqueidbetween 2 and 2 ^ 32 - 1
#(anddifferentfromthemaster)
#defaultsto 2 ifmaster-hostisset
#butwillnotfunctionasaslaveifomitted
#server-id = 2
#
#Thereplicationmasterforthisslave-required
#master-host = <hostname>
#
#Theusernametheslavewilluseforauthenticationwhenconnecting
#tothemaster-required
#master-user = <username>
#
#Thepasswordtheslavewillauthenticatewithwhenconnectingto
#themaster-required
#master-password = <password>
#
#Theportthemasterislisteningon.
#optional-defaultsto 3306
#master-port = <port>
#
#binarylogging-notrequiredforslaves , butrecommended
#log-bin = mysql-bin

#Pointthefollowingpathstodifferentdedicateddisks
#tmpdir = /tmp/
#log-update = /path-to-dedicated-directory/hostname

#UncommentthefollowingifyouareusingBDBtables
#bdb_cache_size = 4M
#bdb_max_lock = 10000

#UncommentthefollowingifyouareusingInnoDBtables
#innodb_data_home_dir = /var/lib/mysql/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /var/lib/mysql/
#innodb_log_arch_dir = /var/lib/mysql/
#Youcanset.._buffer_pool_sizeupto 50 - 80 %
#ofRAMbutbewareofsettingmemoryusagetoohigh
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
#Set.._log_file_sizeto 25 %ofbufferpoolsize
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

[ mysqldump ]
quick
max_allowed_packet = 16M

[ mysql ]
no-auto-rehash
#RemovethenextcommentcharacterifyouarenotfamiliarwithSQL
#safe-updates

[ isamchk ]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[ myisamchk ]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[ mysqlhotcopy ]
interactive-timeout


[ MYSQL_CLUSTER ]
ndb-connectstring = 192.168.1.79 #locationofmanagementserver

19.my.cnf

#ExampleMySQLconfigfileformediumsystems.
#
#Thisisforasystemwithlittlememory(32M-64M)whereMySQLplays
#animportantpart , orsystemsupto128MwhereMySQLisusedtogetherwith
#otherprograms(suchasawebserver)
#