Re: [Maria-discuss] MariaDB Server 10.3 notes

[Federico Razzoli]

But those people can't use Galera, pt, Xtrabackup... If we care about Windows, 
that software should be ported first, because it's general purpose.

Federico




Dom 16/10/16, Tim Callaghan  ha scritto:

 Oggetto: Re: [Maria-discuss] MariaDB Server 10.3 notes
 A: "Reindl Harald" 
 Cc: "Maria Discuss" 
 Data: Domenica 16 ottobre 2016, 14:45
 
 I was just
 adding context. I agree that Windows is very uninteresting
 in a production context, but not having a version of TokuDB
 for Windows certainly excluded people (academic and
 professional) from trying it out on their laptops.
 
 On Sat, Oct 15, 2016 at
 1:10 PM, Reindl Harald 
 wrote:
 
 
 
 
 Am 15.10.2016 um 17:22 schrieb Tim Callaghan:
 
 
 Every time the topic of getting TokuDB to run on Windows the
 developers
 
 could not have run out of the room any faster.  :)
 
 
 
 
 frankly what is the purpose of running MySQL/MariaDB on
 Windows?
 
 who does that in production?
 
 
 
 for development?
 
 seriously?
 
 develop a application on Windows which finally runs on a
 different OS?
 
 
 
 not in 2016 when anybody sane in his mind would setup a
 virtual machine so that his testing servers are really
 reflecting the later production environment (for the poor
 guys which are running Windows on their bare metal
 development machine)
 
 
 
 
 
 __ _
 
 Mailing list: https://launchpad.net/~maria-d
 iscuss
 
 Post to     : maria-discuss@lists.launchpad.
 net
 
 Unsubscribe : https://launchpad.net/~maria-d
 iscuss
 
 More help   : https://help.launchpad.net/Lis
 tHelp
 
 
 
 -Segue allegato-
 
 ___
 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
 

___
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

Re: [Maria-discuss] Virtual CHECK constraint using Virtual columns

[Sergei Golubchik]

Hi, Peter!

On Oct 16, Peter Laursen wrote:
> Didn't CHECK CONSTRAINTS get introduced in MySQL 8? Then better port it
> from there into MariaDB I think.  -- Peter

I'm afraid you've got it backwards :)

MySQL 8.0 has no CHECK constraint (at least it's not mentioned in
http://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-0.html).

MariaDB has it (https://mariadb.com/kb/en/mariadb/constraint/) since July 4th.

Regards,
Sergei
Chief Architect MariaDB
and secur...@mariadb.org

___
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

Re: [Maria-discuss] Virtual CHECK constraint using Virtual columns

[Peter Laursen]

Didn't CHECK CONSTRAINTS get introduced in MySQL 8? Then better port it
from there into MariaDB I think.  -- Peter

On Sun, Oct 16, 2016 at 4:45 PM, Pantelis Theodosiou 
wrote:

> Would this be good to be added in the documentation of VIRTUAL columns?
>
> Or as a separate page, as a way to enforce/emulate arbitrary CHECK
> constraints?
>
> It can be slightly simplified (IF is not needed) and the BOOLEAN could be
> BIT (not sure if that adds any complication):
>
> CREATE TABLE truth (t BIT PRIMARY KEY) ;
> INSERT INTO truth (t) VALUES (TRUE) ;
> -- and remove all write permissions to the table
>
> CREATE TABLE checker (
> i float,
> i_must_be_between_7_and_12 BIT
>  AS (i BETWEEN 7 AND 12)   -- whatever CHECK
> constraint we want here
>  PERSISTENT,
> CONSTRAINT check_i_must_be_between_7_and_12
> FOREIGN KEY (i_must_be_between_7_and_12)
>   REFERENCES truth (t)
> );
>
> On Wed, Apr 6, 2016 at 6:46 PM, Pantelis Theodosiou 
> wrote:
>
>>
>>
>> On Mon, Apr 4, 2016 at 2:10 PM, Peter Laursen 
>> wrote:
>>
>>> As described in this Blog http://mablomy.blogspot.d
>>> k/2016/04/check-constraint-for-mysql-not-null-on.html. A very nice
>>> hack/trick IMO.
>>>
>>> However it is not working with MariaDB as VC's cannot be declared NOT
>>> NULL.  What prevents that?
>>>
>>>
>> (Peter, sorry fro the previous private reply, not sure how I got the
>> reply buttons wrong.)
>>
>> I can't answer that, but there's another workaround for (some) CHECK
>> constraints, described here: http://dba.stackexchange.com/q
>> uestions/9662/check-constraint-does-not-work/22019#22019
>>
>> Unfortunately, it works only for smallish (int or date) ranges. We can't
>> use for floats or decimals (as it would require a very big reference table).
>>
>> But it could be combined with the hack you link, using something like:
>>
>>
>> CREATE TABLE truth (t BOOLEAN PRIMARY KEY) ;
>> INSERT INTO truth (t) VALUES (TRUE) ;
>> -- and remove all write permissions to the table
>>
>> CREATE TABLE checker (
>> i int,
>> i_must_be_between_7_and_12 BOOLEAN
>>  AS (IF(i BETWEEN 7 AND 12, TRUE, FALSE))
>>  PERSISTENT,
>> CONSTRAINT check_i_must_be_between_7_and_12
>> FOREIGN KEY (i_must_be_between_7_and_12)
>>   REFERENCES truth (t)
>> );
>>
>>
>> Haven't tested it but should work for more complex constraints as well.
>>
>> Pantelis
>>
>>
>
> ___
> 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
>
>
___
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

Re: [Maria-discuss] Virtual CHECK constraint using Virtual columns

[Pantelis Theodosiou]

My suggestion is for documenting existing functionality and a use case for
VIRTUAL columns.

When CHECK constraints are actually added, it will be obsolete of course
but still useful for those that use older versions (5, 10).


On Sun, Oct 16, 2016 at 3:51 PM, Peter Laursen 
wrote:

> Didn't CHECK CONSTRAINTS get introduced in MySQL 8? Then better port it
> from there into MariaDB I think.  -- Peter
>
>
>
On Sun, Oct 16, 2016 at 4:45 PM, Pantelis Theodosiou 
> wrote:
>
>> Would this be good to be added in the documentation of VIRTUAL columns?
>>
>> Or as a separate page, as a way to enforce/emulate arbitrary CHECK
>> constraints?
>>
>> It can be slightly simplified (IF is not needed) and the BOOLEAN could be
>> BIT (not sure if that adds any complication):
>>
>> CREATE TABLE truth (t BIT PRIMARY KEY) ;
>> INSERT INTO truth (t) VALUES (TRUE) ;
>> -- and remove all write permissions to the table
>>
>> CREATE TABLE checker (
>> i float,
>> i_must_be_between_7_and_12 BIT
>>  AS (i BETWEEN 7 AND 12)   -- whatever CHECK
>> constraint we want here
>>  PERSISTENT,
>> CONSTRAINT check_i_must_be_between_7_and_12
>> FOREIGN KEY (i_must_be_between_7_and_12)
>>   REFERENCES truth (t)
>> );
>>
>> On Wed, Apr 6, 2016 at 6:46 PM, Pantelis Theodosiou 
>> wrote:
>>
>>>
>>>
>>>
>>>
>>
>
___
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

Re: [Maria-discuss] MariaDB Server 10.3 notes

[Tim Callaghan]

I was just adding context. I agree that Windows is very uninteresting in a
production context, but not having a version of TokuDB for Windows
certainly excluded people (academic and professional) from trying it out on
their laptops.

On Sat, Oct 15, 2016 at 1:10 PM, Reindl Harald 
wrote:

>
>
> Am 15.10.2016 um 17:22 schrieb Tim Callaghan:
>
>> Every time the topic of getting TokuDB to run on Windows the developers
>> could not have run out of the room any faster.  :)
>>
>
> frankly what is the purpose of running MySQL/MariaDB on Windows?
> who does that in production?
>
> for development?
> seriously?
> develop a application on Windows which finally runs on a different OS?
>
> not in 2016 when anybody sane in his mind would setup a virtual machine so
> that his testing servers are really reflecting the later production
> environment (for the poor guys which are running Windows on their bare
> metal development machine)
>
>
> ___
> 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
>
___
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

Re: [Maria-discuss] MariaDB Server 10.3 notes

[Justin Swanhart]

Doesn't the Bing team port rocks?  Obviously there is interest in support for 
Windows in Redmond, but apparently not for TokuDB.

The market decides.  It has been demonstrated that TokuDB isn't precisely 
general purpose, so the desire to port it is lesser.

Plenty of people run Windows and MySQL in production.  They just aren't members 
of our community, because we tend to ostracize them for their OS choice.

Sent from my iPhone

> On Oct 16, 2016, at 8:45 AM, Tim Callaghan  wrote:
> 
> I was just adding context. I agree that Windows is very uninteresting in a 
> production context, but not having a version of TokuDB for Windows certainly 
> excluded people (academic and professional) from trying it out on their 
> laptops.
> 
>> On Sat, Oct 15, 2016 at 1:10 PM, Reindl Harald  
>> wrote:
>> 
>> 
>>> Am 15.10.2016 um 17:22 schrieb Tim Callaghan:
>>> Every time the topic of getting TokuDB to run on Windows the developers
>>> could not have run out of the room any faster.  :)
>> 
>> frankly what is the purpose of running MySQL/MariaDB on Windows?
>> who does that in production?
>> 
>> for development?
>> seriously?
>> develop a application on Windows which finally runs on a different OS?
>> 
>> not in 2016 when anybody sane in his mind would setup a virtual machine so 
>> that his testing servers are really reflecting the later production 
>> environment (for the poor guys which are running Windows on their bare metal 
>> development machine)
>> 
>> 
>> ___
>> 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
> 
> ___
> 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
___
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

[Maria-discuss] Missing MariaDB Seal logos?

[Colin Charles]

Hi!

Visiting:
https://mariadb.com/kb/en/mariadb/branding-guidelines/

You’ll note that the Powered by MariaDB badges still exist 
(https://mariadb.org/about/logos/) — they should really say Powered by MariaDB 
Server

But what is missing are all the seal logos? Currently beyond the archives at 
Wikimedia Commons 
(https://commons.wikimedia.org/wiki/File:Mariadb-seal-browntext.svg), they seem 
to have disappeared

Is this just an oversight and something that needs fixing?

Thanks
--
Colin Charles, http://bytebot.net/blog/
twitter: @bytebot | skype: colincharles
"First they ignore you, then they laugh at you, then they fight you, then you 
win." -- Mohandas Gandhi



signature.asc
Description: Message signed with OpenPGP using GPGMail
___
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

Re: [Maria-discuss] MariaDB Server 10.3 notes

[Reindl Harald]

could you get rid of

* top posting
* convert a plaintext thread to html
* reply all?

Am 16.10.2016 um 04:09 schrieb Roberto Spadim:

There're financial software running windows withoutproblems


that is all nice - but the whole point of a database server which is 
reachable over network is that it can run on a dedicated machine and the 
client can by anything anywhere


consider the development ressources which could be spent better like 
fixing bugs as "mysqld: 161016  5:16:22 [Note] /usr/libexec/mysqld 
(mysqld 10.0.27-MariaDB) starting as process 19795 ..." after a year 
still spit in the syslog instead in the mysql general log



Em sábado, 15 de outubro de 2016, Reindl Harald > escreveu:



Am 15.10.2016 um 17:22 schrieb Tim Callaghan:

Every time the topic of getting TokuDB to run on Windows the
developers
could not have run out of the room any faster.  :)


frankly what is the purpose of running MySQL/MariaDB on Windows?
who does that in production?

for development?
seriously?
develop a application on Windows which finally runs on a different OS?

not in 2016 when anybody sane in his mind would setup a virtual
machine so that his testing servers are really reflecting the later
production environment (for the poor guys which are running Windows
on their bare metal development machine)


___
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

Re: [Maria-discuss] Virtual CHECK constraint using Virtual columns

[Pantelis Theodosiou]

On Sun, Oct 16, 2016 at 5:15 PM, Sergei Golubchik  wrote:

> Hi, Peter!
>
> On Oct 16, Peter Laursen wrote:
> > Didn't CHECK CONSTRAINTS get introduced in MySQL 8? Then better port it
> > from there into MariaDB I think.  -- Peter
>
> I'm afraid you've got it backwards :)
>
> MySQL 8.0 has no CHECK constraint (at least it's not mentioned in
> http://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-0.html).
>
> MariaDB has it (https://mariadb.com/kb/en/mariadb/constraint/) since July
> 4th.
>
> Regards,
> Sergei
> Chief Architect MariaDB
> and secur...@mariadb.org



Sergei, great and thank you!
I wasn't paying attention, This is great news (to me)!
___
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

Re: [Maria-discuss] MariaDB Server 10.3 notes

[Rich Prohaska]

I was a software developer at Tokutek working on TokuDB.  If I wanted to
continue working on TokuDB, Tokutek had to make money to pay for the
expenses of running a company.  Supporting TokuDB on Windows led to
absolutely no business, so why would I want to waste time supporting it?
We would jump through hoops to support Windows (or any other platform), but
the money to pay for it was not there.

On Sat, Oct 15, 2016 at 11:22 AM, Tim Callaghan 
wrote:

> Every time the topic of getting TokuDB to run on Windows the developers
> could not have run out of the room any faster.  :)
>
> -Tim
>
> On Thu, Oct 13, 2016 at 7:49 AM, Peter Laursen 
> wrote:
>
>> I think Sergei G. told me once that TokuDB would not compile with Visual
>> Studio and that MariaDB would only try to fix it in MariaDB if Toku people
>> wanted to collaborate on this (what they did not). it probably was before
>> TokuDB was swalloed by Percona .
>>
>> -- Peter
>>
>> On Thu, Oct 13, 2016 at 1:36 PM, Vladislav Vaintroub <
>> vvaintr...@gmail.com> wrote:
>>
>>>
>>>
>>> On 13.10.2016 12:00, Peter Laursen wrote:
>>>
>>> I have a few questions
>>>
>>> 1) will RocksDB be available on Windows? ToduDB isn't (because it does
>>> not compile on Visual Studio I think).
>>>
>>> Personally, I plan to make this happen . At least RocksDB works on
>>> Windows, the port seems to be done by competent people (MS Bing folks) so
>>> that part compiles, a runs and was benchmarked as well.
>>> https://github.com/facebook/rocksdb/blob/4cab5ebecdb42ceff70
>>> 30a7606b5b5c31ba702ef/WINDOWS_PORT.md
>>> I expect this port to be solid.
>>>
>>> As for TokuDB,  if I remember correctly, its original team declared it
>>> to be compilable and runnable only on Linux x64 with  "modern" C++ (back
>>> than it could have been gcc's idea of C++11)  and absolutely necessary
>>> jemalloc , so I figured it was not worth looking at making a port. I even
>>> would speculate nobody has tried to compile TokuDB on Windows that far.
>>>
>>>
>>>
>>> 2) How large a set of configuraton options will RocksDB have? InnoDB now
>>> has100+ I guess, and that is a mess IMO. I liked the simplicity of the now
>>> dead Primebase (if I remember the name right) storage engine in this
>>> respect. Also is there an overview somehere of current and planned
>>> configuration options?
>>>
>>>
>>> -- Peter
>>> -- Webyog
>>>
>>>
>>> On Thu, Oct 13, 2016 at 6:50 AM, Roberto Spadim 
>>> wrote:
>>>
 just some ideas...

 --
 at first time i read plugable parser, and i was thinking that it could
 allow nosql (handler socket/memcahce) protocol inside mysql "session"
 (connect + auth + allow communicate with server), removing the sql
 parser/optimizer without loosing mysql_connect() authentication/security

 a "plugable" parser, could remove a lot of nosql client side/server
 side libs, maybe a nosql parser could be nice to be implemented
 like"mysql_crud_get()", "mysql_crud_set()", etc .. without installing a
 daemon plugin (handlersocket/memcache)

 a plugable parser could allow a python/R/julia/anything to run a
 analytics algorithm direct to storage engine? i don't know if this could
 help at allow v8/others languages at server side but the idea sounds ok to
 me, something like mysql_v8_eval("v8 script"), just ideas...

 ___
 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


>>>
>>>
>>> ___
>>> 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
>>>
>>>
>>>
>>> ___
>>> 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
>>>
>>>
>>
>> ___
>> 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
>>
>>
>
> ___
> 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
>
>
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More 

Re: [Maria-discuss] Virtual CHECK constraint using Virtual columns

[Peter Laursen]

ok .. I should have checked properly! :-(

On Sun, Oct 16, 2016 at 6:15 PM, Sergei Golubchik  wrote:

> Hi, Peter!
>
> On Oct 16, Peter Laursen wrote:
> > Didn't CHECK CONSTRAINTS get introduced in MySQL 8? Then better port it
> > from there into MariaDB I think.  -- Peter
>
> I'm afraid you've got it backwards :)
>
> MySQL 8.0 has no CHECK constraint (at least it's not mentioned in
> http://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-0.html).
>
> MariaDB has it (https://mariadb.com/kb/en/mariadb/constraint/) since July
> 4th.
>
> Regards,
> Sergei
> Chief Architect MariaDB
> and secur...@mariadb.org
>
___
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

Re: [Maria-discuss] Virtual CHECK constraint using Virtual columns

[Federico Razzoli]

As Sergei said, MariaDB 10.2 has CHECKs.

In old versions, honestly I don't like your solution. Take a look at what locks 
will be set:
https://www.percona.com/blog/2006/12/12/innodb-locking-and-foreign-keys/

You can use trigger instead. When you only want to execute a check like this, 
triggers are not slow. Just SIGNAL an error is the value of 
i_must_be_between_7_and_12 is not valid.

Federico



Dom 16/10/16, Pantelis Theodosiou  ha scritto:

 Oggetto: Re: [Maria-discuss] Virtual CHECK constraint using Virtual columns
 A: "Maria Discuss" 
 Data: Domenica 16 ottobre 2016, 16:45
 
 Would this be good to be added in the
 documentation of VIRTUAL columns?
 
 Or as a separate page, as a way to
 enforce/emulate arbitrary CHECK constraints?
 
 It can be slightly
 simplified (IF is not needed) and the BOOLEAN could be BIT
 (not sure if that adds any complication):
 
 CREATE
 TABLE truth (t BIT PRIMARY KEY) ;
 INSERT INTO
 truth (t) VALUES (TRUE) ;    
 -- and remove
 all write permissions to the table
 
 CREATE TABLE checker ( 
 
     i float, 
 
     i_must_be_between_7_and_12 BIT
 
 
  AS (i BETWEEN 7 AND 12)  
                 -- whatever CHECK constraint we want
 here  
 
  PERSISTENT,
     CONSTRAINT check_i_must_be_between_7_and_ 12    FOREIGN KEY
 (i_must_be_between_7_and_12)
  
 REFERENCES truth (t)
     );
 
 On Wed, Apr 6, 2016 at 6:46
 PM, Pantelis Theodosiou 
 wrote:
 
 
 On Mon, Apr 4, 2016 at 2:10 PM, Peter
 Laursen 
 wrote:
 As
 described in this Blog http://mablomy.blogspot.
 dk/2016/04/check-constraint- for-mysql-not-null-on.html.
 A very nice hack/trick IMO.
 However it is not working with
 MariaDB as VC's cannot be declared NOT NULL.  What
 prevents that? 
 
 (Peter, sorry fro the previous
 private reply, not sure how I got the reply buttons
 wrong.)
 
 I
 can't answer that, but there's another workaround
 for (some) CHECK constraints, described here: http://dba.stackexchange.com/
 questions/9662/check- constraint-does-not-work/
 22019#22019
 
 Unfortunately,
  it works only for smallish (int or date) ranges. We
 can't use for 
 floats or decimals (as it would require a very big reference
 table).
 
 But it
 could be combined with the hack you link, using something
 like:
 
 
 CREATE TABLE truth (t
 BOOLEAN PRIMARY KEY) ;
 INSERT INTO
 truth (t) VALUES (TRUE) ;    
 -- and remove
 all write permissions to the table
 
 CREATE TABLE checker ( 
 
     i int, 
 
     i_must_be_between_7_and_12
 BOOLEAN 
 
  AS (IF(i BETWEEN 7 AND 12,
 TRUE, FALSE))  
 
  PERSISTENT,
    
 CONSTRAINT check_i_must_be_between_7_and_ 12    FOREIGN KEY
 (i_must_be_between_7_and_12)
  
 REFERENCES truth (t)
     );
 
 
 Haven't tested it
 but should work for more complex constraints as well.
  
 Pantelis
 
 
 
 
 -Segue allegato-
 
 ___
 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
 

___
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

Re: [Maria-discuss] New MariaDB 10.1.18 Galera setup question

[Daniel Black]

On 16/10/16 09:26, Alex Evonosky wrote:
> Hello team-
> 
> Quick question-
> 
> I recently just installed mariaDB 10.1.18 (via apt-get) and all went
> well, no issues..  Here is my galera.cnf file:
> 
> cat galera.cnf 
> [mysqld]
> binlog_format   = ROW
> default_storage_engine  = InnoDB
> innodb_autoinc_lock_mode= 2
> innodb_locks_unsafe_for_binlog  = 1
> 
> wsrep_on= ON
> wsrep_causal_reads  = ON
> wsrep_cluster_address   = gcomm://10.10.10.104
> ,10.10.13.2
> wsrep_cluster_name  = soho_cluster
> wsrep_node_address  = 10.10.10.104
> wsrep_provider  = /usr/lib/galera/libgalera_smm.so
> wsrep_provider_options  = "gcache.size=512M"
> wsrep_slave_threads = 4 # Should be equal to the number of
> cpu-cores.
> wsrep_sst_auth  = "sstuser:r3pl1c@t3"
> #wsrep_sst_method= xtrabackup-v2
> wsrep_sst_method= rsync
> 
> 
> 
> I started the server as: galera_new_cluster and see no errors.  Syslog
> reports mariaDB has started.  However, I never see any messages with WSREP.
> 
> 
> 
> the database stat shows:
> 
> mysql -u root -p -e "show status like 'wsrep%'"

show *GLOBAL* status like 'wsrep_%'

> Enter password: 
> +--+--+
> | Variable_name| Value|
> +--+--+
> | wsrep_cluster_conf_id| 18446744073709551615 |
> | wsrep_cluster_size   | 0|
> | wsrep_cluster_state_uuid |  |
> | wsrep_cluster_status | Disconnected |
> | wsrep_connected  | OFF  |
> | wsrep_local_bf_aborts| 0|
> | wsrep_local_index| 4294967295   |
> | wsrep_provider_name  |  |
> | wsrep_provider_vendor|  |
> | wsrep_provider_version   |  |
> | wsrep_ready  | OFF  |
> | wsrep_thread_count   | 0|
> +--+--+
> 
> 
> The wsrep always shows OFF.  I have removed and purged any and all
> mysql, mysql-server etc three times and get the same result.  Is there
> something I am missing?

What is in the error log?

Have you started one node with galera_new_cluster? (ref:
https://github.com/linux-on-ibm-power/mysql-server)


note: replies on list only.


___
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

Re: [Maria-discuss] Best way to scale writes

[Daniel Black]

On 15/10/16 03:33, Jon Foster wrote:
> I have a DB scenario that is very write intensive. Essentially its a
> large scale hit counter of sorts. Currently we're running on a single
> 12core server with 6 SSDs in a RAID6 array.

Not using RAID6 would be a good start.

> But we're looking for a way
> to scale out write volume by adding more servers, hopefully as
> conveniently as I might add Apache servers to a website. We see two
> servers laboring so we add a third to the mix and so on.
> 
> I'm still looking at the various technologies available to me and was
> wondering if someone out there had some suggestions on this front.
> Although Galera Cluster says it scales for write loads too

Where? This is dubious for the reasons below (which are the same as why
raid6 is poor).

> it also says that all servers write the same data

(well - *have* the same data rather than have it written)

> and make sure its committed by the time the transaction is completed.
> So it seems like write performance
> would never scale because all servers are doing the same write.
> 
> Maybe I'm missing something.

I don't think so. You seem to have that worked out.

> Anyhow some pointers would be appreciated.

MyRocks will be interesting to keep an eye on.

Answering Justin's question and details to what component in
hardware/MariaDB is the limiting factor is probably critical before you
go much further. Perhaps even getting professional help.


___
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