Re: 2 servers 1 common data base

2010-06-10 Thread Benedikt Schackenberg
hello, you can not simultaneously fix two deamons to a data directory. a mysql daemon always has exclusive access to the data directory. Am 10.06.2010 07:09, schrieb camelia botez: and use the same data bas -- SP data GmbH T 06131 218111 F 06131 218112 E schackenb...@termindoc.de W

Re: 2 servers 1 common data base

2010-06-10 Thread Johan De Meersman
Yups. If you want to have two active servers, you'll need to set up master-master replication and give each server it's own datastore. Note that there's a load of caveats if you want to write to both servers, though - read up on the documentation. 2010/6/10 Benedikt Schackenberg

Re: 2 servers 1 common data base

2010-06-10 Thread Walter Heck - OlinData.com
On Thu, Jun 10, 2010 at 07:09, camelia botez camelia.bo...@weizmann.ac.il wrote: What can be done to run on both servers mysqld simultaneously and use the same data base? You are probably asking the wrong question here. Let's take a step back and ask you another question: What is it you want to

Re: 2 servers 1 common data base

2010-06-10 Thread Joerg Bruehe
Hi! camelia botez wrote: We have 2 mysql servers - one active , second standby. The data base is on nsf storage file system mounted on the active server. We want to turn on active the second server and to be able to use both servers with the same nfs mounted data base. NFS may be good for

Re: 2 servers 1 common data base

2010-06-10 Thread Johan De Meersman
On Thu, Jun 10, 2010 at 10:27 AM, Joerg Bruehe joerg.bru...@sun.com wrote: | There may be some merit to this in a specialized setup (SAN systems - | I'm not convinced of them, but don't claim expert knowledge about them), As a slight aside, I'd like to offer you two major advantages of SAN

2 servers 1 common data base

2010-06-09 Thread camelia botez
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 We have 2 mysql servers - one active , second standby. The data base is on nsf storage file system mounted on the active server. We want to turn on active the second server and to be able to use both servers with the same nfs mounted data base. Just