Mysql Upgradation

Sachin Watane

unread,

Feb 22, 2016, 11:38:23 PM2/22/16

to VGLUG

Hello All,

Is there any way to upgrade mysql from 5.0 to 5.6 without downtime .

Regards
Sachin

Pinakin Bhatt

unread,

Feb 23, 2016, 12:35:11 AM2/23/16

to vg...@googlegroups.com

Hi..

Currently it is on window OR on Linux ?

Regards,

Pinakin

--
Please read http://www.catb.org/~esr/faqs/smart-questions.html before posting.
You received this message because you are subscribed to the "Vibrant GNU/Linux User Group".
To stop receiving emails from this group, mail to VGLUG+un...@googlegroups.com
To post to this group, send email to VG...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/VGLUG

---
You received this message because you are subscribed to the Google Groups "VGLUG" group.
To unsubscribe from this group and stop receiving emails from it, send an email to vglug+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Sachin Watane

unread,

Feb 23, 2016, 11:44:56 AM2/23/16

to VGLUG

on linux

Alok Thaker

unread,

Feb 24, 2016, 6:23:29 AM2/24/16

to VGLUG

Hi,

If you have a master-master replication you can always go upgrade with one being on standby. Best practice for you can be to migrate the database by taking backup to new mysql instance of 5.6.

If you are on cloud Amazon RDS would have been upgraded without downtime.

Thanks & Regards,

Alok Thaker

Sachin Watane

unread,

Feb 25, 2016, 10:46:57 AM2/25/16

to VGLUG

Don't have master master setup in our location we have individual server.

Regards,
Sachin

Alok Thaker

unread,

Feb 26, 2016, 2:08:48 AM2/26/16

to VGLUG

Hi,

You can take mysql dump backup and try to migrate to the new instance then after cross checking flush the individual server. That would have a no downtime and ease to use.