Load Peaks on Standby/Replication Server using Luks/dmcrypt

From: Dennis Schwan <dennis(dot)schwan(at)1und1(dot)de>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Load Peaks on Standby/Replication Server using Luks/dmcrypt
Date: 2020-01-28 10:02:10
Message-ID: 5566a35a-fbc9-39f4-d033-ed1a13bc82da@1und1.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

we are using luks/dmycrypt to encrypt our pgdata volumes.
On some standby/replication machines we see load peaks up to 15x of the
primary server.
If we remove the dmcrypt/luks and run it on a non-encrypted device this
does not happen.

We have tried to analyze this but could not find where the load comes from.
Using atop, pg_top we do not see any waits, not on cpu and not on I/O,
just the higher load.

We see this on KVM hosts and also on Hardware (HDD, SSD, RAID/Non-RAID)
and also tried to set different powerprofiles in the BIOS.

Do you have any idea here? I am happy to get any information you need to
analyze this problem.

Thanks,
Dennis

--
Dennis Schwan

DBA
Database Services

1&1 De-Mail GmbH | Brauerstraße 50 | 76135 Karlsruhe | Germany
Phone: +49 721 91374-8738
E-Mail: dennis(dot)schwan(at)1und1(dot)de | Web: www.1und1.de

Hauptsitz Montabaur, Amtsgericht Montabaur, HRB 23266

Geschäftsführer: Alexander Charles, Thomas Ludwig, Jan Oetjen, Sascha Vollmer

Member of United Internet

Diese E-Mail kann vertrauliche und/oder gesetzlich geschützte Informationen enthalten. Wenn Sie nicht der bestimmungsgemäße Adressat sind oder diese E-Mail irrtümlich erhalten haben, unterrichten Sie bitte den Absender und vernichten Sie diese E-Mail. Anderen als dem bestimmungsgemäßen Adressaten ist untersagt, diese E-Mail zu speichern, weiterzuleiten oder ihren Inhalt auf welche Weise auch immer zu verwenden.

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient of this e-mail, you are hereby notified that saving, distribution or use of the content of this e-mail in any way is prohibited. If you have received this e-mail in error, please notify the sender and delete the e-mail.

Browse pgsql-general by date

  From Date Subject
Next Message Игорь Выскорко 2020-01-28 13:50:07 Jsonb first level keys statistic
Previous Message Willy-Bas Loos 2020-01-28 09:04:46 Re: temporary data after diskspace error