Simple Upgrade question for MariaDB Database Servers from 5.5.68 to 10.5.

[bibleman]

I am wanting to upgrade my MariaDB Database Servers from 5.5.68 to 10.5.

I have oscommerce 2.3.4 heavily modified.

Just a question if anyone knows or has made this upgrade.

Does upgrading this database server affect any older sites on VPS such as an older oscommerce application (https://www.ministryhelps.com) ???

In other words is it backwards compatible? 

Plesk allows me to do this from inside my control panel, very easily as I have read.

https://support.plesk.com/hc/en-us/articles/12388091703703--How-to-upgrade-MySQL-5-5-to-5-6-5-7-or-MariaDB-5-5-to-10-x-on-Linux

Thanks 

Leon

[Jack_mcs]

We did that upgrade a few years ago. As I recall, there were a few older sites using passwords that were too simple that failed but that was a quick fix. MariaDB 10.6 is the latest stable version so you should upgrade to it instead of 10.5. In one of the versions, they added an option to revert back but I never tested that feature. For what it is worth, we have upgraded MariaDB twice on a server that has versions of oscommerce starting with 2.2 (MS2), as well as various other platforms and never had any issues, except the one above.

[bibleman]

15 hours ago, Jack_mcs said:

We did that upgrade a few years ago. As I recall, there were a few older sites using passwords that were too simple that failed but that was a quick fix. MariaDB 10.6 is the latest stable version so you should upgrade to it instead of 10.5. In one of the versions, they added an option to revert back but I never tested that feature. For what it is worth, we have upgraded MariaDB twice on a server that has versions of oscommerce starting with 2.2 (MS2), as well as various other platforms and never had any issues, except the one above.

Thanks so much!

Your advice worked beautifully - no issues whatsoever.

I did notice a problem, that was there before I ran the update however.
 

Quote

 

Problems with indexes of table `wp_posts`

http://216.14.120.159:8880/phpMyAdmin/themes/dot.gif The indexes post_parent and sm_idx_post_parent seem to be equal and one of them could possibly be removed.

Indexes http://216.14.120.159:8880/phpMyAdmin/themes/dot.gif

http://216.14.120.159:8880/phpMyAdmin/themes/dot.gif The indexes post_parent and sm_idx_post_parent seem to be equal and one of them could possibly be removed.

Action			Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
http://216.14.120.159:8880/phpMyAdmin/themes/dot.gif Edit	http://216.14.120.159:8880/phpMyAdmin/themes/dot.gif Rename	http://216.14.120.159:8880/phpMyAdmin/themes/dot.gif Drop	PRIMARY	BTREE	Yes	No	ID	613	A	No
http://216.14.120.159:8880/phpMyAdmin/themes/dot.gif Edit	http://216.14.120.159:8880/phpMyAdmin/themes/dot.gif Rename	http://216.14.120.159:8880/phpMyAdmin/themes/dot.gif Drop	post_name	BTREE	No	No	post_name (191)	613	A	No
http://216.14.120.159:8880/phpMyAdmin/themes/dot.gif Edit	http://216.14.120.159:8880/phpMyAdmin/themes/dot.gif Rename	http://216.14.120.159:8880/phpMyAdmin/themes/dot.gif Drop	type_status_date	BTREE	No	No	post_type	36	A	No
							post_status	47	A	No
							post_date	613	A	No
							ID	613	A	No
http://216.14.120.159:8880/phpMyAdmin/themes/dot.gif Edit	http://216.14.120.159:8880/phpMyAdmin/themes/dot.gif Rename	http://216.14.120.159:8880/phpMyAdmin/themes/dot.gif Drop	post_parent	BTREE	No	No	post_parent	204	A	No
http://216.14.120.159:8880/phpMyAdmin/themes/dot.gif Edit	http://216.14.120.159:8880/phpMyAdmin/themes/dot.gif Rename	http://216.14.120.159:8880/phpMyAdmin/themes/dot.gif Drop	post_author	BTREE	No	No	post_author	8	A	No
http://216.14.120.159:8880/phpMyAdmin/themes/dot.gif Edit	http://216.14.120.159:8880/phpMyAdmin/themes/dot.gif Rename	http://216.14.120.159:8880/phpMyAdmin/themes/dot.gif Drop	sm_idx_post_parent	BTREE	No	No	post_parent	204	A	No
http://216.14.120.159:8880/phpMyAdmin/themes/dot.gif Edit	http://216.14.120.159:8880/phpMyAdmin/themes/dot.gif Rename	http://216.14.120.159:8880/phpMyAdmin/themes/dot.gif Drop	sm_idx_post_date	BTREE	No	No	post_date	613	A	No

 

 

Is all I have to do... is simply drop one of the indexes that is mentioned in the warning:  either the post_parent or the sm_idx_post_parent  ???

Will this help speed up the database?

Thanks

Leon