[hibernate-dev] MariaDB on CI

[Sanne Grinovero]

On 20 July 2015 at 17:41, Steve Ebersole <steve at hibernate.org> wrote:
> Sanne for MariaDB (and MySQL if we ever add it) we need to add at least one
> more setting:
>
> sql-mode="traditional"

I've applied this change.

--Sanne

>
> We could probably get away with less ANSI compliant mode, but after days
> playing with this I just want to cover my bases :)
>
> On Sat, Jul 18, 2015 at 3:37 PM Sanne Grinovero <sanne at hibernate.org> wrote:
>>
>> Thanks, great suggestions!
>> I've applied these and some more.
>>
>> The MariaDB configuration:
>>  -
>> https://github.com/hibernate/ci.hibernate.org/blob/master/roles/mariadb-server/files/my.cnf
>>
>> The PosgreSQL configuration files:
>>  -
>> https://github.com/hibernate/ci.hibernate.org/blob/master/roles/postgres-server/files/pg_hba.conf
>>  -
>> https://github.com/hibernate/ci.hibernate.org/blob/master/roles/postgres-server/files/postgresql.conf
>>
>> Both are running with these settings now on each CI slave.
>> Sanne
>>
>> On 18 July 2015 at 00:49, Steve Ebersole <steve at hibernate.org> wrote:
>> > [18:45] <sebersole> whoa..
>> > [18:45] <sebersole> sannegrinovero: we definitely need this for mariadb
>> > on
>> > ci...
>> > [18:46] <sebersole> sync_binlog=0 innodb_flush_log_at_trx_commit=0
>> > innodb_doublewrite=0
>> > [18:46] <sebersole> tests were much faster
>> >
>> > These were suggested to me on the #mariadb list.  I added them to my
>> > local
>> > /etc/my.cnf file and the tests were significantly faster.
>> > _______________________________________________
>> > hibernate-dev mailing list
>> > hibernate-dev at lists.jboss.org
>> > https://lists.jboss.org/mailman/listinfo/hibernate-dev