MariaDB vs MySQL

Discussion in 'Databases' started by webmastersb, Oct 30, 2011.

  1. #1
    Hi ,
    Is anyone know about difference between MariaDB and MySQL ?
     
    webmastersb, Oct 30, 2011 IP
  2. shiful

    shiful Peon

    Messages:
    23
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    MariaDB And MySQl Both are Database System. MariaDB Is A Binary drop In Replacement Of The Same MySQL Version.
    Exampley We Can Say , MySQL-5.1 is Compatible With MariaDB-5.1 or 5.2 or 5.3. Both data Base System's Component Are Similar.
    If U Create Any Database By MySQL-5.1 and if you Uninstall MySQL System After Create those Data Base, No Problem
    Those Created Data base Will Work After install MariaDB-5.1 or 5.2 or 5.3.

    The One Difference difference between MariaDB and MySQL is :
    If you are using any of the following options in your /etc/my.cnf or other my.cnf file you should remove them.
    This is also true for MySQL 5.1 or newer or beginner.

    If you uninstalled a MySQL RPM to install MariaDB, note that the MySQL RPM on uninstall renames /etc/my.cnf to /etc/my.cnf.rpmsave.

    After installing MariaDB you should do the following to restore your old configuration options:
    mv -vi/etc/my.cnf.rpmsave/etc/my.cnf

    I think you Have Understood that. If you can Feed Back me.
     
    shiful, Oct 30, 2011 IP
  3. webmastersb

    webmastersb Well-Known Member

    Messages:
    347
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    130
    #3
    Thank you @shiful ,
    which is the best of them for use for site db ?
     
    webmastersb, Oct 30, 2011 IP
  4. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #4
    Maria is significantly improved over out of the box MySQL. However, if your site's database usage is fairly low, then there's not going to be a noticeable difference in performance. The only time you would really need to go with Maria or Percona MySQL branches, are when you need the performance improvements that these offer, or other features like xtrabackup that's not available with standard mysql.
     
    jestep, Oct 31, 2011 IP
  5. Mithuasha

    Mithuasha Banned

    Messages:
    1,056
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Difference between Mysql and MariaDb is that Mysql is bought by Oracle but MariaDB is opensource branch.
     
    Mithuasha, Dec 31, 2011 IP