Comments - The maria/5.3-gis tree on Launchpad.

11 years, 7 months ago Gene Vayngrib

thx, but the real question now is, how do I include Aria egine into Percona Server?

 
11 years, 7 months ago Vladislav Vaintroub

thx, but the real question now is, how do I include Aria egine into Percona Server?

The real question is why do you want to have Aria engine in Percona Server, if you can have MariaDB that already includes useful parts of PerconaServer as well as Aria engine? :)

On a more serious note, it might be possible to include Aria or other storage engines into Percona Server (since it has MySQL "pluggability" as well). Likely some hacking in build scripts would be necessary. We never tried it here. I think appropriate place to ask a PerconaServer related question like this question is http://forum.percona.com/

 
11 years, 7 months ago Gene Vayngrib

You make a good point, I will as on Percona forum. When the official MySQL builds stopped coming a couple of years ago, we actually switched to MariaDB. Then MariaDB development seemed to have slowed down and the features we wanted were availble only in PerconaServer, so we switched to it. Each transition had its own problems and I am not yet ready to introduce another disturbance into our production environment, especially since MariaDB is not yet at the MySQL 5.6 level (we need precise object shapes support and are evaluating a move to MySQL 5.6) and fully ACID-compliant Aria 2.0 is not ready yet (we need spatial tables with spatial indexes to be part of the transaction that involves InnoDB tables). If you could offer any thoughts on addressing issues at hand, I would be very greatful.

 
11 years, 6 months ago Sergei Golubchik

Hm. MariaDB supports precise object shapes since the version 5.3, which went GA on 29-02-2012. While MySQL 5.6 is still a milestone release.

 
11 years, 6 months ago Gene Vayngrib

good to know, thx. I presume you mean geo functions starting with ST_ prefix.

 
11 years, 6 months ago Alexey Botchkov

That's right. These 'ST_functions' are available in MariaDB.

 
11 years, 6 months ago Gene Vayngrib

thanks for all the replies!

If I may, in evaluating the switch to MariDB, we will need the functionality we use in Percona Server now, specifically, the MEMORY engine dynamic row format patch that allows to support TEXT fields. - I hope it is present in MariaDB 5.5 (my googling indicates this but not conclusively). - And while at it, was MariaDB ever improved to use this DFR patch for the internal tmp tables? I Googled and could not locate anything written on this subject, except a year old Percona blog post mentioning that they intended to do it some day: http://www.mysqlperformanceblog.com/2011/09/06/dynamic-row-format-for-memory-tables/

Many Thanks, Gene

 
11 years, 6 months ago Sergei Golubchik

Unfortunately, dynamic row format patch for MariaDB was never finished. We've started porting it, but then it was put on hold.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.