WARNING - OLD ARCHIVES

This is an archived copy of the Xen.org mailing list, which we have preserved to ensure that existing links to archives are not broken. The live archive, which contains the latest emails, can be found at http://lists.xen.org/
   
 
 
Xen 
 
Home Products Support Community News
 
   
 

xen-users

Re: [Xen-users] mysql & xen - is anyone using this combinationsuccessful

To: Ian Pratt <m+Ian.Pratt@xxxxxxxxxxxx>
Subject: Re: [Xen-users] mysql & xen - is anyone using this combinationsuccessfully?
From: Paul Laws <paul.laws@xxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 25 May 2005 10:43:37 +0100
Cc: xen-users@xxxxxxxxxxxxxxxxxxx
Delivery-date: Wed, 25 May 2005 09:43:06 +0000
Envelope-to: www-data@xxxxxxxxxxxxxxxxxxx
In-reply-to: <A95E2296287EAD4EB592B5DEEFCE0E9D1E41D7@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
List-help: <mailto:xen-users-request@lists.xensource.com?subject=help>
List-id: Xen user discussion <xen-users.lists.xensource.com>
List-post: <mailto:xen-users@lists.xensource.com>
List-subscribe: <http://lists.xensource.com/cgi-bin/mailman/listinfo/xen-users>, <mailto:xen-users-request@lists.xensource.com?subject=subscribe>
List-unsubscribe: <http://lists.xensource.com/cgi-bin/mailman/listinfo/xen-users>, <mailto:xen-users-request@lists.xensource.com?subject=unsubscribe>
References: <A95E2296287EAD4EB592B5DEEFCE0E9D1E41D7@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
Sender: xen-users-bounces@xxxxxxxxxxxxxxxxxxx
User-agent: Mozilla Thunderbird 1.0.2 (X11/20050418)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Ian Pratt wrote, On 24/05/05 13:54:
>  
> 
>>I'm beginning to wonder whether it's safe to use mysql on xen 
>>in a live environment.
> 
> 
> We've tended to do our testing with PostgreSQL, but we obviously want
> mysql to work perfectly too.
> 
> Are you just running with the glibc tls disabled? If so, its possible
> that its an incompatibility with the old thread library that it falls
> back to.

I'm using gentoo, and have specifically excluded the "nptl" USE flag to
prevent the new thread handling. I have no tls directory under /lib, so I
guess this is working (?)

> 
> The best soloution is to install a 'xen friendly' glibc for your
> installation. What distro are you running?
> 
> The othe ralternative is to not disable tls by mv'ing the directory out
> the way, but to leave it active. You'll get some loss of performance,
> but it should be executed correctly.
> 
> Another interesting datapoint would be to try the unstable.bk tree. It's
> still a bit 'raw', but providing you're just using the features present
> in 2.x its actually pretty stable.
> 
> If anyone has a simple recipe for deterministically provoking this issue
> it would be good to know. 

FWIW, my setup here has involved several machines a couple of "live" ones
basically used to hold transient data in a queue, a development box and a
reporting server containing large volumes of log records - mostly used for
queries.

It's the reporting server which had the data corruption, and the two queue
handlers which have experienced the segvs.

The queue handlers are running on identical boxes (IBM e325s over scsi), and
the reporting server on a generic system over SATA, if this helps.

The queue handlers have both had the segv, but at different times. They're in
a round-robin carrying much the same traffic. I guess this means the problem
is going to be difficult to reproduce :-(

> 
> Best,
> Ian 
> 
> 

Hope this helps,
Paul.

- --
Paul Laws
Analyst / Programmer
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFClEjJYmQ8biuDK88RAiKzAJ46ALzxjd+jqMmsve4XMJi/PpEAhgCfWs9Q
f9qKuhOJh4MKPXuX2lBdBSA=
=TMDL
-----END PGP SIGNATURE-----

_______________________________________________
Xen-users mailing list
Xen-users@xxxxxxxxxxxxxxxxxxx
http://lists.xensource.com/xen-users