MySQL upgrades?

--=-UtPJhLVdq2Z3hxVHJ+Rm
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

Good day all

I am looking for someone that can maybe help me with some info
regarding the upgrading of MySQL.

We have a MySQL database currently running with a master/slave
replication setup.

The current version of the database is as follows:

mysql> select version();
+------------------------------+
| version() |
+------------------------------+
| 5.0.72sp1-enterprise-gpl-log |
+------------------------------+
1 row in set (0.00 sec)

This is currently running on RedHat.


This database is however set to be migrated to new hardware later
during this month and discussions have been in place in order to upgrade
the Database to the latest version possible.

As it would seem, the latest enterprise (pro/advanced) version
available are version 5.1.46sp1 and version 5.1.50 which includes the
interim updates as well.


I am trying to find someone who has had experience and can give
me some pointers in the following regard as this will be my first
database upgrade:

1. which one of these two version will be the best to upgrade to.
2. where can I get information on how to upgrade the database
itself
3. has anyone done this before? if so, is there anything that we
should look out for?


I would really appreciate the help here.

Regards
Machiel

--=-UtPJhLVdq2Z3hxVHJ+Rm--

Re: MySQL upgrades?

--00163683344ce37699048f5860a5
Content-Type: text/plain; charset=ISO-8859-1

If you planing to migrate to a new hardware, then install the new version of
mysql and take dump of the current data and imported into ur new m/c and
test your app. If you all looks fine, then ur done.

regards
anandkl

On Fri, Sep 3, 2010 at 3:53 PM, Machiel Richards > wrote:

> Good day all
>
> I am looking for someone that can maybe help me with some info
> regarding the upgrading of MySQL.
>
> We have a MySQL database currently running with a master/slave
> replication setup.
>
> The current version of the database is as follows:
>
> mysql> select version();
> +------------------------------+
> | version() |
> +------------------------------+
> | 5.0.72sp1-enterprise-gpl-log |
> +------------------------------+
> 1 row in set (0.00 sec)
>
> This is currently running on RedHat.
>
>
> This database is however set to be migrated to new hardware later
> during this month and discussions have been in place in order to upgrade
> the Database to the latest version possible.
>
> As it would seem, the latest enterprise (pro/advanced) version
> available are version 5.1.46sp1 and version 5.1.50 which includes the
> interim updates as well.
>
>
> I am trying to find someone who has had experience and can give
> me some pointers in the following regard as this will be my first
> database upgrade:
>
> 1. which one of these two version will be the best to upgrade to.
> 2. where can I get information on how to upgrade the database
> itself
> 3. has anyone done this before? if so, is there anything that we
> should look out for?
>
>
> I would really appreciate the help here.
>
> Regards
> Machiel
>

--00163683344ce37699048f5860a5--

Re: MySQL upgrades?

On 03/09/2010 12:23 p, Machiel Richards wrote:
> Good day all
>
> I am looking for someone that can maybe help me with some info
> regarding the upgrading of MySQL.
>
> We have a MySQL database currently running with a master/slave
> replication setup.
>
> The current version of the database is as follows:
>
> mysql> select version();
> +------------------------------+
> | version() |
> +------------------------------+
> | 5.0.72sp1-enterprise-gpl-log |
> +------------------------------+
> 1 row in set (0.00 sec)
>
> This is currently running on RedHat.
>
>
> This database is however set to be migrated to new hardware later
> during this month and discussions have been in place in order to upgrade
> the Database to the latest version possible.
>
> As it would seem, the latest enterprise (pro/advanced) version
> available are version 5.1.46sp1 and version 5.1.50 which includes the
> interim updates as well.
>
>
> I am trying to find someone who has had experience and can give
> me some pointers in the following regard as this will be my first
> database upgrade:
>
> 1. which one of these two version will be the best to upgrade to.
> 2. where can I get information on how to upgrade the database
> itself
> 3. has anyone done this before? if so, is there anything that we
> should look out for?
>
>
> I would really appreciate the help here.
>
> Regards
> Machiel
>
In the old machine

mysqldump -p etc etc dbname > database.sql

then copy the database.sql to the new machine and run

mysql -p < database.sql

It should work regardless of the version you are exporting/importing to.

--
Jangita | +256 76 91 8383 | Y! & MSN: jangita@yahoo.com
Skype: jangita | GTalk: jangita.nyagudi@gmail.com

--
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 upgrades?

Hi Machiel, all!


Machiel Richards wrote:
> Good day all
>=20
> I am looking for someone that can maybe help me with some info
> regarding the upgrading of MySQL.
>=20
> We have a MySQL database currently running with a master/slave
> replication setup.
>=20
> The current version of the database is as follows:
>=20
> mysql> select version();
> +------------------------------+
> | version() |
> +------------------------------+
> | 5.0.72sp1-enterprise-gpl-log |=20
> +------------------------------+
> 1 row in set (0.00 sec)

Ok, so you are an enterprise customer, running a QSP (quarterly) build.

>=20
> This is currently running on RedHat.

A decent platform.

>=20
> This database is however set to be migrated to new hardware late=
r
> during this month and discussions have been in place in order to upgrad=
e
> the Database to the latest version possible.

This makes sense. MySQL 5.0 is in extended support only, so all users
should seize a suitable occasion (like a hardware upgrade) to change to
MySQL 5.1.
Those who follow new development more closely would use MySQL 5.5, but I
trust they have left 5.0 already.

> =20
> As it would seem, the latest enterprise (pro/advanced) version
> available are version 5.1.46sp1 and version 5.1.50 which includes the
> interim updates as well.

Correct.
The next QSP build is planned to be 5.1.49sp1, which is expected to be
published in October.

>=20
> [[...]]
>=20
> 1. which one of these two version will be the best to upgrade to.

It is your choice whether you want to continue running QSP (quarterly)
or MRU (monthly) builds. This choice is not permanent, with any upgrade
you can switch between QSP and MRU packages.

I don't see any reason to pick any older version than one of these.
You should check the changelogs of 5.1.47 through 5.1.50 whether they
contain any change you are interested in - if yes, that might settle the
question.
If none of their changes seems relevant to you, you might stay with the
QSP builds and take MySQL 5.1.46sp1, updating to newer QSP versions with
the frequency that suits your environment.

> 2. where can I get information on how to upgrade the database
> itself
> 3. has anyone done this before? if so, is there anything that we
> should look out for?

I'm no expert on this, but AFAIK the MySQL 5.1 manual has a section on th=
at.


HTH,
Jörg

--=20
Joerg Bruehe, MySQL Build Team, joerg.bruehe@oracle.com
ORACLE Deutschland B.V. & Co. KG, Komturstrasse 18a, D-12099 Berlin
Geschaeftsfuehrer: Juergen Kunz, Marcel v.d. Molen, Alexander v.d. Ven
Amtsgericht Muenchen: HRA 95603


--
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