developers in another country ?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
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
Photo of damiri

damiri

  • 100 Points 100 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Photo of Ranzo Taylor

Ranzo Taylor, Employee

  • 1,572 Points 1k badge 2x thumb
-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.
Photo of damiri

damiri

  • 100 Points 100 badge 2x thumb
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. 
Photo of Ranzo Taylor

Ranzo Taylor, Employee

  • 1,572 Points 1k badge 2x thumb
-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
-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.
(Edited)
Photo of damiri

damiri

  • 100 Points 100 badge 2x thumb
since we have to do Sparc to Intel, this may not be good solution for us. Thanks for your input.
Photo of Matt Singer

Matt Singer

  • 70 Points
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
Photo of damiri

damiri

  • 100 Points 100 badge 2x thumb
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 ;-)
Photo of Matt Singer

Matt Singer

  • 70 Points
:) Glad you got what you need. Sorry about the slow response.

Matt