•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 455,974 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,754 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser: Programming Forums
Views: 1260 | Replies: 0
![]() |
hi...
i have setup the mysql replication but i dont know for some reason its not replicating the data.. i may be missing some configuration.. please help me... to do the same..
Thanks in advance..
Pooran Jaiswal
my.cnf entries on slave server
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
skip-networking
old_passwords=1
server-id=3
master-host=192.168.x.x
master-port=3306
master-user=yyyyyyyy
master-password=xxxxx
log-bin=/var/log/mysql/bin.log
log-bin-index=/var/log/mysql/log-bin.index
log-error=/var/log/mysql/error.log
relay-log=/var/log/mysql/relay.log
relay-log-info=/var/log/mysql/relay-log.info
relay-log-index=/var/log/mysql/relay-log.index
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
my.cnf entries on master server
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
skip-networking
old_passwords=1
server-id=1
log-bin=/var/log/mysql/bin.log
log-bin-index=/var/log/mysql/log-bin.index
log-error=/var/log/mysql/error.log
binlog-do-db=somedb
binlog-ignore-db=mysql
binlog-ignore-db=test
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/lib/mysql/mysql.sock
datadir=/var/lib/mysql
i have setup the mysql replication but i dont know for some reason its not replicating the data.. i may be missing some configuration.. please help me... to do the same..
Thanks in advance..
Pooran Jaiswal
my.cnf entries on slave server
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
skip-networking
old_passwords=1
server-id=3
master-host=192.168.x.x
master-port=3306
master-user=yyyyyyyy
master-password=xxxxx
log-bin=/var/log/mysql/bin.log
log-bin-index=/var/log/mysql/log-bin.index
log-error=/var/log/mysql/error.log
relay-log=/var/log/mysql/relay.log
relay-log-info=/var/log/mysql/relay-log.info
relay-log-index=/var/log/mysql/relay-log.index
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
my.cnf entries on master server
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
skip-networking
old_passwords=1
server-id=1
log-bin=/var/log/mysql/bin.log
log-bin-index=/var/log/mysql/log-bin.index
log-error=/var/log/mysql/error.log
binlog-do-db=somedb
binlog-ignore-db=mysql
binlog-ignore-db=test
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/lib/mysql/mysql.sock
datadir=/var/lib/mysql
![]() |
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
- MySQL datatype problem.... (PHP)
- MySql installing problem (MySQL)
- Date type problem JSP, mySQL (Java)
- php/mysql communication problem (PHP)
- PHP-MySQL Conn Problem in Win XP (PHP)
- Problem printing from IE6 (Web Browsers)
- mysql start up problem (MySQL)
Other Threads in the MySQL Forum
- Previous Thread: kill sleep process/connections
- Next Thread: Help in Join table


Linear Mode