Forums

This topic contains 16 replies, has 4 voices, and was last updated by  __ 4 years, 6 months ago.

Viewing 15 posts - 1 through 15 (of 17 total)
  • Author
    Posts
  • #172335

    chrisburton
    Participant

    Has anyone worked with MariaDB? Thoughts? Issues?

    #172343

    __
    Participant

    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?

    #172350

    chrisburton
    Participant

    @traq I’m trying to install it but running into major issues. I suck at the CL.

    #172353

    shaneisme
    Participant

    Is there a quick soundbite somewhere on what this project has on MySQL?

    #172355

    chrisburton
    Participant

    What do you mean by soundbite? You can search for benchmarks which seems to be quite amazing.

    #172361

    chrisburton
    Participant

    Ok. 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).

    #172366

    chrisburton
    Participant

    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.

    #172367

    __
    Participant

    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!

    #172372

    chrisburton
    Participant

    There 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.

    #172441

    nixnerd
    Participant

    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:

    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?

    #172442

    nixnerd
    Participant

    Sorry, didn’t see you were switching to SQLite… probably a good call for most uses.

    #172443

    chrisburton
    Participant

    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.

    #172444

    nixnerd
    Participant

    Anyway, I’m just messing around with this stuff — nothing important.

    Word.

    #174656

    chrisburton
    Participant

    Finally got this to work. I just had to remove mysql and reinstall MariaDB

    sudo yum remove mysql*
    
    sudo yum install MariaDB*
    
    #174658

    __
    Participant

    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.

Viewing 15 posts - 1 through 15 (of 17 total)

You must be logged in to reply to this topic.

icon-link icon-logo-star icon-search icon-star