From: Reindl Harald
Date: May 26 2011 9:52pm
Subject: Re: Changing the default database location
List-Archive: http://lists.mysql.com/mysql/225116
Message-Id: <4DDECBB7.8050108@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enigEFD29F6FB54A64FA001C199A"

--------------enigEFD29F6FB54A64FA001C199A
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

PLEASE do not reply to the list and some peopole on the list
mailing-list is really enough

Am 26.05.2011 23:49, schrieb Prabhat Kumar:
>>
>> The reason to move database onto the network is that multiple user can=

>> access it. Do you think there is a better alternative?
>>
>=20
> shared storage device with MySQL does not work. Perheps it will corrupt=

> datafile.
> Not sure what do mean by 'multiple user can access' ; Once mysql instal=
l you
> can create N no of  users and let them access..
>=20
> On Fri, May 20, 2011 at 1:06 PM, Johan De Meersman <vegivamp@stripped>=
wrote:
>=20
>> ----- Original Message -----
>>> From: "Reindl Harald" <h.reindl@stripped>
>>>
>>> so put the wgole mysqld and its data on a server in the network
>>> for this mysql was built and not for borking the dadadir somewhere
>>> else
>>
>> Hmm. The way I interpret what he's saying, is that he wants multiple
>> instances accessing the same datafiles. If that's the case, Firdosh, d=
on't -
>> MySQL is not made for concurrent access to the same datafiles. If mult=
iple
>> people/applications need access to the same data, let them connect to =
the
>> same server. If that's not an option, you're going to have to look at
>> replication.
>>
>> I repeat, there is no setup possible where it is safe to have multiple=

>> instances of mysqld access the same datafiles.
>>
>> If you do, the first thing you'll notice is that one instance doesn't =
see
>> the other instance's update. The second thing you'll notice, is that y=
our
>> data files will be FUBAR. Fucked Up Beyond Any Recognition. Not kiddin=
g,
>> here.
>>
>> --
>> Bier met grenadyn
>> Is als mosterd by den wyn
>> Sy die't drinkt, is eene kwezel
>> Hy die't drinkt, is ras een ezel
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=3Daim.prabhat@stripped
>>
>>
>=20
>=20

--=20

Mit besten Gr=FC=DFen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofm=FChlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/

http://www.thelounge.net/signature.asc.what.htm


--------------enigEFD29F6FB54A64FA001C199A
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk3ey7cACgkQhmBjz394Ank+kwCfepg7Drp0n/pQFHCnYBTKaLUT
zgsAn0ELVxiAYdl1D2utwwvH+/vHuHl4
=ouTx
-----END PGP SIGNATURE-----

--------------enigEFD29F6FB54A64FA001C199A--