Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 11 Feb 2015, 01:30
AusPhotography's Avatar
AusPhotography AusPhotography is offline
 
Join Date: Nov 2007
Real name: Rick-owner, Kym-admin
About Databases and other wondrous things (MariaDB)

For some time now MariaDB has been taking over from MySQL as the preferred open source database.

The reasons are well covered here: https://blog.openshift.com/why-maria...ew-with-monty/

WHM/cPanel have been their usual slow (cautious) approach have made MariaDB the future replacing MySQL.

We upgraded this morning. MariaDB is faster and has a smaller memory foot print.
Initially I'm seeing up to ~20% surprisingly faster database; but this won't make a huge difference to your site experience as the database component of any page hit is only 10-15%.
I.e. maybe 2% of the overall transaction.

Why upgrade?
  1. MariaDB is faster
  2. MariaDB has some better features in regards being resilient to crashes
  3. MariaDB has less bugs/issues than MySQL
  4. Very large sites (eg. Wikipedia) have changed to MariaDB
  5. MariaDB also has more than 10,000,000 users now (lots of people with experience and bugs reports etc.)
  6. It is now the default database on some major Linux distributions (again well supported)
  7. It is plug compatible with MySQL - it is easy for us to change
  8. MariaDB is the future and we are protected from the whims of Oracle who now control MySQL
  9. The MariaDB core team is ex MySQL because the did not like Oracle's approach
__________________
www.AusPhotography.net.au a.k.a. AP is a photography forum where members share their photography, photo editing skills and techniques. We run regular photographic competitions; Rick (site owner) and Kym (site tech) using this account
*** Home of the AP fully comprehensive vb4 photographic competition management solution ***
Reply With Quote
  #2  
Old 11 Feb 2015, 04:33
puertoblack2003's Avatar
puertoblack2003 puertoblack2003 is offline
 
Join Date: Aug 2005
Is it free to use? I've heard that they charge for running it.
__________________
Android Custom Creations
Reply With Quote
  #3  
Old 11 Feb 2015, 10:03
Dave Dave is online now
 
Join Date: Jun 2010
Real name: Dave
MariaDB is free to use.
I've been using it for like 1.5 year now and I'm very satisfied with MariaDB.
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #4  
Old 11 Feb 2015, 18:03
Replicant's Avatar
Replicant Replicant is offline
 
Join Date: Sep 2014
Real name: Mel
Originally Posted by AusPhotography View Post
9. The MariaDB core team is ex MySQL because the did not like Oracle's approach
Seems to be a trend with software.
Reply With Quote
  #5  
Old 11 Feb 2015, 21:15
AusPhotography's Avatar
AusPhotography AusPhotography is offline
 
Join Date: Nov 2007
Real name: Rick-owner, Kym-admin
Originally Posted by puertoblack2003 View Post
Is it free to use? I've heard that they charge for running it.
Free as it is fully FOSS.
__________________
www.AusPhotography.net.au a.k.a. AP is a photography forum where members share their photography, photo editing skills and techniques. We run regular photographic competitions; Rick (site owner) and Kym (site tech) using this account
*** Home of the AP fully comprehensive vb4 photographic competition management solution ***
Reply With Quote
  #6  
Old 15 Feb 2015, 21:10
puertoblack2003's Avatar
puertoblack2003 puertoblack2003 is offline
 
Join Date: Aug 2005
Originally Posted by AusPhotography View Post
Free as it is fully FOSS.
I gave it a go. Installed it next to mysql.I ran into some issues with database table corruption.But it was fixed via commands. Going to play around with it and compare it.

regards
__________________
Android Custom Creations
Reply With Quote
  #7  
Old 16 Feb 2015, 08:29
AusPhotography's Avatar
AusPhotography AusPhotography is offline
 
Join Date: Nov 2007
Real name: Rick-owner, Kym-admin
I've got all MySQL tables converted to Aria and the XtraDB default, which replaces InnoDB in place - runs sweet as !

Found a bug... (due to MariaDB versions being '10.0.16-MariaDB')
In ../admincp/index.php line 55 make the following change (vB4.2.2)

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

also in ../admincp/diagnostic.php line 340 make the following change (vB4.2.2)

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

and line 719

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

--------------- Added 16 Feb 2015 at 12:47 ---------------

Found a bug... (due to MariaDB versions being '10.0.16-MariaDB')
In ../admincp/index.php line 55 make the following change (vB4.2.2)

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

__________________
www.AusPhotography.net.au a.k.a. AP is a photography forum where members share their photography, photo editing skills and techniques. We run regular photographic competitions; Rick (site owner) and Kym (site tech) using this account
*** Home of the AP fully comprehensive vb4 photographic competition management solution ***

Last edited by AusPhotography; 17 Feb 2015 at 00:20.
Reply With Quote
  #8  
Old 16 Feb 2015, 14:21
squidsk's Avatar
squidsk squidsk is offline
 
Join Date: Nov 2010
Have you reported that on the bug tracker? It's a small enough bug that it should be able to be fixed.
Reply With Quote
  #9  
Old 16 Feb 2015, 21:21
puertoblack2003's Avatar
puertoblack2003 puertoblack2003 is offline
 
Join Date: Aug 2005
Originally Posted by AusPhotography View Post
I've got all MySQL tables converted to Aria and the XtraDB default, which replaces InnoDB in place - runs sweet as !
can you point me out to how you complish that.I searched around there's little information about mariadb proper configurations etc etc,

thanks
__________________
Android Custom Creations
Reply With Quote
  #10  
Old 17 Feb 2015, 00:09
AusPhotography's Avatar
AusPhotography AusPhotography is offline
 
Join Date: Nov 2007
Real name: Rick-owner, Kym-admin
Originally Posted by puertoblack2003 View Post
can you point me out to how you complish that.I searched around there's little information about mariadb proper configurations etc etc,

thanks
InnoDB -> XtraDB is default for MariaDB > 10.0.8
Aria conversion is easy using phpMyAdmin, just change the table type
or
ALTER TABLE xxxx ENGINE=Aria;

--------------- Added 17 Feb 2015 at 00:23 ---------------

Tracker http://tracker.vbulletin.com/browse/VBIV-16069
__________________
www.AusPhotography.net.au a.k.a. AP is a photography forum where members share their photography, photo editing skills and techniques. We run regular photographic competitions; Rick (site owner) and Kym (site tech) using this account
*** Home of the AP fully comprehensive vb4 photographic competition management solution ***
Reply With Quote
  #11  
Old 17 Feb 2015, 06:02
puertoblack2003's Avatar
puertoblack2003 puertoblack2003 is offline
 
Join Date: Aug 2005
Originally Posted by AusPhotography View Post
InnoDB -> XtraDB is default for MariaDB > 10.0.8
Aria conversion is easy using phpMyAdmin, just change the table type
or
ALTER TABLE xxxx ENGINE=Aria;

--------------- Added 17 Feb 2015 at 00:23 ---------------

Tracker http://tracker.vbulletin.com/browse/VBIV-16069
I'm using 5.5.40 version. do i apply same setting conversion?
__________________
Android Custom Creations
Reply With Quote
  #12  
Old 17 Feb 2015, 17:04
squidsk's Avatar
squidsk squidsk is offline
 
Join Date: Nov 2010
The sql syntax should be the same and as long as the destination engine for the query is installed and enabled (which it should be if that 5.5.40 is mariadb 5.5.40) then yes that sql query should do the trick.
Reply With Quote
  #13  
Old 18 Feb 2015, 09:59
AusPhotography's Avatar
AusPhotography AusPhotography is offline
 
Join Date: Nov 2007
Real name: Rick-owner, Kym-admin
MariaDB did not implement MySQL 5.6 completely due to instability/quality issues.
Hence they started a new numbering system 10.x.x.x
__________________
www.AusPhotography.net.au a.k.a. AP is a photography forum where members share their photography, photo editing skills and techniques. We run regular photographic competitions; Rick (site owner) and Kym (site tech) using this account
*** Home of the AP fully comprehensive vb4 photographic competition management solution ***
Reply With Quote
  #14  
Old 25 Feb 2015, 03:59
AusPhotography's Avatar
AusPhotography AusPhotography is offline
 
Join Date: Nov 2007
Real name: Rick-owner, Kym-admin
Originally Posted by squidsk View Post
Have you reported that on the bug tracker? It's a small enough bug that it should be able to be fixed.
It's in 4.2.3beta 4
__________________
www.AusPhotography.net.au a.k.a. AP is a photography forum where members share their photography, photo editing skills and techniques. We run regular photographic competitions; Rick (site owner) and Kym (site tech) using this account
*** Home of the AP fully comprehensive vb4 photographic competition management solution ***
Reply With Quote
  #15  
Old 27 Apr 2016, 17:50
markoroots markoroots is offline
 
Join Date: May 2013
Real name: Marco Miglietta
Guys after done this, how to fix the right syntax of the sql queries to the database??
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 17:10.

Layout Options | Width: Wide Color: