User Tag List

Thanks useful information Thanks useful information:  7
Results 1 to 3 of 3

Thread: Databases and other tales from the Tech side

  1. #1
    It's all about the Light!
    Tech Admin
    Kym's Avatar
    Join Date
    15 Jun 2008
    Location
    Modbury, Adelaide
    Posts
    9,640
    Mentioned
    17 Post(s)
    Tagged
    0 Thread(s)

    Databases and other tales from the Tech side

    For some time now MariaDB has been taking over from MySQL as the preferred open source database.

    The reasons are well covered here: https://blog.openshift.com/why-maria...ew-with-monty/

    WHM/cPanel (the way our site is managed, i.e. the site management tool set) have been their usual slow (cautious) approach have made MariaDB the future replacing MySQL.

    We upgraded this morning. MariaDB is faster and has a smaller memory foot print. Initially I'm seeing ~20% faster database; but this won't make a huge difference to your site experience as the database component of any page hit is only 10-15%.

    Why upgrade?

    1. MariaDB is faster
    2. MariaDB has some better features in regards being resilient to crashes
    3. MariaDB has less bugs/issues than MySQL
    4. Very large sites (eg. Wikipedia) have changed to MariaDB
    5. MariaDB also has more than 10,000,000 users now (lots of people with experience and bugs reports etc.)
    6. It is now the default database on some major Linux distributions (again well supported)
    7. It is plug compatible with MySQL - it is easy for us to change
    8. MariaDB is the future and we are protected from the whims of Oracle who now control MySQL
    9. The MariaDB core team is ex MySQL because the did not like Oracle's approach
    regards, Kym Gallery Honest & Direct Constructive Critique Appreciated! ©
    Digital & film, Bits of glass covering 10mm to 500mm, and other stuff



  2. #2
    Member
    Join Date
    03 Feb 2012
    Location
    Swan Hill
    Posts
    293
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi Kym, I don't know if its my end or not but since the upgrade, it seems to be a lot slower than before.

    The other problem I have is, if I try to add an attachment from the site that i have uploaded, instead of seeing the picture, I get a link to click on when I post a reply.

  3. #3
    It's all about the Light!
    Tech Admin
    Threadstarter
    Kym's Avatar
    Join Date
    15 Jun 2008
    Location
    Modbury, Adelaide
    Posts
    9,640
    Mentioned
    17 Post(s)
    Tagged
    0 Thread(s)
    The attachment issue is something else
    The speed varied today as I did some maintenance; but is stable now

Posting Permissions

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