Everything seems quite clear to me.
But, having single VIP makes a multimaster replica quite useless.
im thinking about using pacemaker to create a cloned VIP binded to a cloned
HA proxy which is health-checking the galera/mysql status to route the
traffic.
or more easily pacemaker with a singl
On 07/09/2023 16:09, Andrei Borzenkov wrote:
On Thu, Sep 7, 2023 at 5:01 PM lejeczek via Users wrote:
Hi guys.
I'm trying to set ocf_heartbeat_pgsqlms agent but I get:
...
Failed Resource Actions:
* PGSQL-PAF-5433 stop on ubusrv3 returned 'invalid parameter' because 'Parameter
"recovery_
On Thu, Sep 7, 2023 at 5:01 PM lejeczek via Users wrote:
>
> Hi guys.
>
> I'm trying to set ocf_heartbeat_pgsqlms agent but I get:
> ...
> Failed Resource Actions:
> * PGSQL-PAF-5433 stop on ubusrv3 returned 'invalid parameter' because
> 'Parameter "recovery_target_timeline" MUST be set to 'lat
Hi guys.
I'm trying to set ocf_heartbeat_pgsqlms agent but I get:
...
Failed Resource Actions:
* PGSQL-PAF-5433 stop on ubusrv3 returned 'invalid
parameter' because 'Parameter "recovery_target_timeline"
MUST be set to 'latest'. It is currently set to ''' at Thu
Sep 7 13:58:06 2023 after 54m
On Wednesday 06 September 2023 at 17:01:24, Damiano Giuliani wrote:
> Everything is clear now.
> So the point is to use pacemaker and create the floating vip and bind it to
> sqlproxy to health check and route the traffic to the available and healthy
> galera nodes.
Good summary.
> It could be u