 |
|
|
|
Next: RFS: playonlinux
|
| Author |
Message |
External
Since: May 09, 2007
Posts: 3
|
(Msg. 1) Posted: Wed Feb 11, 2009 11:20 am
Post subject: sarge 32bit --> lenny 64bit upgrade
Archived from groups: linux>debian>isp (more info?)
|
|
|
Hello all,
I have one server which is still running sarge (because of
mysql-server 4.0). I want to upgrade it, but also want to add more
memory (4GB in total), so I would like to have 64bit version
installed.
There are few possibilities how to do it:
1) Upgrade sarge to etch, then upgrade etch to lenny
- try to change lenny 32bit into 64bit (I know it's not supported but
I have found few documents on how to do it)
- or forget about 64bit (is it worth for 4 GB RAM acting as mail
server and central mysql server?)
2) Don't upgrade. Backup /home and try to install from scratch lenny
64bit. But how to do it? Which filesystems to keep and which
re-format? I suppose I should re-format everything except /home and
/var, or else I would end up with old 32bit versions of some files
still there.
I suppose it's no problem for installer to detect existing MD devices
(md0 for /, md1 for LVM, md2 for swap), activate them, detect LVM PV
on md1 and use the existing LVs - either configuring them with new
filesystem or keeping the old data (/home and /var).
Which method would you prefer?
--
bYE, Marki
--
To UNSUBSCRIBE, email to debian-isp-REQUEST RemoveThis @lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster RemoveThis @lists.debian.org |
|
| Back to top |
|
 | |
External
Since: Dec 11, 2006
Posts: 65
|
(Msg. 2) Posted: Wed Feb 11, 2009 1:20 pm
Post subject: Re: sarge 32bit --> lenny 64bit upgrade [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Marek Podmaka wrote:
> (is it worth for 4 GB RAM acting as mail
> server and central mysql server?)
It is always worth to get away from pentium 1 compiled package, use 8
general purpose registers and no memory pages, instead of the very old
system in 32 bits.
> 2) Don't upgrade. Backup /home and try to install from scratch lenny
> 64bit. But how to do it? Which filesystems to keep and which
> re-format? I suppose I should re-format everything except /home and
> /var, or else I would end up with old 32bit versions of some files
> still there.
>
> I suppose it's no problem for installer to detect existing MD devices
> (md0 for /, md1 for LVM, md2 for swap), activate them, detect LVM PV
> on md1 and use the existing LVs - either configuring them with new
> filesystem or keeping the old data (/home and /var).
>
> Which method would you prefer?
You can keep your /home if there's only data there, but I have to warn
you that you will NOT be able to use a 32 bits mysql /var/lib/mysql
folder on a 64 bits system. You WILL have to use mysqldump and then
reimport.
Anyway, you are right, the Debian installer can see your RAID and LVM
devices and not reformat them if you ask correctly.
Thomas
--
To UNSUBSCRIBE, email to debian-isp-REQUEST.TakeThisOut@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster.TakeThisOut@lists.debian.org |
|
| Back to top |
|
| |
External
Since: Feb 11, 2009
Posts: 2
|
(Msg. 3) Posted: Wed Feb 11, 2009 3:20 pm
Post subject: Re: sarge 32bit --> lenny 64bit upgrade [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hi Thomas,
> You can keep your /home if there's only data there, but I have to warn
> you that you will NOT be able to use a 32 bits mysql /var/lib/mysql
> folder on a 64 bits system. You WILL have to use mysqldump and then
> reimport.
Could you please be a bit more specific about the mysql problem(s) one
will get? I just thought about a similar migration, not from sarge but
from etch 32 bit to etch 64 bit on a production machine.
Thanks,
Claus
--
CHECON EDV-Consulting und Redaktion
Claus Herwig * Barer Straße 70 * 80799 München
+49 89 27826981 * Fax 27826982 * c.herwig RemoveThis @checon.de
--
To UNSUBSCRIBE, email to debian-isp-REQUEST RemoveThis @lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster RemoveThis @lists.debian.org |
|
| Back to top |
|
| |
External
Since: Jan 23, 2007
Posts: 4
|
(Msg. 4) Posted: Wed Feb 11, 2009 3:20 pm
Post subject: Re: sarge 32bit --> lenny 64bit upgrade [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Claus Herwig wrote:
> Hi Thomas,
>
>> You can keep your /home if there's only data there, but I have to warn
>> you that you will NOT be able to use a 32 bits mysql /var/lib/mysql
>> folder on a 64 bits system. You WILL have to use mysqldump and then
>> reimport.
>
> Could you please be a bit more specific about the mysql problem(s) one
> will get? I just thought about a similar migration, not from sarge but
> from etch 32 bit to etch 64 bit on a production machine.
>
Quite simple, really: it won't work. You need to do a mysqldump to a
text file and reload it on the 64-bit system.
~Seth
--
To UNSUBSCRIBE, email to debian-isp-REQUEST RemoveThis @lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster RemoveThis @lists.debian.org |
|
| Back to top |
|
| |
External
Since: May 09, 2007
Posts: 3
|
(Msg. 5) Posted: Thu Feb 12, 2009 5:20 am
Post subject: Re: sarge 32bit --> lenny 64bit upgrade [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hello,
Wednesday, February 11, 2009, 20:03:05, Claus Herwig wrote:
>> You can keep your /home if there's only data there, but I have to warn
>> you that you will NOT be able to use a 32 bits mysql /var/lib/mysql
>> folder on a 64 bits system. You WILL have to use mysqldump and then
>> reimport.
> Could you please be a bit more specific about the mysql problem(s) one
> will get? I just thought about a similar migration, not from sarge but
> from etch 32 bit to etch 64 bit on a production machine.
OK, thanks for this info...
I don't have any more databases on the old server - I had to move them
one by one to other server with mysql 5.0 because of the charset
support in mysql 4.0 and 4.1. But this is also 32bit system, so I know
I have to mysqldump and not just scp the /var/lib/mysql.
--
bYE, Marki
--
To UNSUBSCRIBE, email to debian-isp-REQUEST DeleteThis @lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster DeleteThis @lists.debian.org |
|
| Back to top |
|
| |
External
Since: Feb 13, 2009
Posts: 1
|
(Msg. 6) Posted: Fri Feb 13, 2009 3:20 am
Post subject: Re: sarge 32bit --> lenny 64bit upgrade [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Marek Podmaka wrote:
> I have one server which is still running sarge (because of
> mysql-server 4.0). I want to upgrade it, but also want to add more
> memory (4GB in total), so I would like to have 64bit version
> installed.
Keep in mind that you don't always need 64 bit just because you have
more than 4 GB of memory. You can use a 32-bit "-bigmem" kernel in some
cases.
Using a -bigmem kernel means that all the processes together can use the
entire RAM, but each individual process can only access between 3-4 GB.
That may not be sufficient if you're running a huge database that
requires lots of memory dedicated to a single MySQL process, for
example, but it does work if you're using the RAM for lots of smaller
processes (such as a server running zillions of Apache processes or
POP/IMAP/SMTP processes).
--
Robert L Mathews, Tiger Technologies, http://www.tigertech.net/
--
To UNSUBSCRIBE, email to debian-isp-REQUEST RemoveThis @lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster RemoveThis @lists.debian.org |
|
| Back to top |
|
| |
External
Since: Nov 08, 2008
Posts: 16
|
(Msg. 7) Posted: Fri Feb 20, 2009 5:20 am
Post subject: Re: sarge 32bit --> lenny 64bit upgrade [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On Wed, Feb 11, 2009 at 9:37 PM, Seth Mattinen <sethm.TakeThisOut@rollernet.us> wrote:
> Claus Herwig wrote:
>> Hi Thomas,
>>
>>> You can keep your /home if there's only data there, but I have to warn
>>> you that you will NOT be able to use a 32 bits mysql /var/lib/mysql
>>> folder on a 64 bits system. You WILL have to use mysqldump and then
>>> reimport.
>>
>> Could you please be a bit more specific about the mysql problem(s) one
>> will get? I just thought about a similar migration, not from sarge but
>> from etch 32 bit to etch 64 bit on a production machine.
>>
>
> Quite simple, really: it won't work. You need to do a mysqldump to a
> text file and reload it on the 64-bit system.
Really? I've did a rsync yesterday from a mysql5.0 database on "etch"
32-bit to a mysql5.0 database on "lenny" 64-bit and it works without
any problem.
Cheers
--
To UNSUBSCRIBE, email to debian-isp-REQUEST.TakeThisOut@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster.TakeThisOut@lists.debian.org |
|
| Back to top |
|
| |
External
Since: Feb 11, 2009
Posts: 2
|
(Msg. 8) Posted: Fri Feb 20, 2009 5:20 am
Post subject: Re: sarge 32bit --> lenny 64bit upgrade [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
>>> Could you please be a bit more specific about the mysql problem(s) one
>>> will get? I just thought about a similar migration, not from sarge but
>>> from etch 32 bit to etch 64 bit on a production machine.
>>>
>> Quite simple, really: it won't work. You need to do a mysqldump to a
>> text file and reload it on the 64-bit system.
>
> Really? I've did a rsync yesterday from a mysql5.0 database on "etch"
> 32-bit to a mysql5.0 database on "lenny" 64-bit and it works without
> any problem.
Thanks for the hint. That was what I thought to have done some month
ago, too - without any problem. But I have to admit that today I'm not
really sure about the mysql versions involved at that time. So basically
thats why I'm asked for more details about the problems 
Claus
--
CHECON EDV-Consulting und Redaktion
Claus Herwig * Barer Straße 70 * 80799 München
+49 89 27826981 * Fax 27826982 * c.herwig.TakeThisOut@checon.de
--
To UNSUBSCRIBE, email to debian-isp-REQUEST.TakeThisOut@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster.TakeThisOut@lists.debian.org |
|
| Back to top |
|
| |
External
Since: Dec 11, 2006
Posts: 65
|
(Msg. 9) Posted: Fri Feb 20, 2009 7:20 am
Post subject: Re: sarge 32bit --> lenny 64bit upgrade [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Teodor wrote:
> Really? I've did a rsync yesterday from a mysql5.0 database on "etch"
> 32-bit to a mysql5.0 database on "lenny" 64-bit and it works without
> any problem.
>
> Cheers
Then maybe the newer MySQL server has some code to do the conversion,
because I'm pretty sure that it did not work previously. Once, I had a
server crash (defective PSU), then we had to reinstall all on a new
hardware. The only way I was able to get my database back, was doing a
chroot to the backup of the old server, start (the 32 bits) MySQL, do a
dump, stop MySQL, exit from chroot, start (the 64 bits) MySQL, and
reimport. I say it again: it did not work AT ALL to use the 32 bits data
in the 64 bits MySQL server. This was ALL running in Etch, at the time.
Thomas
--
To UNSUBSCRIBE, email to debian-isp-REQUEST.RemoveThis@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster.RemoveThis@lists.debian.org |
|
| Back to top |
|
| |
External
Since: Dec 23, 2004
Posts: 10
|
(Msg. 10) Posted: Fri Feb 20, 2009 1:20 pm
Post subject: Re: sarge 32bit --> lenny 64bit upgrade [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
--On February 20, 2009 9:10:25 AM -0800 Seth Mattinen <sethm RemoveThis @rollernet.us>
wrote:
>
>
> Care to share any environment details that could be useful?
>
> ~Seth
I don't think MySQL's on disk format changes at all between 32 and 64 bit
variants, including the InnoDB tables. It certainly hasn't changed in a
non-backwards compatible way since like... 3.23ish time frame... Atleast
not as far as I know.
--
To UNSUBSCRIBE, email to debian-isp-REQUEST RemoveThis @lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster RemoveThis @lists.debian.org |
|
| Back to top |
|
| |
External
Since: Jan 23, 2007
Posts: 4
|
(Msg. 11) Posted: Fri Feb 20, 2009 1:20 pm
Post subject: Re: sarge 32bit --> lenny 64bit upgrade [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Teodor wrote:
> On Wed, Feb 11, 2009 at 9:37 PM, Seth Mattinen <sethm.DeleteThis@rollernet.us> wrote:
>> Claus Herwig wrote:
>>> Hi Thomas,
>>>
>>>> You can keep your /home if there's only data there, but I have to warn
>>>> you that you will NOT be able to use a 32 bits mysql /var/lib/mysql
>>>> folder on a 64 bits system. You WILL have to use mysqldump and then
>>>> reimport.
>>> Could you please be a bit more specific about the mysql problem(s) one
>>> will get? I just thought about a similar migration, not from sarge but
>>> from etch 32 bit to etch 64 bit on a production machine.
>>>
>> Quite simple, really: it won't work. You need to do a mysqldump to a
>> text file and reload it on the 64-bit system.
>
> Really? I've did a rsync yesterday from a mysql5.0 database on "etch"
> 32-bit to a mysql5.0 database on "lenny" 64-bit and it works without
> any problem.
>
> Cheers
Care to share any environment details that could be useful?
~Seth
--
To UNSUBSCRIBE, email to debian-isp-REQUEST.DeleteThis@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster.DeleteThis@lists.debian.org |
|
| Back to top |
|
| |
External
Since: Nov 08, 2008
Posts: 16
|
(Msg. 12) Posted: Sun Feb 22, 2009 9:20 am
Post subject: Re: sarge 32bit --> lenny 64bit upgrade [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On Fri, Feb 20, 2009 at 7:10 PM, Seth Mattinen <sethm.RemoveThis@rollernet.us> wrote:
> Teodor wrote:
>> Really? I've did a rsync yesterday from a mysql5.0 database on "etch"
>> 32-bit to a mysql5.0 database on "lenny" 64-bit and it works without
>> any problem.
>
> Care to share any environment details that could be useful?
There are no hacks, just typical Debian hosts. I can only guess that
it works from mysql5.0 to mysql5.0 but not from mysql4 to myslq5.
Cheers
--
To UNSUBSCRIBE, email to debian-isp-REQUEST.RemoveThis@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster.RemoveThis@lists.debian.org |
|
| Back to top |
|
| |
|
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
Linux