Can this be done? - Firebird master -> MySQL slave

Hi

This is more a theoretical question than a practical one.

If i had a firebird db setup to run business apps and a company wanted to create an outward facing site for online customers using up to date live information. Can firebird be setup with a mysql db running as a slave to process select queries from a website?

And what is the simple overview of how this is done?

Hello Hello Hello Hello Hello

hmm hey its pretty spacious in here.

anywho to expand a little.

Im thinking on insert, update, delete request PHP sends a message to FB to produce a csv for particular rows? and then uses that ONLOAD function to load the file to the mysql db?

Am i close?

You can do everything (more or less) if you really want to, but this is not always a good idea ...
Why can't you use the same db? Or another Firebird (there are free FBReplicator and commercial replication tools available and you can use external tables)? Or even (arghhh) two MySQLs?

I do see you point, im not an expert in FB but throughout my db unit of my course, it will drilled into me all the date / codd principles ACID etc etc and although i do like mysql, it doesnt make me feel as secure when im using it. Innodb is better tho than myisam tho.

My theoretical Q can from the thought of using FB as a main company db and exporting any queries on FB to a companies web server, which is tailored for fast select queries.

I have seem many replication tools for intra db communication, but none for realtime inter db communication.

two examples:
Oracle DBLinks and MSSQL's Linked servers.

ah thanks. and these can dynamically sync two different databases from different manufacturers?

And is there anything like this for FB, Mysql systems?

those are tools that can be used to sync different non ethrogeneous databases.
I'm not aware of something similar for MySQL or Firebird.