Move matomo to the swarm cluster ?

[fredvd]

The matomo service installed is now a manual configured Linode 4Gb, stats.plone.org. @ericof has already set up some matomo servers on a swarm cluster, we should move it to our cluster.

The mariadb process running on the stats.plone.org server has crashed a few times because it gets killed by the OOM, @fredvd has updated the mariadb version to latest stable and tuned down the ram mariadb can use for crashes.

One challenge is that Matomo requires mysql/mariadb. We have a managed HA 3 node managed postgresql cluster. A linode 2Gb managed mysql cluster without HA costs $30. the current 4Gb shared cpu linode costs $24 so moving matomo to the cluster would actually cost $6 but removes the burden of managing a mysql server.

[ericof]

@fredvd what do you mean with "A linode 2Gb managed mysql cluster without HA"? Is it 1 server or more than one? Matomo is not as "core" to our structure as the Plone sites, so we could use a cheaper MySQL offering (if there is one)

[fredvd]

@fredvd what do you mean with "A linode 2Gb managed mysql cluster without HA"? Is it 1 server or more than one? Matomo is not as "core" to our structure as the Plone sites, so we could use a cheaper MySQL offering (if there is one)

That is one server/node database sevice. So it's a managed mysql database, but no redudancy/failover/cluster setup, the cheapest offering we can/should choose, you could technically pick a 1Gb linode (nanode) as the underlying VM size for the db, but thats too small.

A 3 node managed mysql database with HA costs $70 a month. Linodes 'managed' pricing is nonlineair and strange: you pick a 'compute' VM from the default list and then Linode adds a markup for installing and managing the mysqldb. But a 2Gb Linode is $12, and the managed single node costs $30.

[fredvd]

This is with the 3 nodes selected: (but imho not necesssary)