July 18th, 2004, 02:17 PM
Can this be done? - Firebird master -> MySQL slave
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?
July 21st, 2004, 05:23 AM
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?
July 21st, 2004, 05:54 AM
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?
July 22nd, 2004, 06:15 AM
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.
July 22nd, 2004, 07:25 AM
Oracle DBLinks and MSSQL's Linked servers.
July 22nd, 2004, 11:16 AM
ah thanks. and these can dynamically sync two different databases from different manufacturers?
And is there anything like this for FB, Mysql systems?
July 23rd, 2004, 02:51 AM
those are tools that can be used to sync different non ethrogeneous databases.
I'm not aware of something similar for MySQL or Firebird.