๐Ÿ“˜ Technical Requirements

Oempro is designed to work even on low-resource server environments, but we strongly recommend a dedicated server for Oempro. Below, you can find two server specifications for different purposes. These server specs are tested environments and can easily handle the given data volume.

Scenario #1

For storing up to 1 million subscribers and sending up to 15 million emails per month)

Server Specs:

  • 8x CPU
  • 32GB RAM
  • 500GB SSD disk space
  • This setup can host the MySQL on the same server with Oempro
  • Ubuntu 18.04LTS or similar operating system

Scenario #2

For storing more than 1 million subscribers and sending more than 15 million emails per month)

Server Specs:

  • 40x CPU
  • 64GB RAM
  • 500GB SSD disk space
  • This setup can host the MySQL on the same server with Oempro
  • Ubuntu 18.04LTS or similar operating system

Installation Instructions

These are not mandatory server requirements. You can host Oempro on less powerful server as well but the performance and capacity of handling data volume will decrease.

These two server specs are tested ones and already being used in production level with given data and delivery volumes.

MySQL version 5.7 or 8 is supported but we have fully tested Oempro on MySQL v5.7.

For any questions regarding server specs and installation, please donโ€™t hesitate to contact us via hello@octeth.com or by replying below.

  • The article was helpful
  • The article was not helpful

0 voters

1 Like

knowing the version of MySQL supported is important. Please consider adding to the technical requirements posting.

1 Like

Thanks for the feedback @rays, youโ€™re right. I just updated the post. Cheers.

MariaDB 10.5 seems to be unsupported as stats_link and stats_open tables have 2 new generated fields (ClickDateYYYYMMDD, ClickDatew and OpenDateYYYYMMDD, OpenDatew respectively) where date_format() function is unsupported as of this writing.

SQL Error (1901): Function or expression โ€˜date_format()โ€™ cannot be used in the GENERATED ALWAYS AS clause of ClickDateYYYYMMDD

Hi @andor.toth, we havenโ€™t tested Oempro with MariaDB yet. Yes, some Oempro MySQL tables have generated fields and this may cause problems if MariaDB doesnโ€™t support it. We will include the built-in MySQL server container with Oempro soon. Until then, we recommend MySQL 5.7.

keyword โ€œSTOREDโ€ is not supported in the generation clause in MariaDB. just use โ€œPERSISTENTโ€. you can easily adjust when you change the keyword in this file โ€œinstall/sources/mysql.sqlโ€ before installation.

Well said, thanks @finexus.