X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 06CAF329D91 for ; Wed, 8 Sep 2004 17:06:02 +0100 (BST) 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 35182-02 for ; Wed, 8 Sep 2004 16:05:36 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 0BE80329CB0 for ; Wed, 8 Sep 2004 17:05:36 +0100 (BST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i88G5YCp035941 for ; Wed, 8 Sep 2004 16:05:35 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i88Fo3xx030299 for pgsql-admin@postgresql.org; Wed, 8 Sep 2004 15:50:03 GMT From: Christopher Browne X-Newsgroups: comp.databases.postgresql.admin Subject: Re: replication between mysql 3.23 and postgresql 7.2.4? Date: Wed, 08 Sep 2004 10:56:41 -0400 Organization: cbbrowne Computing Inc Lines: 53 Message-ID: References: <20040908122513.80296.qmail@web51905.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1006 (Gnus v5.10.6) XEmacs/21.4 (Security Through Obscurity, linux) Cancel-Lock: sha1:/szK7xfoxr2Ypt7dEniAsjmGUDs= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/74 X-Sequence-Number: 14777 A long time ago, in a galaxy far, far away, k_b0000@yahoo.se (k b) wrote: > Hello. > > I have a slightly off topic question. > Is it possible to set up replication between a mysql > 3.23.56 server and a postgresql 7.2.4 server without > any extra software in between? > > i am primarily interested in replication from the > mysql server to the postgresql server, but two way > replication might be needed later on. > > is it possible? > where can i find more information? You might look at how MySQL's "native" replication schemes are implemented, and see if there is some way to adapt them to generate SQL statements that could be injected into a PostgreSQL instance. But what this amounts to is "rolling your own solution." It also strikes me as a good instance of a "fool's errand," as the semantics of the systems are so strikingly different that you'll find that if you _do_ implement some form of replication, it won't work nearly as well as you would hope or need. The comments comparing MySQL with Oracle seem pretty appropriate Notably: "If you find your application works as equally well on Oracle as it does on MySQL, then you are vastly underutilising Oracle and probably paying for it as well." In the case of PostgreSQL, you may not be paying anything for it, but you certainly won't be getting any benefit out of it if you use it exactly the same as you use MySQL. And why PostgreSQL 7.2.4? That's a fairly ancient version, now. If you're prepared to do something as experimental as building a two-way replication system between MySQL and PostgreSQL, jumping straight to 8.0 won't introduce any risks that would be noticeable in comparison to the ones you already face. The 'conservative' approach would be to use 7.4.3, anyways. You might as well not bother; that will involve a whole lot less effort, and leave you less disgruntled at the end of the process. -- "cbbrowne","@","cbbrowne.com" http://cbbrowne.com/info/sgml.html I just got skylights put in my place. The people who live above me are furious.