Solved

MYSQL, log shipping for multiple DB

Posted on 2013-05-25
1
702 Views
Last Modified: 2013-05-25
Hello,
  I have multiple DB on mySQL server. Currently, only one log-bin file is generated. Is it possible to have a  log-bin for each Database.

Also, if you have one log-bin for all DB . The what would be the syntax for mySQLlogbin to restore the logs for a particular DB


Thanks for your help
0
Comment
Question by:SiemensSEN
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 5

Accepted Solution

by:
DOSLover earned 200 total points
ID: 39197233
With mysqld_multi, a separate section can be created for each database specifying separate path and logs. This will create separate instances of MySQL for each db.

Also, mysqlbinlog command with database option can separate log entries for a database, even though we use the same log for multiple databases.
   > mysqlbinlog   binlog.00001  --database=testdb123
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question