📘 Technical Requirements

Knowledge Base Installation & Upgrade
#1

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
#3

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

1 Like
#4

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

#5
:round_pushpin: Start Here
#6
#7

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

#8

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.

#9

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.

#10

Well said, thanks @finexus.