Campaign FDA: limitation | Community
Skip to main content
S
supratim320
Level 5
May 16, 2023
Solved

Campaign FDA: limitation

  • May 16, 2023
  • 2 replies
  • 1466 views

Hi Everyone,

We are working on a use case where incremental data will be pulled from Mysql database instance into campaign DB using FDA connection. However, before finalizing the solution, we want to know more volumetric information:

a. how much data should we pull in one time

b. is there any load issue in the Mysql instance

c. how does the FDA connection is closed and if not getting closed, what steps can Mysql instance perform

d. what should be the frequency of pull

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 Craig_Thonis

Hi Supratim,

 

First, review the documentation below and ensure you are on a supported FDA database. Based on the current compatibility matrix, it appears that MySQL has been deprecated for FDA and is no longer supported.

Compatibility Matrix:
https://experienceleague.adobe.com/docs/campaign-classic/using/release-notes/compatibility-matrix.html?lang=en

That said, if you should choose a different FDA, we do have documentation on several specific DB configurations below:

https://experienceleague.adobe.com/docs/campaign-classic/using/installing-campaign-classic/accessing-external-database/configure-fda/config-databases/configure-fda.html?lang=en

 

To your specific questions. Unfortunately, as Campaign no longer supports MySql I cannot provide any recommendations other than to migrate to a supported database. From what I see on my end, the decision not to support MySql was due to ongoing performance issues with the database platform.

2 replies

david--garcia
david--garcia
Level 10
May 16, 2023

All in all, performance is down to your own infrastructure specifications, the conneciton handshake/handling is managed by the connector, the frequency of pull doesnt matter, but should take into consideration the impact on loading large sets of data during peak hours/business hours when system is running at full capacity, from experience I've used the FDA module to load millions of records.

 

The best way to answer your questions would be to set up a performance baseline on both systems, then start loading data itnto campaign whilst monitoring  performance (bandwith, system resources) and start ramping up the volume until you are happy on the performance metrics.

    Craig_Thonis
    Adobe Employee
    Craig_ThonisAdobe EmployeeAccepted solution
    Adobe Employee
    May 16, 2023

    Hi Supratim,

     

    First, review the documentation below and ensure you are on a supported FDA database. Based on the current compatibility matrix, it appears that MySQL has been deprecated for FDA and is no longer supported.

    Compatibility Matrix:
    https://experienceleague.adobe.com/docs/campaign-classic/using/release-notes/compatibility-matrix.html?lang=en

    That said, if you should choose a different FDA, we do have documentation on several specific DB configurations below:

    https://experienceleague.adobe.com/docs/campaign-classic/using/installing-campaign-classic/accessing-external-database/configure-fda/config-databases/configure-fda.html?lang=en

     

    To your specific questions. Unfortunately, as Campaign no longer supports MySql I cannot provide any recommendations other than to migrate to a supported database. From what I see on my end, the decision not to support MySql was due to ongoing performance issues with the database platform.

      david--garcia
      david--garcia
      Level 10
      May 16, 2023

      I think the documentation may not be correct or up to date, in the deprecated section it says mySQL 5.1 is not compatible but it says more recent versions are supported, however, they've not updated the FDA compatibility matrix.

       

       

      Craig_Thonis
      Adobe Employee
      Craig_ThonisAdobe Employee
      Adobe Employee
      May 16, 2023

      Hi David,

      Based on some internal R&D tickets, MySQL 8 is being reviewed but not yet certified. Additionally, the last modification on the compatibility matrix is today. Based on this, I would advise proceeding with MySQL server through FDA until it has been certified and updated on the matrix.

       

      That said, @supratim320, if there is no other option, please contact Campaign Support, who can confirm with R&D whether or not your version of MySQL is or will be supported in the future.

        Terms & ConditionsAccessibility statement

        Loading footer...