Created
August 7, 2024 17:52
-
-
Save MartinMiles/1e18daed206060135e8ef43350cc93fa to your computer and use it in GitHub Desktop.
XM Cloud config to plug external database via SQL containers
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<configuration | |
xmlns:patch="www.sitecore.net/.../"> | |
<sitecore> | |
<eventing defaultProvider="sitecore"> | |
<eventQueueProvider> | |
<eventQueue name="rrh" patch:after="evertQueue[@name='web']" type="Sitecore.Data.Eventing.$(database)EventQueue, Sitecore.Kernel"> | |
<param ref="dataApis/dataApi[@name='$(database)']" param1="$(name)" /> | |
<param ref="PropertyStoreProvider/store[@name='$(name)']" /> | |
</eventQueue> | |
<eventQueue name="coreold" patch:after="evertQueue[@name='web']" type="Sitecore.Data.Eventing.$(database)EventQueue, Sitecore.Kernel"> | |
<param ref="dataApis/dataApi[@name='$(database)']" param1="$(name)" /> | |
<param ref="PropertyStoreProvider/store[@name='$(name)']" /> | |
</eventQueue> | |
</eventQueueProvider> | |
</eventing> | |
<PropertyStoreProvider> | |
<store name="rrh" patch:after="store[@name='master']" prefix="rrh" getValueWithoutPrefix="true" singleInstance="true" type="Sitecore.Data.Properties.$(database)PropertyStore, Sitecore.Kernel"> | |
<param ref="dataApis/dataApi[@name='$(database)']" param1="$(name)" /> | |
<param resolve="true" type="Sitecore.Abstractions.BaseEventManager, Sitecore.Kernel" /> | |
<param resolve="true" type="Sitecore.Abstractions.BaseCacheManager, Sitecore.Kernel" /> | |
</store> | |
<store name="coreold" patch:after="store[@name='master']" prefix="custom" getValueWithoutPrefix="true" singleInstance="true" type="Sitecore.Data.Properties.$(database)PropertyStore, Sitecore.Kernel"> | |
<param ref="dataApis/dataApi[@name='$(database)']" param1="$(name)" /> | |
<param resolve="true" type="Sitecore.Abstractions.BaseEventManager, Sitecore.Kernel" /> | |
<param resolve="true" type="Sitecore.Abstractions.BaseCacheManager, Sitecore.Kernel" /> | |
</store> | |
</PropertyStoreProvider> | |
<databases> | |
<database id="rrh" patch:after="database[@id='master']" singleInstance="true" type="Sitecore.Data.DefaultDatabase, Sitecore.Kernel"> | |
<param desc="name">$(id)</param> | |
<icon>Images/database_master.png</icon> | |
<securityEnabled>true</securityEnabled> | |
<dataProviders hint="list:AddDataProvider"> | |
<dataProvider ref="dataProviders/main" param1="$(id)"> | |
<disableGroup>publishing</disableGroup> | |
<prefetch hint="raw:AddPrefetch"> | |
<sc.include file="/App_Config/Prefetch/Common.config" /> | |
<sc.include file="/App_Config/Prefetch/Webdb.config" /> | |
</prefetch> | |
</dataProvider> | |
</dataProviders> | |
<!-- <proxiesEnabled>false</proxiesEnabled> --> | |
<archives hint="raw:AddArchive"> | |
<archive name="archive" /> | |
<archive name="recyclebin" /> | |
</archives> | |
<cacheSizes hint="setting"> | |
<data>100MB</data> | |
<items>50MB</items> | |
<paths>2500KB</paths> | |
<itempaths>50MB</itempaths> | |
<standardValues>2500KB</standardValues> | |
</cacheSizes> | |
<BlobStorage hint="raw:AddBlobStorage"> | |
<providers default="classic"> | |
<provider name="classic" type="Sitecore.Data.Blobs.ClassicSqlBlobProvider, Sitecore.Kernel"> | |
<param desc="databaseName">$(id)</param> | |
</provider> | |
</providers> | |
</BlobStorage> | |
</database> | |
<database id="coreold" patch:after="database[@id='master']" singleInstance="true" type="Sitecore.Data.DefaultDatabase, Sitecore.Kernel"> | |
<param desc="name">$(id)</param> | |
<icon>Images/database_master.png</icon> | |
<securityEnabled>true</securityEnabled> | |
<dataProviders hint="list:AddDataProvider"> | |
<dataProvider ref="dataProviders/main" param1="$(id)"> | |
<disableGroup>publishing</disableGroup> | |
<prefetch hint="raw:AddPrefetch"> | |
<sc.include file="/App_Config/Prefetch/Common.config" /> | |
<sc.include file="/App_Config/Prefetch/Webdb.config" /> | |
</prefetch> | |
</dataProvider> | |
</dataProviders> | |
<!-- <proxiesEnabled>false</proxiesEnabled> --> | |
<archives hint="raw:AddArchive"> | |
<archive name="archive" /> | |
<archive name="recyclebin" /> | |
</archives> | |
<cacheSizes hint="setting"> | |
<data>100MB</data> | |
<items>50MB</items> | |
<paths>2500KB</paths> | |
<itempaths>50MB</itempaths> | |
<standardValues>2500KB</standardValues> | |
</cacheSizes> | |
<BlobStorage hint="raw:AddBlobStorage"> | |
<providers default="classic"> | |
<provider name="classic" type="Sitecore.Data.Blobs.ClassicSqlBlobProvider, Sitecore.Kernel"> | |
<param desc="databaseName">$(id)</param> | |
</provider> | |
</providers> | |
</BlobStorage> | |
</database> | |
</databases> | |
</sitecore> | |
</configuration> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment