[huskerlug] Re: CERT Advisory

It is a low load MySQL and it's pretty dash and hack on going, just =
tossed a
prebuilt binary on Solaris 8 on a SPARC 5 110Mhz.  So far (crosses =
fingers)
it's held up...the SQL stuff was run locally with the apache and PHP on =
a
Dual PPro 200. Split it out more for proof of concept and the files
themselves are not stored on the box itself ratter remote mounted into =
the
FS from a different system. (only has a 1G drive and that was just =
enough to
get the OS on :-)

What series was your sun box? I've found the older SPARC 5s and such to =
be
rock solid machines great for web serving, however the Ultra1s with =
<200Mhz
have know heavy load problems especially running in 64bit mode and the =
Ultra
5 and even 10s (especially the ones with IDE) they just don't seem near =
as
reliable as the older boxes I got.

BSD is the next step in adding to it...just need to find some decent
hardware to try installing it...tried FreeBSD on SPARC fought thru the
install but it still would not go, then tried on a spare K6-2 500 with
assorted drives not sure on hardware or my own ignorance but in any case =
it
would boot but never mount all the drives...

Someone mentioned admining...most of the systems are *nix so that does =
make
it easy...the Novell server was already setup I use it more like a NAS =
then
anything else. Right now someone else admins it but if they leave and/or =
the
system dies I'll just replace it with something else.

-----Original Message-----
From: huskerlug-bounce@xxxxxxxxxxxxx =
[mailto:huskerlug-bounce@xxxxxxxxxxxxx]
On Behalf Of David William Eder
Sent: Saturday, August 16, 2003 7:33 AM
To: huskerlug@xxxxxxxxxxxxx
Subject: [huskerlug] Re: CERT Advisory



Oops, change of topic....

I find it interesting that you use Solaris for MySQL.  I have found =
MySQL to
be unreliable on Solaris with a high load [we believe in fully using our
servers; if the load is below 1.0, then we could have bought a smaller =
box
(just kiding)].  After a year and a half trying to make it stable, we
finally move to Redhat 9 on a new (that is new to us, another ebay
purchase) server.  The symptoms we were experiencing included data
corruption (MySQL cannot repair the data files), permanently locked =
tables
(read only access to certain tables even after reboot), and bad indexes
(cannot find records until indexes are rebuild or deleted).

By the time we left Solaris, we were doing check, repair, omtimize, and
analyze on every night and sending mail if it could not be fixed or the
errors were more than fifteen.  Further, we were making hourly backups =
of
the entire database to a set of diskfiles.  I also spent countless hours
looking for slight optimizations to try to reduce the number and size of
queries on the server. (This probably led to a better product.)

We got tired of not trusting our server.

On the fair side, the Solaris box (and it's failover) were both =
purchased on
e-bay by my employer.  It is possible that they both had some sort of
hardware problem.  We could never find any.  It could also be a virtual
memory problem.  Sometimes the load would go up because we were running
programs in swap.  If you are running Linux and you swap out certain
portions of Xfree86, switching to another virtual terminal and rebooting =
the
machine appears to be the only way to get X working again, even after =
you
free up memory and the load returns to normal.  MySQL on Solaris might =
have
similar issues.

I have had better experience with Irix.  I had a MySQL/PHP driven =
website
with 1.2 million page views per week.  The load was much,much higher, =
but it
weathered the storm (bandwidth use was another story).  It survived huge
inserts, massive indexes, and hundreds of millions of queries each week.
The load on the Solaris box is small in comparison.

On a side note, by charting the load on a heavily hit website, you can =
tell
when lunch time and quitting time hit in each timezone. ;)

David.


----
Husker Linux Users Group mailing list
To unsubscribe, send a message to huskerlug-request@xxxxxxxxxxxxx
with a subject of UNSUBSCRIBE

Other related posts: