[Voyage-linux] MySQL

[Robert Rawlins - Think Blue]

Hi Rainer,

Thanks for the reply!

In my application we want to have the second partition read/write. We have a
database and also a small number of XML and image files which we need to
exist even after a reboot or power failure, the plan is to put these onto
the second partition.

When I make the entry in fstab does the partition get mounted on boot? If
so, how do I access the disk to save to it? What is the path to that
partition?

DD is an application we use to replicate the CF cards, so we only need to
build one and then use DD to make replicas, it's much quicker than building
from scratch each time :-D

Thanks,

Robert

-----Original Message-----
From:
voyage-linux-bounces+robert.rawlins=thinkbluemedia.co.uk at list.voyage.hk
[mailto:voyage-linux-bounces+robert.rawlins=thinkbluemedia.co.uk at list.voyage
.hk] On Behalf Of Rainer Stratmann
Sent: 07 May 2009 10:52
To: voyage-linux at voyage.hk
Subject: Re: [Voyage-linux] MySQL

Hello Robert,

if you never did it before you have to know how it works.
You have to modify the /etc/fstab and insert a rule for a second (or more) 
partition.
So that Linux knows you can mount from it.

Before that you have to create 2 (or more) partition(s) with cfdisk for 
example.
And then to format the partitions.
In my application the second partition can be mount also readolny.
Do you want also that your second partition can be read only?
Or do you want only read/write?

The best is learning by doing.
If you have questions you can post...
I also use the Live CD.
What do you mean with DD exactly?

Rainer

Am Donnerstag, 7. Mai 2009 12:40 schrieb Robert Rawlins - Think Blue:
> Hi Rainer,
>
> This is something we have talked about in the past but I have not tried to
> do it yet. I've never worked with multiple partitions in Linux before. I
> like this idea very much.
>
> Do you have any advice on how to create this second partition? And how I
> can write files to it? Are there any gotchas I need to watch out for?
We're
> currently creating our disks using the Live CD. I assume this is where I
> create the second partition?
>
> Also, do you know if this second partition included in a disk replication
> using DD?
>
> Thanks,
>
> Robert
>
>
> -----Original Message-----
> From:
> voyage-linux-bounces+robert.rawlins=thinkbluemedia.co.uk at list.voyage.hk
>
[mailto:voyage-linux-bounces+robert.rawlins=thinkbluemedia.co.uk at list.voyag
>e .hk] On Behalf Of Rainer Stratmann
> Sent: 07 May 2009 10:22
> To: voyage-linux at voyage.hk
> Subject: Re: [Voyage-linux] MySQL
>
> May be it will work if you make a second partition.
> Then you can make this partition permanently writable.
> So I do with my application.
> Rainer
>
> Am Donnerstag, 7. Mai 2009 12:13 schrieb Robert Rawlins - Think Blue:
> > Hey Chris,
> >
> > Did you make any progress with this? I myself run MySQL on Voyage, at
the
> > moment we remove the RO/RW stuff so the disk is always writable, this
>
> works
>
> > o.k but does introduce problems and I'd be much happier if we could keep
>
> it
>
> > all in the standard config of being ro with only certain writable
>
> elements.
>
> > I have one application which needs to write files (.xml) and db stuff to
> > the disk however everything else can afford to be lost after a
>
> reboot/power
>
> > failure, it's just this db/file data which needs to be retained.
> >
> > It'd be nice if we could get something working.
> >
> > Rob
> >
> > -----Original Message-----
> > From:
> > voyage-linux-bounces+robert.rawlins=thinkbluemedia.co.uk at list.voyage.hk
>
>
[mailto:voyage-linux-bounces+robert.rawlins=thinkbluemedia.co.uk at list.voyag
>
> >e .hk] On Behalf Of Chris
> > Sent: 24 April 2009 03:37
> > To: voyage-linux at voyage.hk
> > Subject: [Voyage-linux] MySQL
> >
> > Hi,
> >
> > I want to get MySQL working on Voyage and maintaining it as readonly to
> > guard against any damage to the data due to power outages.
> > When I try to install and run MySQL I am no longer able to mount read
> > only, so I guess it is writing temp files or something which will need
> > to be moved to tmpfs.
> >
> > Any idea on how to do this?
> >
> > Thanks,
> > Chris
> >
> > _______________________________________________
> > Voyage-linux mailing list
> > Voyage-linux at list.voyage.hk
> > http://list.voyage.hk/mailman/listinfo/voyage-linux
> >
> >
> > _______________________________________________
> > Voyage-linux mailing list
> > Voyage-linux at list.voyage.hk
> > http://list.voyage.hk/mailman/listinfo/voyage-linux
>
> _______________________________________________
> Voyage-linux mailing list
> Voyage-linux at list.voyage.hk
> http://list.voyage.hk/mailman/listinfo/voyage-linux
>
>
> _______________________________________________
> Voyage-linux mailing list
> Voyage-linux at list.voyage.hk
> http://list.voyage.hk/mailman/listinfo/voyage-linux

_______________________________________________
Voyage-linux mailing list
Voyage-linux at list.voyage.hk
http://list.voyage.hk/mailman/listinfo/voyage-linux