Comments - The maria/5.3-gis tree on Launchpad.
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.
clarification: I changed aria to aria1 in create table and MySQL performed it without a problem.
You can see that your statement
produced 2 warnings. If you run
right afterwards, you'll see that the unknown engine was substituted by a default one. To avoid this behavior, you can set sql_mode to NO_ENGINE_SUBSTITUTION.
thx, but the real question now is, how do I include Aria egine into Percona Server?
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/
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.
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.
good to know, thx. I presume you mean geo functions starting with ST_ prefix.
That's right. These 'ST_functions' are available in MariaDB.
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
Unfortunately, dynamic row format patch for MariaDB was never finished. We've started porting it, but then it was put on hold.