Skip site navigation (1) Skip section navigation (2)

Re: Data split -- Creating a copy of database without outage

From: Haifeng Liu <liuhaifeng(at)live(dot)com>
To: "Igor Shmain" <igor(dot)shmain(at)gmail(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Data split -- Creating a copy of database without outage
Date: 2012-05-30 01:13:22
Message-ID: BLU0-SMTP239E0F0C71120AD3E440D9CB90A0@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-admin
Why not use a partitioned table? You can write a trigger to control which partition the coming data should be inserted.

Regards,
----
Liu Haifeng
Home: http://liuhaifeng.com




On May 30, 2012, at 4:13 AM, Igor Shmain wrote:

> Can you please help with advice?
> 
> I need to design a solution for a database which will grow and will require a horizontal split at some moment.
> 
> Here is how I am planning to do it: Every record in every table has a shard number. After the database becomes too large (gets too many requests), the tables need to be horizontally split. It means that for every table all records with some specific shard numbers need to be moved to a new database.
> 
> My plan is to (1) create a copy of the database on a new server (backup/restore?), (2) synchronize the databases (how?), and then (3) forward all requests for the moved shards to the new database. (I will get rid of the unneeded shards later). An important requirement: there should be no outage for the users.
> 
> What are the ways to achieve it?
> 
>  
> 
> Thank you in advance,
> -igorS
> 
>  
> 

In response to

Responses

pgsql-admin by date

Next:From: Igor ShmainDate: 2012-05-30 15:14:02
Subject: Re: Data split -- Creating a copy of database without outage
Previous:From: Igor ShmainDate: 2012-05-29 20:13:32
Subject: Data split -- Creating a copy of database without outage

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group