General Question About Delphix

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered

I am doing Delphix POC So i want to know answer of some questions like

take a example size of source databse is 93 mb and after linked it to dSource compressed size is 35 mb (roughly..).

Q1) How compression is done in Delphix when source database is linked as dSource?

Q2)When we Provision the Snapshot of dSource and Creating VDB then what will be the size of VDB (i.e it's size will equal to compressed size or same as size of Source Database) in Target Machine?

Q3) if the size of VDB is compressed one in Target Machine then how sql query works on compressed data?

Q4) when we insert Data in the VDB then it is added as unvirtualized space or as virtualized space in Target Machine?

please responce if you know because it may help others also.

Photo of Manish Kumar

Manish Kumar

  • 220 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Scott MacDonald

Scott MacDonald, Staff Engineer

  • 2,722 Points 2k badge 2x thumb

I'll try to answer your questions here:

Q1 - The compression is implemented by the Delphix filesystem internally when data is written to it, it is totally transparent to whatever reads/writes it (usually a Database instance). Delphix essentially takes a 'copy' of the source database and keeps this (compressed) copy on Delphix storage.

Q2 - A VDB's data is not stored on a target server, it is mounted over the network from the Delphix Server. However, to the target server, it will look the same size as the source.

Q3 - As above, the compression is not visible to the database. It just means less disk space is used by Delphix.

Q4 - As above, it does not use any space on the target machine. The space is used on Delphix.

To clarify, Delphix does not store any database data on a target server, only internally on the Delphix server itself. The only space used on a target system by Delphix is for what we call the "toolkit", which is basically the small set of tools we need to mount/unmount filesystems, start/stop the VDBs, and similar tasks.

I hope that helps, 

Photo of Scott MacDonald

Scott MacDonald, Staff Engineer

  • 2,722 Points 2k badge 2x thumb
Hi Manish,

Could you share which region/country you are working in? I can ask one of the Sales Engineering guys to get in touch with you to provide assistance, if that is helpful, or are you already working with someone from Delphix?