Do you use MySQL?

[DAve]

Greg 'groggy' Lehey wrote:
> 
> - Which version of FreeBSD are you running?

4.11 and 5.4 We will not be upgrading to 6 anytime soon if at all.

> 
> - Which version of MySQL are you running?
> 

4.0.2

> - If you're not running MySQL 5.0, why not?
> 

Why should we use 5.0? We use MySQL in a production environment. We 
cannot spend time troubleshooting issues. When a new version has a 
capability we cannot live without we test, test, test, test it first, 
then spend much time reading forums to see what problems others have 
been having. We have run crippled software before because WE found the 
bug and had to wait for a fix. No fun delaying a production application.

When the opportunity presents itself we install and test new software or 
new versions to help the developers move forward (we tested and ran Ruby 
On Rails for three months, now working with it to see if it has a place 
in our development environment). But we cannot do that all the time.

Also we have many older pieces of hardware that cannot run a newer 
version because the older hardware cannot support the newer OS, which in 
turn is required to run the newest MySQL. The new MySQL, if not 
compatible with the old MySQL, does me no good.

Example, we have many old Sparc boxes, still going strong, running 
Solaris 2.5 and MySQL 3.23. If I use MySQL 5.0 I can no longer use 
replication. So an upgrade to MySQL 5.0 means new hardware. It's a hard 
sell upstairs unless the new combination offers substantial improvement. 
(Yes the Sparcs are old, but they run, and they run, and they run. 
Sometimes we forget to check on them they are so reliable, I wish my new 
hardware was as good).

We are looking at a package to upgrade the older Sparcs to 4.0.2, but 
"If it ain't broke....."

> - Where do you get your MySQL software from?
> 
>   * From the MySQL web site?
>   * From a FreeBSD CD/DVD distribution?
>   * Package (precompiled) from the FreeBSD web site (either directly
>     or via a mirror)?
>   * From the ports collection?

Used to be all compiled source, now we use the ports collection.

> 
> - Which threading library are you using?  Why?

Default, because that is what the ports maintainer supports.

> 
> - Have you had to change the default installation (different compile
>   flags, different installation directories, etc.)?

No, maybe optimized if needed.

> 
> - Do you have any problems that you think are related to the choice of
>   the version you're using?
> 

None, MySQL is a rock.

DAve

-- 
This message was checked by forty monkeys and
found to not contain any SPAM whatsoever.

Your monkeys may vary