Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.postgresql Subject: Re: Split database content without outage Date: Mon, 4 Jun 2012 23:17:50 +0000 (UTC) Organization: solani.org Lines: 23 Message-ID: References: <767f369f-5ff9-4fbf-aae1-3fc868293139@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: solani.org 1338851870 16052 eJwNyckBwDAIA7CVCsUQjxOu/Udo9RVeF68whxsW23Y9CDLO1Wdb1GqWwxo2M/KvkyWwVYXpBx22EPk= (4 Jun 2012 23:17:50 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Mon, 4 Jun 2012 23:17:50 +0000 (UTC) User-Agent: Pan/0.135 (Tomorrow I'll Wake Up and Scald Myself with Tea; GIT 30dc37b master) X-User-ID: eJwNycERACEIA8CWhATCleOA9l/C+dzZQFq2mJGMG5ftg1WbVXDBRCYlOwP2TAH7ewb8rSx+91EPWg== Cancel-Lock: sha1:QsdopS3o2fVREJ8vbNpjm1eUko0= X-NNTP-Posting-Host: eJwFwQERADEIAzBLz0rLXg5w4F/CEkKmDhflXC5oJta0IZ0O3fkOEUkN+twsTYh/nlqV9QMCiBCY Xref: csiph.com comp.databases.postgresql:361 On Tue, 29 May 2012 12:32:06 -0700, 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? Use Oracle. -- http://mgogala.byethost5.com