Re: Which replication is the best for our case ? - Mailing list pgsql-general

From Arthur Silva
Subject Re: Which replication is the best for our case ?
Date
Msg-id CAO_YK0VBJPSNe09fRNXL6g9bWFCa_BYvKbAH2aJOfAUF7SYybg@mail.gmail.com
Whole thread Raw
In response to Re: Which replication is the best for our case ?  ("ben.play" <benjamin.cohen@playrion.com>)
List pgsql-general

On Tue, Jun 30, 2015 at 1:57 PM, ben.play <benjamin.cohen@playrion.com> wrote:
Hi guys,

Thank you a lot for your answers.

In fact, I tried to write the easiest explanation of my problem in order to
be understood...
My project is developed with Symfony and Doctrine (BERK, i know ...).

The project has more than 2 years and Doctrine makes some bad decisions and
lock all the table for a while.
We are developing the project without Doctrine but it will not be available
within 1 year...

To be more precise : We have a database with more than 400 Gb and ONE table
with more than 100 Gb of data. This is huge for doctrine. When the cron
runs, it writes a lot on the disks in temporary file (although we have 128
GB of Ram...). Of course, each table is well indexes...

That is why I'm thinking about replication : My server A (master) is for my
users... and my server B is a server reserved for calculations (and this
server B which writes on the base)

This is a image of my dream system :
<http://postgresql.nabble.com/file/n5855916/9e41ce1f-38ea-4fba-a437-a43c598e655c.jpg>
(If you can't see the image :
http://tof.canardpc.com/view/9e41ce1f-38ea-4fba-a437-a43c598e655c.jpg)


Thank you a lot for your help !



--
View this message in context: http://postgresql.nabble.com/Which-replication-is-the-best-for-our-case-tp5855685p5855916.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Hello,

Streaming replication will do just fine from ServerA to ServerB, but as for the rest of the data flow I'm afraid we will need more details.


pgsql-general by date:

Previous
From: "ben.play"
Date:
Subject: Re: Which replication is the best for our case ?
Next
From: John R Pierce
Date:
Subject: Re: Which replication is the best for our case ?