For filePro and overall strength which is best, SUSE or RedHat?
Lerebours, Jose
Jose.Lerebours at EagleGL.com
Fri Mar 4 06:15:10 PST 2005
Mark volunteered:
[ snip ]
> > If this gets the green light, I am looking at 600 users
> > throughout Central and South America (just the tip of the
> > ice).
>
> Across how many servers?
>
I figure I start with a single server as this is a trial. If
filePro gets the OK, I might be able to earn all of the countries.
Then, I will look into clustering as needed.
> > I am intending on mirroring my filePro files in MySQL to
> > provide ODBC visibility. I am not sure if I should run
> > MySQL on same server as filePro or on a different server.
>
> Irrelevant, if you have the mysql client on the fP system.
> That's what
> -h hostname is for. :) Take your pick.
>
Like I said, I have never used MySQL but I am sure there are
many tricks one can use to get the mirroring done. Thanks!
> > I am planning on using PHP or Perl (or both) to push data
> > from filePro to MySQL. Of course, if I can import
> > directly from MySQL and have scheduled tasks that will be
> > even better, hence, I have never used MySQL.
>
> Why are you going to use PHP (gack) -or- perl? That's an
> added level of
> obfuscation that's simply not needed. Use raw file I/O
> functions to write
> a MySQL script file that will manipulate your data, and
> simply SYSTEM off
> the mysql client to have the data updated. It'll take a
> little vigilance
> if you're doing UPDATEs as well as INSERTs, since you'll want
> to keep track
> of whether or not you've ever created the record in MySQL in the first
> place--just so you know which command and syntax to use for a
> record. You
> could make a case for perl or PHP if you wanted to query the
> remote end
> first and do it with the lowest overhead, but given proper
> design of the fP
> end, this should be unnecessary. If it's push-only, you
> should be fine
> without any other language programming for a middle layer.
>
Agree. Careful design must be done in the filePro end to
minimize problems with MySQL. There will be new records, edited
records and inserted details ... So, I will need to account for
all of them.
[ snip ]
>
> Whose support? Vendor or third-party? If vendor, well...I have no
> experience with SuSE's support. Never needed it. I've got lousy
> experience with RH's support, on a product whose quality has
> dived since
> they started reaming people for said support. IMHO, RH
> support isn't worth
> the cost of the box, much less what you actually pay for it.
> Also look
> into what kind of support you get at what prices. Then
> figure what you
> might need, what you can get for those prices, and weigh it against
> third-party support on an as-needed basis.
>
> Third party...some people specialize, but almost any decent
> tech should be
> able to hop between the two fairly readily. I do it all the time.
>
> I don't hesitate recommending SuSE 9.x. I have grave
> reservations about
> RHEL, and will until they get with it and start releasing
> something that's
> at -least- as solid as RH 7.[23] were. They started diving at 8.0.
>
Well, it could be a mixture of both. I got your number. Frankly
speaking, I mentioned your name as a potential support provider for
Linux and MySQL :)
Regards;
Jose Lerebours
More information about the Filepro-list
mailing list