Delphix Products

Expand all | Collapse all

developers in another country ?

Jump to Best Answer
  • 1.  developers in another country ?

    Posted 08-23-2014 03:44:00 PM
    Hi,
    I have in one country Oracle 11g on Oracle Sparc installation, Solaris 11 for production. In another country we have developers developing apps on Intel based servers, mostly virtualized with Vmware vSphere 5.5. 

    Database in size is 4TB and we often needs to move data from production to development and this takes really long since we are copying it all the time. 

    My questions are:

    - Since on Solaris host we don't have access but Oracle login (rented as service), is this enough for Delphix ?
    - Is it possbile to move it accross platforms like this from Solaris Sparc to Solaris Intel or Linux Intel Oracle ?
    - What is best way to do initial dump if this is possible so we don't move 4TB accross wan but do initial dump and then just replicate?
    - We would need 24h data, paste of change is cca 10%, what pipe is requreid to move data in 12h (this depends on really how data will be compressed before) ? 
    - what would be proper setup on development site for this: we were thinking of 2xDL560 with FAS2552 all flash for 5TB, What is best configuration for Delphix?

    Best regards,

    Damir
    #Tip


  • 2.  RE: developers in another country ?
    Best Answer

    Posted 08-23-2014 05:23:00 PM
    -You need an OS user as well.  We have helped many customers with 3rd party service providers, this is usually a manageable hurdle.  SSH key exchange, and use of the "oracle" user, can remove the need for your service provider to provide a password or create a new user.  
    -Delphix currently supports UNIX to LINUX conversion.  "UNIX" includes Solaris Sparc, HP-UX, and AIX.  Solaris on Intel is currently not supported, but it might work.
    -Even over long distances, we typically use the network.  The initial runtime might be many days, but the impact on production is minimal.  If required, you can ship a tape, build a standby, and use that for your initial sync.
    -Subsequent syncs of 400 GB/day over 12h would require a 100 Mbps pipe.  Typical compression rates are what you'd expect: 2-5x and depends on your data.  NB: the pace of change can be hard to determine...a single block changed 100 times will only be shipped once to Delphix. The amount of archive log files is a rough indicator, but can be much, much larger (or, rarely, smaller!) than the changed blocks pulled by Delphix.  The size of an incremental backup is the right thing to check, not your archive logs.  A true change rate of 10% on a database that large is rare, while 400 GB of logs is easy to believe.  Your change rate, expressed as unique database blocks changed, might be low enough for 10 Mbps to work.
    -Server sizing and topology shouldn't be done on forums. Delphix is both vertically and horizontally scalable. Our solution architects provide scripts and expertise to help you determine the right server sizes and topology.  The server you described might work, but then again it might not.


  • 3.  RE: developers in another country ?

    Posted 08-24-2014 09:33:00 AM
    Hi Ranzo,
    thank you for your reply:

    - so database/OS user is required and nothing is installed on production system ? 
    - Production is Solaris Sparc and we planning to use Solaris Intel for development. Any plans to support Solaris Intel?
    - It is long distance. We don't have problem with shipping initial seed over. 
    - So smaller pipe, we will work with older data. This is acceptable ...Also, we have to watch to log files. Will check that out as well 
    - Ok for server sizing. 


  • 4.  RE: developers in another country ?

    Posted 08-24-2014 04:24:00 PM
    -There is a small toolkit installed, which contains a JVM and scripts.  This can comfortably fit in an existing user home directory.  You need 256 MB.  http://docs.delphix.com/display/DOCS41/Requirements+for+Oracle+Source+Hosts+and+Databases">http://docs.delphix.com/display/DOCS41/Requirements+for+Oracle+Source+Hosts+and+Databases">http://docs.delphix.com/display/DOCS41/Requirements+for+Oracle+Source+Hosts+and+Databases
    -No plans to my knowledge around Solaris Intel for endian conversion.  But Solaris Intel is absolutely supported for normal operation, where the source and targets are the same OS and RDBMS version.  http://docs.delphix.com/display/DOCS41/Supported+Operating+Systems+and+DBMS+Versions+for+Oracle+Envi...
    -A WAN doesn't imply stale data.  Many customers use long distance networks to stay current with fresh data from 10+ TB sources.  This is because typically the count of unique changed blocks is much lower than the total number of changes.  That's an assumption based on typical databases; your mileage may vary.  Our solution architects would be happy to give you a precise answer.


  • 5.  RE: developers in another country ?

    Posted 08-24-2014 07:38:00 PM
    since we have to do Sparc to Intel, this may not be good solution for us. Thanks for your input.



  • 6.  RE: developers in another country ?

    Posted 08-26-2014 02:42:00 PM
    Hi Damir,

    So that I can get you to the right resource for additional information, can you tell me where you are located?

    thanks
    Matt


  • 7.  RE: developers in another country ?

    Posted 08-26-2014 02:43:00 PM
    Mat, already talked with Karsten Stöhr from Delphix. I also filled in form on your website but look slike you are more responsive here then from the web ;-)


  • 8.  RE: developers in another country ?

    Posted 08-26-2014 02:47:00 PM
    :) Glad you got what you need. Sorry about the slow response.

    Matt