New Artifactory host w/ existing fullDB MS SQL instance

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

New Artifactory host w/ existing fullDB MS SQL instance

linusHillyard
I've built an instance of Artifactory utilizing MS SQL as a database backend; storage setting 'fullDB'(both metadata and artifact BLOBs).  I've chosen the full storage SQL backend in an attempt to provide a 'stateless' Artifactory instance.  I'm hoping for the ability to delete or lose the 'current’ Artifactory instance, then re-provision and rely on configuration management to build a new VM and attach it to the existing MS SQL instance.

However in my testing when attaching the newly provisioned Artifactory instance to the existing MS SQL DB, I'm not seeing the previous VM's repos in the Artifact Repository Browser.   When looking in the ’Storage' section of the Advanced Admin console I see the previous repos in the Storage Summary with Repository Type and Package Type value of ’NA’.   So it’s as though the storage does see the repo but cannot identify the appropriate metadata.  No Artifactory version change occurred between the two different builds.

Is it possible to attach a new instance of Artifactory to an existing fullDB instance as a means of host migration?
Reply | Threaded
Open this post in threaded view
|

Re: New Artifactory host w/ existing fullDB MS SQL instance

Juanjo
You also need to generate the XML blobs with the mail server, repository definitions, etc.

Your idea is right, and that is what I do... but getting there will take you a few days scripting the configuration generation. :)

Artifactory is not the nicest system to automate IMO.
________________________________________
From: linusHillyard <[hidden email]>
Sent: 19 February 2016 05:56
To: [hidden email]
Subject: [Artifactory-users] New Artifactory host w/ existing fullDB MS SQL     instance

I've built an instance of Artifactory utilizing MS SQL as a database backend;
storage setting 'fullDB'(both metadata and artifact BLOBs).  I've chosen the
full storage SQL backend in an attempt to provide a 'stateless' Artifactory
instance.  I'm hoping for the ability to delete or lose the 'current’
Artifactory instance, then re-provision and rely on configuration management
to build a new VM and attach it to the existing MS SQL instance.

However in my testing when attaching the newly provisioned Artifactory
instance to the existing MS SQL DB, I'm not seeing the previous VM's repos
in the Artifact Repository Browser.   When looking in the ’Storage' section
of the Advanced Admin console I see the previous repos in the Storage
Summary with Repository Type and Package Type value of ’NA’.   So it’s as
though the storage does see the repo but cannot identify the appropriate
metadata.  No Artifactory version change occurred between the two different
builds.

Is it possible to attach a new instance of Artifactory to an existing fullDB
instance as a means of host migration?



--
View this message in context: http://forums.jfrog.org/New-Artifactory-host-w-existing-fullDB-MS-SQL-instance-tp7580825.html
Sent from the Artifactory - Users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Artifactory-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/artifactory-users

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Artifactory-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/artifactory-users