ITPub博客

首页 > Linux操作系统 > Linux操作系统 > some thougts about some work as to db admin in paipai.com

some thougts about some work as to db admin in paipai.com

原创 Linux操作系统 作者:tengrid 时间:2009-05-18 19:19:51 0 删除 编辑

http://www.jaredstill.com/content/perl-for-dbas.html

this article generally introduced the perl for Oracle,include the history of perl,fuctionality for database,DBI ,and how to get and install it in various platforms, obviously, if you want to become a skilled Oracle DBA,you should use perl;

as to our paipai.com's Storage backgroud,that's a compound environment of numerous mysql boxes and some Standby Oracle DBs (after some days ), we need to resolve the data Extract,Transfer,Load (ETL) from all the mysql boxes and ÓLTP Oracle DBs to a central DW, how to incremently get the needed data? instead completely unload and load separately?


maybe,use the DBI in perl can be useful, if not, perhaps we have to develop some tools to dig the mysql's binary logs, transfer them to oracle-recognized SQLs,then apply the SQLs in the DW DB, at this point,the tools will like the replication utilities STREAMS or Shareplex, is it?

this need the DBAs in paipai.com have the good knowleges about mysql and Oracle,especially, must have the hands-on c/c++ skills, OMG,so big gap between the reality and the future!

but pls DO NOT be afraid , hunter,saima,ivanqiu and so many workmates may give us wonderful helpness
and , God will bless you, boys.

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/94384/viewspace-600303/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-05-18

  • 博文量
    136
  • 访问量
    381303