I’ve hit cpanel update “blocker” the other day going from version 11.38 to 11.40.
|
1 |
[20131113.193112] E Blocker found: Newer releases of cPanel & WHM are not compatible with your MySQL version: 5.0. Upgrade your MySQL server to a version greater or equal to 5.1 |
cPanel update demands to upgrade MySQL and would not take no for an answer – why?
MySQL version 5.1 hits end-of-life on December 2013 and even though Red Hat mysql 5.0 is different from vanilla version and has to be supported until the end of Centos 5 support, cPanel wants to cover all bases and we really don’t have a choice in the situation.
Now, what we should to to continue?
The answer lays in the problem description – if you click on details link you will see following popup frame:
Now, when you click MySQL upgrade link you will be directed to “Software->MySQL Upgrade” WHM menu.
You will be present with choice of 3 MySQL versions – yours 5.0 which is no good anymore, 5.1 and 5.5. Since 5.1 support is about to end it will make more sense to skip it and do the upgrade right to the MySQL version 5.5.
It would be wise to take a time to do full database backup. After that you can continue with the WHM wizard to upgrade MySQL which will involve 1 more interactive step and then automatic package installation, database conversion and rebuilding PHP with the latest MySQL libs.
Word of caution – make sure that your current MySQL config file /etc/my.cnf is compatible with MySQL 5.5 version and you have /var/run/mysqld directory that belong to mysql user and group.
Here is my minimal my.cnf that could be safely used for MySQL ver 5.5 and further adjusted for your needs.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql tmpdir=/dev/shm old_passwords=1 max_connections = 200 max_allowed_packet = 1024M #log-queries-not-using-indexes log_slow_queries = /tmp/slow_log long_query_time = 6 key_buffer = 150M myisam_sort_buffer_size = 4M join_buffer_size = 64M read_buffer_size = 1M sort_buffer_size = 1M table_cache = 128K thread_cache_size = 96K wait_timeout = 30 connect_timeout = 30 #innodb-file-per-table innodb_buffer_pool_size = 540M innodb_flush_method=O_DIRECT innodb_flush_log_at_trx_commit = 1 query_cache_limit = 8M query_cache_size = 128M query_cache_type = 1 query_prealloc_size = 163840 query_alloc_block_size = 32768 open_files_limit=10406 [mysql.server] user=mysql #basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid |
After making sure that all steps of MySQL upgrade were complete you can click details links again and then use updates link to re-run cPanel update. This time it should complete successfully.
0 Comments.