{"id":256,"date":"2022-04-01T16:46:00","date_gmt":"2022-04-01T09:46:00","guid":{"rendered":"http:\/\/congdong.longvan.net\/?p=256"},"modified":"2022-04-01T17:27:36","modified_gmt":"2022-04-01T10:27:36","slug":"huong-dan-nang-cap-mysql-mariadb-tren-directadmin","status":"publish","type":"post","link":"https:\/\/longvan.net\/cong-dong\/huong-dan-nang-cap-mysql-mariadb-tren-directadmin\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn n\u00e2ng c\u1ea5p MySQL\/MariaDB tr\u00ean DirectAdmin"},"content":{"rendered":"
\n
I. T\u1ed5ng quan
\n<\/strong><\/h5>\n

MySQL<\/strong> l\u00e0 m\u1ed9t h\u1ec7 th\u1ed1ng qu\u1ea3n tr\u1ecb c\u01a1 s\u1edf d\u1eef li\u1ec7u m\u00e3 ngu\u1ed3n m\u1edf (g\u1ecdi t\u1eaft l\u00e0 RDBMS) ho\u1ea1t \u0111\u1ed9ng theo m\u00f4 h\u00ecnh client-server.
\n
\nMariaDB<\/strong> l\u00e0 h\u1ec7 qu\u1ea3n tr\u1ecb c\u01a1 s\u1edf d\u1eef li\u1ec7u mi\u1ec5n ph\u00ed \u0111\u01b0\u1ee3c ph\u00e1t tri\u1ec3n t\u1eeb h\u1ec7 qu\u1ea3n tr\u1ecb c\u01a1 s\u1edf d\u1eef li\u1ec7u m\u00e3 ngu\u1ed3n m\u1edf MySQL. MariaDB \u0111\u01b0\u1ee3c ph\u00e1t tri\u1ec3n nh\u1eb1m thay th\u1ebf c\u00f4ng ngh\u1ec7 c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL, v\u00ec th\u1ebf n\u00f3 t\u01b0\u01a1ng th\u00edch v\u00e0 cho m\u1ed9t hi\u1ec7u su\u1ea5t cao h\u01a1n so v\u1edbi MySQL.<\/p>\n

M\u1ed9t s\u1ed1 t\u00ednh n\u0103ng chung th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng tr\u00ean MySQL\/MariaDB <\/strong>:<\/p>\n

    \n
  • T\u1ea1o m\u1edbi v\u00e0 qu\u1ea3n l\u00fd c\u01a1 s\u1ee1 d\u1eef li\u1ec7u (hay c\u00f2n g\u1ecdi l\u00e0 Database).<\/li>\n
  • L\u01b0u tr\u1eef c\u01a1 s\u1ee1 d\u1eef li\u1ec7u (hay c\u00f2n g\u1ecdi l\u00e0 Database).<\/li>\n
  • H\u1ed7 tr\u1ee3 l\u00e0m n\u1ec1n t\u1ea3ng \u0111\u1ec3 kh\u1edfi t\u1ea1o web site.<\/li>\n
  • \u0110a t\u00ednh n\u0103ng:\u00a0MySQL c\u00f3 th\u1ec3 h\u1ed7 tr\u1ee3 h\u00e0ng lo\u1ea1t c\u00e1c ch\u1ee9c n\u0103ng SQL t\u1eeb h\u1ec7 qu\u1ea3n tr\u1ecb c\u01a1 s\u1edf d\u1eef li\u1ec7u quan h\u1ec7 tr\u1ef1c ti\u1ebfp v\u00e0 c\u1ea3 gi\u00e1n ti\u1ebfp tr\u00ean nhi\u1ec1u n\u1ec1n t\u1ea3ng.<\/li>\n<\/ul>\n
    \u00a0II. <\/strong>N\u00e2ng c\u1ea5p database
    \n<\/strong><\/h5>\n
      \n
    1. B\u01b0\u1edbc 1: X\u00e1c \u0111\u1ecbnh lo\u1ea1i database \u0111ang s\u1eed d\u1ee5ng (MySQL\/MariaDB)<\/strong>: \u0111\u1ec3 ki\u1ec3m tra \u0111\u01b0\u1ee3c database DirectAdmin \u0111ang s\u1eed d\u1ee5ng l\u00e0 lo\u1ea1i n\u00e0o, ti\u1ebfn h\u00e0nh nh\u01b0 sau:\n
        \n
      • Truy c\u1eadp SSH v\u00e0o server DirectAdmin.<\/li>\n
      • Truy c\u1eadp MySQL b\u1eb1ng l\u1ec7nh sau:
        \n# mysql -V<\/em>
        \nho\u1eb7c
        \n# mysql -u root -p<\/em>
        \nNh\u01b0 \u1edf d\u01b0\u1edbi v\u00ed d\u1ee5 m\u00ecnh l\u00e0 phi\u00ean b\u1ea3n \u201cMariaDB 5.5.68<\/strong>\u201d.
        \n\"image-1633428545151.png\"<\/li>\n
      • Ngo\u00e0i ra, lo\u1ea1i database \u0111ang s\u1eed d\u1ee5ng tr\u00ean DirectAdmin c\u0169ng c\u00f3 th\u1ec3 ki\u1ec3m tra b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng custombuild, th\u1ef1c hi\u1ec7n c\u00e1c l\u1ec7nh c\u1ee5 th\u1ec3 nh\u01b0 sau:
        \n# cd \/usr\/local\/directadmin\/custombuild<\/em>
        \n# .\/build versions<\/em>
        \n\"image-1633428588351.png\"<\/li>\n<\/ul>\n<\/li>\n
      • B\u01b0\u1edbc 2: C\u1eadp nh\u1eadt <\/strong> MariaDB\/MySQL<\/strong>\n
          \n
        • V\u1edbi MariaDB<\/strong>\n
            \n
          • B1:<\/strong> Di chuy\u1ec3n t\u1edbi th\u01b0 m\u1ee5c custombuild sau \u0111\u00f3 nh\u1eadp nh\u1eefng l\u1ec7nh d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 c\u1eadp nh\u1eadt c\u00e1c phi\u00ean b\u1ea3n m\u1edbi nh\u1ea5t c\u1ee7a \u1ee9ng d\u1ee5ng\/d\u1ecbch v\u1ee5 m\u00e0 Direct Admin qu\u1ea3n l\u00fd:
            \n# cd \/usr\/local\/directadmin\/custombuild<\/em>
            \n# .\/build update<\/em>
            \n# .\/build version<\/em><\/li>\n
          • B2: <\/strong>X\u00e1c \u0111\u1ecbnh phi\u00ean b\u1ea3n MariaDB mu\u1ed1n n\u00e2ng c\u1ea5p \u0111\u1ebfn. C\u00e1c phi\u00ean b\u1ea3n c\u00f3 h\u1ed7 tr\u1ee3 tr\u00ean DirectAdmin bao g\u1ed3m 5.5, 10.0, 10.1, 10.2, 10.3 v\u00e0 10.4<\/li>\n
          • B3:<\/strong> C\u1eadp nh\u1eadt l\u1ea1i version MariaDB
            \nTh\u1ef1c hi\u1ec7n c\u00e1c l\u1ec7nh nh\u01b0 sau: (trong v\u00ed d\u1ee5 n\u00e0y s\u1ebd n\u00e2ng c\u1ea5p \u0111\u1ebfn phi\u00ean b\u1ea3n mariadb 10.1)
            \n# cd \/usr\/local\/directadmin\/custombuild<\/em>
            \n# .\/build set mariadb 10.1<\/em>
            \n# .\/build set mysql_inst mariadb<\/em>
            \n# .\/build set mysql_backup yes<\/em>
            \n# .\/build update
            \n\"image-1633428656415.png\"<\/em>
            \n# .\/build mariadb
            \n<\/em>Khi ch\u1ea1y l\u1ec7nh # .\/build mariadb<\/strong>\u00a0 ta ch\u1edd trong gi\u00e2y l\u00e1t
            \n\"image-1633428718685.png\"<\/em>
            \n.\"image-1633428709053.png\"<\/li>\n
          • L\u01b0u \u00fd: <\/strong>Khi \u0111\u00e3 th\u1ef1c h\u1ec7nh c\u00e1c l\u1ec7nh \u2018.\/build set *<\/strong>\u2018. Ch\u00fang ta c\u00f3 th\u1ec3 xem l\u1ea1i file b\u1eb1ng l\u1ec7nh d\u01b0\u1edbi \u0111\u00e2y:
            \n# cat \/usr\/local\/directadmin\/custombuild\/options.conf<\/em><\/em><\/li>\n<\/ul>\n<\/li>\n
          • V\u1edbi MySQL:<\/strong>\n
              \n
            • B1:<\/strong> Di chuy\u1ec3n t\u1edbi th\u01b0 m\u1ee5c custombuild sau \u0111\u00f3 nh\u1eadp nh\u1eefng l\u1ec7nh d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 c\u1eadp nh\u1eadt c\u00e1c phi\u00ean b\u1ea3n m\u1edbi nh\u1ea5t c\u1ee7a \u1ee9ng d\u1ee5ng\/d\u1ecbch v\u1ee5 m\u00e0 Direct Admin qu\u1ea3n l\u00fd:
              \n# cd \/usr\/local\/directadmin\/custombuild<\/em>
              \n# .\/build update<\/em>
              \n# .\/build version<\/em><\/li>\n
            • B2: <\/strong>X\u00e1c \u0111\u1ecbnh phi\u00ean b\u1ea3n MySQL mu\u1ed1n n\u00e2ng c\u1ea5p \u0111\u1ebfn. C\u00e1c phi\u00ean b\u1ea3n c\u00f3 h\u1ed7 tr\u1ee3 tr\u00ean DirectAdmin bao g\u1ed3m 5.1, 5.5, 5.6, 5.7 ho\u1eb7c 8.0.<\/li>\n
            • B3<\/strong>: C\u1eadp nh\u1eadt phi\u00ean b\u1ea3n MySQL b\u1eb1ng c\u00e1c l\u1ec7nh sau: (v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y s\u1ebd n\u00e2ng c\u1ea5p \u0111\u1ebfn phi\u00ean b\u1ea3n 8.0)
              \n<\/strong># cd \/usr\/local\/directadmin\/custombuild<\/em>
              \n# .\/build set mysql 8.0<\/em>
              \n# .\/build set mysql_inst mysql<\/em>
              \n# .\/build set mysql_backup yes<\/em>
              \n# .\/build update<\/em>
              \n\"image-1633428851212.png\"<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n
            • B\u01b0\u1edbc 3: Rebuid PHP: <\/strong>\n
                \n
              • Sau khi c\u1eadp nh\u1eadt d\u1ecbch v\u1ee5 Database<\/strong> nh\u01b0 MySQL\/MariaDB<\/strong> th\u00ec c\u1ea7n ph\u1ea3i recompile l\u1ea1i PHP version<\/strong> \u0111\u1ec3 c\u00f3 th\u1ec3 c\u1eadp nh\u1eadt s\u1eed d\u1ee5ng c\u00e1c th\u01b0 vi\u1ec7n m\u1edbi c\u1ee7a d\u1ecbch v\u1ee5 MySQL\/MariaDB<\/strong> \u0111\u00e3 \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt, n\u1ebfu kh\u00f4ng recompile s\u1ebd d\u1ec5 ph\u00e1t sinh l\u1ed7i h\u1ec7 th\u1ed1ng website \u0111ang ch\u1ea1y.<\/li>\n
              • Ti\u1ebfp t\u1ee5c ti\u1ebfn h\u00e0nh c\u1eadp nh\u1eadt trong th\u01b0 m\u1ee5c custombuild
                \n# .\/build php n<\/em><\/li>\n
              • Sau khi recompile l\u1ea1i PHP<\/strong> version, ta ti\u1ebfn c\u00f3 th\u1ec3 ti\u1ebfn h\u00e0nh ki\u1ec3m tra l\u1ea1i version hi\u1ec7n l\u1ea1i c\u1ee7a MySQL\/MariaDB<\/strong> b\u1eb1ng l\u1ec7nh sau
                \n# mysql -V
                \n<\/em>Ho\u1eb7c c\u00e1c l\u1ec7nh t\u01b0\u01a1ng t\u1ef1 \u1edf B\u01b0\u1edbc 1
                \n<\/em><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n

                Nh\u01b0 v\u1eady, Long V\u00e2n \u0111\u00e3 ho\u00e0n th\u00e0nh h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n n\u00e2ng c\u1ea5p MySQL\/MariaDB s\u1eed d\u1ee5ng panel DirecAdmin.
                \nCh\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng !
                \n<\/em><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

                I. T\u1ed5ng quan MySQL l\u00e0 m\u1ed9t h\u1ec7 th\u1ed1ng qu\u1ea3n tr\u1ecb c\u01a1 s\u1edf d\u1eef li\u1ec7u m\u00e3 ngu\u1ed3n m\u1edf (g\u1ecdi t\u1eaft l\u00e0 RDBMS) ho\u1ea1t \u0111\u1ed9ng theo m\u00f4 h\u00ecnh client-server. MariaDB l\u00e0 h\u1ec7 qu\u1ea3n tr\u1ecb c\u01a1 s\u1edf d\u1eef li\u1ec7u mi\u1ec5n ph\u00ed \u0111\u01b0\u1ee3c ph\u00e1t tri\u1ec3n t\u1eeb h\u1ec7 qu\u1ea3n tr\u1ecb c\u01a1 s\u1edf d\u1eef li\u1ec7u m\u00e3 ngu\u1ed3n m\u1edf MySQL. MariaDB \u0111\u01b0\u1ee3c […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_oasis_is_in_workflow":0,"_oasis_original":0,"footnotes":""},"categories":[28],"tags":[],"class_list":["post-256","post","type-post","status-publish","format-standard","hentry","category-directadmin"],"_links":{"self":[{"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts\/256","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/comments?post=256"}],"version-history":[{"count":2,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts\/256\/revisions"}],"predecessor-version":[{"id":276,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts\/256\/revisions\/276"}],"wp:attachment":[{"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/media?parent=256"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/categories?post=256"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/tags?post=256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}