X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 10D8FD1B220 for ; Tue, 22 Jun 2004 11:28:46 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 75070-08 for ; Tue, 22 Jun 2004 14:28:45 +0000 (GMT) Received: from math.uchicago.edu (math.uchicago.edu [128.135.72.38]) by svr1.postgresql.org (Postfix) with ESMTP id 58929D1B199 for ; Tue, 22 Jun 2004 11:28:40 -0300 (ADT) Received: from billnotebook (wireless-197-223.uchicago.edu [128.135.197.223]) by math.uchicago.edu (8.12.10/8.12.10) with SMTP id i5MESffM016537 for ; Tue, 22 Jun 2004 09:28:45 -0500 Message-ID: <004001c45865$59cc9f20$dfc58780@billnotebook> From: "Bill" To: Subject: postgresql and openmosix migration Date: Tue, 22 Jun 2004 09:29:39 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_003D_01C4583B.70D68C00" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=HTML_20_30, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200406/225 X-Sequence-Number: 7283 This is a multi-part message in MIME format. ------=_NextPart_000_003D_01C4583B.70D68C00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I am trying to make a cluster out of any database, postgresql or mysql = or any other free database. I have looked at openmosix patched with the mi= gshm patch for shared memory support and it seems that neither work fully. = Postgresql in particular uses "shared memory but not the system semaphores= for locking it". Thus apparently it won't benefit from an openmosix clust= er. In addition mysql doesn't seem to migrate because it is multithreaded.= Any ideas of how I can cluster my database (around 800 GB in size so even= partial replication is not really practical)? If interested this is my source for openmosix and migshm information http:/= /howto.ipng.be/MigSHM-openMosix/x90.html Thanks. ------=_NextPart_000_003D_01C4583B.70D68C00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi, I am trying to make a cluster out of a= ny=20 database, postgresql or mysql or any other free database.  I have look= ed at=20 openmosix patched with the migshm patch for shared memory support and it se= ems=20 that neither work fully.  Postgresql in particular uses "shared memory= but=20 not the system semaphores for locking it".  Thus apparently it won't= =20 benefit from an openmosix cluster.  In addition mysql doesn't seem to= =20 migrate because it is multithreaded.  Any ideas of how I can cluster m= y=20 database (around 800 GB in size so even partial replication is not really= =20 practical)?
 
If interested this is my source for openmo= six and=20 migshm information http://howto.ipng.b= e/MigSHM-openMosix/x90.html
 
Thanks.
------=_NextPart_000_003D_01C4583B.70D68C00--