MySQL Forums
Forum List  »  Replication

replication multiple Database on Same Master/Slave Server
Posted by: mukti roy
Date: February 20, 2013 01:06PM

Hi,
I have two databases on Master.
1) DB1
2) DB2

Now DB1(Master) is replicated to other 3 Slave Server.
Same DB2(Master) is also replicated to above 3 Slave server.

Now I want to perform following steps
1)stop replication on DB2,DB1.
2) drop the DB2.
3) Create again the DB2.
4) start replication for DB2.

Is these above steps can create any impact on DB1? It is urgent. kindly reply me ASAP.


Find Below setting in my.cnf file in Master
================================================================================
server-id=123

# It may be wise to include the server-name or an easy identifier
# to the server in these logs, such as 'log-bin=/var/lib/mysqllogs/db1-bin-log'
#log-bin=xyz
#binlog-do-db=xyz_10mar2012

log-bin=Db_8thsept
#binlog-do-db=Db_8thsept
binlog-do-db=DB1
binlog-do-db=DB2
#log-bin-index=/var/lib/mysqllogs/bin-log.index
#relay-log=/var/lib/mysqllogs/relay-log
#relay-log-index=/var/lib/mysqllogs/relay-log.index

# MySQL 5.0+ Only
expire_logs_days=2

# This is usually only needed when setting up chained replication.
#log-slave-updates

# Enable this to make replication more resilient against server
# crashes and restarts, but can cause higher I/O on the server.
#sync_binlog=1

==============================================================================
below setting in my.cnf on slave server
================================================================================

server-id=422234
slave-skip-errors=1062
# It may be wise to include the server-name or an easy identifier
# to the server in these logs, such as 'log-bin=/var/lib/mysqllogs/db1-bin-log'
#log-bin=XYZ
#binlog-do-db=XYZ_10mar2012
#replicate-rewrite-db=XYZ_10mar2012->xyz_23jun12
#replicate-do-db=xyz_23jun12

log-bin=Db_8thsept
binlog-do-db=DB1
replicate-do-db=DB1
replicate-do-db=DB2


#log-bin-index=/var/lib/mysqllogs/bin-log.index
#relay-log=/var/lib/mysqllogs/relay-log
#relay-log-index=/var/lib/mysqllogs/relay-log.index
#relay-log-space-limit = 4G

# MySQL 5.0+ Only
expire_logs_days=14

# This is usually only needed when setting up chained replication.
#log-slave-updates

# Enable this to make replication more resilient against server
# crashes and restarts, but can cause higher I/O on the server.
#sync_binlog=1



Edited 1 time(s). Last edit at 02/20/2013 01:23PM by mukti roy.

Options: ReplyQuote


Subject
Views
Written By
Posted
replication multiple Database on Same Master/Slave Server
5291
February 20, 2013 01:06PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.