Found onlineNIf you have more information, none of them will succeed successfully. If you are depressed, the level may be limited ...! I have been continuously researching, testing, and fully implementedLinuxStart twoMysql, and have a better understanding of mysql!
The procedure is as follows:
I. Compile and install twoMysqlThe steps are as follows:
DownloadMysql, HereMysql-6.0.11-alpha.tar.gzExample
Install the first database(Primary Database)
(RedSome are default database file paths and can be changed to others, such:Data,VarAnd so on)
Tar zxvf mysql-6.0.11-alpha.tar.gz
Cd mysql-6.0.11-alpha
. /Configure -- prefix =/usr/local/mysql -- sysconfdir =/usr/local/mysql/etc -- with-tcp-port = 3306 -- localstatedir =/usr/local/mysql/Localstate-- With-unix-socket-path =/tmp/mysql3306.sock -- with-charset = utf8 -- with-collation = utf8_general_ci -- with-extra-charsets = gbk, gb2312, binary -- enable-thread-safe-client -- with-plugins = innobase -- with-mysqld-user = mysql -- with-charset = utf8-- With-client-ldflags =-all-static -- with-mysqld-ldflags =-all-static
Make & make install
Install the second database(Slave Database)
Tar zxvf mysql-6.0.11-alpha.tar.gz
Cd mysql-6.0.11-alpha
. /Configure -- prefix =/usr/local/mysql3307 -- sysconfdir =/usr/local/mysql3307/etc -- with-tcp-port = 3307 -- localstatedir =/usr/local/mysql3307/Localstate-- With-unix-socket-path =/tmp/mysql3307.sock -- with-charset = utf8 -- with-collation = utf8_general_ci -- with-extra-charsets = gbk, gb2312, binary -- enable-thread-safe-client -- with-plugins = innobase -- with-mysqld-user = mysql -- with-charset = utf8-- With-client-ldflags =-all-static -- with-mysqld-ldflags =-all-static
Make & make install
To modify all character sets:-- With-extra-charsets =AllYou can.
2. initialize the database scripts respectively (under the compiled directory)
Scripts/mysql_install_db -- basedir =/usr/local/mysql/-- user = mysql
Scripts/mysql_install_db -- basedir =/usr/local/mysql3307/-- user = mysql
Note: available-- Datadir = PATHThe parameter specifies the database file path. The default value is compile time.-- Localstatedir
3. Modify the slave Database Configuration File
Copy the configuration file:
Cp/usr/local/software/mysql-6.0.11-alpha/support-files/my-medium.cnf/usr/local/mysql/etc/my. cnf
Cp/usr/local/software/mysql-6.0.11-alpha/support-files/my-medium.cnf/usr/local/mysql3307/etc/my. cnf
4. ModifyMy. cnfFile
The main content is as follows:
AddInnoDBSupported:
[Client]
# Password= Your_password
Port=3307--Database port number
Socket= /Tmp/mysqls. sock-- SockFile Path
Default-character-set = utf8--ClientUTF8Connection
[Mysqld]
Port= 3307--Database port number
Socket=/Tmp/mysqls. sock-- SockFile Path
Default-storage-engine = INNODB
Default-character-set = UTF8--Default Character Set
Init_connect = 'set NAMES utf8'--ToUTF8Connection
Skip-name-resolve--CancelDNSReverse resolution
Lower_case_table_names = 1--Case Insensitive table names
Start the database (go to their respective directories)
MASTER:./Mysqld_safe &
From:./Mysqld_safe &
Enable Automatic Configuration:
Cp/usr/local/software/mysql-6.0.11-alpha/support-files/mysql. server/etc/init. d/mysql
Cp/usr/local/software/mysql-6.0.11-alpha/support-files/mysql. server/etc/init. d/mysql3307
Modify basedir and datadir in/etc/init. d/mysql3007
Basedir =/usr/local/mysql3307
Datadir =/usr/local/mysql3307/var
Stop Database
MASTER:./Mysqladmin shutdown
From:./Mysqladmin shutdown
You can modify the configurations to meet your business needs.