{"id":312,"date":"2019-10-17T17:22:21","date_gmt":"2019-10-17T21:22:21","guid":{"rendered":"https:\/\/www.phmsciences.com\/blog\/?p=312"},"modified":"2019-10-17T17:32:16","modified_gmt":"2019-10-17T21:32:16","slug":"updating-mariadb-10-2-to-10-3-in-centos-7","status":"publish","type":"post","link":"https:\/\/www.phmsciences.com\/blog\/updating-mariadb-10-2-to-10-3-in-centos-7\/","title":{"rendered":"Upgrading from MariaDB 10.2 to MariaDB 10.3 on CentOS 7"},"content":{"rendered":"<p>Just updated MariaDB from 10.2 to 10.3 on multiple servers using Red Hat&#8217;s Software Collections (https:\/\/www.softwarecollections.org\/en\/). Used the following commands. Might be of use to someone, good luck!<\/p>\n<pre># Install MariaDB 10.3\nyum install rh-mariadb103-mariadb-server\nyum install rh-mariadb103-mariadb-server-utils\n\n# Add MariaDB 10.3 to $PATH\nscl enable rh-mariadb103 bash\nsource \/opt\/rh\/rh-mariadb103\/enable\n\n# Stop 10.2 server, copy database, set permissions, start 10.3 server\nsystemctl stop rh-mariadb102-mariadb.service;\ncp -r \/var\/opt\/rh\/rh-mariadb102\/lib\/mysql \/var\/opt\/rh\/rh-mariadb103\/lib;\nchown -R mysql:mysql \/var\/opt\/rh\/rh-mariadb103\/lib\/mysql;\nsystemctl start rh-mariadb103-mariadb\n\n# Upgrade tables\nmysql_upgrade -p[PASSWORD]\n\n# Set 10.3 to start on boot, disable 10.2\nsystemctl disable rh-mariadb102-mariadb\nsystemctl enable rh-mariadb103-mariadb\n\n# Add 10.3 to paths on reboot (and remove 10.2) \nrm \/etc\/profile.d\/rh-mariadb102.sh\ncp \/opt\/rh\/rh-mariadb103\/enable \/etc\/profile.d\/rh-mariadb103.sh\n\n<\/pre>\n<p>Don\u00e2\u20ac\u2122t forget to edit your new database configuration file, which is located at <code>\/etc\/opt\/rh\/rh-mariadb103\/my.cnf<\/code>. Your old configuration will be at <code>\/etc\/opt\/rh\/rh-mariadb102\/my.cnf<\/code>. The <code>\/my.cnf.d\/<\/code> subdirectory at the same location may contain additional configuration files.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Just updated MariaDB from 10.2 to 10.3 on multiple servers using Red Hat&#8217;s Software Collections (https:\/\/www.softwarecollections.org\/en\/). Used the following commands. Might be of use to someone, good luck! # Install MariaDB 10.3 yum install rh-mariadb103-mariadb-server yum install rh-mariadb103-mariadb-server-utils # Add MariaDB 10.3 to $PATH scl enable rh-mariadb103 bash source \/opt\/rh\/rh-mariadb103\/enable # Stop 10.2 server, copy [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[21,20,22],"class_list":["post-312","post","type-post","status-publish","format-standard","hentry","category-linux","tag-centos","tag-linux","tag-mariadb"],"_links":{"self":[{"href":"https:\/\/www.phmsciences.com\/blog\/wp-json\/wp\/v2\/posts\/312","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.phmsciences.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.phmsciences.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.phmsciences.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.phmsciences.com\/blog\/wp-json\/wp\/v2\/comments?post=312"}],"version-history":[{"count":10,"href":"https:\/\/www.phmsciences.com\/blog\/wp-json\/wp\/v2\/posts\/312\/revisions"}],"predecessor-version":[{"id":322,"href":"https:\/\/www.phmsciences.com\/blog\/wp-json\/wp\/v2\/posts\/312\/revisions\/322"}],"wp:attachment":[{"href":"https:\/\/www.phmsciences.com\/blog\/wp-json\/wp\/v2\/media?parent=312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.phmsciences.com\/blog\/wp-json\/wp\/v2\/categories?post=312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.phmsciences.com\/blog\/wp-json\/wp\/v2\/tags?post=312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}