Any and all non-support discussions
Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
by 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?
-
boybawang
-
- Posts: 989
- Joined: Sat Nov 14, 2009 1:18 pm
- Location: Dumaguete City, Negros Oriental, Philippines
-
by 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
-
by 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
-
by 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?
-
boybawang
-
- Posts: 989
- Joined: Sat Nov 14, 2009 1:18 pm
- Location: Dumaguete City, Negros Oriental, Philippines
-
by 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
-
by 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
-
by 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
-
boybawang
-
- Posts: 989
- Joined: Sat Nov 14, 2009 1:18 pm
- Location: Dumaguete City, Negros Oriental, Philippines
-
by 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
-
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], jamiemurray and 26 guests