From: | Arthur Silva <arthurprs(at)gmail(dot)com> |
---|---|
To: | "ben(dot)play" <benjamin(dot)cohen(at)playrion(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Which replication is the best for our case ? |
Date: | 2015-06-30 18:24:33 |
Message-ID: | CAO_YK0VBJPSNe09fRNXL6g9bWFCa_BYvKbAH2aJOfAUF7SYybg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Jun 30, 2015 at 1:57 PM, ben.play <benjamin(dot)cohen(at)playrion(dot)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(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2015-06-30 19:15:22 | Re: Which replication is the best for our case ? |
Previous Message | ben.play | 2015-06-30 16:57:03 | Re: Which replication is the best for our case ? |