[OpenAFS] mysql data from openafs
Sven Oehme
oehmes@de.ibm.com
Fri, 23 Jul 2004 11:54:32 +0200
This is a multipart message in MIME format.
--=_alternative 00365A8CC1256EDA_=
Content-Type: text/plain; charset="US-ASCII"
yes ,
afs will not really save the file to the Fileserver , unless you close the
file . in a mysql database case it will never save it to the server . this
is a very good feature , because it gives you always a consistent file .
but if you mysql system itself , or the afs client on that system crashes
, you will loose all changes since the last close to the file and mysql
will not close any files of a active db .
Sven
-------------------------------------------------------------------------------------------------------------------------
Dept. A141, TG/SSG EMEA AIS Strategy and Architecture
Development Leader Stonehenge
IBM intranet ---> http://w3.ais.mainz.de.ibm.com/stonehenge/
internet ---> http://www-5.ibm.com/services/de/its/filestore.html
Phone (+49)-6131-84-3151
Fax (+49)-6131-84-6708
Mobil (+49)-171-970-6664
E-Mail : oehmes@de.ibm.com
Temp <tempone@isg.si>
Sent by: openafs-info-admin@openafs.org
07/23/2004 11:36 AM
To
openafs-info@openafs.org
cc
Subject
Re: [OpenAFS] mysql data from openafs
Any specific reason?
On Friday 23 of July 2004 11:27, Sven Oehme wrote:
> hy ,
>
> use an ip token for that...
>
> but i personally would not recommend to store mysql databases in afs ..
>
> Sven
>
>
---------------------------------------------------------------------------
>---------------------------------------------- Dept. A141, TG/SSG EMEA
AIS
> Strategy and Architecture
> Development Leader Stonehenge
> IBM intranet ---> http://w3.ais.mainz.de.ibm.com/stonehenge/
> internet ---> http://www-5.ibm.com/services/de/its/filestore.html
> Phone (+49)-6131-84-3151
> Fax (+49)-6131-84-6708
> Mobil (+49)-171-970-6664
> E-Mail : oehmes@de.ibm.com
>
>
>
> Temp <tempone@isg.si>
> Sent by: openafs-info-admin@openafs.org
> 07/23/2004 11:07 AM
>
> To
> openafs-info@openafs.org
> cc
>
> Subject
> [OpenAFS] mysql data from openafs
>
>
>
>
>
>
> Hello there :-)
>
> I successfouly created voumes, mounted them and created an user for
mysql.
> The only way i'm aware of giving access to mysql database(user) is like
> this:
> su mysql
> klog mysql
> start mysql :-)
> exit
>
> But tokens expire and i i have to do this every time the system reboots
> too.
>
> I wonder how can i make mysql user always authenticated so i can just
> start
> the mysql database and it will have access to files on afs?
> Any ideas?
>
> Tanx for info.
>
> Regards M.
> _______________________________________________
> OpenAFS-info mailing list
> OpenAFS-info@openafs.org
> https://lists.openafs.org/mailman/listinfo/openafs-info
_______________________________________________
OpenAFS-info mailing list
OpenAFS-info@openafs.org
https://lists.openafs.org/mailman/listinfo/openafs-info
--=_alternative 00365A8CC1256EDA_=
Content-Type: text/html; charset="US-ASCII"
<br><font size=2 face="sans-serif">yes , </font>
<br>
<br><font size=2 face="sans-serif">afs will not really save the file to
the Fileserver , unless you close the file . in a mysql database case it
will never save it to the server . this is a very good feature , because
it gives you always a consistent file . but if you mysql system itself
, or the afs client on that system crashes , you will loose all changes
since the last close to the file and mysql will not close any files of
a active db .</font>
<br>
<br><font size=2 face="sans-serif">Sven</font>
<br>
<br><font size=2 face="sans-serif">-------------------------------------------------------------------------------------------------------------------------<br>
Dept. A141, TG/SSG EMEA AIS Strategy and Architecture<br>
Development Leader Stonehenge <br>
IBM intranet ---> http://w3.ais.mainz.de.ibm.com/stonehenge/<br>
internet ---> http://www-5.ibm.com/services/de/its/filestore.html<br>
Phone (+49)-6131-84-3151<br>
Fax (+49)-6131-84-6708<br>
Mobil (+49)-171-970-6664<br>
E-Mail : oehmes@de.ibm.com</font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=40%><font size=1 face="sans-serif"><b>Temp <tempone@isg.si></b>
</font>
<br><font size=1 face="sans-serif">Sent by: openafs-info-admin@openafs.org</font>
<p><font size=1 face="sans-serif">07/23/2004 11:36 AM</font>
<td width=59%>
<table width=100%>
<tr>
<td>
<div align=right><font size=1 face="sans-serif">To</font></div>
<td valign=top><font size=1 face="sans-serif">openafs-info@openafs.org</font>
<tr>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td valign=top>
<tr>
<td>
<div align=right><font size=1 face="sans-serif">Subject</font></div>
<td valign=top><font size=1 face="sans-serif">Re: [OpenAFS] mysql data
from openafs</font></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br>
<br>
<br><font size=2><tt>Any specific reason?<br>
<br>
On Friday 23 of July 2004 11:27, Sven Oehme wrote:<br>
> hy ,<br>
><br>
> use an ip token for that...<br>
><br>
> but i personally would not recommend to store mysql databases in afs
..<br>
><br>
> Sven<br>
><br>
> ---------------------------------------------------------------------------<br>
>---------------------------------------------- Dept. A141, TG/SSG
EMEA AIS<br>
> Strategy and Architecture<br>
> Development Leader Stonehenge<br>
> IBM intranet ---> http://w3.ais.mainz.de.ibm.com/stonehenge/<br>
> internet ---> http://www-5.ibm.com/services/de/its/filestore.html<br>
> Phone (+49)-6131-84-3151<br>
> Fax (+49)-6131-84-6708<br>
> Mobil (+49)-171-970-6664<br>
> E-Mail : oehmes@de.ibm.com<br>
><br>
><br>
><br>
> Temp <tempone@isg.si><br>
> Sent by: openafs-info-admin@openafs.org<br>
> 07/23/2004 11:07 AM<br>
><br>
> To<br>
> openafs-info@openafs.org<br>
> cc<br>
><br>
> Subject<br>
> [OpenAFS] mysql data from openafs<br>
><br>
><br>
><br>
><br>
><br>
><br>
> Hello there :-)<br>
><br>
> I successfouly created voumes, mounted them and created an user for
mysql.<br>
> The only way i'm aware of giving access to mysql database(user) is
like<br>
> this:<br>
> su mysql<br>
> klog mysql<br>
> start mysql :-)<br>
> exit<br>
><br>
> But tokens expire and i i have to do this every time the system reboots<br>
> too.<br>
><br>
> I wonder how can i make mysql user always authenticated so i can just<br>
> start<br>
> the mysql database and it will have access to files on afs?<br>
> Any ideas?<br>
><br>
> Tanx for info.<br>
><br>
> Regards M.<br>
> _______________________________________________<br>
> OpenAFS-info mailing list<br>
> OpenAFS-info@openafs.org<br>
> https://lists.openafs.org/mailman/listinfo/openafs-info<br>
_______________________________________________<br>
OpenAFS-info mailing list<br>
OpenAFS-info@openafs.org<br>
https://lists.openafs.org/mailman/listinfo/openafs-info<br>
</tt></font>
<br>
--=_alternative 00365A8CC1256EDA_=--