What is DB compatibility for MariaDB

[matrixbegins]

HI Guys,
I am very excited about the Magento 2 launch. I am running MariaDB 5.5 which is not supported by Magento. What other version of MariaDB are supported by Magento? or is MariaDB even supported.

[kandy]

MariaDB 10

[matrixbegins]

Thanks!

[TexanHogman]

To clarify, with Magento 2 we have test environments for our CI process. In order for us to claim support for any component we must be able to repeatedly validate with every code push. We have not added MariaDB so we can't claim official support. Compatibility is a different story and we have heard success stories with MariaDB but since we aren't testing with every code delivery, we rely on the community for validation. Hopefully this helps differentiate supported versus compatible

[ihor-sviziev]

I see that we have installation mysql 5.6 before running tests, can we add same installation for mariadb and perform required tests with mariadb?

[matrixbegins]

I am not sure if it's a contribution or not. I installed Magento with Maria DB 10.
It worked great. However during DB installation halted while importing user configurations. Please see followings:

Starting Magento installation:
File permissions check...

Enabling Maintenance Mode...

Installing deployment configuration...

Installing database schema:
Schema creation/updates:
Module 'Magento_Core':
Include /var/www/magento2/app/code/Magento/Core/sql/core_setup/install-2.0.0.php

Module 'Magento_Store':
Include /var/www/magento2/app/code/Magento/Store/sql/store_setup/install-2.0.0.php

Module 'Magento_Directory':
Include /var/www/magento2/app/code/Magento/Directory/sql/directory_setup/install-2.0.0.php

Module 'Magento_Backup':

Module 'Magento_Theme':

Module 'Magento_Eav':
Include /var/www/magento2/app/code/Magento/Eav/sql/eav_setup/install-2.0.0.php

Module 'Magento_Customer':
Include /var/www/magento2/app/code/Magento/Customer/sql/customer_setup/install-2.0.0.php

Module 'Magento_CatalogImportExport':

Module 'Magento_Indexer':
Include /var/www/magento2/app/code/Magento/Indexer/sql/indexer_setup/install-2.0.0.php

Module 'Magento_Cms':
Include /var/www/magento2/app/code/Magento/Cms/sql/cms_setup/install-2.0.0.php

Module 'Magento_Backend':

Module 'Magento_Catalog':
Include /var/www/magento2/app/code/Magento/Catalog/sql/catalog_setup/install-2.0.0.php

Module 'Magento_Rule':

Module 'Magento_CatalogInventory':
Include /var/www/magento2/app/code/Magento/CatalogInventory/sql/cataloginventory_setup/install-2.0.0.php

Module 'Magento_Payment':

Module 'Magento_CheckoutAgreements':
Include /var/www/magento2/app/code/Magento/CheckoutAgreements/sql/checkoutagreements_setup/install-2.0.0.php

Module 'Magento_Sales':
Include /var/www/magento2/app/code/Magento/Sales/sql/sales_setup/install-2.0.0.php

Module 'Magento_CmsUrlRewrite':

Module 'Magento_ConfigurableImportExport':

Module 'Magento_Msrp':

Module 'Magento_Contact':

Module 'Magento_AdminNotification':
Include /var/www/magento2/app/code/Magento/AdminNotification/sql/adminnotification_setup/install-2.0.0.php

Module 'Magento_Cron':
Include /var/www/magento2/app/code/Magento/Cron/sql/cron_setup/install-2.0.0.php

Module 'Magento_Widget':
Include /var/www/magento2/app/code/Magento/Widget/sql/widget_setup/install-2.0.0.php

Module 'Magento_Bundle':
Include /var/www/magento2/app/code/Magento/Bundle/sql/bundle_setup/install-2.0.0.php

Module 'Magento_CustomerImportExport':

Module 'Magento_DesignEditor':
Include /var/www/magento2/app/code/Magento/DesignEditor/sql/designeditor_setup/install-2.0.0.php

Module 'Magento_Dhl':

Module 'Magento_Authorization':
Include /var/www/magento2/app/code/Magento/Authorization/sql/authorization_setup/install-2.0.0.php

Module 'Magento_Downloadable':
Include /var/www/magento2/app/code/Magento/Downloadable/sql/downloadable_setup/install-2.0.0.php

Module 'Magento_Checkout':

Module 'Magento_Email':
Include /var/www/magento2/app/code/Magento/Email/sql/email_setup/install-2.0.0.php

Module 'Magento_Fedex':

Module 'Magento_GiftMessage':
Include /var/www/magento2/app/code/Magento/GiftMessage/sql/giftmessage_setup/install-2.0.0.php

Module 'Magento_GoogleAdwords':

Module 'Magento_GoogleAnalytics':

Module 'Magento_GoogleOptimizer':
Include /var/www/magento2/app/code/Magento/GoogleOptimizer/sql/googleoptimizer_setup/install-2.0.0.php

Module 'Magento_GoogleShopping':
Include /var/www/magento2/app/code/Magento/GoogleShopping/sql/googleshopping_setup/install-2.0.0.php

Module 'Magento_GroupedImportExport':

Module 'Magento_GroupedProduct':

Module 'Magento_ImportExport':
Include /var/www/magento2/app/code/Magento/ImportExport/sql/importexport_setup/install-2.0.0.php

Module 'Magento_CatalogRule':
Include /var/www/magento2/app/code/Magento/CatalogRule/sql/catalogrule_setup/install-2.0.0.php

Module 'Magento_User':
Include /var/www/magento2/app/code/Magento/User/sql/user_setup/install-2.0.0.php

Module 'Magento_LayeredNavigation':

Module 'Magento_Log':
Include /var/www/magento2/app/code/Magento/Log/sql/log_setup/install-2.0.0.php

Module 'Magento_ConfigurableProduct':
Include /var/www/magento2/app/code/Magento/ConfigurableProduct/sql/configurableproduct_setup/install-2.0.0.php

Module 'Magento_Multishipping':

Module 'Magento_Newsletter':
Include /var/www/magento2/app/code/Magento/Newsletter/sql/newsletter_setup/install-2.0.0.php

Module 'Magento_OfflinePayments':

Module 'Magento_SalesRule':
Include /var/www/magento2/app/code/Magento/SalesRule/sql/salesrule_setup/install-2.0.0.php

Module 'Magento_PageCache':

Module 'Magento_Centinel':

Module 'Magento_Persistent':
Include /var/www/magento2/app/code/Magento/Persistent/sql/persistent_setup/install-2.0.0.php

Module 'Magento_ProductAlert':
Include /var/www/magento2/app/code/Magento/ProductAlert/sql/productalert_setup/install-2.0.0.php

Module 'Magento_Reports':
Include /var/www/magento2/app/code/Magento/Reports/sql/reports_setup/install-2.0.0.php

Module 'Magento_RequireJs':

Module 'Magento_Review':
Include /var/www/magento2/app/code/Magento/Review/sql/review_setup/install-2.0.0.php

Module 'Magento_Rss':

Module 'Magento_CatalogWidget':

Module 'Magento_Captcha':
Include /var/www/magento2/app/code/Magento/Captcha/sql/captcha_setup/install-2.0.0.php

Module 'Magento_OfflineShipping':
Include /var/www/magento2/app/code/Magento/OfflineShipping/sql/offlineshipping_setup/install-2.0.0.php

Module 'Magento_Search':
Include /var/www/magento2/app/code/Magento/Search/sql/search_setup/install-2.0.0.php

Module 'Magento_Sendfriend':
Include /var/www/magento2/app/code/Magento/Sendfriend/sql/sendfriend_setup/install-2.0.0.php

Module 'Magento_Shipping':

Module 'Magento_Sitemap':
Include /var/www/magento2/app/code/Magento/Sitemap/sql/sitemap_setup/install-2.0.0.php

Module 'Magento_CatalogSearch':
Include /var/www/magento2/app/code/Magento/CatalogSearch/sql/catalogsearch_setup/install-2.0.0.php

Module 'Magento_Tax':
Include /var/www/magento2/app/code/Magento/Tax/sql/tax_setup/install-2.0.0.php

Module 'Magento_TaxImportExport':

Module 'Magento_CatalogUrlRewrite':
Include /var/www/magento2/app/code/Magento/CatalogUrlRewrite/sql/catalogurlrewrite_setup/install-2.0.0.php

Module 'Magento_Translation':
Include /var/www/magento2/app/code/Magento/Translation/sql/translation_setup/install-2.0.0.php

Module 'Magento_Ui':

Module 'Magento_Ups':

Module 'Magento_UrlRewrite':
Include /var/www/magento2/app/code/Magento/UrlRewrite/sql/urlrewrite_setup/install-2.0.0.php

Module 'Magento_Integration':
Include /var/www/magento2/app/code/Magento/Integration/sql/integration_setup/install-2.0.0.php

Module 'Magento_Usps':

Module 'Magento_Webapi':

Module 'Magento_Weee':
Include /var/www/magento2/app/code/Magento/Weee/sql/weee_setup/install-2.0.0.php

Module 'Magento_CurrencySymbol':

Module 'Magento_Wishlist':
Include /var/www/magento2/app/code/Magento/Wishlist/sql/wishlist_setup/install-2.0.0.php

Schema post-updates:
Module 'Magento_Core':
Module 'Magento_Store':
Module 'Magento_Directory':
Module 'Magento_Backup':
Module 'Magento_Theme':
Module 'Magento_Eav':
Module 'Magento_Customer':
Module 'Magento_CatalogImportExport':
Module 'Magento_Indexer':
Module 'Magento_Cms':
Module 'Magento_Backend':
Module 'Magento_Catalog':
Module 'Magento_Rule':
Module 'Magento_CatalogInventory':
Module 'Magento_Payment':
Module 'Magento_CheckoutAgreements':
Module 'Magento_Sales':
Module 'Magento_CmsUrlRewrite':
Module 'Magento_ConfigurableImportExport':
Module 'Magento_Msrp':
Module 'Magento_Contact':
Module 'Magento_AdminNotification':
Module 'Magento_Cron':
Module 'Magento_Widget':
Module 'Magento_Bundle':
Module 'Magento_CustomerImportExport':
Module 'Magento_DesignEditor':
Module 'Magento_Dhl':
Module 'Magento_Authorization':
Module 'Magento_Downloadable':
Module 'Magento_Checkout':
Module 'Magento_Email':
Module 'Magento_Fedex':
Module 'Magento_GiftMessage':
Module 'Magento_GoogleAdwords':
Module 'Magento_GoogleAnalytics':
Module 'Magento_GoogleOptimizer':
Module 'Magento_GoogleShopping':
Module 'Magento_GroupedImportExport':
Module 'Magento_GroupedProduct':
Module 'Magento_ImportExport':
Module 'Magento_CatalogRule':
Module 'Magento_User':
Module 'Magento_LayeredNavigation':
Module 'Magento_Log':
Module 'Magento_ConfigurableProduct':
Module 'Magento_Multishipping':
Module 'Magento_Newsletter':
Module 'Magento_OfflinePayments':
Module 'Magento_SalesRule':
Module 'Magento_PageCache':
Module 'Magento_Centinel':
Module 'Magento_Persistent':
Module 'Magento_ProductAlert':
Module 'Magento_Reports':
Module 'Magento_RequireJs':
Module 'Magento_Review':
Module 'Magento_Rss':
Module 'Magento_CatalogWidget':
Module 'Magento_Captcha':
Module 'Magento_OfflineShipping':
Module 'Magento_Search':
Module 'Magento_Sendfriend':
Module 'Magento_Shipping':
Module 'Magento_Sitemap':
Module 'Magento_CatalogSearch':
Module 'Magento_Tax':
Module 'Magento_TaxImportExport':
Module 'Magento_CatalogUrlRewrite':
Module 'Magento_Translation':
Module 'Magento_Ui':
Module 'Magento_Ups':
Module 'Magento_UrlRewrite':
Module 'Magento_Integration':
Module 'Magento_Usps':
Module 'Magento_Webapi':
Module 'Magento_Weee':
Module 'Magento_CurrencySymbol':
Module 'Magento_Wishlist':

Installing user configuration...

[nyov]

did it finish eventually?

If it helps, I haven't run anything but MariaDB for a long time, and I didn't see any issues here after several Magento2 installs.

[matrixbegins]

I am re-running it right now, entire installation just to check if it goes further.

[alankent]

There are different definitions of "support". There are people with an official support contract (Enterprise Edition). There is what we claim in our documentation. And then there is what works (but we don't promise and test). The core Magento team at this stage is focusing on MySQL - it is what we test against. We are not going to test against all the other "MySQL compatible" databases - there are too many. But it is a great area for the community to look into if they wish - we make our tests available for others to run.

[matrixbegins]

Great Alan. Can you please give little guidelines what magento is doing at step Installing User configs so that It can be little help for me debugging further.

[matrixbegins]

Managed to run with little debug and Using CLI.

[buskamuza]

@matrixbegins , do you still need help with "user config" step? Did you figure out what caused the issue you had?
Did you try Web Wizard or Console Installer?

[matrixbegins]

I used console installer. Web installer didn't worked for me.

php -f index.php install --base_url=http://local.2mage.com/ --backend_frontname=myadmin --db_name=2_mage_db --db_user=root --db_host=localhost --db_pass=pass123 --admin_firstname=Ankur --admin_lastname=Pandey [email protected] --admin_username=admin --admin_password=admin123 --language=en_IN --currency=INR --timezone=Asia/Calcutta

[buskamuza]

If you want to look into the code, here user config data is being installed - https://github.com/magento/magento2/blob/master/setup/module/Magento/Setup/src/Model/Installer.php#L594
On hight level:

1. Extracts user configuration values from user input data. See https://github.com/magento/magento2/blob/master/setup/module/Magento/Setup/src/Model/UserConfigurationDataMapper.php#L24 for list of options that are considered as a user configuration
2. For each option creates \Magento\Backend\Model\Config object and saves it to the DB

This is the first action that uses models from the Magento application. Maybe there are some issues related to the configuration of the application (deployment configuration can't be read or something).
Do you have display_errors and error_reporting enabled to maximum?

[matrixbegins]

I am Logging all errors in PHP-FPM pool's Error File. I am running into other issues. For that I suppose I must open a new ticket.