{"id":1844,"date":"2020-07-26T12:52:25","date_gmt":"2020-07-26T05:52:25","guid":{"rendered":"https:\/\/www.domosquare.com\/tutorial\/?p=1844"},"modified":"2020-07-26T12:52:55","modified_gmt":"2020-07-26T05:52:55","slug":"upgrade-mysql-ke-mariadb-pada-centos-dan-ubuntu-debian","status":"publish","type":"post","link":"https:\/\/www.domosquare.com\/tutorial\/server\/upgrade-mysql-ke-mariadb-pada-centos-dan-ubuntu-debian.html","title":{"rendered":"Upgrade mysql ke mariaDB pada Centos dan Ubuntu\/Debian"},"content":{"rendered":"\n<p>Pada tutorial ini kita akan belajar bagaimana mengupgrade mysql server ke mariadb<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Daftar Isi<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69fd027f477f6\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69fd027f477f6\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.domosquare.com\/tutorial\/server\/upgrade-mysql-ke-mariadb-pada-centos-dan-ubuntu-debian.html\/#Backup_Database\" >Backup Database<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.domosquare.com\/tutorial\/server\/upgrade-mysql-ke-mariadb-pada-centos-dan-ubuntu-debian.html\/#Menyiapkan_Repo\" >Menyiapkan Repo<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.domosquare.com\/tutorial\/server\/upgrade-mysql-ke-mariadb-pada-centos-dan-ubuntu-debian.html\/#Pada_centos\" >Pada centos<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.domosquare.com\/tutorial\/server\/upgrade-mysql-ke-mariadb-pada-centos-dan-ubuntu-debian.html\/#Pada_UbuntuDebian\" >Pada Ubuntu\/Debian<\/a><\/li><\/ul><\/nav><\/div>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Backup_Database\"><\/span>Backup Database<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Pertama sebelum mengupgrade pastikan Anda sudah membackup dahulu seluruh database Anda, dan sebaiknya backupnya juga di download sehingga lebih aman.<\/p>\n\n\n\n<p>Berikut perintah untuk mengekspor semua database ke file sql:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysqldump --all-databases > \/tmp\/all-database.sql<\/pre>\n\n\n\n<p>Selain di export, agar aman kita backup juga folder data mysqlnya:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">cp -a \/var\/lib\/mysql\/ \/var\/lib\/mysql.bak<\/pre>\n\n\n\n<p>Setelah diexport dan di backup, silahkan stop service mysqlnya<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">service mysql stop<\/pre>\n\n\n\n<p>Mungkin nama servicenya dapat berbeda tergantung sistem, jadi dapat disesuaikan saja.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Menyiapkan_Repo\"><\/span>Menyiapkan Repo<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Ok selanjutnya kita siapkan repo untuk MariaDB nya, kenapa? Karena tentu lebih baik jika repo software nya tersedia kita menggunakan repo nya langsung sehingga untuk update nantinya juga lebih cepat.<\/p>\n\n\n\n<p>Untuk menyiapkan repo silahkan kunjungi:<\/p>\n\n\n\n<p><a href=\"https:\/\/downloads.mariadb.org\/mariadb\/repositories\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/downloads.mariadb.org\/mariadb\/repositories\/<\/a><\/p>\n\n\n\n<p>Nanti Anda create isi repo file sesuai OS nya dengan lebih mudah.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"859\" height=\"567\" src=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2020\/07\/image-29.png\" alt=\"\" class=\"wp-image-1846\" srcset=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2020\/07\/image-29.png 859w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2020\/07\/image-29-300x198.png 300w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2020\/07\/image-29-768x507.png 768w\" sizes=\"auto, (max-width: 859px) 100vw, 859px\" \/><figcaption>Konfigurasi Repo<\/figcaption><\/figure>\n\n\n\n<p>Pada halaman konfigurasi repo Anda bisa memilih ingin install versi berapa dari MariaDB nya.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Pada_centos\"><\/span>Pada centos<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Sebelum melanjutkan install , sebaiknya mysql-server yang sudah terinstall sebelumnya di hapus, untuk menghindari error saat instalasi.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">yum remove mysql-server<\/pre>\n\n\n\n<p>Selanjutnya kita lakukan instalasi mariaDB:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">yum -y install MariaDB-server MariaDB-client<\/pre>\n\n\n\n<p>Sekarang kita coba start mysqlnya kembali:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">service mysql start<\/pre>\n\n\n\n<p>Dan kita coba cek versi nya apakah sudah benar yang terinstall:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"628\" height=\"40\" src=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2020\/07\/image-28.png\" alt=\"\" class=\"wp-image-1845\" srcset=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2020\/07\/image-28.png 628w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2020\/07\/image-28-300x19.png 300w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><\/figure>\n\n\n\n<p>Jika sudah berhasil lakukan mysql_upgrade untuk mengupgrade versi database yang terinstall sebelumnya.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql_upgrade<\/pre>\n\n\n\n<p>Nah seharusnya jika proses sudah benar, mysql server sudah siap digunakan kembali seperti biasa &#x1f60a;&#x1f44d;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Pada_UbuntuDebian\"><\/span>Pada Ubuntu\/Debian<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Setelah mengkonfigurasi repo pada point pertama, setelah itu Anda bisa jalankan perintah pada saat pembuatan repo pada point diatas, misal:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo apt-get install software-properties-common<br>sudo apt-key adv --fetch-keys 'https:\/\/mariadb.org\/mariadb_release_signing_key.asc'<br>sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http:\/\/mirror.telkomuniversity.ac.id\/mariadbrepo\/10.4\/ubuntu bionic main'<\/pre>\n\n\n\n<p>Setelah key berhasil diimport, selanjutnya lanjutkan dengan proses install mariaDB nya:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo apt update\nsudo apt install mariadb-server<\/pre>\n\n\n\n<p>Jika sudah selesai sekarang sama seperti pada centos \ud83d\ude42 start kembali mysqlnya:<\/p>\n\n\n\n<p>service mysql start<\/p>\n\n\n\n<p>Dan jangan lupa cek versi serta lakukan upgrade database jika versi sudah benar:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql_upgrade<\/pre>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>Ops, masih bingung? Atau khawatir database hilang? Yuk beli <a rel=\"noreferrer noopener\" href=\"https:\/\/www.domosquare.com\/server\/vps-openvz-iix\" target=\"_blank\">VPS <\/a>atau Server di Domosquare.com saja, nanti kita bantuin secara gratis.<\/p>\n\n\n\n<p>Atau bagi Anda yang ingin memanfaatkan jasa setup bisa juga memesan jasa nya saja &#x1f601; Silahkan kontak sales@domosquare.com untuk hal ini.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pada tutorial ini kita akan belajar bagaimana mengupgrade mysql server ke mariadb Backup Database Pertama sebelum mengupgrade pastikan Anda sudah membackup dahulu seluruh database Anda, dan sebaiknya backupnya juga di download sehingga lebih aman. Berikut perintah untuk mengekspor semua database ke file sql: mysqldump &#8211;all-databases > \/tmp\/all-database.sql Selain di export, agar aman kita backup juga [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"rating_form_position":"","rating_results_position":"","mr_structured_data_type":"","_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[810],"tags":[815,813],"class_list":["post-1844","post","type-post","status-publish","format-standard","hentry","category-server","tag-mysql","tag-vps"],"jetpack_featured_media_url":"","multi-rating":{"mr_rating_results":[{"adjusted_star_result":0,"star_result":0,"total_max_option_value":5,"adjusted_score_result":0,"score_result":0,"percentage_result":0,"adjusted_percentage_result":0,"count":0,"post_id":1844}]},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/posts\/1844","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/comments?post=1844"}],"version-history":[{"count":2,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/posts\/1844\/revisions"}],"predecessor-version":[{"id":1848,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/posts\/1844\/revisions\/1848"}],"wp:attachment":[{"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/media?parent=1844"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/categories?post=1844"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/tags?post=1844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}