{"id":252,"date":"2022-04-01T16:36:43","date_gmt":"2022-04-01T09:36:43","guid":{"rendered":"http:\/\/congdong.longvan.net\/?p=252"},"modified":"2022-04-01T17:27:15","modified_gmt":"2022-04-01T10:27:15","slug":"huong-dan-chuyen-doi-mysql-sang-mariadb-tren-directadmin","status":"publish","type":"post","link":"https:\/\/longvan.net\/cong-dong\/huong-dan-chuyen-doi-mysql-sang-mariadb-tren-directadmin\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn chuy\u1ec3n \u0111\u1ed5i MySQL sang MariaDB tr\u00ean DirectAdmin"},"content":{"rendered":"
\n
I. T\u1ed5ng quan:<\/strong><\/h5>\n
    \n
  1. MySQL l\u00e0 g\u00ec?
    \n<\/strong>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.<\/li>\n
  2. MariaDB l\u00e0 g\u00ec?<\/strong>
    \nMariaDB 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.<\/li>\n
  3. L\u00fd do m\u00e0 ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n chuy\u1ec3n t\u1eeb mysql sang mariadb :
    \n<\/strong>Hi\u1ec7n nay v\u00ec m\u1ed9t l\u00fd do n\u00e0o \u0111\u00f3 m\u00e0 ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n s\u1eed d\u1ee5ng MariaDB h\u01a1n l\u00e0 MySQL nh\u01b0:<\/p>\n
      \n
    • H\u1ed5 tr\u1ee3 nhi\u1ec1u c\u00f4ng c\u1ee5 l\u01b0u tr\u1eef h\u01a1n mysql v\u00e0 ph\u00e1t h\u00e0nh sau mysql.<\/li>\n
    • L\u00e0 m\u1ed9t m\u00e3 ngu\u1ed3n m\u1edf th\u1eadt s\u1ef1 v\u00ec hi\u1ec7n t\u1ea1i MySQL ch\u1ecbu s\u1ef1 chi ph\u1ed1i c\u1ee7a oracle v\u00e0 kh\u00f4ng v\u1eadn h\u00e0nh b\u1edfi c\u1ed9ng \u0111\u1ed3ng.<\/li>\n
    • MariaDB \u0111\u01b0\u1ee3c b\u1ea3o tr\u00ec b\u1edfi ng\u01b0\u1eddi t\u1ea1o ra MySQL.<\/li>\n
    • Ho\u00e0n to\u00e0n t\u01b0\u01a1ng th\u00edch v\u1edbi MySQL.<\/li>\n
    • Nhi\u1ec1u t\u00ednh n\u0103ng hay h\u01a1n MySQL.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n
      II. H\u01b0\u1edbng d\u1eabn chuy\u1ec3n MySQL sang MariaDB tr\u00ean DirectAdmin:<\/strong><\/h5>\n
        \n
      1. B\u01b0\u1edbc 1:\u00a0<\/strong>ki\u1ec3m tra:\n
          \n
        • Y\u00eau c\u1ea7u version DirectAdmin ph\u1ea3i tr\u00ean 1.5 v\u00e0 version Custombuild ph\u1ea3i tr\u00ean 2.0<\/li>\n
        • SSH v\u00e0o server v\u00e0 th\u1ef1c hi\u1ec7n c\u00e1c l\u1ec7nh \u0111\u1ec3 ki\u1ec3m tra version DirectAdmin v\u00e0 Custombuild:
          \n# \/usr\/local\/directadmin\/directadmin v<\/em># cd \/usr\/local\/directadmin\/custombuild<\/em>
          \n# .\/build version<\/em><\/li>\n
        • Ki\u1ec3m tra version MySQL b\u1eb1ng l\u1ec7nh
          \n<\/em># mysqld\u00a0 \u2013V
          \n<\/em><\/em>\"image-1633425348346.png\"
          \n<\/em><\/em>v\u00e0 k\u1ebft qu\u1ea3 phi\u00ean b\u1ea3n mysql hi\u1ec7n \u0111ang ch\u1ea1y l\u00e0 5.7.35.<\/li>\n<\/ul>\n<\/li>\n
        • B\u01b0\u1edbc 2:<\/strong> Chuy\u1ec3n MySQL sang MariaDB tr\u00ean DirectAdminin v\u1edbi CustomBuild 2.0\n
            \n
          • Th\u1ef1c hi\u1ec7n c\u00e1c l\u1ec7nh sau:# cd \/usr\/local\/directadmin\/custombuild
            \n<\/em># .\/build set mariadb 10.6
            \n<\/em># .\/build set mysql_inst mariadb
            \n<\/em># .\/build set mysql_backup yes
            \n<\/em># .\/build update
            \n<\/em># .\/build mariadb<\/em><\/p>\n

            \"image-1633425564727.png\"\"image-1633425576288.png\"
            \nSau \u0111\u00f3 ch\u00fang ta ch\u1edd h\u1ec7 th\u1ed1ng t\u1ef1 build \u0111\u1ebfn khi ch\u1ea1y xong.<\/li>\n

          • \u0110\u1ec3 ki\u1ec3m tra th\u01b0 m\u1ee5c ch\u1ee9a database \u0111\u01b0\u1ee3c dump ra n\u1eb1m \u1edf \u0111\u00e2u ch\u00fang ta s\u1eed d\u1ee5ng 2 l\u1ec7nh sau:
            \n# cd \/usr\/local\/directadmin\/custombuild
            \n<\/em># cat options.conf | grep mysql_backup_dir<\/em>\"image-1633426511424.png\"<\/em><\/li>\n
          • Ki\u1ec3m tra version Mariadb v\u1eeba build, ch\u00fang ta d\u00f9ng l\u1ec7nh:
            \n# mysqld -V<\/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 c\u1ea5u h\u00ecnh multi PHP s\u1eed d\u1ee5ng panel DirecAdmin. Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng !<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

            I. T\u1ed5ng quan: MySQL l\u00e0 g\u00ec? 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 g\u00ec? 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 […]<\/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-252","post","type-post","status-publish","format-standard","hentry","category-directadmin"],"_links":{"self":[{"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts\/252","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=252"}],"version-history":[{"count":3,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts\/252\/revisions"}],"predecessor-version":[{"id":275,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts\/252\/revisions\/275"}],"wp:attachment":[{"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/media?parent=252"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/categories?post=252"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/tags?post=252"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}