Setting Up Replication in MySQL Keep live copies of your database running to increase performance and provide redundancy [Discuss (2) | Link to this hack]
Comments on this hack
Showing messages 1 through 2 of 2.
Setting Up Replication javaidurrehman@yahoo.com
2004-07-01 01:57:23
javaid
[View]
################
#master config
server-id=1
log-bin=/var/lib/mysql/logbin/khi-bin
log-slave-updates
#'''''''''''''''
master-host=192.168.1.1
master-user=rep
master-password=rep
master-port=3306
skip-innodb
################
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/lib/mysql/errlog/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
'**************************************
[mysqld]
#######################
#Slave
server-id=2
log-bin=/var/lib/mysql/logbin/sms-bin
log-slave-updates
master-host=192.168.1.2
master-user=rep
master-password=rep
master-port=3306
skip-innodb
#########################
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/lib/mysql/errlog/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
''''''''''''''''''
a->b->a
any more contact
javaidurrehman@yahoo.com