CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • MySQL 5.6
Pages: [1]

Author Topic: MySQL 5.6  (Read 1039 times)

sggreener

  • I post occasionally
  • **
  • Posts: 35
  • Karma: 0
    • The SpatialDB Advisor
  • CiviCRM version: 4.6.15
  • CMS version: Joomla 5.5.1
  • MySQL version: 5.6.29
  • PHP version: 5.3.8
MySQL 5.6
August 06, 2012, 04:33:31 am
My site is running:

Joomla! 2.5.6 Stable
MySQL 5.5.24
Php 5.3.13
CiviCRM 4.1.2

I was wondering whether it was possible to upgrade MySQL to version 5.6?

regards
Simon

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: MySQL 5.6
August 06, 2012, 07:21:57 am
Hi. Is there a certain reason you have for wanting 5.6? Some new feature or something?
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

sggreener

  • I post occasionally
  • **
  • Posts: 35
  • Karma: 0
    • The SpatialDB Advisor
  • CiviCRM version: 4.6.15
  • CMS version: Joomla 5.5.1
  • MySQL version: 5.6.29
  • PHP version: 5.3.8
Re: MySQL 5.6
August 06, 2012, 11:22:40 pm
Yes there is. In MySQL 5.6 searching spatial data now is done geometrically other than by mbr/envelope. So, I can find say a census tract which actually contains a specific point. This is not possible before MySQL 5.6.
regards
Simon

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: MySQL 5.6
August 06, 2012, 11:39:33 pm

you should give it a try with 5.6 and see what if anything breaks

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

sggreener

  • I post occasionally
  • **
  • Posts: 35
  • Karma: 0
    • The SpatialDB Advisor
  • CiviCRM version: 4.6.15
  • CMS version: Joomla 5.5.1
  • MySQL version: 5.6.29
  • PHP version: 5.3.8
Re: MySQL 5.6
August 07, 2012, 04:17:05 am
Thanks.

Do you know if any tests have been run by the CiviCRM developers against the new version or if the new version will be supported in the next release? I'm on CiviHosting shared services so updating myself won't be possible. I can certainly try it on a standalone VM.

regards
Simon

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: MySQL 5.6
August 07, 2012, 05:59:07 am
The odds are low of anyone testing in the near future yet high that it will just work. You could certainly test it fairly easily.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: MySQL 5.6
August 07, 2012, 07:27:16 am

None of the developers we know of are using 5.6 and highly unlikely that any of us will upgrade anytime soon

Is 5.6 main stream as yet? Seemed fairly hard to find it on the mysql.com pages

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • MySQL 5.6

This forum was archived on 2017-11-26.