[hibernate-dev] MariaDB on CI

[Steve Ebersole]

Sanne for MariaDB (and MySQL if we ever add it) we need to add at least one
more setting:

sql-mode="traditional"

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
>