[FX.php List] Two DB's or One?

Sat Sep 23 13:42:51 MDT 2006

Bob, do you mean it's best to run FMU on a different box than your  
actual web server? Cuz FMU works equally well with OS X or OS X  
Server. The biggest upside to using OS X Server are the nice GUI  
tools for managing Apache. The biggest downside to using OS X Server  
is battling my clients' compulsion to turn on other OS X Server  
services like AFP and FTP, since they perceive them as being "wasted"  
if just FMU is running. If you want to dedicate a Mac to FMU - or  
FMSA for that matter, its purpose is far more likely to remain  
dedicated to FileMaker if it's just running OS X, and not OS X Server.

Dale

On Sep 23, 2006, at 9:54 AM, Bob Patin wrote:

> Well, that would work, although it would be best not to run FMU and  
> OS X Server on the same machine.
>
> Bob Patin
> Longterm Solutions
> bob at longtermsolutions.com
> 615-333-6858
> http://www.longtermsolutions.com
>
>   CONTACT US VIA INSTANT MESSAGING:
>      AIM or iChat: longterm1954
>      Yahoo: longterm_solutions
>      MSN: tech at longtermsolutions.com
>      ICQ: 159333060
>
>
>
>
>> Thanks for your input.
>>
>> Now back to the details of this one particular client..
>>
>> If the solution stays in FMP 6 and stays in the client's office:
>> 	- local FMP users would be served by Server 5.5 on server 1.
>> 	- web users would be served by 6.0 Unlimited on a server 2.
>> 	- OS X Server also on server 2 for web serving
>> 	- Reliable WAN would need to be added.
>> 	- Remote access (Timbuktu/ARD) would substitute onsite IT staff
>>
>> Do I have it right?  My head is into FMP 8.5 right now, and it's  
>> hard to go back that far without my head hurting. ;-)
>>
>> Thanks,
>>
>>
>> Jonathan
>>
>>
>> At 10:27 PM -0500 9/22/06, Bob Patin wrote:
>>> ... a single database... :)
>>>
>>> I have quite a few clients who have shopping carts, and they use  
>>> the same cart database for tracking customers, mailing lists,  
>>> etc. I also have other clients who use their membership databases  
>>> in their office, and also on their websites...
>>>
>>> Bob Patin
>>> Longterm Solutions
>>> bob at longtermsolutions.com
>>> 615-333-6858
>>> http://www.longtermsolutions.com
>>>
>>>   CONTACT US VIA INSTANT MESSAGING:
>>>      AIM or iChat: longterm1954
>>>      Yahoo: longterm_solutions
>>>      MSN: tech at longtermsolutions.com
>>>      ICQ: 159333060
>>>
>>>
>>> On Sep 22, 2006, at 9:43 PM, Jonathan Schwartz wrote:
>>>
>>>> Err....do which?  Use a single DB or two separate DB's?
>>>>
>>>> J
>>>>
>>>>
>>>> At 8:58 PM -0500 9/22/06, Bob Patin wrote:
>>>>> Jonathan,
>>>>>
>>>>> I do it all the time with almost every client who has a web  
>>>>> database...
>>>>>
>>>>> Bob Patin
>>>>> Longterm Solutions
>>>>> bob at longtermsolutions.com
>>>>> 615-333-6858
>>>>> http://www.longtermsolutions.com
>>>>>
>>>>>   CONTACT US VIA INSTANT MESSAGING:
>>>>>      AIM or iChat: longterm1954
>>>>>      Yahoo: longterm_solutions
>>>>>      MSN: tech at longtermsolutions.com
>>>>>      ICQ: 159333060
>>>>>
>>>>>
>>>>> On Sep 22, 2006, at 8:55 PM, Jonathan Schwartz wrote:
>>>>>
>>>>>> Up until now, all my fx.php solutions have been built around  
>>>>>> an isolated FMP database to serve the web.  When there is a  
>>>>>> primary db back at the client, I use various routines to  
>>>>>> update and synch the two, as needed. Obviously, none of the  
>>>>>> solutions required live up-to-the-second data availability on  
>>>>>> the web.
>>>>>>
>>>>>> I'm wondering how many folks are using the same db for both  
>>>>>> internal and web publishing?  If so, how is it working out?   
>>>>>> If not, why not?
>>>>>>
>>>>>> A little bit more detail...if the client isn't sophisticated,  
>>>>>> doesn't have an IT staff or a fast WAN connection, this would  
>>>>>> suggest to me *not* to keep the web db at the client office.   
>>>>>> Rather, keep the web db at a reliable web host.
>>>>>>
>>>>>> One more detail.  I promise. ;-)....If the solution is in FMP  
>>>>>> 6, that would pretty much rule putting the entire solution in  
>>>>>> a remote hosting location, because FMP is so poor in a WAn  
>>>>>> environment.
>>>>>>
>>>>>> Thoughts?
>>>>>>
>>>>>> Jonathan
>>>>>> --
>>>>>>
>>>>>> Jonathan Schwartz
>>>>>> FileMaker 8 Certified  Developer
>>>>>> Associate Member, FileMaker Solutions Alliance
>>>>>> Schwartz & Company
>>>>>> jonathan at eschwartz.com
>>>>>> http://www.eschwartz.com
>>>>>> http://www.exit445.com
>>>>>> 415-381-1852
>>>>>>
>>>>>> _______________________________________________
>>>>>> FX.php_List mailing list
>>>>>> FX.php_List at mail.iviking.org
>>>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>>
>>>>> _______________________________________________
>>>>> FX.php_List mailing list
>>>>> FX.php_List at mail.iviking.org
>>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>
>>>>
>>>> --
>>>>
>>>> Jonathan Schwartz
>>>> FileMaker 8 Certified  Developer
>>>> Associate Member, FileMaker Solutions Alliance
>>>> Schwartz & Company
>>>> jonathan at eschwartz.com
>>>> http://www.eschwartz.com
>>>> http://www.exit445.com
>>>> 415-381-1852
>>>>
>>>> _______________________________________________
>>>> FX.php_List mailing list
>>>> FX.php_List at mail.iviking.org
>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org
>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
>>
>> -- 
>>
>> Jonathan Schwartz
>> FileMaker 8 Certified  Developer
>> Associate Member, FileMaker Solutions Alliance
>> Schwartz & Company
>> jonathan at eschwartz.com
>> http://www.eschwartz.com
>> http://www.exit445.com
>> 415-381-1852
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list