replication between mysql 3.23 and postgresql 7.2.4?

[k b]

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?

many thanks
kb

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[许冠严]

I think it is impossible, unless you use an extra software.because the logfile format of mysql is different from postgresql's.
----- Original Message -----
From: "k b" <***@yahoo.se>
To: <pgsql-***@postgresql.org>
Sent: Wednesday, September 08, 2004 8:25 PM
Subject: [ADMIN] replication between mysql 3.23 and postgresql 7.2.4?

Post by k b
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?
many thanks
kb
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
---------------------------(end of broadcast)---------------------------TIP 4: Don't 'kill -9' the postmaster

[Christopher Browne]

Post by k b
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
<http://sql-info.de/mysql/vs/mysql-oracle.html>

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.