Forum

Thread tagged as: Question, Hosting

MySQL Upgrade from 5.5 to 5.6. Running Perch 2.8.26. Concerns?

Hello!

My web host just announced they will be upgrading from MySQL 5.5 to 5.6 on April 20th. Is there any reason I should be concerned for my client's version of Perch or Perch in general? I can find no information about a maximum version of MySQL for Perch, just a minimum.

My client is on a tight upgrade schedule for budget reasons, and bringing Perch up-to-date to the current version wasn't planned until next month, but I will move the schedule up if there are concerns.

Full diagnostics below. (Some lines removed for privacy)

PERCH INFORMATION

Perch: 2.8.26
Production mode: Production (100)
Installed apps: content (2.8.26), assets (2.8.26), categories (2.8.26), perch_blog (5.0), perch_forms (1.8.3), perch_podcasts (1.2), perch_twitter (3.5.1)
DB driver: PDO
DB tables: perch2_blog_authors (6), perch2_blog_comments (1441), perch2_blog_index (6050), perch2_blog_posts (147), perch2_blog_posts_to_tags (742), perch2_blog_sections (1), perch2_blog_tags (492), perch2_blogs (1), perch2_categories (21), perch2_category_counts (13), perch2_category_sets (2), perch2_content_index (1725), perch2_content_items (265), perch2_content_regions (21), perch2_forms (3), perch2_forms_responses (421), perch2_navigation (2), perch2_navigation_pages (43), perch2_page_templates (5), perch2_pages (14), perch2_podcasts (1), perch2_podcasts_downloads (15909), perch2_podcasts_episodes (52), perch2_resource_log (213), perch2_resource_tags (2), perch2_resources (93), perch2_resources_to_tags (4), perch2_settings (33), perch2_twitter_scheduled_tweets (0), perch2_twitter_settings (1), perch2_twitter_tweets (221), perch2_user_passwords (0), perch2_user_privileges (45), perch2_user_role_privileges (37), perch2_user_roles (3), perch2_users (4)
Users: 4
App runtimes:
<?php
    $apps_list = array(
        'content', 
        'categories',
        'perch_blog',
        'perch_forms',
        'perch_podcasts',
        'perch_twitter'
    );
Scheduled tasks for perch_blog: delete_spam_comments (1440 mins)
Scheduled tasks for perch_twitter: post_tweets (1 mins)
Editor plug-ins: markitup, redactor
H1: eca6510a59c75187a891054212b5302d
L1: 7329a6b741e1afaf9f6a964ef537216d
F1: 2edba60ed1f613d6dd804feb202456a2
headerColour: #b9c095
content_singlePageEdit: 1
helpURL:
siteURL: /
hideBranding: 0
content_collapseList: 1
lang: en-gb
update_2.8.7: done
latest_version: 2.8.15
on_sale_version: 2.8.29
headerScheme: light
content_frontend_edit: 1
dashboard: 1
hide_pwd_reset: 0
content_hideNonEditableRegions: 1
perch_blog_post_url: /blog/{postSlug}/
perch_blog_slug_format: %Y/%m/%d/{postTitle}
perch_blog_akismet_key: 9bae445cf88f
perch_blog_max_spam_days: 7
perch_blog_comment_notify: 1
perch_blog_update: 5.0.1
perch_twitter_update: 3.5
update_2.8.8: done
update_2.8.10: done
update_2.8.11: done
update_2.8.13: done
update_2.8.14: done
update_2.8.16: done
update_2.8.18: done
perch_blog_site_name:
update_2.8.26: done
PERCH_DEVELOPMENT: 10
PERCH_STAGING: 50
PERCH_PRODUCTION: 100
PERCH_DB_PREFIX: perch2_
PERCH_TZ: America/Los_Angeles
PERCH_LOGINPATH: /perch
PERCH_RESPATH: /perch/resources
PERCH_HTML5: 1
PERCH_RWD: 1
PERCH_RUNWAY:
PERCH_ERROR_MODE: DIE
PERCH_DATE_LONG: %d %B %Y
PERCH_DATE_SHORT: %d %b %Y
PERCH_TIME_SHORT: %H:%M
PERCH_TIME_LONG: %H:%M:%S
PERCH_RUNWAY_ROUTED:
PERCH_STRONG_PASSWORDS:
PERCH_DEBUG:
PERCH_PREVIEW_ARG: preview
PERCH_DEFAULT_DOC: index.php
PERCH_DEFAULT_EXT: .php
PERCH_PRODUCTION_MODE: 100
PERCH_HTML_ENTITIES:
PERCH_SSL:
PERCH_STRIPSLASHES:
PERCH_PROGRESSIVE_FLUSH: 1
PERCH_PARANOID:
PERCH_FORCE_SECURE_COOKIES:
PERCH_PASSWORD_MIN_LENGTH: 6
PERCH_MAX_FAILED_LOGINS: 10
PERCH_AUTH_LOCKOUT_DURATION: 1 HOUR
PERCH_VERIFY_UPLOADS:
PERCH_AUTH_PLUGIN:
PERCH_DB_CHARSET: utf8
PERCH_DB_PORT:
PERCH_DB_SOCKET:
PERCH_SESSION_TIMEOUT_MINS: 20
PERCH_APPS_EDITOR_PLUGIN: markitup
PERCH_APPS_EDITOR_MARKUP_LANGUAGE: textile
HOSTING SETTINGS

PHP: 5.6.19
Zend: 2.6.0
OS: FreeBSD
SAPI: cgi-fcgi
Safe mode: not detected
MySQL client: mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
MySQL server: 5.5.47-log
Free disk space: 1.68 TB
Extensions: Core, date, ereg, libxml, openssl, pcre, sqlite3, zlib, bcmath, bz2, calendar, ctype, curl, dba, dom, hash, fileinfo, filter, ftp, gd, gettext, gmp, SPL, iconv, session, intl, json, ldap, mbstring, mcrypt, mssql, standard, mysqlnd, mysqli, odbc, pcntl, mysql, PDO, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, pspell, Reflection, imap, SimpleXML, soap, sockets, exif, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, cgi-fcgi, PDFlib, mhash
GD: Yes
ImageMagick: No
PHP max upload size: 4M
PHP max form post size: 8M
PHP memory limit: 128M
Total max uploadable file size: 4M
Resource folder writeable: Yes
Session timeout: 24 minutes
Native JSON: Yes
Filter functions: Yes
Transliteration functions: Yes
PATH: /bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin
ORIG_SCRIPT_NAME: /fcgi-bin/php5_wrapper.sh
ORIG_PATH_INFO: /perch/core/settings/diagnostics/index.php
SCRIPT_NAME: /perch/core/settings/diagnostics/index.php
REQUEST_URI: /perch/core/settings/diagnostics/?extended
QUERY_STRING: extended
REQUEST_METHOD: GET
SERVER_PROTOCOL: HTTP/1.1
GATEWAY_INTERFACE: CGI/1.1
REDIRECT_URL: /perch/core/settings/diagnostics/index.php
REDIRECT_QUERY_STRING: extended
REMOTE_PORT: 56601
SERVER_SOFTWARE: Apache/2.2.31
HTTP_ACCEPT_ENCODING: gzip, deflate
HTTP_ACCEPT_LANGUAGE: en-us
HTTP_USER_AGENT: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_3) AppleWebKit/601.4.4 (KHTML, like Gecko) Version/9.0.3 Safari/601.4.4
HTTP_COOKIE: PHPSESSID=o95n975ev7167bv40pv5usu8i1; __atuvc=1%7C53%2C4%7C21%2C1%7C22; cmsa=1; __utma=114422544.1858519435.1419904235.1440173896.1440184812.23; _ga=GA1.2.1858519435.1419904235; _gat=1
HTTP_CONNECTION: close
HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
UNIQUE_ID: Vw-UdNiSwzYAATVcbGgAAAA0
REDIRECT_STATUS: 200
REDIRECT_HANDLER: application/x-httpd-php
REDIRECT_UNIQUE_ID: Vw-UdNiSwzYAATVcbGgAAAA0
FCGI_ROLE: RESPONDER
PHP_SELF: /perch/core/settings/diagnostics/index.php
REQUEST_TIME_FLOAT: 1460655220.0102
REQUEST_TIME: 1460655220
Abby Larsen

Abby Larsen 0 points

  • 5 years ago
Simon Clay

Simon Clay 127 points

No problems there. Perch will run even up to the latest PHP7 :)

Abby Larsen

Abby Larsen 0 points
Registered Developer

Thanks, Simon! I'll take your word for it, then. :)

Simon Clay

Simon Clay 127 points

:) ha ha thanks, the boss says so too...

https://forum.grabaperch.com/forum/12-14-2015-perch-and-php-7

Abby Larsen

Abby Larsen 0 points
Registered Developer

I'd be happier if that message mentioned MySQL 5.6! I've noticed that some folks in the forum have diagnostics which include MySQL 5.6, so it must work, right? Still, confirmation from the horse's mouth would be nice. :)

Simon Clay

Simon Clay 127 points

Yes indeed. I have quite a few sites running on PHP 5.6 and it's confirmed in this article (right at the end).

Abby Larsen

Abby Larsen 0 points
Registered Developer

Ah. But I was wondering about MySQL not PHP! :D

Rachel Andrew

Rachel Andrew 394 points
Perch Support

That shouldn't be a problem.