latest svn builds and mariaDB

Any and all non-support discussions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

latest svn builds and mariaDB

Postby boybawang » Tue Sep 30, 2014 10:52 am

Hi guys, do the latest SVN version of vicidial now recommends using mariadb instead of higher versions of mysql?
Vicidial Installation + Configuration + Support + Custom Development
Download my ebook on installing vicidial for free http://download.vicidial.com/ubuntu/VIC ... 100331.pdf
skype: deodax.cordova@gmail.com
m: +639172063730
boybawang
 
Posts: 989
Joined: Sat Nov 14, 2009 1:18 pm
Location: Dumaguete City, Negros Oriental, Philippines

Re: latest svn builds and mariaDB

Postby geoff3dmg » Tue Sep 30, 2014 11:28 am

AFAIK yes. Matt or Kumba would know best though.
Vicibox 5.03 from .iso | VERSION: 2.10-451a BUILD: 140902-0816 | Asterisk 1.8.28.2-vici | Multi-Server | Amfeltec H/W Timing Cards | No Extra Software After Installation | Dell PowerEdge 1850 | Pentium 4 'Prescott' Xenon Quad @ 3.40GHz
geoff3dmg
 
Posts: 403
Joined: Tue Jan 29, 2013 4:35 am
Location: Lancashire, UK

Re: latest svn builds and mariaDB

Postby mflorell » Tue Sep 30, 2014 12:54 pm

Yes, we do not recommend using versions of MySQL higher than the 5.1.X branch. Above that you should use MariaDB.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: latest svn builds and mariaDB

Postby boybawang » Tue Sep 30, 2014 9:37 pm

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
Vicidial Installation + Configuration + Support + Custom Development
Download my ebook on installing vicidial for free http://download.vicidial.com/ubuntu/VIC ... 100331.pdf
skype: deodax.cordova@gmail.com
m: +639172063730
boybawang
 
Posts: 989
Joined: Sat Nov 14, 2009 1:18 pm
Location: Dumaguete City, Negros Oriental, Philippines

Re: latest svn builds and mariaDB

Postby geoff3dmg » Wed Oct 01, 2014 4:26 am

I have the same build as you here. Those tables are MyISAM here.
Vicibox 5.03 from .iso | VERSION: 2.10-451a BUILD: 140902-0816 | Asterisk 1.8.28.2-vici | Multi-Server | Amfeltec H/W Timing Cards | No Extra Software After Installation | Dell PowerEdge 1850 | Pentium 4 'Prescott' Xenon Quad @ 3.40GHz
geoff3dmg
 
Posts: 403
Joined: Tue Jan 29, 2013 4:35 am
Location: Lancashire, UK

Re: latest svn builds and mariaDB

Postby mflorell » Wed Oct 01, 2014 4:59 am

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?
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: latest svn builds and mariaDB

Postby boybawang » Wed Oct 01, 2014 6:11 am

from scratch, thats the table layout after upgrading to innodb, i will have to change it to MyISAM
Vicidial Installation + Configuration + Support + Custom Development
Download my ebook on installing vicidial for free http://download.vicidial.com/ubuntu/VIC ... 100331.pdf
skype: deodax.cordova@gmail.com
m: +639172063730
boybawang
 
Posts: 989
Joined: Sat Nov 14, 2009 1:18 pm
Location: Dumaguete City, Negros Oriental, Philippines

Re: latest svn builds and mariaDB

Postby boybawang » Wed Oct 01, 2014 6:12 am

the database was on 2.4 then upgraded to 2.6 then 2.8 then to the latest 2.10
Vicidial Installation + Configuration + Support + Custom Development
Download my ebook on installing vicidial for free http://download.vicidial.com/ubuntu/VIC ... 100331.pdf
skype: deodax.cordova@gmail.com
m: +639172063730
boybawang
 
Posts: 989
Joined: Sat Nov 14, 2009 1:18 pm
Location: Dumaguete City, Negros Oriental, Philippines


Return to General Discussion

Who is online

Users browsing this forum: Google [Bot] and 43 guests