#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2004
    Posts
    21
    Rep Power
    0

    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?
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2004
    Posts
    21
    Rep Power
    0
    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?
  4. #3
  5. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    539
    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?
  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2004
    Posts
    21
    Rep Power
    0
    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.
  8. #5
  9. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    539
  10. #6
  11. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2004
    Posts
    21
    Rep Power
    0
    ah thanks. and these can dynamically sync two different databases from different manufacturers?

    And is there anything like this for FB, Mysql systems?
  12. #7
  13. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    539
    and these can dynamically sync two different databases from different manufacturers?
    those are tools that can be used to sync different non ethrogeneous databases.
    I'm not aware of something similar for MySQL or Firebird.

IMN logo majestic logo threadwatch logo seochat tools logo