Skip to main content
Answer

Running Acumatica ERP with MySQL Database limit

  • April 20, 2023
  • 3 replies
  • 155 views

Forum|alt.badge.img

Good day

Is there any size limit to  the database size of running a with MySQL database?

If there is no limit what is the advantage of running Acumatica ERP with MySQL over Microsoft SQL Server?

Best answer by apanchamia

There is currently no size limit for My SQL, however in several scenarios we have experienced better performance with MS SQL Server on larger databases (> 200gb) .

While MySQL is also supported db engine, MSSQL remains the preferred as well as recommended db engine.

3 replies

jwright
Jr Varsity III
Forum|alt.badge.img+1
  • Jr Varsity III
  • July 2, 2024

Kudzai, did you find your answer?


apanchamia
Acumatica Employee
  • Acumatica Services Team
  • Answer
  • July 2, 2024

There is currently no size limit for My SQL, however in several scenarios we have experienced better performance with MS SQL Server on larger databases (> 200gb) .

While MySQL is also supported db engine, MSSQL remains the preferred as well as recommended db engine.


jwright
Jr Varsity III
Forum|alt.badge.img+1
  • Jr Varsity III
  • July 2, 2024

Thanks for jumping in @apanchamia with your wisdom on this topic.