> On Jun 10, 2016, at 9:27 AM, Sridhar N Bamandlapally <sridhar....@gmail.com> > wrote: > > 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
