MySQL Upgrading

MySQL Upgrading

am 23.06.2010 15:33:49 von Steven Staples

Hi,

I am looking at upgrading my servers Debian version from Etch to Lenny, and
in doing that, I think it will upgrade MySQL from 5.0.32 to the lenny
version, which is 5.0.53 (I think).

I have also been thinking about using the 'dotdeb' packages, which will
upgrade it even further to 5.1.47. I have done this on a test server, and
it all my stored procedures and stuff work fine, so now to my question.

Will this break any replication if I don't upgrade my replication server
that is still running 5.0.32 (until I upgrade that server as well, which
could be a few weeks due to timing)?

The other issue, is that the replication server is running multiple
instances of the same MySQL on different ports, so that I can replicate
multiple sources to a single server (that has attached tape drives for
backup purposes), is it possible to run both versions of mysql (the 5.0.32
and the 5.1.47)? granted, this is not the debian mailing list, just
thought I would ask that last part ;)


Steven Staples




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: MySQL Upgrading

am 24.06.2010 01:13:29 von Rob Wultsch

On Wed, Jun 23, 2010 at 6:33 AM, Steven Staples wrote:
> Hi,
>
> I am looking at upgrading my servers Debian version from Etch to Lenny, a=
nd
> in doing that, I think it will upgrade MySQL from 5.0.32 to the lenny
> version, which is =A05.0.53 (I think).
>
> I have also been thinking about using the 'dotdeb' packages, which will
> upgrade it even further to 5.1.47. =A0I have done this on a test server, =
and
> it all my stored procedures and stuff work fine, so now to my question.
>
> Will this break any replication if I don't upgrade my replication server
> that is still running 5.0.32 (until I upgrade that server as well, which
> could be a few weeks due to timing)?

It will. I suggest upgrading to at least 5.0.67 if you have no fear of
internal users, and the most recent version of 5.0 and 5.1 (I don't
recall what they are) if you have fears of malicious users.

> The other issue, is that the replication server is running multiple
> instances of the same MySQL on different ports, so that I can replicate
> multiple sources to a single server (that has attached tape drives for
> backup purposes), is it possible to run both versions of mysql (the 5.0.3=
2
> and the 5.1.47)? =A0 =A0granted, this is not the debian mailing list, jus=
t
> thought I would ask that last part ;)
>
>
> Steven Staples
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dwultsch@gmail=
..com
>
>



--=20
Rob Wultsch
wultsch@gmail.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg