June 10, 2014 at 3:08 pm #172335
Has anyone worked with MariaDB? Thoughts? Issues?June 10, 2014 at 4:17 pm #172343
Just 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 #172350
@traq I’m trying to install it but running into major issues. I suck at the CL.June 10, 2014 at 5:38 pm #172353
Is there a quick soundbite somewhere on what this project has on MySQL?June 10, 2014 at 6:00 pm #172355
What do you mean by soundbite? You can search for benchmarks which seems to be quite amazing.June 10, 2014 at 7:56 pm #172361
Ok. I got MariaDB installed but now I’m seeing a PHP error regarding
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 #172366
Update: 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
Apparently, 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 #172372
There was an option to use
php5-mysqlndhowever, 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 #172441
MariaDB 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 type
mysql… that’s how much of a drop-in replacement it is.
The best documentation I’ve found for it is here:
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 #172442
Sorry, didn’t see you were switching to SQLite… probably a good call for most uses.June 11, 2014 at 10:49 am #172443
I 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 #172444
Anyway, I’m just messing around with this stuff — nothing important.
Word.July 4, 2014 at 10:40 pm #174656
Finally 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
just 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.
You must be logged in to reply to this topic.