This is what I feel will give me solution to maintain production (current+7days) and archive(current+history) without any etl/scheduler
But there is no feature available in any database
Sridhar
Opentext
If that's what you want, in any database, then MySQL's "SET sql_log_bin" statement could probably be used to accomplish what you want.
But, the engineering effort needed to get streaming replication to populate your data warehouse is probably much higher than just building an ETL job. Are you so certain your situation is so special that you can't use what the rest of the industry uses?
-Dan
