{"id":27,"date":"2008-03-08T10:54:21","date_gmt":"2008-03-08T03:54:21","guid":{"rendered":"http:\/\/blog.whplus.com\/2008\/03\/08\/memindahkan-direktori-mysql.html"},"modified":"2008-03-08T11:06:56","modified_gmt":"2008-03-08T04:06:56","slug":"memindahkan-direktori-mysql","status":"publish","type":"post","link":"https:\/\/www.whplus.com\/blog\/2008\/03\/08\/memindahkan-direktori-mysql.html","title":{"rendered":"Memindahkan direktori mysql"},"content":{"rendered":"<p>Kemarin salah satu pelanggan dedicated server kami mengalami masalah penuhnya partisi \/var karena penambahan database mysql yang demikian besar.<\/p>\n<pre>Filesystem            Size  Used Avail Use% Mounted on\r\n\/dev\/hda8              52G   15G   35G  30% \/home\r\n\/dev\/hda2             9.9G  3.5G  5.9G  38% \/usr\r\n\/dev\/hda3             7.9G  7.4G  161M  98% \/var<\/pre>\n<p>Karena tidak mungkin lagi membuat partisi baru maka direktori mysql terpaksa dipindahkan ke partisi \/home karena masih banyak sisanya.<\/p>\n<p>Berikut ini prosedur pemindahan direktori mysql dari \/var\/lib\/mysql ke \/home\/mysql.<\/p>\n<p>Pertama stop mysql dan edit my.cnf<\/p>\n<pre>service chkservd stop\r\nservice mysql stop\r\nnano -w \/etc\/my.cnf<\/pre>\n<p>Pada bagian mysqld ubah\/tambahkan baris berikut:<\/p>\n<pre>pid-file = \/home\/mysql\/mysqld.pid\r\nsocket = \/var\/lib\/mysql\/mysql.sock\r\n\r\ndatadir = \/home\/mysql\r\nbasedir = \/home\/mysql<\/pre>\n<p>Kemudian copy isi direktori \/var\/lib\/mysql ke \/home\/mysql. Kami menggunakan perintah rsync dua kali untuk memastikan bahwa tidak ada yang tertinggal.<\/p>\n<pre>rsync -vrplogDtH \/var\/lib\/mysql\/ \/home\/mysql\/\r\nrsync -vrplogDtH \/var\/lib\/mysql\/ \/home\/mysql\/<\/pre>\n<p>Sekarang buat link mysql.sock agar mysql bisa berjalan dengan semestinya:<\/p>\n<pre>ln -s \/home\/mysql\/mysql.sock \/var\/lib\/mysql\/mysql.sock\r\nrm -rf \/tmp\/mysql.sock\r\nln -s \/home\/mysql\/mysql.sock \/tmp\/mysql.sock<\/pre>\n<p>Akhirnya restart mysql :<\/p>\n<pre>killall -9 mysqld\r\nservice mysql start\r\nservice chkservd start<\/pre>\n<p>Sebelum menghapus data mysql yang ada di direktori lama, alangkah baiknya dimonitor beberapa  hari dulu untuk memastikan sesuatunya berjalan dengan semestinya. Jika semua sudah beres baru lakukan sbb:<\/p>\n<pre>service chkservd stop\r\nservice mysql stop\r\nrm -rf \/var\/lib\/mysql\r\nmkdir \/var\/lib\/mysql\r\nchown mysql \/var\/lib\/mysql\r\nln -s \/home\/mysql\/mysql.sock \/var\/lib\/mysql\/mysql.sock\r\nrm -rf \/tmp\/mysql.sock\r\nln -s \/home\/mysql\/mysql.sock \/tmp\/mysql.sock\r\nservice mysql start\r\nservice chkservd start<\/pre>\n<p>Proses pemindahan data mysql selesai dan sekarang mysql berjalan di direktori yang baru.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kemarin salah satu pelanggan dedicated server kami mengalami masalah penuhnya partisi \/var karena penambahan database mysql yang demikian besar. Filesystem Size Used Avail Use% Mounted on \/dev\/hda8 52G 15G 35G 30% \/home \/dev\/hda2 9.9G 3.5G 5.9G 38% \/usr \/dev\/hda3 7.9G 7.4G 161M 98% \/var Karena tidak mungkin lagi membuat partisi baru maka direktori mysql terpaksa\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.whplus.com\/blog\/2008\/03\/08\/memindahkan-direktori-mysql.html\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-27","post","type-post","status-publish","format-standard","hentry","category-tutorial"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.whplus.com\/blog\/wp-json\/wp\/v2\/posts\/27","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.whplus.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.whplus.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.whplus.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.whplus.com\/blog\/wp-json\/wp\/v2\/comments?post=27"}],"version-history":[{"count":0,"href":"https:\/\/www.whplus.com\/blog\/wp-json\/wp\/v2\/posts\/27\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.whplus.com\/blog\/wp-json\/wp\/v2\/media?parent=27"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.whplus.com\/blog\/wp-json\/wp\/v2\/categories?post=27"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.whplus.com\/blog\/wp-json\/wp\/v2\/tags?post=27"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}