Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 23 Jun 2014, 13:25
Alfa1's Avatar
Alfa1 Alfa1 is offline
 
Join Date: Dec 2005
Can I switch to MariaDB with vb3.8?

Is vbulletin 3.8 compatible with MariaDB 10?
Will I run into any problems if I switch from MySQL 5.5 to MariaDB 10?
Reply With Quote
  #2  
Old 23 Jun 2014, 15:36
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
I'm using MariaDB on my vBulletin 4 installation and it works perfectly fine. MariaDB is basically just a MySQL fork. The functionality is exactly the same as MariaDB, you just keep using the same MySQL extension.
Reply With Quote
  #3  
Old 23 Jun 2014, 15:53
Alfa1's Avatar
Alfa1 Alfa1 is offline
 
Join Date: Dec 2005
I am currently using mysql 5.5. So this means I should use mysql 5.5 + mariaDB 10? Or is there a minimum version for mariadb?
Reply With Quote
  #4  
Old 23 Jun 2014, 16:19
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
Originally Posted by Alfa1 View Post
I am currently using mysql 5.5. So this means I should use mysql 5.5 + mariaDB 10? Or is there a minimum version for mariadb?
The difference between MariaDB 10 and 5.5 is that MariaDB 10 has new unique features and contains features ported over from MySQL 5.6. I don't think it matters if you use MariaDB 10 or 5.5, I would just use 5.5 though.
Reply With Quote
  #5  
Old 23 Jun 2014, 16:49
Alfa1's Avatar
Alfa1 Alfa1 is offline
 
Join Date: Dec 2005
If vbulletin 3.8 is compatible with mysql 5.6 then I will just use mariadb 10.
But I have no clue if vb 3.8 is compatible with mysql 5.6
Does anyone know?
Reply With Quote
  #6  
Old 23 Jun 2014, 16:57
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
Originally Posted by Alfa1 View Post
If vbulletin 3.8 is compatible with mysql 5.6 then I will just use mariadb 10.
But I have no clue if vb 3.8 is compatible with mysql 5.6
Does anyone know?
According to vBulletin.com:
Originally Posted by vBulletin.com
vBulletin 3.8.0 requires at least PHP 4.3.3 and MySQL 4.0.16 (These are the same requirements as vBulletin 3.7), but we strongly recommend that all customers run PHP 5.2.8 with APC and MySQL 5.1.30 or later.
You can always give it a shot, it shouldn't be too hard to downgrade in case it does not work.
Reply With Quote
  #7  
Old 23 Jun 2014, 17:02
Alfa1's Avatar
Alfa1 Alfa1 is offline
 
Join Date: Dec 2005
You have a point there. I asked vb staff some time ago but they did not respond.
Reply With Quote
  #8  
Old 23 Jun 2014, 19:41
vbresults vbresults is offline
 
Join Date: Apr 2009
I'm running the latest MariaDB 5.5 on vB 3.8 without any issues.
Reply With Quote
  #9  
Old 23 Jun 2014, 23:46
Alfa1's Avatar
Alfa1 Alfa1 is offline
 
Join Date: Dec 2005
Do you use 3.8.8 or 3.8.7?
Reply With Quote
  #10  
Old 24 Jun 2014, 00:07
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
As far as I remember, there are no query differences between 3.8.7 & 3.8.8.

(but its over a year since i did most of the changes, so I may have forgotton something).
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #11  
Old 24 Jun 2014, 00:18
Alfa1's Avatar
Alfa1 Alfa1 is offline
 
Join Date: Dec 2005
IIRC this was changed: http://www.vbulletin.com/forum/forum...-dbalter-class
But I altered that anyway and am using mysql 5.5
I wonder if there was anythign more.
Reply With Quote
  #12  
Old 24 Jun 2014, 00:27
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
You're right, that was fixed in 388, but those are not used in day to day running of the forum anyway.

I see no reason 387/388 would not run happily on mariadb or mysql 5.6.

My local dev server runs mysql 5.6.14, and I have test vb3 sites that run just fine (even my test vb.org, which is vb 3.6.12).
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #13  
Old 24 Jun 2014, 01:37
Alfa1's Avatar
Alfa1 Alfa1 is offline
 
Join Date: Dec 2005
Thanks. This is all very helpful. I'll upgrade to mysql 5.6 first. If that runs well (which seems likely) then I'll go for MariaDB 10 or even Percona if that turns out to be better.
Reply With Quote
  #14  
Old 24 Jun 2014, 16:54
vbresults vbresults is offline
 
Join Date: Apr 2009
Originally Posted by Alfa1 View Post
Do you use 3.8.8 or 3.8.7?
Did both with no problems, now running 3.8.8.

You might be thinking of the PHP version, which can definitely play into this.
Reply With Quote
  #15  
Old 25 Jun 2014, 08:44
Alfa1's Avatar
Alfa1 Alfa1 is offline
 
Join Date: Dec 2005
im getting loads of this now:

Database error in vBulletin 3.8.7:

Invalid SQL:

INSERT INTO vb_postlog
(postid, useragent, ip, dateline)
VALUES
(1484838, 'Mozilla/5.0 (BlackBerry; U; BlackBerry 9360; en) AppleWebKit/534.11+ (KHTML, like Gecko) Version/7.1.0.258 Mobile Safari/534.11+', 2927070735, 1403684239);

MySQL Error : Data too long for column 'useragent' at row 1
Error Number : 1406


I have set the string to 255 which is the max, but it still results in errors. Probably because of UFT-8. What to do?

Last edited by Alfa1; 25 Jun 2014 at 09:05.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 08:40.

Layout Options | Width: Wide Color: