MariaDB

Someone who has deployed MariaDB ([url=“https://mariadb.org/”]https://mariadb.org/[/url])? It serves visible more performance and no conflicts by now.

Doesn't work. tried on two servers - It'll work well enough to replace mySQL but for the moment CS-Cart is not written for Maria and consequently is slower than mySQL overall.

I have 4.0.1 running on Maria DB 5.5, without any problem at this time. If I compare to MySQL its power is much better. I am afraid of possible future complications.

MariaDB doesn't play well with CPanel/WHM if you are running that environment. As Jesse mentioned, it made our site run slower until we we reverted back to mySQL drivers.

I'll try MariaDB on 4.1.3 in a few weeks, shouldn't be a problem. I guess it's about 5% gain in perfomance although.

We're back on MariaDb now, but in a new server environment; Litespeed/Xcache/MariaDB (no WHM Control Panel)

anyone knows what is the status of mariadb with cs-cart now?

anyone knows what is the status of mariadb with cs-cart now?

I corresponded with tech support at Simbirsk and they confirmed that CS Cart V4.3 is ready for MariaDB.

I plan an upgrade myself later this week. As for Cpanel and MariaDB, that is now well provided for since March 2014.


I corresponded with tech support at Simbirsk and they confirmed that CS Cart V4.3 is ready for MariaDB.

I plan an upgrade myself later this week. As for Cpanel and MariaDB, that is now well provided for since March 2014.

I have been using MariaDB for a months without any problems. Site was initially on 4.2.4 with MariaDB 10 now running 4.3.6 with MariaDB.

MariaDB works fine w/ CS-Cart now and is supported/managed by Cpanel/WHM. It is a good choice for high-performance sites.

We also knit together a galera cluster using MariaDB ... for self-replicating goodness.

.. or to be more specific ... 2 galera servers in a cluster with 10 web servers in front of that.

interesting to read. Out of interest are you using MariaDB on a Galera cluster with CS Cart? If so did you find that your order numbers jump or that pagination doesn't work in the admin?

I thought cscart was myisam and galareia needed to be innodb

Hi,

I recently (last few months) have been getting database errors 2-4 times a month. Previously, I did not have any for over a year.

Most start like this:

Database (error)
Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'asc LIMIT 0, 500' at line 1 (1064)

I just read this post regarding Maria Database. I did not know I was using anything other than a mySQL database. I don't even know what the is unique about a MariaDB. Does this error message indicate I am using MariaDB? My host upgraded the server several months ago. Could the database change form mySQL to MariaDB on its own?

The errors are very infrequent so I have not contacted CS-Cart or my host at this time. When checking the database in cPanel, no errors are indicated.

Thanks,

Bob

anyone knows what is the status of mariadb with cs-cart now?

As a system administrator I should say that MariaDB perfectly works with CS-Cart and any other applications which uses MySQL as a database. MariaDB is a community-developed fork of the MySQL and MariaDB intends to maintain compatibility with MySQL APIs and commands. JFYI.

We might consider going over to MariaDB from MySQL 5.6 if...we can get both a V4.2.4 and a V4.3.8 store working with it.

PHP 7 we might do if we are either able to upgrade the V4.2.4 store or import the store into a 2nd store front of another V4.3.8 store we have.

What performance increases could we expect Gleb ?

We might consider going over to MariaDB from MySQL 5.6 if...we can get both a V4.2.4 and a V4.3.8 store working with it.

You can easily switch from MySQL to MariaDB without any risk to mess something up.

PHP 7 we might do if we are either able to upgrade the V4.2.4 store or import the store into a 2nd store front of another V4.3.8 store we have.

Unfortunately, you should keep PHP 5.6 on case you want to have CS-Cart younger than 4.3.7. Maybe you should try to create a patch for PHP 7.0.x. compatibility. I'm sure that size won't be so big.

What performance increases could we expect Gleb ?

Well, I haven't done performance tests by myself yet, so I don't know how fast MariaDB actually is. Netherless, a few months ago I had a meeting with PerconaDB developer on a conference. He said that in common case the latest version of MySQL, MariaDB, PerconaDB have the same speed because the most significant contributions are still coming from Oracle's team. I have no reasons not to trust him.

Anyway, I suppose that we should prepare detailed tests and make our independent conclusion about usage MariaDB on production.

You can easily switch from MySQL to MariaDB without any risk to mess something up.

Unfortunately, you should keep PHP 5.6 on case you want to have CS-Cart younger than 4.3.7. Maybe you should try to create a patch for PHP 7.0.x. compatibility. I'm sure that size won't be so big.

Well, I haven't done performance tests by myself yet, so I don't know how fast MariaDB actually is. Netherless, a few months ago I had a meeting with PerconaDB developer on a conference. He said that in common case the latest version of MySQL, MariaDB, PerconaDB have the same speed because the most significant contributions are still coming from Oracle's team. I have no reasons not to trust him.

Anyway, I suppose that we should prepare detailed tests and make our independent conclusion about usage MariaDB on production.

All in all what you are actually saying is that upgrading to MariaDB might not bring the performance increase that I am looking for in comparison to upgrading from PHP 5.6 to PHP 7.

Am I correct in my assumption ?

All in all what you are actually saying is that upgrading to MariaDB might not bring the performance increase that I am looking for in comparison to upgrading from PHP 5.6 to PHP 7.

Am I correct in my assumption ?

Yes. I was trying to say that upgrading PHP from 5.6 to 7.0 have a more significant impact on performance than migration from MySQL to MariaDB. In general, CS-Cart haven't any bottlenecks in database and I/O, but in some cases (especially on heavy loaded stores) it's possible.