Home -> Mailing Lists -> Oracle-L -> Re: Developers wanting individual Unit Test (no data) databases - suggestions?

Re: Developers wanting individual Unit Test (no data) databases - suggestions?

From: Gerald Venzl <gerald.venzl_at_oracle.com>
Date: Fri, 11 Aug 2017 11:17:34 -0700
Message-Id: <92A5F56C-6949-4911-92B1-BC15A0F219AF_at_oracle.com> 








Yes, they can run it locally and if you have a CI/CD toolchain (Jenkins, etc) it too can spin those up those databases automatically in the background on the servers.
Just saying that as unit tests are usually executed during multiple stages: The developer while development, the version control on accepting the commit, the integration tests and automatic builds, etc. running after code has been committed, etc.



If you/the developer like they can snap from a Unit test master but frankly with Docker you just build a master image and give it to all developers and they just spin up a container of that image.
No need to snap as long as you don’t have any more complex snapshot requirements as said before.



Thx,





Gerald Venzl | Senior Principal Product Manager
Email: gerald.venzl_at_oracle.com <mailto:gerald.venzl_at_oracle.com> | Phone: +1.650.633.0085 <tel:+16506330085>
Oracle ST & Database Development 


400 Oracle Parkway | Redwood Shores | 94065 | USA


> On Aug 11, 2017, at 11:02, Chris Taylor <christopherdtaylor1994_at_gmail.com> wrote:
> 
> Could a developer run docker locally and snap from a Unit Test master?  I'm not familiar with Docker - trying to figure out the infrastructure (at a high level) to support something like this.
> 
> Chris
> 
> 
> On Fri, Aug 11, 2017 at 12:44 PM, Gerald Venzl <gerald.venzl_at_oracle.com <mailto:gerald.venzl_at_oracle.com>> wrote:
> 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_at_oracle.com <mailto:gerald.venzl_at_oracle.com> | 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_at_gmail.com <mailto:dbakevlar_at_gmail.com>> 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_at_soocs.de <mailto:contact_at_soocs.de>> 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: _at_OracleSK

>> 

>> > Chris Taylor <christopherdtaylor1994_at_gmail.com <mailto:christopherdtaylor1994_at_gmail.com>> 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

>> --

>> http://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=>

> 



--
http://www.freelists.org/webpage/oracle-l


Received on Fri Aug 11 2017 - 20:17:34 CEST












Original text of this message