On Tue, Jun 30, 2015 at 1:57 PM, ben.play <benjamin.co...@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.