[Maria-discuss] Upgrading From MySQL 5.6 to MariaDB 10.1
Hi there, I'm not seeing any concise information in the MariaDB docs about the recommended upgrade plan from MySQL 5.6 to MariaDB 10.1. Should I install MariaDB 10.0 and then 10.1? Or can I run right to 10.1? I'm running an older version of Ubuntu (12.04 Precise). Looking at the repo, it looks like I can stick with Precise, and hand that upgrade later. Or are there recommended min version of Ubuntu I should hit first? Thanks! Mike
Am 23.02.2017 um 21:17 schrieb Michael Caplan:
Hi there,
I'm not seeing any concise information in the MariaDB docs about the recommended upgrade plan from MySQL 5.6 to MariaDB 10.1. Should I install MariaDB 10.0 and then 10.1? Or can I run right to 10.1?
I'm running an older version of Ubuntu (12.04 Precise). Looking at the repo, it looks like I can stick with Precise, and hand that upgrade later. Or are there recommended min version of Ubuntu I should hit first?
normally you just update and run "mysql_upgrade -u root -p" mysql/mariadb is not postgres
On 02/23/2017 03:37 PM, Reindl Harald wrote:
normally you just update and run "mysql_upgrade -u root -p" mysql/mariadb is not postgres
some of us could benefit from official language that we could give to customers.
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Am 23.02.2017 um 23:03 schrieb mike bayer:
On 02/23/2017 03:37 PM, Reindl Harald wrote:
normally you just update and run "mysql_upgrade -u root -p" mysql/mariadb is not postgres
some of us could benefit from official language that we could give to customers
how do you imagine "official"? in any sense "official" in teh software world means "you are going from version x tro version y with *excatly* options z" - well, fine, but taht don't match more than a few people of the real world anyways to be honest: such questions are completly useless - if you don#t have a machine where you can test your data with your configuration 1:1 step back and get one - that's it and will always be independent of operating system, software, configuration and data and even if you have - be prepared that something unexpected happens on the live machine which did not show on the clone - be prepeared to deal with it - it's that simple
On 02/23/2017 05:22 PM, Reindl Harald wrote:
Am 23.02.2017 um 23:03 schrieb mike bayer:
On 02/23/2017 03:37 PM, Reindl Harald wrote:
normally you just update and run "mysql_upgrade -u root -p" mysql/mariadb is not postgres
some of us could benefit from official language that we could give to customers
how do you imagine "official"?
in any sense "official" in teh software world means "you are going from version x tro version y with *excatly* options z" - well, fine, but taht don't match more than a few people of the real world anyways
to be honest: such questions are completly useless - if you don#t have a machine where you can test your data with your configuration 1:1 step back and get one - that's it and will always be independent of operating system, software, configuration and data
and even if you have - be prepared that something unexpected happens on the live machine which did not show on the clone - be prepeared to deal with it - it's that simple
I work for well known vendor where thousands of customers will at some point be getting 10.1 installed where they previously had 5.6 as part of a larger installation. All other aspects of the OS and configuration remain identical. We need to answer the question whether or not customers are to be told to rebuild a new data directory from scratch and run a full mysqldump, potentially taking many hours, or if the installer can just run mysql_upgrade, taking a few seconds. Asking all our customers to try the whole thing out on a copy of their production machine and to debug their own installation is not an option. If a piece of software shipped by a software vendor works or not with the datafile from a given version of their software is an answerable question. The mariadb documentation encourages upgrades from 5.5->10.0 for example, and does not suggest that the data directory has to be fully dumped and restored. That's what "official" means in this context.
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Am 24.02.2017 um 00:09 schrieb mike bayer:
On 02/23/2017 05:22 PM, Reindl Harald wrote:
Am 23.02.2017 um 23:03 schrieb mike bayer:
On 02/23/2017 03:37 PM, Reindl Harald wrote:
normally you just update and run "mysql_upgrade -u root -p" mysql/mariadb is not postgres
some of us could benefit from official language that we could give to customers
how do you imagine "official"?
in any sense "official" in teh software world means "you are going from version x tro version y with *excatly* options z" - well, fine, but taht don't match more than a few people of the real world anyways
to be honest: such questions are completly useless - if you don#t have a machine where you can test your data with your configuration 1:1 step back and get one - that's it and will always be independent of operating system, software, configuration and data
and even if you have - be prepared that something unexpected happens on the live machine which did not show on the clone - be prepeared to deal with it - it's that simple
I work for well known vendor where thousands of customers will at some point be getting 10.1 installed where they previously had 5.6 as part of a larger installation. All other aspects of the OS and configuration remain identical
then you hopefully have some test instalaltions
We need to answer the question whether or not customers are to be told to rebuild a new data directory from scratch and run a full mysqldump, potentially taking many hours, or if the installer can just run mysql_upgrade, taking a few seconds
seriously? the data-directory on the machine i compose this mail is from 2003 or so which was mysql-3.x and was in 2006 for some time on mysql-6.0.x-alpha, later downgraded
Asking all our customers to try the whole thing out on a copy of their production machine and to debug their own installation is not an option.
yes, because it's your job to grab some random datadirs, make a snapshot, try it out and know the outcome - whatever the outcome is it will never be granted that it works unconditional for every instance but you know wtihin 5 minutes if it's possible at all
If a piece of software shipped by a software vendor works or not with the datafile from a given version of their software is an answerable question. The mariadb documentation encourages upgrades from 5.5->10.0 for example, and does not suggest that the data directory has to be fully dumped and restored. That's what "official" means in this context
only if there wouldn't be that much storage engines, some like MyISAM living just in a folder per database, otehrs like xtradb/innodb with a global table space which is horrible in case of minor incompatibilities without our crash 2009 it would have been a no-brainer in the reality it was https://jira.mariadb.org/browse/MDEV-11898?page=com.atlassian.jira.plugin.sy..., remove that idiotic files and ignore the error message in the log until someone manages to get that fuckup cleaned from global table space *without* dump/restore for no good reasons the crashes did not happen with mysql 5.5, mariadb 5.5 or mariadb 10.0 while the problem happened with mysql-5.1 - that said about knowing the outcome
My scenario maybe is slightly different. I was on CentOS 6.8 and MySQL 5.3 . I set up another server with CentOS 7 and MariaDB 10.1. I migrated the databases and ran 'mysql_upgrade'. I have not experienced any problems. -----Original Message----- From: Maria-discuss [mailto:maria-discuss-bounces+chris.a.adams=state.or.us@lists.launchpad.net] On Behalf Of Michael Caplan Sent: Thursday, February 23, 2017 12:17 PM To: maria-discuss@lists.launchpad.net Subject: [Maria-discuss] Upgrading From MySQL 5.6 to MariaDB 10.1 Hi there, I'm not seeing any concise information in the MariaDB docs about the recommended upgrade plan from MySQL 5.6 to MariaDB 10.1. Should I install MariaDB 10.0 and then 10.1? Or can I run right to 10.1? I'm running an older version of Ubuntu (12.04 Precise). Looking at the repo, it looks like I can stick with Precise, and hand that upgrade later. Or are there recommended min version of Ubuntu I should hit first? Thanks! Mike _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
On 02/23/2017 03:17 PM, Michael Caplan wrote:
Hi there,
I'm not seeing any concise information in the MariaDB docs about the recommended upgrade plan from MySQL 5.6 to MariaDB 10.1. Should I install MariaDB 10.0 and then 10.1? Or can I run right to 10.1?
I asked about this in depth about a month ago here: https://lists.launchpad.net/maria-discuss/msg04248.html I didn't get any reply, perhaps because it was too detailed or was too much asking for an "official" reply. But it looks very much like mysql_upgrade can be run against a 5.x database straight to 10.1.
I'm running an older version of Ubuntu (12.04 Precise). Looking at the repo, it looks like I can stick with Precise, and hand that upgrade later. Or are there recommended min version of Ubuntu I should hit first?
Thanks!
Mike
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Hi Mike [mike bayer], On 02/24/2017 12:03 AM, mike bayer wrote:
On 02/23/2017 03:17 PM, Michael Caplan wrote:
Hi there,
I'm not seeing any concise information in the MariaDB docs about the recommended upgrade plan from MySQL 5.6 to MariaDB 10.1. Should I install MariaDB 10.0 and then 10.1? Or can I run right to 10.1?
I asked about this in depth about a month ago here:
https://lists.launchpad.net/maria-discuss/msg04248.html
I didn't get any reply, perhaps because it was too detailed or was too much asking for an "official" reply. But it looks very much like mysql_upgrade can be run against a 5.x database straight to 10.1.
Sorry about missing the question. I would stay cautious claiming anything about "5.x", but for MariaDB 5.5 => 10.1 it should be okay, there are no known reasons for it not to work. Generally we encourage small jumps rather than big, but 5.5=>10.1 is not too big, it has been tested internally to some extent, and a lot of users must have done it by now, no complaints. If you encounter any issues, please file a bug report. Data backup before upgrade is always highly recommended. Regards, Elena
I'm running an older version of Ubuntu (12.04 Precise). Looking at the repo, it looks like I can stick with Precise, and hand that upgrade later. Or are there recommended min version of Ubuntu I should hit first?
Thanks!
Mike
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Hi Michael, On 02/23/2017 10:17 PM, Michael Caplan wrote:
Hi there,
I'm not seeing any concise information in the MariaDB docs about the recommended upgrade plan from MySQL 5.6 to MariaDB 10.1. Should I install MariaDB 10.0 and then 10.1? Or can I run right to 10.1?
I'm running an older version of Ubuntu (12.04 Precise). Looking at the repo, it looks like I can stick with Precise, and hand that upgrade later. Or are there recommended min version of Ubuntu I should hit first?
There is no point installing 10.0 as an intermediate step, you can go directly to 10.1. Precise is okay for now, but I wouldn't recommend to stick with it for long, as it has EOL in 2 months, which means MariaDB might stop producing packages soon afterwards. The next LTS would be a better choice. Data-wise, simple upgrade 5.6 => 10.1 should work all right. That is, you have 5.6 datadir, install MariaDB 10.1, start it with the existing datadir, run mysql_upgrade, it should work. Package-wise, it's a bit more complicated. We are trying to support, whenever possible, upgrade from MySQL/MariaDB packages built by Debian/Ubuntu to MariaDB's packages. But you're using Oracle's own packages, currently we don't monitor or maintain direct upgrade from them, and I'm quite certain it won't "just work". To perform the upgrade, I would recommend to - backup the data dir (in case something goes very wrong); - uninstall all 5.6.x-1ubuntu12.04 packages that you have (don't purge); - add MariaDB 10.1 repo to the source list and install MariaDB; - run mysql_upgrade. Please keep in mind that there are some differences between MariaDB and MySQL 5.6, including (but not limited to) server options. So, if you keep your old config file and if there are options which MariaDB does not have, server startup might choke. You will see in the error log which options it didn't recognize. Regards, Elena
Thanks!
Mike
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
participants (5)
-
Chris Adams -
Elena Stepanova -
Michael Caplan -
mike bayer -
Reindl Harald