Page 1 of 1

latest svn builds and mariaDB

PostPosted: Tue Sep 30, 2014 10:52 am
by boybawang
Hi guys, do the latest SVN version of vicidial now recommends using mariadb instead of higher versions of mysql?

Re: latest svn builds and mariaDB

PostPosted: Tue Sep 30, 2014 11:28 am
by geoff3dmg
AFAIK yes. Matt or Kumba would know best though.

Re: latest svn builds and mariaDB

PostPosted: Tue Sep 30, 2014 12:54 pm
by mflorell
Yes, we do not recommend using versions of MySQL higher than the 5.1.X branch. Above that you should use MariaDB.

Re: latest svn builds and mariaDB

PostPosted: Tue Sep 30, 2014 9:37 pm
by boybawang
I have noticed that there are some innoDB tables on the svn version VERSION: 2.10-451a BUILD: 140902-0816 did mariadb convert them from myISAM or did this version come with some innodb type of tables?

Image

Re: latest svn builds and mariaDB

PostPosted: Wed Oct 01, 2014 4:26 am
by geoff3dmg
I have the same build as you here. Those tables are MyISAM here.

Re: latest svn builds and mariaDB

PostPosted: Wed Oct 01, 2014 4:59 am
by mflorell
MariaDB uses MyISAM as it's default table type. MySQL 5.5 and higher uses InnoDB as it's default table type. How did you install Vicidial?

Re: latest svn builds and mariaDB

PostPosted: Wed Oct 01, 2014 6:11 am
by boybawang
from scratch, thats the table layout after upgrading to innodb, i will have to change it to MyISAM

Re: latest svn builds and mariaDB

PostPosted: Wed Oct 01, 2014 6:12 am
by boybawang
the database was on 2.4 then upgraded to 2.6 then 2.8 then to the latest 2.10