2 Replies Latest reply on Nov 4, 2010 6:59 AM by rjlevesque

    Database setup questions



      Database setup questions


      I would like to have the forums help in order to achieve a good set up my database.

      As you will gather from my explanations and questions, I’m certainly not an IT specialist, so your help is greatly appreciated.

      Our setting is a research project within the University. As all of you know that means we’re short on funding, so prohibitively expensive solutions are out of the question (although I understand the importance of a good database, so I certainly have some funds allocated to that).

      Our study started several years ago, using access on PC. Because of the instability of access, the data was stored on MySQL, with access as a front end.

      In the last years we have switched to Mac, and we planned to replicate our initial setup, again storing the date on MySQL, but with FileMaker Pro as a front now.,

      Basically our current setup is a small work group of 3-5 Macs, connected by an airport, but could be connected by cables if that would be desirable. MySQL is running on one Mac, with FileMaker Pro on all Macs fetching the data on that single MySQL server.

       Since I would prefer not to connect to the database via the Internet, we currently cannot work on the database when we’re in a physically different location.  If possible this would be an option would like to implement.

       So these are the questions: 

      1)   It is indeed a good set up?

      2)    In MySQL there is the option to replicate as a slave database. If I understand correctly this would allow me to work off-line. Would this be a good option or is this fraught with dangers? Is there a possibility to do this replication in FileMaker?

      3)    Do I actually still needs MySQL as a back end? Or would it be faster to migrate the data to FileMaker?  Is there some possibility to work with the data in FileMaker (so that all Macs fetch their data within FileMaker), but have some kind of mirror in MySQL as a backup only?

        • 1. Re: Database setup questions

          If using mySQL then what you have setup should work fine for your needs, given what information you offered here. However, if you want to stop using a mySQL back-end you would most likely need FMP Server to tie all the client database solutions together, whereas now you have mySQL pulling it all together.

          As for mySQL replication slaves, honestly the only thing that could really be helpful to you for I would think is the advantage of having a running backup of the database as a security.

          • 2. Re: Database setup questions

            Also, in reference to your question about a backup...filemaker has a backup option you can choose or ...

            If this is a system that is up and running all the time then if it were me I would write a little batch script (apple script if Mac) to backup the solution file regularly. You can even schedule this to happen automatically with Windows Task Scheduler or Mac/FreeBSD Cron. The scheduler would simply run the script which backs up the solution file for you each day, week, or month.