Making Percona/MariaDB/MySQL better at sharding, and supporting complex queries (with MPP capability, window functions, CTE,etc.) would really compete with an enterprise DB, with RedShift, and with Fabric.  Shard-Query can greatly outperform both the enterprise MySQL Infobright (and MC ColumnStore) because it parallelizes operations differently, and supports horizontal scale-out over more than one node (which IB does, and CS does differently).

So what about group replication?  I'm very much interested in group replication plugins.  Using the GR plugin interface in combination with a rewrite layer that sits outside of the parser, it should provide notifications for transaction events and row changes which a sharding layer could act on appropriately to replicate or distribute data.  It would coordinate distributed transactions.  This would provide a layer to compete with Fabric.  If I were to contribute such a layer it would of course have OLAP support.  This would work with all storage engines and push down operations in a more optimal way than other distributed MySQL solutions like MC ColumnStore.

Making it so you can run SQL in the server should be a priority, in my opinion, as well as implementing a rewrite interface that is outside of the parser.  I can commit to contributing this new rewrite interface to Percona/MySQL/MariaDB (whomever wants to implement it) through a relatively simple patch to MariaDB and MySQL (Percona Server is similar enough to MySQL such that the MySQL patch should apply cleanly or close to it). 

With those capabilities I can implement Shard-Query inside of the server.  The company that I am in the process of joining will support these changes, and will be responsive to bug reports, etc.  I want to stress that operating in the free market to support extensions and plugins to open source software does not represent "competition".  MariaDB can't use their non-compete clause to prevent me from operating in the ecosystem, as I would be unable to obtain any job in the marketplace.  That represents unfair competition.  You can't prevent me from practicing my profession.  Shard-Query (WarpSQL) is engine and server agnostic as long as the server conforms to the pluggable API which WarpSQL uses. In order to prevent any possible perceived conflict of interest, or perceived competition, I won't provide any patches for columnstore, which is a separate MySQL fork maintained by MariaDB Corporation, than MariaDB itself, which is overseen by the Foundation. 

Let's have a peaceful and community, and let's make MySQL much better at complex queries.


On Fri, Oct 14, 2016 at 10:32 AM, Roberto Spadim <roberto@spadim.com.br> wrote:
i read opnions about why choose mysql, and the common point is 'mysql runs simple queries really fast' i think that's the main feature of mysql

2016-10-14 11:25 GMT-03:00 Reindl Harald <h.reindl@thelounge.net>:


Am 14.10.2016 um 15:21 schrieb Richard Bensley:
Me and many others had hope that TokuDB would be the death of InnoDB in
MariaDB, and the catalyst to a truly amazing open source database.

please fix that "many others" above by saying "some others" - if we would like a "truly amazing open source database" with is not a mysql dropin replacement we would just use postgresql - the "dead of innodb and myisam in mariadb" would be a clear reason to migrate away at all



_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp



--
Roberto Spadim
SPAEmpresarial - Software ERP
Eng. Automação e Controle

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp