Answers.Body: <p>I just wanted to add this in here...I think in terms of safety, it would probably be better to upgrade to the VPS or your own dedicated server. While expensive, I'm not sure I'd be OK with having constituent data on a shared hosting environment.  It would also give you a bit more flexibility in terms of upgrades.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-03-31T15:10:07.673Z
Answers.Text: For many non-profits who rely solely on donor gifts to operate, I agree. For small, member-run non-profits / clubs, the shared environments from reputable providers segregate data sufficiently to meet most CRM and privacy needs. Flexibility would be nice though :-)
Answers.UserDisplayName: Geof Newton
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-03-31T04:29:53.477Z
Answers.LastActivityDate: 2021-03-31T04:29:53.477Z
Answers.UserDisplayName: Taylor Pyles
Answers.Body: <p>Geoff - although I do want to encourage you to upgrade your mysql you are still able to install the free version of CiviCRM on mysql 5.6 at this stage. We are discussing when to stop supporting it over here <a href="https://lab.civicrm.org/dev/core/-/issues/2481" rel="nofollow noreferrer">https://lab.civicrm.org/dev/core/-/issues/2481</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-03-30T14:04:11.937Z
Answers.Text: So to clarify, 5.35 is still supporting MySQL 5.6? The official doc says it needs 5.7+ but I hadn't seen any big notifications or warnings on the 5.34+ releases like I was expecting ~
Answers.UserDisplayName: Geof Newton
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-03-31T04:54:21.610Z
Answers.Text: Yes - we did propose dropping 5.6 support but in the end didn't.
Answers.UserDisplayName: eileen
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-04-01T21:18:34.670Z
Answers.Text: Upgraded to 5.35.1 and all is right with the world :-). The big warning banner about the MySQL version on the db upgrade page is a little unsettling but the upgrade script completed without any issues.
Answers.UserDisplayName: Geof Newton
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-03-30T04:23:25.800Z
Answers.LastActivityDate: 2021-03-30T04:23:25.800Z
Answers.UserDisplayName: eileen
Body: <p>HostGator has frozen their shared platforms at MySQL 5.6 with no plans to offer MySQL 5.7 to the shared packages, even though 5.6 went EOL on February 5th, 2021. They're pushing people to use their Virtual Private Server which is about 10x the cost of shared. So, if you're installing CiviCRM, DON'T host with HostGator.
  We'd like to stay up-to-date on CiviCRM, at least the security fixes, but the only option seems to be to pay for Extended Security Release. Are there any alternatives for those who have been locked out by their hosting platforms?
  cheers ... :) gn</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-03-25T22:09:02.037Z
Comments.Text: care to give indication of the actual monthly costs for existing and VPS?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-03-26T09:00:11.240Z
Comments.Text: I was told the same thing by Siteground UK - it's hard to understand why they would not upgrade MySQL on the shared servers.  However since Siteground's migration from  cPanel to 'Site Tools' also became a problem I migrated my clients to hostinguk.net, solving both problems.
Comments.UserDisplayName: Andy Clark
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-03-26T14:32:02.543Z
Comments.Text: @petednz-fuzion - HostGator's shared platforms range from $2.75/mo (single-site) to $5.25/mo (unlimited sites + static IP). Virtual Private Server is $29.95/mo which, after adding in some of the site add-ons, is getting back to the $90/mo we were paying for hosted CRM :-\
Comments.UserDisplayName: Geof Newton
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-03-27T00:19:33.313Z
Comments.Text: My experience with SiteGround UK has been different to Andy Clark . Yes, they were not prepared to offer MySQL 5.7 on cPanel for shared platforms, but they are migrating all customers away from that to Site Tools. I was worried about the move, thinking I'd loose quite a bit of functionality and have to deal with my test and training sites quite differently. When the move was forced it all went very smoothly and I had MySQL 5.7, I can do everything I need to and some functionality has improved, so I am happy
Comments.UserDisplayName: Mick Kahn
Tags: <mysql><hosting><hosting-providers>
Title: Trapped by MySQL 5.6
ThreadText: # Trapped by MySQL 5.6
  
  (Asked by: username_0 on 2021-03-25)
  
  HostGator has frozen their shared platforms at MySQL 5.6 with no plans to offer MySQL 5.7 to the shared packages, even though 5.6 went EOL on February 5th, 2021. They're pushing people to use their Virtual Private Server which is about 10x the cost of shared. So, if you're installing CiviCRM, DON'T host with HostGator.
  We'd like to stay up-to-date on CiviCRM, at least the security fixes, but the only option seems to be to pay for Extended Security Release. Are there any alternatives for those who have been locked out by their hosting platforms?
  cheers ... :) gn
  
  **Tags:** mysql, hosting, hosting-providers
  
  > **Comments:**
  > **username_1**: care to give indication of the actual monthly costs for existing and VPS?  
  > **username_2**: I was told the same thing by Siteground UK - it's hard to understand why they would not upgrade MySQL on the shared servers.  However since Siteground's migration from  cPanel to 'Site Tools' also became a problem I migrated my clients to hostinguk.net, solving both problems.  
  > **username_0**: @petednz-fuzion - HostGator's shared platforms range from $2.75/mo (single-site) to $5.25/mo (unlimited sites + static IP). Virtual Private Server is $29.95/mo which, after adding in some of the site add-ons, is getting back to the $90/mo we were paying for hosted CRM :-\  
  > **username_3**: My experience with SiteGround UK has been different to username_2 . Yes, they were not prepared to offer MySQL 5.7 on cPanel for shared platforms, but they are migrating all customers away from that to Site Tools. I was worried about the move, thinking I'd loose quite a bit of functionality and have to deal with my test and training sites quite differently. When the move was forced it all went very smoothly and I had MySQL 5.7, I can do everything I need to and some functionality has improved, so I am happy  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_5 on 2021-03-30. Score: 3 | Accepted answer
  
  Geoff - although I do want to encourage you to upgrade your mysql you are still able to install the free version of CiviCRM on mysql 5.6 at this stage. We are discussing when to stop supporting it over here <https://lab.civicrm.org/dev/core/-/issues/2481>
  
  > **Comments:**
  > **username_0**: So to clarify, 5.35 is still supporting MySQL 5.6? The official doc says it needs 5.7+ but I hadn't seen any big notifications or warnings on the 5.34+ releases like I was expecting ~  
  > **username_5**: Yes - we did propose dropping 5.6 support but in the end didn't.  
  > **username_0**: Upgraded to 5.35.1 and all is right with the world :-). The big warning banner about the MySQL version on the db upgrade page is a little unsettling but the upgrade script completed without any issues.  
  
  ---
  
  ### Answer by username_4 on 2021-03-31. Score: 1
  
  I just wanted to add this in here...I think in terms of safety, it would probably be better to upgrade to the VPS or your own dedicated server. While expensive, I'm not sure I'd be OK with having constituent data on a shared hosting environment. It would also give you a bit more flexibility in terms of upgrades.
  
  > **Comments:**
  > **username_0**: For many non-profits who rely solely on donor gifts to operate, I agree. For small, member-run non-profits / clubs, the shared environments from reputable providers segregate data sufficiently to meet most CRM and privacy needs. Flexibility would be nice though :-)  
  
  ---
  
  