[hibernate-dev] MariaDB on CI

[Steve Ebersole]

Another change is to make sure our test user has create/drop privileges on
all databases, and to be able to create/drop databases:

grant create, drop on *.* to 'hibernate_orm_test'@'localhost';

We will need similar for the other databases too.



On Tue, Jul 21, 2015 at 6:02 PM Sanne Grinovero <sanne at hibernate.org> wrote:

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