question about the plan for mariadb version 10.2

cloudfoundry / cf-mysql-release

Cloud Foundry MySQL Release

Apache License 2.0

58 stars 106 forks source link

question about the plan for mariadb version 10.2 #201

Open eujungkim opened 6 years ago

eujungkim commented 6 years ago

Do you have the plan for mariadb version 10.2? I want to know your loadmap for mariadb version.

cf-gitbot commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

@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 commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

@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 commented 6 years ago

@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 commented 6 years ago

@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.