Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: enabling/starting a database service in YAST - MYSQL or MariaDB?

  1. #1

    Default enabling/starting a database service in YAST - MYSQL or MariaDB?

    Hi there,

    I'd heard that MariaDB has effectively replaced MySQL in opensuse.
    I want to enable one of the two to use in Owncloud.

    In YAST it still says MySQL.
    Is that actually starting/enabling MariaDB, or MySQL?

  2. #2
    Join Date
    May 2012
    Location
    Finland
    Posts
    2,022

    Default Re: enabling/starting a database service in YAST - MYSQL or MariaDB?

    MariaDB is installed by default, if for example, you install the LAMP pattern.

    It's merely called 'mysql' in the services for historical compatibility reasons.
    .: miuku #suse @ irc.freenode.net
    :: miuku@opensuse.org

    .: h​ttps://download.opensuse.org/repositories/home:/Miuku/

  3. #3

    Default Re: enabling/starting a database service in YAST - MYSQL or MariaDB?

    Quote Originally Posted by Miuku View Post
    MariaDB is installed by default, if for example, you install the LAMP pattern.

    It's merely called 'mysql' in the services for historical compatibility reasons.
    That's correct.

    But if you mean in YaST->Software Management, both are still included in the distribution.
    "mysql-community-server" is the original MySQL, whereas MariaDB's package name is "mariadb".

    You can also run "mysql -V" to find out which one you are using...

    If you are using MySQL, and want to switch to MariaDB, just install "mariadb". Or the other way round.

  4. #4
    Join Date
    Jun 2008
    Location
    West Yorkshire, UK
    Posts
    3,495

    Default Re: enabling/starting a database service in YAST - MYSQL or MariaDB?

    Quote Originally Posted by wolfi323 View Post
    If you are using MySQL, and want to switch to MariaDB, just install "mariadb". Or the other way round.
    Not now; I have mariadb 10 installed which is not wholly compatible with mysql any longer. You can swap but the recommended way is to create a backup with mysqldump, delete the existing installation, install the new one and then copy the files from the backup. The last wholly compatible versions were 5.5.
    Last edited by john_hudson; 24-Mar-2015 at 15:14. Reason: Additional information

  5. #5

    Default Re: enabling/starting a database service in YAST - MYSQL or MariaDB?

    Quote Originally Posted by john_hudson View Post
    Not now; I have mariadb 10 installed which is not wholly compatible with mysql any longer.
    You are right of course.

    Switching is doable, but well, I shouldn't have mentioned it...

    But then, the question (and my answer) was only about the server, not the databases.
    And MySQL and MariaDB _should_ be compatible from a client's point of view.
    Last edited by wolfi323; 24-Mar-2015 at 15:42.

  6. #6

    Default Re: enabling/starting a database service in YAST - MYSQL or MariaDB?

    Quote Originally Posted by Miuku View Post
    MariaDB is installed by default, if for example, you install the LAMP pattern.

    It's merely called 'mysql' in the services for historical compatibility reasons.
    cheers, as long as the YAST enabled "MySQL" service is calling MariaDB i'm happy (might as well use the recommended service).

    p.s. are there other areas i might bump into confusion enabling ownlcoud to use the Dafault opensuse database (i.e. MariaDB)?

    Thank you all.

  7. #7
    Join Date
    Jun 2008
    Location
    West Yorkshire, UK
    Posts
    3,495

    Default Re: enabling/starting a database service in YAST - MYSQL or MariaDB?

    You'd have to be doing something fairly specialised to encounter differences; anything straightforward isn't going to be affected. The mariadb documentation at https://mariadb.com/kb/en/ sets out clearly where there are differences.

  8. #8

    Default Re: enabling/starting a database service in YAST - MYSQL or MariaDB?

    Quote Originally Posted by john_hudson View Post
    You'd have to be doing something fairly specialised to encounter differences; anything straightforward isn't going to be affected. The mariadb documentation at https://mariadb.com/kb/en/ sets out clearly where there are differences.
    aha, that is at a lower level that i am anticipating.

    really only thinking of initial owncloud setup, where i tell it not to use SQLlite, and look for (m)SQL instead.

    will owncloud point itself to mariadb, or will it be looking for mysql, when it is mariadb i enabled in the YAST services (even though it says mysql).


  9. #9
    Join Date
    May 2012
    Location
    Finland
    Posts
    2,022

    Default Re: enabling/starting a database service in YAST - MYSQL or MariaDB?

    Quote Originally Posted by Jedibeeftrix View Post
    aha, that is at a lower level that i am anticipating.
    To this date I'm yet to encounter any application that doesn't work on MariaDB out of the box compared to MySQL.

    With support for things like TokuDB and Galera Cluster out of the box, if anything, MariaDB now offers more features than MySQL.
    .: miuku #suse @ irc.freenode.net
    :: miuku@opensuse.org

    .: h​ttps://download.opensuse.org/repositories/home:/Miuku/

  10. #10

    Default Re: enabling/starting a database service in YAST - MYSQL or MariaDB?

    Quote Originally Posted by Jedibeeftrix View Post
    will owncloud point itself to mariadb, or will it be looking for mysql, when it is mariadb i enabled in the YAST services (even though it says mysql).
    OwnCloud will not "point itself" to anything, I would say.

    I don't know owncloud from experience, but normally you'd have to tell it during installation/configuration to which mysql server it should connect.
    This communication runs via sockets or TCP, so it doesn't care at all nor chooses whether mariadb or mysql (or whatever else that might provide the same interface) runs. It just connects to the running instance that you tell it to connect to.
    And it's the same with all other clients.

    So, if you installed mariadb and are starting mariadb during boot, and tell owncloud to connect to localhost, it'd be using mariadb of course.

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •