Hey Chris,
Many people use Docker for this these days.
Docker integrates well with almost all CI/CD tools and it allows you to spin up
a DB fast and just throw it away afterwards, which makes it perfect for Unit
Testing.
If you don’t even need any data or not much, it’s a great fit.
If you do need a lot of data or more sophisticated snapshot and rollback then
probably not so much.
Another benefit of Docker is that Community Edition is free which is probably
all you need for unit testing.
Community Edition also ships in the Oracle Linux addons if you happen to run on
OL.
Thx,
---------------
Gerald Venzl | Senior Principal Product Manager
Email: gerald.venzl@xxxxxxxxxx <mailto:gerald.venzl@xxxxxxxxxx> | Phone:
+1.650.633.0085 <tel:+16506330085>
Oracle ST & Database Development
400 Oracle Parkway | Redwood Shores | 94065 | USA
On Aug 11, 2017, at 10:35, Kellyn Pot'Vin-Gorman <dbakevlar@xxxxxxxxx> wrote:
Which would result in a storage purchase, scripting project to manage it all
and lock into hardware. Delphix and a couple others work on any hardware,
are cloud mobile and have a self-service portal so the DBA doesn't have to
manage it all. The new pricing model makes it worth the look!
Yes, I work for Delphix...:)
Kellyn Gorman
Technical Intelligence Manager
On Fri, Aug 11, 2017 at 1:31 PM Stefan Koehler <contact@xxxxxxxx
<mailto:contact@xxxxxxxx>> wrote:
Hey Chris,
you don't need any special product for this purpose - just a CoW filesystem
with snapshot technology like ZFS :)
Best Regards
Stefan Koehler
Independent Oracle performance consultant and researcher
Website: http://www.soocs.de ;
<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.soocs.de&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PQcxBKCX5YTpkKY057SbK10&r=zUfLpQOHlJTnMpyBPavQbdKRMt_LVE0xNvj73TLA4pQ&m=HdpAyoT7x6Lrc1Tzn5vM4Akby_wpG842bQEV3aruODc&s=uoe2_mIWZYIS115tKAaYX0r7QALuXiZxvhULSzWKSD0&e=>
Twitter: @OracleSK
Chris Taylor <christopherdtaylor1994@xxxxxxxxx--
<mailto:christopherdtaylor1994@xxxxxxxxx>> hat am 11. August 2017 um 19:25
geschrieben:
We've got a relatively large development group who want to have many Unit
Test databases (without data) that they can spin up on demand and destroy
when done.
I'm curious what products are available that could facilitate something
like this?
I was thinking something like this:
Unit Test (UT Master) - code replicated from production nightly (never used
for testing)
How could I facilitate users creating a copy on demand of UTMaster using
something like:
VMWare or
Delphix or
Docker or
something
I'm basically looking to see what options are to accomplish something like
this.
I was thinking if we stood up UT Master on a VM, we could snap the VM into
another copy for a specific developer on demand.
Chris
//www.freelists.org/webpage/oracle-l ;
<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.freelists.org_webpage_oracle-2Dl&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PQcxBKCX5YTpkKY057SbK10&r=zUfLpQOHlJTnMpyBPavQbdKRMt_LVE0xNvj73TLA4pQ&m=HdpAyoT7x6Lrc1Tzn5vM4Akby_wpG842bQEV3aruODc&s=PhZW7UpUQnZi_JN31FnzAI_J16qg7dXBnptd-jhSFJU&e=>
--
Kellyn Pot'Vin-Gorman
about.me/dbakevlar
<https://urldefense.proofpoint.com/v2/url?u=http-3A__about.me_dbakevlar&d=DwMFaQ&c=RoP1YumCXCgaWHvlZYR8PQcxBKCX5YTpkKY057SbK10&r=zUfLpQOHlJTnMpyBPavQbdKRMt_LVE0xNvj73TLA4pQ&m=HdpAyoT7x6Lrc1Tzn5vM4Akby_wpG842bQEV3aruODc&s=PcyHrWG_Og5V5tM02fFWQOL6xjV3Z4h3lPOOgXMvR6o&e=>