question about the plan for mariadb version 10.2

[eujungkim]

question about the plan for mariadb version 10.2

[cf-gitbot]

We have created an issue in Pivotal Tracker to manage this:

https://www.pivotaltracker.com/story/show/155509229

The labels on this github issue will be updated when the story is started.

[menicosia]

Hi @eujungkim,

We've been pretty concerned, of late, that MariaDB is moving farther away from standard MySQL. We have been holding cf-mysql-release at MariaDB 10.1.X to avoid people adopting too many MariaDB-only features.

We originally selected MySQL due to its broad popularity. So, we are exploring options for staying closer to the "standard" MySQL feature set.

Is there something in MariaDB 10.2 that you are looking forward to using? Is there something that you are trying to do which is only addressed by 10.2? I'd love to hear about it.

--
Marco Nicosia
Product Manager
Pivotal Software, Inc.

[eujungkim]

@menicosia Thank you for your answer.

In my company, some people and projects want to use JSON supporting functions.
The functionality is added on MariaDB 10.2.

https://mariadb.com/resources/blog/json-mariadb-102
https://mariadb.com/database/topics/json

[ldangeard-orange]

Hello @menicosia @eujungkim ,
for my part I always wait at least release x.x.15 to have a stable version.
In 10.2, there are some interesting features for standalone MySQL, but not for Galera Cluster :

• Window functions allow calculations to be performed across a set of rows related to the current row
• Common Table Expressions (CTE)
• It is now possible to create a user with a `CREATE USER'
• InnoDB tables spatial indexes
• UNDO tablespace, to prevent the tablespace system from getting bigger
• first shy version for Flashback only for INSERT, UPDATE and DELETE
• external table for zip file with Connect engine

[ldangeard-orange]

In 10.2.x, it's possible to limit ressource for user especially
WITH MAX_USER_CONNECTIONS <value>

This will limit the number of connections per user, avoiding DoS (Denial of Service attack) for example.

[GETandSELECT]

@ldangeard-orange with MariaDB 10.1.x and even MariaDB 5.5 it was possible to set max_user_connections. It must be implemented in service broker.

[ldangeard-orange]

@GETandSELECT. Exact. thank you to check what I write ! :-)
The new function is just CREATE USER... or ALTER USER with

MAX_QUERIES_PER_HOUR count
MAX_UPDATE_PER_HOUR count
MAX_CONNECTIONS_PER_HOUR count
MAX_USER_CONNECTIONS COUNT

[GETandSELECT]

@ldangeard-orange I recommend you to switch to https://github.com/cloudfoundry-incubator/pxc-release, it's Percona Xtradb Cluster which is based on Oracle MySQL community edition. They don't yet ship MySQL 8 but I think that will happen soon. With MySQL 8 you can do the resource limitations you wish. But please be warned, that feature will generate 500 error in apps.