Announcement

Collapse
No announcement yet.

MariaDB 10 Guide.

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    Hi Justin
    Many thanks, and I havenot tried Mariadb myself, but guessing removal of old 5.x before installing new 10.x, is most likely because it of conflicts/errors on dependecies, therefore it is easier to remove and install, then go through all depency failures.
    I stress this is just my thoughts and may not be correct
    Many thanks
    John

    Comment


    • #17
      I was hoping this thread would be more updated by now as to the compatibility with interworx features. I know interworx has it's own DB for itself, but I'm talking about where interworx interacts with SiteWorx accounts...like backups for example.

      I'm thinking I might get a cheap cloud VPS at my datacenter with InterWorx and just test it out for a month before I try to upgrade my live server. The one feature that I do like on the new MySQL5.6 (which is equivalent to the MariaDB 10.0) is Full-Text indexes with an innodb table. That would be immediately helpful in a handful of sites I host right now and more going forward.

      But not sure if the trade off is worth it as far as interworx compatibility.
      [ JUSTIN ]
      [ OFF unit ]
      [ WEB DESIGN / DEVELOPMENT, GRAPHIC DESIGN, OTHER STUFF
      ]

      Comment


      • #18
        Hi Justin

        As far as I know, all features work as expected but the only issue is the version shown for MySQL in the IW-CP

        Many thanks

        John

        Comment


        • #19
          So I got word from the interworx team that a bug report has been filed for the version being shown wrong.

          Also, I'm getting my test VPS setup today and going to give this a try following the guide in this thread and this one https://www.liquidweb.com/kb/how-to-...0-on-centos-7/
          [ JUSTIN ]
          [ OFF unit ]
          [ WEB DESIGN / DEVELOPMENT, GRAPHIC DESIGN, OTHER STUFF
          ]

          Comment


          • #20
            Hi Justin

            Many thanks

            I'm sure it will go well for you, as it appears to for others who have posted but appreciate how you got on in an update

            Many thanks

            John

            Comment


            • #21
              Wow, thank you for this tutorial, it's awesome!
              To want to, is to be able to. spelautomater

              Comment


              • #22
                Hopefully your how too may inspire others to post their how too

                Comment


                • #23
                  Question. After upgrading mariadb to 10, interworx cannot stop and start because its trying to use systemd mysqld.service which doesn't exist.
                  How can we map this to mysql.service instead? I tried to find the systemd config for mysql.service to setup symlink but couldnt find that either. Any ideas much appreciated.

                  Thanks,

                  Comment


                  • #24
                    Very good guide, thanks!
                    Web Hosting UK - Affordable Web Hosting and Domains.

                    Comment


                    • #25
                      After all, is MariaDB good and worth the effort to setup?! I have heard many good and bad things about it.
                      Tech Drol

                      Comment


                      • #26
                        Hi rasa

                        Changing from MySQL to mariadb is entirely your choice.

                        If it helps decide, IW on Centos 7 use mariadb and we also use mariadb on centos 7, running latest IW-CP

                        Many thanks

                        John

                        Comment


                        • #27
                          I just wanted to check back in on this. What is InterWorx stance on upgrading our servers to MariaDB? Is there any official repos from Iworx or would following this guide still be the best path?
                          [ JUSTIN ]
                          [ OFF unit ]
                          [ WEB DESIGN / DEVELOPMENT, GRAPHIC DESIGN, OTHER STUFF
                          ]

                          Comment


                          • #28
                            Hi Justin

                            I hope your well and had a lovely Christmas break

                            I would just follow the thread to upgrade to mariaDB

                            We have updated our centos 7 servers and all appears to work lovely. Just make sure you make backups first

                            Hope that helps a little

                            Many thanks

                            John

                            Comment


                            • #29
                              Thanks John, looking back through this thread I believe all my test almost exactly 2 years ago worked fine, I just never *needed* to upgrade, but now I'm hitting the point where some applications need it. Do you know if there is an easy downgrade path? If I run into issues. Can I just easily downgrade by using yum?

                              I think just to be safe I will move over some of my larger / complex sites onto a test server and do the upgrade again (like I did 2 years ago) and just make sure it's all good.

                              Glad to hear it's working well for you!
                              [ JUSTIN ]
                              [ OFF unit ]
                              [ WEB DESIGN / DEVELOPMENT, GRAPHIC DESIGN, OTHER STUFF
                              ]

                              Comment


                              • #30
                                Hi Justin

                                Many thanks

                                I do not think you would be able to yum downgrade as the original had been removed.

                                So Iím thinking you would need to remove mariaDB first and then install MySQL most likely from IW repos

                                Sorry if I am wrong though

                                Many thanks

                                John

                                Comment

                                Working...
                                X