Post by kaji_trade@yahoo.com » Tue Aug 30, 2016 4:03 am

Hi All,

Just want to get some idea? Any one is using mariadb instead mysql?

Seem OpenCart not fully support on this moment?

Thanks


Posts

Joined
Tue May 26, 2015 2:57 pm

Post by artcore » Tue Aug 30, 2016 4:27 am

100% compatible. MariaDB is a drop-in replacement for MySQL

Attn: I no longer provide OpenCart extensions, nor future support - this includes forum posts.
Reason: OpenCart version 3+ ;D

Thanks!


User avatar
Active Member

Posts

Joined
Tue Jul 09, 2013 4:13 am
Location - The Netherlands

Post by fido-x » Tue Aug 30, 2016 10:33 pm

As far as I understand it, MariaDB is not just a "drop-in replacement" for MySQL, it is the new version of MySQL.

Image
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool

If you're not living on the edge ... you're taking up too much space!


User avatar
Expert Member

Posts

Joined
Sat Jun 28, 2008 1:09 am
Location - Tasmania, Australia

Post by artcore » Tue Aug 30, 2016 11:50 pm

Hi Fido-x,
It is. MariaDB is forked from the original MySQL. The original devs went their own way after Oracle bought MySQL.
So both products exist next to each other.

Attn: I no longer provide OpenCart extensions, nor future support - this includes forum posts.
Reason: OpenCart version 3+ ;D

Thanks!


User avatar
Active Member

Posts

Joined
Tue Jul 09, 2013 4:13 am
Location - The Netherlands

Post by fido-x » Wed Aug 31, 2016 12:18 am

Okay. Thanks for the clarification. I guess Oracle couldn't handle the competition.

Image
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool

If you're not living on the edge ... you're taking up too much space!


User avatar
Expert Member

Posts

Joined
Sat Jun 28, 2008 1:09 am
Location - Tasmania, Australia

Post by kaji_trade@yahoo.com » Wed Aug 31, 2016 12:57 am

Hi All,

Thanks the post but anyone is using mariadb on Opencart as daily production? At least OC not state on their requirement, also most extension if involve database still stick on MySQL terms.


Posts

Joined
Tue May 26, 2015 2:57 pm

Post by artcore » Wed Aug 31, 2016 2:20 am

I have all OC versions from 1.5.6 up to 2.3 running on MariaDB on several servers!
I feel its slightly faster than MySQL 5.5 at least.

Attn: I no longer provide OpenCart extensions, nor future support - this includes forum posts.
Reason: OpenCart version 3+ ;D

Thanks!


User avatar
Active Member

Posts

Joined
Tue Jul 09, 2013 4:13 am
Location - The Netherlands

Post by kaji_trade@yahoo.com » Fri Sep 02, 2016 3:36 am

thanks the info.


Posts

Joined
Tue May 26, 2015 2:57 pm

Post by IP_CAM » Fri Sep 02, 2016 11:34 pm

artcore wrote:I have all OC versions from 1.5.6 up to 2.3 running on MariaDB on several servers!
I feel its slightly faster than MySQL 5.5 at least.
---
But since there is no MariaDB Driver in OC 1.5.6, it would be interesting to know,
how you connect this, for someone, always looking for some more peaks ! :D
Ernie

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

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

Post by artcore » Fri Sep 02, 2016 11:52 pm

@Ernie
Any driver would work but I use mysqli ;D

Attn: I no longer provide OpenCart extensions, nor future support - this includes forum posts.
Reason: OpenCart version 3+ ;D

Thanks!


User avatar
Active Member

Posts

Joined
Tue Jul 09, 2013 4:13 am
Location - The Netherlands

Post by IP_CAM » Sat Sep 03, 2016 12:54 am

Oh, so, it needs to be set on the Server only. Well, I use mysqli already, so, I'll have a look on this, whenever
I got my too many full Shop test servers cleaned out. :o
Thanks a lot!
Ernie

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

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

Post by artcore » Sat Sep 03, 2016 4:21 am

Anytime Ernie!

Attn: I no longer provide OpenCart extensions, nor future support - this includes forum posts.
Reason: OpenCart version 3+ ;D

Thanks!


User avatar
Active Member

Posts

Joined
Tue Jul 09, 2013 4:13 am
Location - The Netherlands

Post by Hannah00 » Tue Sep 06, 2016 11:59 am

MariaDB surpasses MySQL as a leader in open source database solutions by delivering enterprise-level high availability, scalability and security.
Opencart will run fine on that platform. MariaDB is a little faster than MySQL, so it makes online store run quick. I did set up OpenCart on my nas server with maria db, but processor and memory is limited. Performance is greatly affected by image size, template design and number of options.

Opencart migration & upgrade tool


User avatar
New member

Posts

Joined
Wed May 04, 2016 5:09 pm
Who is online

Users browsing this forum: No registered users and 17 guests