3,250
edits
Changes
Jump to navigation
Jump to search
Line 6:
Line 6: + − + − + Line 16:
Line 17: − this RPM will allow you to have 2 versions of mysql running!!! − see also for reference: [[Software_Collections:MySQL]] + Line 30:
Line 30: − {{warning box| this is still alpha, only for testing }} − + − +
no edit summary
</blockquote>
</blockquote>
__TOC__
__TOC__
{{Note box| Mysql 5.7 support is up to 31 Oct 2023 so 8 months before SME10 EOL which is 30 June 2024.}}
== Description ==
== Description ==
This contrib purpose is to help configuring mysql57 on SME9 using software collection.
This contrib purpose is to help configuring mysql57 on SME9 and above using software collection.
This RPM will allow you to have 2 versions of Mysql running side by side. You will have to select the one to use in the setup of the specific application - please see "usage" below. Please note that applications and contribs like phpmyadmin etc. will as standard use the original Mysql DBM for your OS unless you change the database connection to Mysql 5.7.
This RPM will allow you to have 2 or more (if also using another contrib for another sclo version) versions of MySQL running side by side. You will have to select the one to use in the setup of the specific application - please see "usage" below. Please note that applications and contribs like phpmyadmin etc. will as standard use the original Mysql DBM for your OS unless you change the database connection to Mysql 5.7.
Most of configuration options are explained for mysql here : [[MySQL]] are also available for mysql57 ( except innoDB options). Only difference is to prefix mysqld and mysql.init db entry by "mysql57-".
Most of configuration options are explained for mysql here : [[MySQL]] are also available for mysql57 ( except innoDB options). Only difference is to prefix mysqld and mysql.init db entry by "mysql57-".
Note that default behaviour will be socket only, and if you enable networking, it will listen on 3309 locally. You then will need to open port to 3309 to access remotely. Also if you want another port you need to define mysql57-mysqld property port to whatever you want. Also remember that default mysql port is reserved to original mysql server
Note that default behaviour will be socket only, and if you enable networking, it will listen on 3309 locally. You then will need to open port to 3309 to access remotely. Also if you want another port you need to define mysql57-mysqld property port to whatever you want. Also remember that default mysql port is reserved to original mysql server
See also for reference: [[Software_Collections:MySQL]]
For SME9 Software collection is only available for x64 architectures.
For SME9 Software collection is only available for x64 architectures.
==Installation==
==Installation==
<tabs container><tab name="For SME 10">
<tabs container><tab name="For SME 10">
yum install smeserver-extrarepositories-centos-sclo -y
yum install smeserver-extrarepositories-centos-sclo -y
yum install --enablerepo=smecontribs,centos-sclo-rh,smetest,smedev smeserver-mysql57
yum install --enablerepo=smecontribs,centos-sclo-rh smeserver-mysql57
source /etc/profile.d/mysql57.sh
source /etc/profile.d/mysql57.sh
and enjoy mysql57, no more command nor reboot required !
and enjoy mysql57, no more commands nor reboot required !
</tab>
</tab>
<tab name="For SME 9">
<tab name="For SME 9">