{"id":586,"date":"2015-09-22T18:10:59","date_gmt":"2015-09-22T18:10:59","guid":{"rendered":"http:\/\/zaf.web.id\/blog\/?p=586"},"modified":"2015-09-22T18:12:40","modified_gmt":"2015-09-22T18:12:40","slug":"masalah-mysql-service-sering-mati-pada-cloud-digitalocean","status":"publish","type":"post","link":"https:\/\/zaf.web.id\/blog\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\/","title":{"rendered":"Masalah MySQL service sering mati pada Cloud DigitalOcean"},"content":{"rendered":"<figure id=\"attachment_673\" aria-describedby=\"caption-attachment-673\" style=\"width: 147px\" class=\"wp-caption alignright\"><a href=\"https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/digitalocean_logo.png\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"wp-image-673 \" src=\"https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/digitalocean_logo-300x300.png?resize=147%2C147\" alt=\"DigitalOcean Logo\" width=\"147\" height=\"147\" srcset=\"https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/digitalocean_logo.png?resize=300%2C300&amp;ssl=1 300w, https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/digitalocean_logo.png?resize=150%2C150&amp;ssl=1 150w, https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/digitalocean_logo.png?resize=619%2C619&amp;ssl=1 619w, https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/digitalocean_logo.png?resize=50%2C50&amp;ssl=1 50w, https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/digitalocean_logo.png?w=900&amp;ssl=1 900w\" sizes=\"auto, (max-width: 147px) 100vw, 147px\" \/><\/a><figcaption id=\"caption-attachment-673\" class=\"wp-caption-text\">DigitalOcean Logo<\/figcaption><\/figure>\n<p>Beberapa bulan terakhir saya\u00a0memutuskan untuk menggunakan layanan <em>cloud server<\/em> dari <a href=\"http:\/\/digitalocean.com\/\" target=\"_blank\">DigitalOcean<\/a> untuk mengakomodir\u00a0semua <em>service,<\/em> baik <em>website<\/em> maupun <em>system management<\/em> yang saya\u00a0gunakan di\u00a0kantor.<\/p>\n<p>Butuh beberapa hari untuk proses migrasi data dari layanan sebelumnya <em>(shared hosting)<\/em> dan\u00a0berjalan cukup baik, sampai saat ini kami sudah menggunakan 3 <em>server (droplet)<\/em> untuk menampung semua kebutuhan. Untuk menghemat <em>operational cost<\/em> 1 <em>server<\/em> saya bisa <em>host<\/em> maksimal \u00a060-an <em>website,<\/em> meskipun itu sangat tidak dianjurkan. Karena tidak semua <em>website<\/em> memiliki <em>traffic<\/em> yang cukup tinggi, jadi saya kira tidak ada masalah menampung sejumlah <em>website<\/em> tersebut dalam 1 <em>server<\/em> secara bersamaan.<!--more--><\/p>\n<p>Pada awalnya tidak ada masalah,\u00a0namun beberapa minggu kemudian mulai sering <em>down.<\/em> Kebanyakan terjadi akibat\u00a0<em>MySQL service<\/em> nya mati.<\/p>\n<figure id=\"attachment_675\" aria-describedby=\"caption-attachment-675\" style=\"width: 660px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/Screen-Shot-2015-09-22-at-11.48.04-PM.png\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-675\" src=\"https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/Screen-Shot-2015-09-22-at-11.48.04-PM-1024x589.png?resize=660%2C380\" alt=\"WordPress Database Error\" width=\"660\" height=\"380\" srcset=\"https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/Screen-Shot-2015-09-22-at-11.48.04-PM.png?resize=1024%2C589&amp;ssl=1 1024w, https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/Screen-Shot-2015-09-22-at-11.48.04-PM.png?resize=300%2C172&amp;ssl=1 300w, https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/Screen-Shot-2015-09-22-at-11.48.04-PM.png?resize=619%2C356&amp;ssl=1 619w, https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/Screen-Shot-2015-09-22-at-11.48.04-PM.png?w=1364&amp;ssl=1 1364w\" sizes=\"auto, (max-width: 660px) 100vw, 660px\" \/><\/a><figcaption id=\"caption-attachment-675\" class=\"wp-caption-text\">WordPress Database Error<\/figcaption><\/figure>\n<p>Untuk <em>Control Panel<\/em> nya saya menggunakan <em><a href=\"http:\/\/www.webuzo.com\" target=\"_blank\">Webuzo<\/a><\/em>, karena \u00a0lengkap dan cukup mudah untuk konfigurasinya.\u00a0Setelah dicek ternyata memang benar <em>MySQL service<\/em> nya yang mati.<\/p>\n<figure id=\"attachment_678\" aria-describedby=\"caption-attachment-678\" style=\"width: 660px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/Screen-Shot-2015-09-23-at-12.26.31-AM.png\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-678\" src=\"https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/Screen-Shot-2015-09-23-at-12.26.31-AM-1024x561.png?resize=660%2C362\" alt=\"Service MySQL Webuzo\" width=\"660\" height=\"362\" srcset=\"https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/Screen-Shot-2015-09-23-at-12.26.31-AM.png?resize=1024%2C561&amp;ssl=1 1024w, https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/Screen-Shot-2015-09-23-at-12.26.31-AM.png?resize=300%2C164&amp;ssl=1 300w, https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/Screen-Shot-2015-09-23-at-12.26.31-AM.png?resize=619%2C339&amp;ssl=1 619w, https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/Screen-Shot-2015-09-23-at-12.26.31-AM.png?w=1472&amp;ssl=1 1472w\" sizes=\"auto, (max-width: 660px) 100vw, 660px\" \/><\/a><figcaption id=\"caption-attachment-678\" class=\"wp-caption-text\">Service MySQL Webuzo<\/figcaption><\/figure>\n<p>Penasaran kira-kira yang bikin <em>service<\/em> nya mati sendiri saya coba\u00a0cek <em>log<\/em> nya, untuk <em>webuzo <a href=\"http:\/\/www.webuzo.com\/blog\/general\/log-paths-for-system-applications-installed-using-webuzo-5133.html\" target=\"_blank\">log<\/a> mysqld<\/em> nya terletak di <code>\/var\/log\/mysqld.log<\/code><\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">140416 11:37:24 mysqld_safe Number of processes running now: 0\r\n140416 11:37:24 mysqld_safe mysqld restarted\r\n140416 11:37:24 &#x5B;Note] Plugin 'FEDERATED' is disabled.\r\n140416 11:37:24 InnoDB: The InnoDB memory heap is disabled\r\n140416 11:37:24 InnoDB: Mutexes and rw_locks use GCC atomic builtins\r\n140416 11:37:24 InnoDB: Compressed tables use zlib 1.2.3\r\n140416 11:37:24 InnoDB: Using Linux native AIO\r\n140416 11:37:24 InnoDB: Initializing buffer pool, size = 128.0M\r\nInnoDB: mmap(137363456 bytes) failed; errno 12\r\n140416 11:37:24 InnoDB: Completed initialization of buffer pool\r\n140416 11:37:24 InnoDB: Fatal error: cannot allocate memory for the buffer pool\r\n140416 11:37:24 &#x5B;ERROR] Plugin 'InnoDB' init function returned error.\r\n140416 11:37:24 &#x5B;ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.\r\n140416 11:37:24 &#x5B;ERROR] Unknown\/unsupported storage engine: InnoDB\r\n140416 11:37:24 &#x5B;ERROR] Aborting<\/pre>\n<p>Setelah diperhatikan baris <code>Fatal error: cannot allocate memory for the buffer pool<\/code>\u00a0baru sadar kalau ternyata <em>memory<\/em>\u00a0(RAM) nya sudah penuh, dalam kondisi ini ada beberapa opsi yang bisa digunakan untuk mengatasi permasalahan tersebut.<\/p>\n<h2>Upgrade Plan<\/h2>\n<p>Yaah, <em>action<\/em> paling mudahnya yaitu tinggal\u00a0<em>upgrage plan<\/em> untuk <em>droplet<\/em> bersangkutan,\u00a0pilih <em>upgrade<\/em> untuk <em>memory<\/em> (RAM) nya saja. Penjelasan lebih detil nya mengenai harga dan spesifikasi plan lain dari <em>DigitalOcean<\/em> silakan <a href=\"https:\/\/www.digitalocean.com\/community\/tutorials\/how-to-resize-your-droplets-on-digitalocean\" target=\"_blank\">kesini<\/a>\u00a0<em>(recommended).<\/em><\/p>\n<h2>Tambah Ukuran SWAP<\/h2>\n<p>Jika opsi diatas dirasa cukup berat <em>(cost),<\/em> dengan menambahkan ukuran SWAP di OS <em>(Linux)<\/em> yang sudah terinstal juga bisa\u00a0mengurangi tingkat <em>crash mysql service.<\/em> Tutorial lengkapnya\u00a0silakan <a href=\"http:\/\/www.webtrafficexchange.com\/solved-mysql-crash-fatal-error-cannot-allocate-memory-buffer-pool\" target=\"_blank\">kesini<\/a>.<\/p>\n<h2>Gunakan\u00a0Monit<\/h2>\n<p><a href=\"https:\/\/mmonit.com\/\" target=\"_blank\">Monit<\/a> adalah program yang berfungsi untuk memantau setiap <em>service<\/em> (yang didaftarkan) dengan kemampuan melakukan aksi jika terjadi sesuatu dengan <em>service<\/em> yang bersangkutan. Misalnya untuk <em>service mysql<\/em>, kita bisa menentukan pengaturan di <em>monit<\/em> jika suatu waktu <em>service mysql<\/em> mati maka <em>monit<\/em> dapat melakukan <em>restart<\/em> terhadap <em>service mysql<\/em> \u00a0secara otomatis. Untuk langkah <em>install<\/em> dan konfigurasi <em>monit<\/em>\u00a0silakan <a href=\"http:\/\/www.tecmint.com\/how-to-install-and-setup-monit-linux-process-and-services-monitoring-program\/\" target=\"_blank\">kesini<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Beberapa bulan terakhir saya\u00a0memutuskan untuk menggunakan layanan cloud server dari DigitalOcean untuk mengakomodir\u00a0semua service, baik&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[58],"tags":[145,146],"class_list":["post-586","post","type-post","status-publish","format-standard","hentry","category-server","tag-digitalocean","tag-mysql-service"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Masalah MySQL service sering mati pada Cloud DigitalOcean - Ahmad Zafrullah<\/title>\n<meta name=\"description\" content=\"Mengatasi MySQL service yang sering mati pada Cloud DigitalOcean. Ada 3 opsi yang dapat dilakukan, upgrade plan, allocate SWAP, dan install Monit.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/zaf.web.id\/blog\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Masalah MySQL service sering mati pada Cloud DigitalOcean - Ahmad Zafrullah\" \/>\n<meta property=\"og:description\" content=\"Mengatasi MySQL service yang sering mati pada Cloud DigitalOcean. Ada 3 opsi yang dapat dilakukan, upgrade plan, allocate SWAP, dan install Monit.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/zaf.web.id\/blog\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\/\" \/>\n<meta property=\"og:site_name\" content=\"Ahmad Zafrullah\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/23Pstars\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/23Pstars\" \/>\n<meta property=\"article:published_time\" content=\"2015-09-22T18:10:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-09-22T18:12:40+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/digitalocean_logo-300x300.png\" \/>\n<meta name=\"author\" content=\"Zaf\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@23Pstars\" \/>\n<meta name=\"twitter:site\" content=\"@23Pstars\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zaf\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/zaf.web.id\\\/blog\\\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/zaf.web.id\\\/blog\\\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\\\/\"},\"author\":{\"name\":\"Zaf\",\"@id\":\"https:\\\/\\\/zaf.web.id\\\/blog\\\/#\\\/schema\\\/person\\\/ba4e955d59a1e6a8284857e74b14e5ed\"},\"headline\":\"Masalah MySQL service sering mati pada Cloud DigitalOcean\",\"datePublished\":\"2015-09-22T18:10:59+00:00\",\"dateModified\":\"2015-09-22T18:12:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/zaf.web.id\\\/blog\\\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\\\/\"},\"wordCount\":437,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/zaf.web.id\\\/blog\\\/#\\\/schema\\\/person\\\/ba4e955d59a1e6a8284857e74b14e5ed\"},\"image\":{\"@id\":\"https:\\\/\\\/zaf.web.id\\\/blog\\\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/zaf.web.id\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/09\\\/digitalocean_logo-300x300.png\",\"keywords\":[\"digitalocean\",\"mysql service\"],\"articleSection\":[\"Server\"],\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/zaf.web.id\\\/blog\\\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/zaf.web.id\\\/blog\\\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\\\/\",\"url\":\"https:\\\/\\\/zaf.web.id\\\/blog\\\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\\\/\",\"name\":\"Masalah MySQL service sering mati pada Cloud DigitalOcean - Ahmad Zafrullah\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/zaf.web.id\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/zaf.web.id\\\/blog\\\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/zaf.web.id\\\/blog\\\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/zaf.web.id\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/09\\\/digitalocean_logo-300x300.png\",\"datePublished\":\"2015-09-22T18:10:59+00:00\",\"dateModified\":\"2015-09-22T18:12:40+00:00\",\"description\":\"Mengatasi MySQL service yang sering mati pada Cloud DigitalOcean. Ada 3 opsi yang dapat dilakukan, upgrade plan, allocate SWAP, dan install Monit.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/zaf.web.id\\\/blog\\\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\\\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/zaf.web.id\\\/blog\\\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\\\/\\\/zaf.web.id\\\/blog\\\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\\\/#primaryimage\",\"url\":\"http:\\\/\\\/zaf.web.id\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/09\\\/digitalocean_logo-300x300.png\",\"contentUrl\":\"http:\\\/\\\/zaf.web.id\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/09\\\/digitalocean_logo-300x300.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/zaf.web.id\\\/blog\\\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/zaf.web.id\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Masalah MySQL service sering mati pada Cloud DigitalOcean\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/zaf.web.id\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/zaf.web.id\\\/blog\\\/\",\"name\":\"Ahmad Zafrullah\",\"description\":\"Work to Learn is better than Learn how to Work\",\"publisher\":{\"@id\":\"https:\\\/\\\/zaf.web.id\\\/blog\\\/#\\\/schema\\\/person\\\/ba4e955d59a1e6a8284857e74b14e5ed\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/zaf.web.id\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/zaf.web.id\\\/blog\\\/#\\\/schema\\\/person\\\/ba4e955d59a1e6a8284857e74b14e5ed\",\"name\":\"Zaf\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\\\/\\\/i0.wp.com\\\/zaf.web.id\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/zaf_auto_x2.jpeg?fit=300%2C300&ssl=1\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/zaf.web.id\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/zaf_auto_x2.jpeg?fit=300%2C300&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/zaf.web.id\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/zaf_auto_x2.jpeg?fit=300%2C300&ssl=1\",\"width\":300,\"height\":300,\"caption\":\"Zaf\"},\"logo\":{\"@id\":\"https:\\\/\\\/i0.wp.com\\\/zaf.web.id\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/zaf_auto_x2.jpeg?fit=300%2C300&ssl=1\"},\"sameAs\":[\"http:\\\/\\\/zaf.web.id\",\"http:\\\/\\\/www.facebook.com\\\/23Pstars\",\"https:\\\/\\\/x.com\\\/23Pstars\"],\"url\":\"https:\\\/\\\/zaf.web.id\\\/blog\\\/author\\\/zaf\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Masalah MySQL service sering mati pada Cloud DigitalOcean - Ahmad Zafrullah","description":"Mengatasi MySQL service yang sering mati pada Cloud DigitalOcean. Ada 3 opsi yang dapat dilakukan, upgrade plan, allocate SWAP, dan install Monit.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zaf.web.id\/blog\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\/","og_locale":"id_ID","og_type":"article","og_title":"Masalah MySQL service sering mati pada Cloud DigitalOcean - Ahmad Zafrullah","og_description":"Mengatasi MySQL service yang sering mati pada Cloud DigitalOcean. Ada 3 opsi yang dapat dilakukan, upgrade plan, allocate SWAP, dan install Monit.","og_url":"https:\/\/zaf.web.id\/blog\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\/","og_site_name":"Ahmad Zafrullah","article_publisher":"http:\/\/www.facebook.com\/23Pstars","article_author":"http:\/\/www.facebook.com\/23Pstars","article_published_time":"2015-09-22T18:10:59+00:00","article_modified_time":"2015-09-22T18:12:40+00:00","og_image":[{"url":"http:\/\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/digitalocean_logo-300x300.png","type":"","width":"","height":""}],"author":"Zaf","twitter_card":"summary_large_image","twitter_creator":"@23Pstars","twitter_site":"@23Pstars","twitter_misc":{"Ditulis oleh":"Zaf","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/zaf.web.id\/blog\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\/#article","isPartOf":{"@id":"https:\/\/zaf.web.id\/blog\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\/"},"author":{"name":"Zaf","@id":"https:\/\/zaf.web.id\/blog\/#\/schema\/person\/ba4e955d59a1e6a8284857e74b14e5ed"},"headline":"Masalah MySQL service sering mati pada Cloud DigitalOcean","datePublished":"2015-09-22T18:10:59+00:00","dateModified":"2015-09-22T18:12:40+00:00","mainEntityOfPage":{"@id":"https:\/\/zaf.web.id\/blog\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\/"},"wordCount":437,"commentCount":0,"publisher":{"@id":"https:\/\/zaf.web.id\/blog\/#\/schema\/person\/ba4e955d59a1e6a8284857e74b14e5ed"},"image":{"@id":"https:\/\/zaf.web.id\/blog\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\/#primaryimage"},"thumbnailUrl":"http:\/\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/digitalocean_logo-300x300.png","keywords":["digitalocean","mysql service"],"articleSection":["Server"],"inLanguage":"id","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/zaf.web.id\/blog\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/zaf.web.id\/blog\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\/","url":"https:\/\/zaf.web.id\/blog\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\/","name":"Masalah MySQL service sering mati pada Cloud DigitalOcean - Ahmad Zafrullah","isPartOf":{"@id":"https:\/\/zaf.web.id\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zaf.web.id\/blog\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\/#primaryimage"},"image":{"@id":"https:\/\/zaf.web.id\/blog\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\/#primaryimage"},"thumbnailUrl":"http:\/\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/digitalocean_logo-300x300.png","datePublished":"2015-09-22T18:10:59+00:00","dateModified":"2015-09-22T18:12:40+00:00","description":"Mengatasi MySQL service yang sering mati pada Cloud DigitalOcean. Ada 3 opsi yang dapat dilakukan, upgrade plan, allocate SWAP, dan install Monit.","breadcrumb":{"@id":"https:\/\/zaf.web.id\/blog\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zaf.web.id\/blog\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/zaf.web.id\/blog\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\/#primaryimage","url":"http:\/\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/digitalocean_logo-300x300.png","contentUrl":"http:\/\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/digitalocean_logo-300x300.png"},{"@type":"BreadcrumbList","@id":"https:\/\/zaf.web.id\/blog\/masalah-mysql-service-sering-mati-pada-cloud-digitalocean\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zaf.web.id\/blog\/"},{"@type":"ListItem","position":2,"name":"Masalah MySQL service sering mati pada Cloud DigitalOcean"}]},{"@type":"WebSite","@id":"https:\/\/zaf.web.id\/blog\/#website","url":"https:\/\/zaf.web.id\/blog\/","name":"Ahmad Zafrullah","description":"Work to Learn is better than Learn how to Work","publisher":{"@id":"https:\/\/zaf.web.id\/blog\/#\/schema\/person\/ba4e955d59a1e6a8284857e74b14e5ed"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zaf.web.id\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":["Person","Organization"],"@id":"https:\/\/zaf.web.id\/blog\/#\/schema\/person\/ba4e955d59a1e6a8284857e74b14e5ed","name":"Zaf","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2024\/09\/zaf_auto_x2.jpeg?fit=300%2C300&ssl=1","url":"https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2024\/09\/zaf_auto_x2.jpeg?fit=300%2C300&ssl=1","contentUrl":"https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2024\/09\/zaf_auto_x2.jpeg?fit=300%2C300&ssl=1","width":300,"height":300,"caption":"Zaf"},"logo":{"@id":"https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2024\/09\/zaf_auto_x2.jpeg?fit=300%2C300&ssl=1"},"sameAs":["http:\/\/zaf.web.id","http:\/\/www.facebook.com\/23Pstars","https:\/\/x.com\/23Pstars"],"url":"https:\/\/zaf.web.id\/blog\/author\/zaf\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":720,"url":"https:\/\/zaf.web.id\/blog\/install-dan-konfigurasi-monit-di-centos\/","url_meta":{"origin":586,"position":0},"title":"Install dan Konfigurasi Monit di CentOS","author":"Zaf","date":"November 10, 2015","format":false,"excerpt":"Monit adalah solusi bagi webmaster yang menggunakan dedicated server (VPS) untuk mengelola dan menjalankan website dengan kebutuhan khusus (punya banyak traffic, butuh library tambahan, atau yang lainnya) yang jarang disediakan oleh penyedia hosting pada umumnya. Menggunakan Monit dapat membantu dalam melakukan monitoring dan bahkan tindakan (action) terhadap beberapa service,\u00a0khususnya pada\u2026","rel":"","context":"dalam &quot;Coretan&quot;","block_context":{"text":"Coretan","link":"https:\/\/zaf.web.id\/blog\/category\/coretan\/"},"img":{"alt_text":"Logo Monit","src":"https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/11\/monit-300x203.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":644,"url":"https:\/\/zaf.web.id\/blog\/ampps-solusi-web-server-stack-pada-mac-os-x-el-capitan\/","url_meta":{"origin":586,"position":1},"title":"AMPPS &#8211; Solusi Web Server Stack pada Mac OS X El Capitan","author":"Zaf","date":"September 24, 2015","format":false,"excerpt":"Pada OS X 10.8 (Mountain Lion) keatas, termasuk\u00a0yang saya gunakan (OS X 10.10 Yosemite)\u00a0telah dibekali dengan dengan apache secara default, tinggal mengaktifkan nya saja dengan perintah [bash]$ sudo apachectl start[\/bash] Sebelum August 2015, saya masih menggunakan OS X Yosemite di MacBook Pro saya. Hingga muncul versi\u00a0terbaru dari OS X El\u2026","rel":"","context":"dalam &quot;macOS&quot;","block_context":{"text":"macOS","link":"https:\/\/zaf.web.id\/blog\/category\/macos\/"},"img":{"alt_text":"OS X El Capitan","src":"https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/os_x_el_capitan.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/os_x_el_capitan.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/os_x_el_capitan.jpg?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2015\/09\/os_x_el_capitan.jpg?resize=700%2C400 2x"},"classes":[]},{"id":1504,"url":"https:\/\/zaf.web.id\/blog\/dump-dan-backup-mysql-ke-s3-digitalocean-spaces\/","url_meta":{"origin":586,"position":2},"title":"Dump dan Backup MySQL ke S3 DigitalOcean Spaces","author":"Zaf","date":"September 9, 2021","format":false,"excerpt":"Alur untuk backup otomatis database langsung ke S3 services, salah satunya ke DigitalOcean (DO) Spaces Integrasi s3cmd Download sesuai platform dari https:\/\/s3tools.org\/s3cmd kemudian jalankan comman untuk konfigurasi : s3cmd --configure Lengkapi credentials sehingga dapat terhubung dengan S3 service Script untuk Dump and Push Buat sebuah file dengan nama do.sh berisi\u2026","rel":"","context":"dalam &quot;Programming&quot;","block_context":{"text":"Programming","link":"https:\/\/zaf.web.id\/blog\/category\/programming\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2021\/09\/Screenshot-from-2021-09-09-14-15-14.png?fit=769%2C311&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2021\/09\/Screenshot-from-2021-09-09-14-15-14.png?fit=769%2C311&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2021\/09\/Screenshot-from-2021-09-09-14-15-14.png?fit=769%2C311&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2021\/09\/Screenshot-from-2021-09-09-14-15-14.png?fit=769%2C311&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":906,"url":"https:\/\/zaf.web.id\/blog\/konfigurasi-ulang-apache-dan-mysql-pada-macos-sierra\/","url_meta":{"origin":586,"position":3},"title":"Konfigurasi ulang Apache dan MySQL pada macOS Sierra","author":"Zaf","date":"Agustus 19, 2016","format":false,"excerpt":"Satu satunya perubahan menonjol dari OS Apple ini\u00a0adalah OS X diganti dengan macOS, jadi versi saat ini tidak lagi diawali dengan OS X Sierra melainkan macOS Sierra. Perlu beberapa minggu bertapa sebelum akhirnya\u00a0memutuskan untuk mencoba versi\u00a0public beta yang rilis 13 June 2016 kemarin. \u00a0Setelah selesai download (sekitar 4GB-an) dan install,\u2026","rel":"","context":"dalam &quot;Coretan&quot;","block_context":{"text":"Coretan","link":"https:\/\/zaf.web.id\/blog\/category\/coretan\/"},"img":{"alt_text":"macOS Sierra","src":"https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2016\/08\/Screen-Shot-2016-08-19-at-9.12.52-AM.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2016\/08\/Screen-Shot-2016-08-19-at-9.12.52-AM.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2016\/08\/Screen-Shot-2016-08-19-at-9.12.52-AM.png?resize=525%2C300 1.5x"},"classes":[]},{"id":326,"url":"https:\/\/zaf.web.id\/blog\/review-indonetmedia-com\/","url_meta":{"origin":586,"position":4},"title":"Review indonetmedia.com","author":"Zaf","date":"Agustus 12, 2014","format":false,"excerpt":"Satu lagi\u00a0web hosting\u00a0dan domain registration provider\u00a0indonesia, CV. Indonetmedia Corporation. Saya hampir lupa kapan pertama kali mulai menggunakan layanan disana, yang jelas sudah lumayan banyak website yang saya percayakan untuk dihost disana,\u00a0sampai-sampai mendaftar untuk menjadi reseller akun hosting yang mana niatnya biar sedikit lebih hemat dan mudah ngelolanya, ngumpulin website-website dalam\u2026","rel":"","context":"dalam &quot;Coretan&quot;","block_context":{"text":"Coretan","link":"https:\/\/zaf.web.id\/blog\/category\/coretan\/"},"img":{"alt_text":"Logo Indonetmedia","src":"https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2014\/08\/logo.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":304,"url":"https:\/\/zaf.web.id\/blog\/review-layanan-hosting-masterweb-com\/","url_meta":{"origin":586,"position":5},"title":"Review layanan hosting masterweb.com","author":"Zaf","date":"Juli 15, 2014","format":false,"excerpt":"Pelaku bisnis dunia maya memang tidak pernah lepas dari\u00a0peran penting sebuah\u00a0hosting, bagaimanapun kualitas sebuah website juga ditunjang oleh performa dari hosting tempat website tersebut di-\"titip\"-kan. Bertahun-tahun pengalaman saya menggunakan layanan hosting yang berbeda-beda, kali ini saya akan menyinggung tentang layanan hosting dari masterweb.com. Dimana dihalaman awalnya tertulis Webhosting No. 1\u2026","rel":"","context":"dalam &quot;Coretan&quot;","block_context":{"text":"Coretan","link":"https:\/\/zaf.web.id\/blog\/category\/coretan\/"},"img":{"alt_text":"masterweb-logo","src":"https:\/\/i0.wp.com\/zaf.web.id\/blog\/wp-content\/uploads\/2014\/07\/masterweb-logo.png?resize=350%2C200","width":350,"height":200},"classes":[]}],"jetpack_likes_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4zLnS-9s","_links":{"self":[{"href":"https:\/\/zaf.web.id\/blog\/wp-json\/wp\/v2\/posts\/586","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zaf.web.id\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zaf.web.id\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zaf.web.id\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zaf.web.id\/blog\/wp-json\/wp\/v2\/comments?post=586"}],"version-history":[{"count":9,"href":"https:\/\/zaf.web.id\/blog\/wp-json\/wp\/v2\/posts\/586\/revisions"}],"predecessor-version":[{"id":683,"href":"https:\/\/zaf.web.id\/blog\/wp-json\/wp\/v2\/posts\/586\/revisions\/683"}],"wp:attachment":[{"href":"https:\/\/zaf.web.id\/blog\/wp-json\/wp\/v2\/media?parent=586"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zaf.web.id\/blog\/wp-json\/wp\/v2\/categories?post=586"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zaf.web.id\/blog\/wp-json\/wp\/v2\/tags?post=586"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}