MySQL Forums
Forum List  »  Backup

Re: Merging some data from many diffirent databases
Posted by: Scott Nemes
Date: May 04, 2012 08:46AM

That sounds like quite the mess! =)

If you are running MySQL in a Linux environment, I would take a look at Percona Xtrabackup. It is a free backup solution which allows you to do incremental backups, and if you use all InnoDB tables it can do non-blocking hot backups so you do not have to take the server down (http://www.percona.com/software/percona-xtrabackup/).

As for the reporting solution, it sounds like you need a pretty typical ETL process that pulls data from each of the databases based on whatever date range you give it. That could easily be automated by using pre-set date ranges (i.e. run for yesterday). For free ETL solutions, I would check out Talend (http://www.talend.com/index.php) and Pentaho (http://www.pentaho.com/).

--
Scott Nemes
MySQL DBA

http://www.linkedin.com/in/scottnemes
http://www.twitter.com/ScottNemes

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Merging some data from many diffirent databases
1583
May 04, 2012 08:46AM


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.