Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2007
    Location
    Gijn, Asturias, Spain
    Posts
    1,724
    Plugin Contributions
    25

    Default MariaDB instead of Mysql?

    I generally use the latest Xampp/php version available for local development work to get a very early warning of any future ZC issues as php steadily gets tightened-up, so regularly export/import my varias dbs across different Xampp installations.

    The latest and future Xampp uses mariaDB instead of mysql.

    There are a couple of threads already regarding issues with mariaDB, maybe...
    In fact the latest Xampp to be released with mariaDB was quickly followed by a bug-fix release.

    While I don't intend to upgrade now from the last version of Xampp with mysql until it confirmed as a non-event, do any of the cognoscenti that inhabit this forum have any comments on this tendency of replacing mysql (that appears to be not just restricted to Xampp)?

    i.e. Any other issues that people have come across with this?
    Steve
    github.com/torvista: Apsona (php7), BackupMySQL Admin/Auto, CEON URI Mapping (php7), Image Checker, Redsys payment module, Spanish Language Pack, Structured Data

  2. #2
    Join Date
    Feb 2012
    Location
    mostly harmless
    Posts
    1,811
    Plugin Contributions
    8

    Default Re: MariaDB instead of Mysql?

    While I would not consider myself a "cognoscenti" on the subject, I have also been seeing the same trend... Including some *nix OSes installing MariaDB as the default SQL Server (if using the "server role" tools during installation).

    I am not using XAMPP when testing under MariaDB or MySQL, but using the binary releases in various *nix repositories (and on Windows the official binary packages directly from MariaDB or Oracle).

    Zen Cart 1.5.x has continued to work without any issues for me under MariaDB (including installation). When testing I have stuck with the default storage engine configured as InnoDB (default changed in MariaDB 10.0.9 to XtraDB. In MySQL 5.5 / 5.6 and MariaDB 5.5 - 10.0.8 InnoDB was the default).

    Of course if STRICT (or certain other) sql modes are enabled, the same Zen Cart patches required for MySQL are required for MariaDB.

    Only "gotcha" I've noticed so far is the two include support for different database storage engines (and do not always create fully binary compatible data stores)... So if one needs to be able to "switch" back and forth, best to make sure one uses a database storage engine supported by both (such as InnoDB) and keep backups via SQL exports (not binary backups).
    The glass is not half full. The glass is not half empty. The glass is simply too big!
    Where are the Zen Cart Debug Logs? Where are the HTTP 500 / Server Error Logs?
    Zen Cart related projects maintained by lhngl : Plugin / Module Tracker

  3. #3
    Join Date
    Jan 2004
    Posts
    64,748
    Blog Entries
    6
    Plugin Contributions
    214

    Default Re: MariaDB instead of Mysql?

    v1.5.5-beta and v1.6.0-pre-alpha appear to install and operate fine using MariaDB on Ubuntu 14.04
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

Similar Threads

  1. 1.5.4 runs on mafriadb but will ot install on mariadb
    By soaringeagle in forum Bug Reports
    Replies: 0
    Last Post: 7 Nov 2015, 09:37 PM
  2. will zencart install on mariadb?
    By soaringeagle in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 7 Nov 2015, 04:22 AM
  3. v151 Do ZC 1.5.1, 1.3.9h can install on mariadb DB on CentOS 7?
    By explorer1979 in forum Installing on a Linux/Unix Server
    Replies: 0
    Last Post: 27 Aug 2014, 08:40 AM
  4. Using Access instead of MySQL
    By motor in forum General Questions
    Replies: 5
    Last Post: 17 May 2007, 09:04 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR