- This topic is empty.
-
AuthorPosts
-
June 10, 2014 at 3:08 pm #172335chrisburtonParticipant
Has anyone worked with MariaDB? Thoughts? Issues?
June 10, 2014 at 4:17 pm #172343__ParticipantJust starting my first project using it. I’ve done a lot of reading, though, and I don’t expect any issues. They’ve gone to great lengths to make it a “drop in” replacement for MySQL. You using it?
June 10, 2014 at 5:09 pm #172350chrisburtonParticipant@traq I’m trying to install it but running into major issues. I suck at the CL.
June 10, 2014 at 5:38 pm #172353shaneismeParticipantIs there a quick soundbite somewhere on what this project has on MySQL?
June 10, 2014 at 6:00 pm #172355chrisburtonParticipantWhat do you mean by soundbite? You can search for benchmarks which seems to be quite amazing.
June 10, 2014 at 7:56 pm #172361chrisburtonParticipantOk. I got MariaDB installed but now I’m seeing a PHP error regarding
new mysqli($params)
Warning: mysqli::mysqli(): Headers and client library minor version mismatch. Headers:50171 Library:50312
The reason for the error is because I am running two incompatible versions.
Client API library version => 5.3.12-MariaDB Client API header version => 5.1.71
How do I update the header version? I’m on Centos 6 (64).
June 10, 2014 at 10:13 pm #172366chrisburtonParticipantUpdate: removed MariaDB.
MariaDB was slowing down my website quite noticeably. I assume it was because of the above. For now, I have switched back to MySQL.
June 10, 2014 at 10:55 pm #172367__ParticipantApparently, the header=>client issue is common enough that they have a page for it. (It’s also not strictly a MariaDB issue; it’s an upgrading issue.)
Did you get the headers upgraded before uninstalling? if so, you still had performance problems?
Once I get to that phase of my project, I’ll let you know how it goes. But honestly I’m surprised, maria has nothing but outstanding reviews. Guess we’ll see!
June 11, 2014 at 1:09 am #172372chrisburtonParticipantThere was an option to use
php5-mysqlnd
however, that package was not found. No idea. I’m looking at SQLite right now.But honestly I’m surprised, maria has nothing but outstanding reviews. Guess we’ll see!
It could have been the commands I was entering. Like I said, I’m completely horrible at it. Ha. Who knows what I screwed up. Also, it must be decent if Wikipedia and Google switched to it. I’m just not sure if I’ll see noticeable results with small queries. I’m hoping that’s where SQLite comes in.
June 11, 2014 at 10:38 am #172441nixnerdParticipantMariaDB is now the default database on Arch Linux… therefore I use it. I use it both on my local LEMP stack as well as my VPS LEMP stack. I’ve had absolutely zero issues with it at all. In fact, when a command on the CLI requires you to type
mysql
, you still typemysql
… that’s how much of a drop-in replacement it is.The best documentation I’ve found for it is here:
https://wiki.archlinux.org/index.php/MySQL
It really shouldn’t be THAT different on your system, as the MariaDB CLI will be the same.
Also, this is technically MySQL documentation, but it all applies to Maria DB. BTW, are you trying to install this on your VPS or your local machine @chrisburton?
June 11, 2014 at 10:39 am #172442nixnerdParticipantSorry, didn’t see you were switching to SQLite… probably a good call for most uses.
June 11, 2014 at 10:49 am #172443chrisburtonParticipantI was trying to install it on my VPS but ran into mismatching issues (shown above). But I highly doubt the performance increase (if at all) would be beneficial for such a small database with few queries. I switched over to SQLite and MySQL had better response times. I think I might stick with MySQL after all because the queries are taking a fraction of a millisecond. It would be a waste of time.
Anyway, I’m just messing around with this stuff — nothing important.
June 11, 2014 at 10:57 am #172444nixnerdParticipantAnyway, I’m just messing around with this stuff — nothing important.
Word.
July 4, 2014 at 10:40 pm #174656chrisburtonParticipantFinally got this to work. I just had to remove mysql and reinstall MariaDB
sudo yum remove mysql* sudo yum install MariaDB*
July 4, 2014 at 11:19 pm #174658__Participantjust had to remove mysql and reinstall MariaDB
Ah. MySQL and MariaDB were probably competing for the same server port. Just for future info, it should be entirely possible for the two to coexist, with a little setup work.
-
AuthorPosts
- The forum ‘Other’ is closed to new topics and replies.