Subject: Re: [GENERAL] 9.0 Streaming Replication Problem to two slaves
From: Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <devrim@gunduz.org>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Michael Best <mbest@pendragon.org>, pgsql-general@postgresql.org
In-Reply-To: <CAOR=d=3Xe0EGsW6PC9in2R4iC+_T7AP3SdZX60Vj7t7+tFe+jA@mail.gmail.com>
References: <4E2DAA04.9000909@pendragon.org>
	 <4E38169E.1090802@pendragon.org>
	 <CAOR=d=3Xe0EGsW6PC9in2R4iC+_T7AP3SdZX60Vj7t7+tFe+jA@mail.gmail.com>
Content-Type: multipart/signed; micalg="pgp-sha1"; protocol="application/pgp-signature"; boundary="=-G8xkn4enRFCnzmEzX832"
Date: Tue, 02 Aug 2011 21:05:47 +0300
Message-ID: <1312308347.2538.56.camel@lenovo01-laptop03.gunduz.org>
Mime-Version: 1.0
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org

--=-G8xkn4enRFCnzmEzX832
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, 2011-08-02 at 11:55 -0600, Scott Marlowe wrote:

> > Is this likely that the disks are too slow on the replication=20
> > servers, or is something else happening, such as the restoration of
> logs is considerably slower than on the primary?
>=20
> Could be.  Are the drives on the slaves much slower?  I'd imagine a
> slave with the same drive setup would be able to keep up.=20

We have a customer who generates 150+ xlogs per minute under daily load,
and our first HS installation failed just because of :

* Network was slow (10 Mbit), so could not keep up with WAL files.
* Disks were also slow on slave.

So yeah, that could be it.

Regards,
--=20
Devrim G=C3=9CND=C3=9CZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Dan=C4=B1=C5=9Fman=C4=B1/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

--=-G8xkn4enRFCnzmEzX832
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)

iEYEABECAAYFAk44PHcACgkQtl86P3SPfQ64QwCffbbWWyvi0KM5jHK7X8r/3DGJ
YbsAnjLD7a2JNt7Y76h6GAmYt95ml8RX
=0EtA
-----END PGP SIGNATURE-----

--=-G8xkn4enRFCnzmEzX832--