1,2,3: You can't shard with BDR. It's only for multimaster (at least for now). Please read the docs.
On Fri, Jul 17, 2015 at 9:02 AM, Amit Bondwal <bondwal.a...@gmail.com> wrote: > Hello everyone, > > We ae working on a application in which we are using posgresql as a > database. We are sure that in future it will extend to level that we have > to scale it horizontally. We have some tables which are going to be more > than 90% of database size. > > I looked at pg_shard, as per my understanding it is for nosql data, in our > case we are going to use postgresql RDBMS features without nosql, pg_shard > have lot on limitation as per our case. > > I looked at postgresql-xl, it looks good as per our requirements, but we > have to do a lot of things to make it high availaiblity and it don't have > debian packages available for debian. > > Now I see BDR, it looks good, it have multimasters, we can start with one > master and later we can add more master servers to avoid failover. > Bellow are my queries:- > > 1. If start with postgresql 9.4 database, later can I upgrade it to DBR > with these already large table, can I distribute these tables or shard > them. Do I need to do some extra changes in database or it will be > complicate later. > > 2. how can I distribute some of tables on my slave nodes, if it have any > limitations please let me know. > > 3. if I started with 4 or 5 node cluster with one master and rest of slave > nodes, how can I take backup of this distributed database to one of my > other server or backup location. > > Please suggest me what would be the best approch for this. > > -- > Thanks & Regards, > > Amit Bondwal >
