As the deals sites grow and more products will be saved into the database, it might be best to consider outsourcing the database load, instead of increasing the Main Server capacity.
When upgrading DO droplet, there is no option to upgrade just the RAM. We might not always need to upgrade both CPU and RAM.
Airtable offers 1,200 records on a free account, and 5,000 records for $12/month. Need to compare this pricing against droplet upgrade, if it's cheaper.
Airtable offers an API where we can do CRUD-based data management.
If we are to use Airtable, we can then outsource products related data into it like Products, Deal Types, Merchants data, etc. Both Main Server and Scripts Server will only have to communicate with the Airtable API. This aleviates RAM consumption in the Main Server which is expensive.
Strapi offers customizing controllers. For example, we can override the default Product controllers so it will only fetch products from Airtable and not from its own database, allowing for less RAM usage.
As the deals sites grow and more products will be saved into the database, it might be best to consider outsourcing the database load, instead of increasing the Main Server capacity.
When upgrading DO droplet, there is no option to upgrade just the RAM. We might not always need to upgrade both CPU and RAM.
Airtable offers 1,200 records on a free account, and 5,000 records for $12/month. Need to compare this pricing against droplet upgrade, if it's cheaper.
Airtable offers an API where we can do CRUD-based data management.
If we are to use Airtable, we can then outsource products related data into it like Products, Deal Types, Merchants data, etc. Both Main Server and Scripts Server will only have to communicate with the Airtable API. This aleviates RAM consumption in the Main Server which is expensive.
Strapi offers customizing controllers. For example, we can override the default Product controllers so it will only fetch products from Airtable and not from its own database, allowing for less RAM usage.
cc @BigKuLaK