[OpenAFS] mysql data from openafs
Sven Oehme
oehmes@de.ibm.com
Fri, 23 Jul 2004 12:49:16 +0200
This is a multipart message in MIME format.
--=_alternative 003B68DFC1256EDA_=
Content-Type: text/plain; charset="US-ASCII"
if you like to use it to cluster your mysql , you should better use -->
http://www.drbd.org/
but it is also good , to have a afs client on the system , for doing a
mysql backup for example in /afs.... to have the backup "local" , but
saved on a different system .
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 12:07 PM
To
openafs-info@openafs.org
cc
Subject
Re: [OpenAFS] mysql data from openafs
I see.
Now i must rethink my design :-)
Tanx.
On Friday 23 of July 2004 11:54, Sven Oehme wrote:
> 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
_______________________________________________
OpenAFS-info mailing list
OpenAFS-info@openafs.org
https://lists.openafs.org/mailman/listinfo/openafs-info
--=_alternative 003B68DFC1256EDA_=
Content-Type: text/html; charset="US-ASCII"
<br><font size=2 face="sans-serif">if you like to use it to cluster your
mysql , you should better use --> http://www.drbd.org/</font>
<br>
<br><font size=2 face="sans-serif">but it is also good , to have a afs
client on the system , for doing a mysql backup for example in /afs....
to have the backup "local" , but saved on a different system
.</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 12:07 PM</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>I see.<br>
Now i must rethink my design :-)<br>
Tanx.<br>
<br>
On Friday 23 of July 2004 11:54, Sven Oehme wrote:<br>
> yes ,<br>
><br>
> afs will not really save the file to the Fileserver , unless you close
the<br>
> file . in a mysql database case it will never save it to the server
. this<br>
> is a very good feature , because it gives you always a consistent
file .<br>
> but if you mysql system itself , or the afs client on that system
crashes<br>
> , you will loose all changes since the last close to the file and
mysql<br>
> will not close any files of a active db .<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:36 AM<br>
><br>
> To<br>
> openafs-info@openafs.org<br>
> cc<br>
><br>
> Subject<br>
> Re: [OpenAFS] mysql data from openafs<br>
><br>
><br>
><br>
><br>
><br>
><br>
> 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>
><br>
> >---------------------------------------------- Dept. A141, TG/SSG
EMEA<br>
><br>
> AIS<br>
><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<br>
><br>
> mysql.<br>
><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>
> _______________________________________________<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 003B68DFC1256EDA_=--