Want to understand why MSSQL and MySQL is still Experimental Configuration in the docs | Community
Skip to main content
Level 2
July 21, 2024
Solved

Want to understand why MSSQL and MySQL is still Experimental Configuration in the docs

  • July 21, 2024
  • 3 replies
  • 1163 views

Hi Team 

As per the below document it says the below url string and Driver is Experimental. What that supposed to mean here. Though it is working just want to understand any risk or experimentation still going on. If so Please let us know what kind of experimentation it is. is it Safe to use. 

  • jdbc:mysql://localhost:3306/databasename for MySQL and MariaDB (experimental);
  • jdbc:sqlserver://localhost:1453;databaseName=name for Microsoft SQL Server (experimental).
  • com.mysql.jdbc.Driver for MySQL and MariaDB (experimental);
  • com.microsoft.sqlserver.jdbc.SQLServerDriver for Microsoft SQL Server (experimental).



https://experienceleague.adobe.com/en/docs/experience-manager-65/content/implementing/deploying/deploying/rdbms-support-in-aem#:~:text=Support%20for%20relational%20database%20persistence,BlobStore%20API%20is%20also%20provided

And in the technical requirements document it says.Microsoft® SQL Server 2016 is supported. why postgres is not in the list. What type of rdbms supported here ? 

https://experienceleague.adobe.com/en/docs/experience-manager-65/content/implementing/deploying/introduction/technical-requirements

Platform Description Support Level

File system with TAR files [1]RepositoryA: Supported
File system with Datastore [1]BinariesA: Supported
Store binaries in TAR files on file system [1]BinariesZ: Not supported for production
Amazon S3BinariesA: Supported
Microsoft® Azure Blob StorageBinariesA: Supported
MongoDB Enterprise 6.0RepositoryA: Supported [3, 4]
MongoDB Enterprise 5.0RepositoryA: Supported [3, 4]
MongoDB Enterprise 4.4RepositoryA: Supported [2, 3, 4, 7]
MongoDB Enterprise 4.2RepositoryA: Supported [2, 3, 4, 7]
MongoDB Enterprise 4.0RepositoryZ: Not supported
MongoDB Enterprise 3.6RepositoryZ: Not supported
MongoDB Enterprise 3.4RepositoryZ: Not supported
IBM® DB2® 10.5Repository & Forms DatabaseR: Restricted Support [5]
Oracle Database 12c (12.1.x)Repository & Forms DatabaseR: Restricted Support
Microsoft® SQL Server 2016Forms DatabaseA: Supported
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by joerghoh

In the end for any production environment you need to have a supported setup; that mans that you should follow the table on the page "technical requirements", which only lists Mongo, DB2 and Oracle DB as supported to use as storage for the repository (DB2 and Oracle as restricted).

 

That means that you don't get production support for a postgres-based AEM setup. That does not necessarily mean that it does not work (I believe that it actually works quite well), but in the end it is a question of being on a supported level or not.

3 replies

EstebanBustamante
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
July 22, 2024

Hi, 

The documentation you referred to is for AEM 6.4. I suggest you open a support ticket directly with Adobe and inquire about the support they provide for AEM versions 6.5 and higher.

Esteban Bustamante
JeganNaAuthor
Level 2
July 23, 2024

It says 6.4 once it is redirected it will be sub page of 6.5. I referred in 6.5 as well same was written. 

joerghoh
Adobe Employee
joerghohAdobe EmployeeAccepted solution
Adobe Employee
July 27, 2024

In the end for any production environment you need to have a supported setup; that mans that you should follow the table on the page "technical requirements", which only lists Mongo, DB2 and Oracle DB as supported to use as storage for the repository (DB2 and Oracle as restricted).

 

That means that you don't get production support for a postgres-based AEM setup. That does not necessarily mean that it does not work (I believe that it actually works quite well), but in the end it is a question of being on a supported level or not.

kautuk_sahni
Community Manager
Community Manager
August 1, 2024

@jeganna Did you find the suggestions from users helpful? Please let us know if you require more information. Otherwise, please mark the answer as correct for posterity. If you've discovered a solution yourself, we would appreciate it if you could share it with the community. Thank you!

Kautuk Sahni