Re: [Maria-discuss] JSON column type

2018-02-22 Thread Brent Clark
Good day Sergei Thanks for replying. Regards Brent On 21/02/2018 16:59, Sergei Golubchik wrote: > Hi, Brent! > > On Feb 21, Brent Clark wrote: >> Good day Guys >> >> I have a client that is looking for JSON support, or better 'JSON column >> type'. >> >> He is asking for MySQL/5.7.8 (Currently

[Maria-discuss] Aria_pack error

2018-02-22 Thread Kenneth Penza
Good afternoon, I am currently working on MariaDB version 10.1.26-MariaDB-1~yakkety running on Ubuntu 16.10 and have encountered an error whilst using aria_pack. The process used to generate the tables is as follows: 1) create table SQL script 2) shutdown MariaDB (systemctl shutdown mar

[Maria-discuss] procedure to change database encryption with file_key_management plugin?

2018-02-22 Thread obsa
I've built mysqld -V mysqld Ver 10.2.14-MariaDB-log for Linux on x86_64 (Source distribution) I'm setting up encryption, following https://mariadb.com/kb/en/library/encryption/ https://mariadb.com/kb/en/library/data-at-rest-encryption/ I created my ke

Re: [Maria-discuss] procedure to change database encryption with file_key_management plugin?

2018-02-22 Thread Sergei Golubchik
Hi, obsa! On Feb 22, o...@mm.st wrote: > > Encryption key management > > MariaDB encryption supports multiple encryption keys, they are > identified by a key identifier — a 32-bit integer. To support > automatic key rotation every key additionally might have different > versions. XtraDB

Re: [Maria-discuss] procedure to change database encryption with file_key_management plugin?

2018-02-22 Thread obsa
hi sergei, On Thu, Feb 22, 2018, at 11:57 AM, Sergei Golubchik wrote: > Without key rotation, there's no automatic way, unfortunately. :-/ > A, perhaps, more convenient approach could be: > > (1) add new key to the keys.txt - with a different ID. > (2) restart the server > (3) do ALTER TABLE