[Voyage-linux] MySQL

[Robert Rawlins - Think Blue]

Gustin, thanks for the advice!

I'll likely be DDing the entire disk so at least that won't be too much of a challenge. Things generally seem pretty simple here then, that's good to know.

I'll try this out later today and see how I get on, I'll once I've got it up and running I'll look into the MySQL configuration to see what needs to be changed in respect to that to get things working.

I'd be interested to hear from Chris (the original poster) about the problems he had with MySQL, even in read only I'd expect the server to be able to write files, they'd just be lost after a reboot? Correct?

Thanks again,

Robert

-----Original Message-----
From: Gustin Johnson [mailto:gustin at echostar.ca] 
Sent: 07 May 2009 12:09
To: Robert Rawlins - Think Blue
Cc: voyage-linux at voyage.hk
Subject: Re: [Voyage-linux] MySQL

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Robert Rawlins - Think Blue wrote:
> 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.
> 
This is nothing new.  There is a lot of documentation out there.
Basically, you create the partition, then format it, then add an entry
in /etc/fstab so that it is mounted on boot.

> Do you have any advice on how to create this second partition? And how I can

I use cfdisk, but my main environment is Linux.  You may wish to RTFM
partitioning under Linux.  It is easy to turf an existing partition
regardless of the OS you are using.

> write files to it? Are there any gotchas I need to watch out for? We're

Once mounted, the new partition appears as another folder on your file
system.  You write files to it like you would any other folder.

> currently creating our disks using the Live CD. I assume this is where I
> create the second partition?

Sure.  You could also do it from within voyage, assuming that there is
free space to partition.
> 
> Also, do you know if this second partition included in a disk replication
> using DD?
> 
If you dd the whole disk (eg. /dev/sda), then yes all partitions are
preserved in the resulting image.  If you want to carve out one of these
partitions from the resulting single image, things can get complicated
(I had to do it once, I documented this here:
http://meganerd.ca/site/node/11).  A better solution in this case is to
dd each partition individually (eg. /dev/sda1 and /dev/sda2).  An even
better solution is to use partimage.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFKAsFHwRXgH3rKGfMRAg80AKCgUeMKH8siiMHcPD/ZT4LmcxlrmgCfcrsp
+TdysYMhRf+wc0MrCXBcZs0=
=IKL0
-----END PGP SIGNATURE-----