• The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

Upgrading mysql questions (CentOS)

Noturns

Regular Pleskian
I have Plesk 12 on Centos 6.6 with MySQL version 5.1.x and i'm considering to update our MySQL core to 5.5 or higher. However the Mysql APT repository supports the following Linux Distros:

Debian - 7
Ubuntu - 12.04 LTS
Ubuntu - 14.04 LTS
Ubuntu - 14.10

Has someone found yum equivalents of apt repositories for CentOS ?

Another question. In the plesk dashboard in Tools & Settings > Database Servers
there you can add Local MySQL Servers. (link to Parallels Plesk manual)

After i have upgraded my CentOS would i still be able to assign or switch to different Mysql versions within Plesk?

Last question are the Local MySQL Servers within Plesk always bases on the Linux MySQL version?

Looking forward in someone their reply
 
Checking if mysql is already installed...
# rpm -q mysql-server
mysql-server-5.1.73-3.el6_5.x86_64


When i do the following command this is the reply i get

# sudo yum localinstall mysql-community-release-el6-5.noarch.rpm
Loaded plugins: fastestmirror, security
Setting up Local Package Process
Cannot open: mysql-community-release-el6-5.noarch.rpm. Skipping.
Nothing to do
 
I first tried the official mysql upgrade and this resulted crashing the mysqld service.

Second attemt installed the Atomic method and this also resulted in crashing the mysqld service. -- Thanks any way for the Atomic suggestion as i never heard of that company

# /etc/init.d/mysqld restart
Stopping mysqld: [ OK ]
MySQL Daemon failed to start.
Starting mysqld: [FAILED]

tail /var/log/mysqld.log
150317 9:37:46 InnoDB: Completed initialization of buffer pool
150317 9:37:46 InnoDB: highest supported file format is Barracuda.
150317 9:37:46 InnoDB: Waiting for the background threads to start
150317 9:37:47 InnoDB: 5.5.42 started; log sequence number 5406293378
150317 9:37:47 [ERROR] Aborting

150317 9:37:47 InnoDB: Starting shutdown...
150317 9:37:47 InnoDB: Shutdown completed; log sequence number 5406293378
150317 9:37:47 [Note]
150317 09:37:47 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

It's a pitty i cant read out the InnoDB events.
I will try the official mysql one more time maybe i looked over something
 
Back
Top