Post by cooltidecol » Thu Oct 05, 2017 5:40 pm

Hi

I am relatively new to OpenCart so forgive any glaringly obvoius holes in my question.

I am hosting this installation on an Azure Windows 2016 VM
I have successfully set up OpenCart 3.0.2.0 (downloaded from www.opencart.com)
This is powered by PHP7.1.7 on IIS10
The Rewrite is working correctly
The MySQL installation is heart of my question...
During the OpenCart installation I successfully set up the MySQL "Remotely" using ClearDB's remote MySQL service.
I then needed to move it to Azure's New MySQL service. This is for both cost, reliability and convenience.
I used the "Schema Transfer Wizard" in MySQL Workbench to transfer the DB from ClearDB to Azure's new native MySQL service. This was easy and it successfully worked.
My question is regarding MySQL tables. When I installed the original site the tables were MyISAM and after the transfer they are InnoDB.
For clarity I have no performance issues with either and assuming they are both secure I have no preference either.
Azure's MySQL service does not allow MyISAM
So my question is: "Am I likely to encounter issues with extensions or addons if I am restricted to InnoDB tables only?"
So far I have installed the UP! template from http://321cart.com and I have connected to my PayPal account but I'm sure I'll want to extend further...

Thanks in advance for your help

Colin

Newbie

Posts

Joined
Wed Jan 25, 2017 7:37 pm

Post by IP_CAM » Fri Oct 06, 2017 9:52 am

Am I likely to encounter issues with extensions or addons if I am restricted to InnoDB tables only?
NO, it's the most modern way to go ! :D
You should just regularly make sure, that all MyISAM DB Tables are switched to InnoDB, to avoid using
multiple DB Engines, by use of some tools like the famous ATOMIX InnoDB-Changer/DB Full Indexer Tool!
Ernie

Ernie's OpenCart v.1.5.6.5 LIGHT + OpenShop Admin v.1.75 Test Sites
http://www.ebikes.li - http://www.evelo.li - http://www.openshop.li
Image


User avatar
Guru Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland
Who is online

Users browsing this forum: No registered users and 1 guest