• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 855
  • Last Modified:

MYSQL, log shipping for multiple DB

  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
1 Solution
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now