 |
|
| Linux Forum Index » General Linux Discussion » Opinions sort... |
|
Page 1 of 1 |
|
| Author |
Message |
| Farticus... |
 Posted: Tue Oct 06, 2009 12:03 am |
|
|
|
Guest
|
I operate a small business and have 4 PC's running on a network
3 PCs are on Windows, the fourth one is running Fedora 5 with MySQL 5.0.18
The Windows machines are necessary as they each have various Windows only
applications running on them.
My query here relates to the unit with Fedora 5 and MySQL.
I want to use the Fedora 5 machine to store the files used for the other 3
machines, as well as use the MySQL server/database.
I don't want to keep upgrading Fedora versions - version 5 is running just
fine at the moment and I don't see that I will need to ever install other
applications on the machine.
QUESTION: Does anyone foresee a problem with runing Fedora 5 as described
above, probably for the next 'n' years?
Then what about MySQL ? - I have set up an application using MySQL over the
network, on each of the three Windows machines and all appears to be running
smoothly, and has been for the last 3 months or so. I have heard that MySQL
can be a bit 'touchey' an might possibly let me down when the data in the
database gets very large (I don't quite known what large is?). In the past I
have run Interbase IB6 successfully - I would rather not use it again for
various reasons.
QUESTION: MySQL, is it reliable?
All comments and suggestions appreciated. |
|
|
| Back to top |
|
|
|
| J.O. Aho... |
| Posted: Tue Oct 06, 2009 9:51 am |
|
|
|
Guest
|
Farticus wrote:
Quote: My query here relates to the unit with Fedora 5 and MySQL.
I want to use the Fedora 5 machine to store the files used for the other 3
machines, as well as use the MySQL server/database.
Run samba on the FC5 machine, then the others can access the shares.
Quote: I don't want to keep upgrading Fedora versions - version 5 is running just
fine at the moment and I don't see that I will need to ever install other
applications on the machine.
QUESTION: Does anyone foresee a problem with runing Fedora 5 as described
above, probably for the next 'n' years?
As long as it's not connected to the world wide internet, it should be okey. I
do recommend you download all the RPMs for FC5 (including all the updates), do
an "yum update". This way you have the latest ever install of FC5 and you will
have the RPMs in case you decide to install something later on.
Quote: Then what about MySQL ? - I have set up an application using MySQL over the
network, on each of the three Windows machines and all appears to be running
smoothly, and has been for the last 3 months or so. I have heard that MySQL
can be a bit 'touchey' an might possibly let me down when the data in the
database gets very large (I don't quite known what large is?). In the past I
have run Interbase IB6 successfully - I would rather not use it again for
various reasons.
QUESTION: MySQL, is it reliable?
Seems like Google hasn't complained, so I think it's good enough for large
databases too.
Problems with mysql is usually the crappy odbc that you must use in microsoft
(it has limited threads you can have open and has all too long keep alive on
those too and odbc is generally 50% of the performance compared to native
connections), badly designed databases (some may work fine with a small number
of rows, but when they grow they slow down to a crawl, as columns which are
used in joins and/or searches aren't indexed or write heavy tables are over
indexed).
I would recommend that you would take the time to switch to a long term
supported Linux distribution instead of using a experimental Linux
distribution, CentOS is a free alternative if you like the RedHat (Fedora
ain't anything else than an experimental RedHat), Ubuntu LTS (current one will
be supported to 2013) if you like debian like Linux. The benefit to use a long
time suppoerted distribution is that you can do upgrades and get fixes, which
you can't get for FC5 (not sure you anymore can find any active repositories,
as it's not been supported for the last 3 years).
--
//Aho |
|
|
| Back to top |
|
|
|
| Moe Trin... |
| Posted: Tue Oct 06, 2009 9:13 pm |
|
|
|
Guest
|
On Tue, 06 Oct 2009, in the Usenet newsgroup alt.linux, in article
<r4Bym.45650$ze1.38859 at (no spam) news-server.bigpond.net.au>, Farticus wrote:
Quote: I operate a small business and have 4 PC's running on a network
3 PCs are on Windows, the fourth one is running Fedora 5 with MySQL
5.0.18
I don't want to keep upgrading Fedora versions - version 5 is running
just fine at the moment and I don't see that I will need to ever
install other applications on the machine.
As long as none of the systems is exposed to a possibly hostile
environment (meaning no outside access at all) - why not?
Quote: QUESTION: Does anyone foresee a problem with runing Fedora 5 as
described above, probably for the next 'n' years?
Fedora was never "designed" for this type of service. It is meant
to be a "state-of-the-art" (bleeding edge) rather than long term
stable (Red Hat Enterprise Linux - or one of the many GPL clones
there-of). Fedora 5 went end of life in June 2007 (the supported
life is something like two release cycles). That MySQL 5.0.18
version is likewise obsolete, having been errata'ed with FC5 to
version 5.0.27-1.fc5 in November 2006. The more current release
in Fedora is at 5.1.36 last I looked.
Quote: QUESTION: MySQL, is it reliable?
How are your backups? Do you KNOW that they work? That's not a
slam of MySQL, but a fact of computers in general. Have to tried
a bare-bones restore?
Old guy |
|
|
| Back to top |
|
|
|
|
|
All times are GMT - 5 Hours
The time now is Mon Nov 30, 2009 12:42 am
|
|