{"id":46456,"date":"2023-04-18T02:54:29","date_gmt":"2023-05-12T19:50:14","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/46456-2\/"},"modified":"2024-04-30T00:02:29","modified_gmt":"2024-04-29T16:02:29","slug":"46456-2","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/46456-2\/","title":{"rendered":""},"content":{"rendered":"

1. \u7d39\u4ecb<\/h1>\n

\u524d\u56de\u306fAlibaba Cloud\u4e0a\u3067Jupyter notebook\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3092\u3057\u3066\u307f\u307e\u3057\u305f\u3002\u7d9a\u304d\u3068\u3057\u3066\u4eca\u56de\u306fJupyter notebook\u3092\u4f7f\u3063\u3066MySQL\u306e\u64cd\u4f5c\u3092\u3084\u3063\u3066\u307f\u307e\u3057\u3087\u3046\u3002MySQL\u306e\u64cd\u4f5c\u306fpython\u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n

\u524d\u56de\u306e\u5185\u5bb9\u306f\u4e0b\u8a18\u306e\u30ea\u30f3\u30af\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002
\n\u300cAlibaba Cloud\u3067Jupyter notebook\u3092\u69cb\u7bc9\u3059\u308b\u300d
\n\u30ea\u30f3\u30af\uff1a\u3000http:\/\/qiita.com\/sbcnan\/private\/c4a5d3d578811ab62e02<\/p>\n

2. \u524d\u63d0<\/h1>\n

\u30fbAlibaba Cloud\u306eECS\u30b5\u30fc\u30d0\u306e\u69cb\u7bc9\u6e08\u307f
\n\u30fbJupyter notebook\u306e\u5916\u90e8\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u304b\u3089\u306e\u63a5\u7d9a\u74b0\u5883\u304c\u8a2d\u5b9a\u6e08\u307f
\n\u30fbJupyter notebook\u3067\u306epython2 or 3 kenel\u304c\u8a2d\u5b9a\u6e08\u307f<\/p>\n

3. MySQL\u74b0\u5883\u306b\u3064\u3044\u3066<\/h1>\n

Alibaba Cloud\u3067\u306fApsara DB\u3068\u3044\u3046Database\u30b5\u30fc\u30d3\u30b9\u3092\u63d0\u4f9b\u3057\u3066\u3044\u307e\u3059\u3002Apsara DB\u306f\u3044\u304f\u3064\u304b\u306e\u7a2e\u985e\u304c\u3042\u308a\u307e\u3059\u304c\u3001\u4eca\u56de\u306f\u826f\u304f\u4f7f\u3046\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30b5\u30fc\u30d3\u30b9 (RDS)\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002ApsaraDB for RDS\u306f\u62e1\u5f35\u53ef\u80fd\u306a\u30aa\u30f3\u30c7\u30de\u30f3\u30c9\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u3059\u3002\u81ea\u52d5\u30e2\u30cb\u30bf\u30ea\u30f3\u30b0\u3001\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306a\u3069\u7ba1\u7406\u30bf\u30b9\u30af\u3082Alibaba Cloud\u3067\u306f\u7c21\u5358\u306b\u3067\u304d\u3066\u4f5c\u696d\u306e\u52b9\u7387\u304c\u9ad8\u3044\u7279\u5fb4\u3067\u3059\u3002\u65e5\u672c\u30ea\u30b8\u30e7\u30f3\u3067\u306fMySQL\uff0cSQL Server, PostgreSQL\u306e\u30a8\u30f3\u30b8\u30f3\u3092\u4f7f\u3048\u307e\u3059\u3002
\n\u30ea\u30f3\u30af\uff1a\u3000https:\/\/jp.aliyun.com\/product\/apsaradb-for-rds?spm=a21mg.8121077.552287.11.mzwSsg<\/p>\n

3. Database\u30b5\u30fc\u30d0\u306e\u7acb\u3061\u4e0a\u3052<\/h1>\n

\u3053\u3053\u3067\u306fApsara DB for RDS\u6a5f\u80fd\u4f7f\u3063\u3066Database\u30b5\u30fc\u30d0\u7acb\u3061\u4e0a\u3052\u307e\u3059\u3002RDS\u306e\u8a2d\u5b9a\u306b\u95a2\u3059\u308b\u8a73\u3057\u3044\u5185\u5bb9\u306f\u6b21\u306e\u30ea\u30f3\u30af\u3092\u53c2\u8003\u3057\u307e\u3057\u3087\u3046\u3002
\n\u30ea\u30f3\u30af\uff1a\u3000https:\/\/jp.aliyun.com\/help\/doc-detail\/26126.htm?spm=a3c0i.o43185ja.b99.28.dcwfAS<\/p>\n

\u3053\u3053\u3067\u3001\u3044\u304f\u3064\u304b\u306e\u8a2d\u5b9a\u5185\u5bb9\u306b\u3064\u3044\u3066\u307e\u305a\u8aac\u660e\u3057\u307e\u3059\u3002
\n1.[Acount ID\/PW]: \u5f8c\u306eDB\u306b\u30ed\u30b0\u30a4\u30f3\u306e\u305f\u3081\u306b\u3001\u3053\u3053\u3067[\u30a2\u30ab\u30a6\u30f3\u30c8\u4f5c\u6210]\u3059\u308b\u6642\u306eID\/PW\u3092\u8a18\u9332\u3057\u3066\u304a\u304d\u307e\u3059\u3002
\n2.[DB name]: \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4f5c\u3063\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u540d\u524d\u8a18\u9332\u3059\u308b
\n3.[RDS name]: ECS\u3068RDS\u304c\u540c\u3058\u30ea\u30b8\u30e7\u30f3\u306b\u8a2d\u7f6e\u3057\u3066\u3044\u308b\u5834\u5408\u306f\u30a4\u30f3\u30c8\u30e9\u30cd\u30c3\u30c8\u3067\u63a5\u7d9a\u3067\u304d\u307e\u3059\u3002\u30a4\u30f3\u30c8\u30e9\u30cd\u30c3\u30c8\u3067RDS\u306b\u63a5\u7d9a\u3059\u308b\u305f\u3081\u306bRDS\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u540d\u3092\u8a18\u9332\u3057\u3066\u304a\u304d\u307e\u3059\u3002
\n4.RDS\u306fMySQL\u30b5\u30fc\u30d0\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n

\"image\"<\/div>\n

4. RDS\u30b5\u30fc\u30d0\u63a5\u7d9a\u306e\u8a2d\u5b9a<\/h1>\n

A.MySQL\u306e\u305f\u3081\u306e\u30d1\u30c3\u30b1\u30fc\u30b8\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h4>\n

1.Python\u306eMySQL\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<\/p>\n

$ pip install pymysql\r\n<\/code><\/pre>\n
\uff08\u30aa\u30d7\u30b7\u30e7\u30f3\uff09\u95a2\u9023\u30d1\u30c3\u30b1\u30fc\u30b8\u3082\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<\/p>\n
$ pip install pandas\r\n$ pip install matplotlib\r\n$ pip install ipython-sql\r\n<\/code><\/pre>\n
B. Jupyter notebook\u3067RDS\u306b\u63a5\u7d9a\u3059\u308b<\/h4>\n
#python\u5411\u3051SQL\u30d1\u30c3\u30b1\u30fc\u30b8\u3092import\u3059\u308b\r\n$ import pymysql\r\ndb = pymysql.connect(host=  'RDS name.mysql.japan.rds.aliyuncs.com',\r\n                             user='Acount ID',\r\n                             password='Acount PW ',\r\n                             db='DB name',\r\n                             charset='utf8',\r\n                             cursorclass=pymysql.cursors.DictCursor)\r\n\r\n#RDS\u30b5\u30fc\u30d0\u306b\u63a5\u7d9a\u3059\u308b\r\ndb.commit()\r\n<\/code><\/pre>\n
\u3053\u308c\u3067Jupyter notebook\u306e\u63a5\u7d9a\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n
C.Jupyter notebook\u3067SQL\u3092\u697d\u3057\u307f\u307e\u3057\u3087\u3046<\/h4>\n
\"image\"<\/div>\n
\"image\"<\/div>\n
\u3053\u308c\u3067\u3001Jupyter notebook\u3067RDS\u30b5\u30fc\u30d0\u306eDatabase\u7de8\u96c6\u306e\u78ba\u8a8d\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002<\/p>\n
4. \u307e\u3068\u3081<\/h1>\n
Jupyter notebook\u306fDatabase\u30b5\u30fc\u30d0\u306b\u63a5\u7d9a\u3059\u308b\u3053\u3068\u3067\u4fbf\u5229\u306b\u64cd\u4f5c\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002RDS\u4ee5\u5916\u306b\u3082\u30ed\u30fc\u30ab\u30ebOS\u74b0\u5883\u3067\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u64cd\u4f5c\u304c\u3067\u304d\u307e\u3059\u3002Jupyter notebook\u3067\u306f\u30c7\u30fc\u30bf\u3092\u30b0\u30e9\u30d5\u3068\u304b\u52d5\u753b\u306b\u5909\u5316\u3059\u308b\u306a\u3069\u8272\u3093\u306a\u30c7\u30fc\u30bf\u5206\u6790\u3001\u53ef\u8996\u5316\u30c4\u30fc\u30eb\u3092\u5229\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u958b\u767a\u306e\u52b9\u7387\u304c\u4e0a\u304c\u308a\u307e\u3059\u3002<\/p>\n
\"\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8<\/div>\n","protected":false},"excerpt":{"rendered":"
1. \u7d39\u4ecb \u524d\u56de\u306fAlibaba Cloud\u4e0a\u3067Jupyter notebook\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3092\u3057\u3066\u307f\u307e\u3057\u305f\u3002 […]<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-46456","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\n- Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/46456-2\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:description\" content=\"1. \u7d39\u4ecb \u524d\u56de\u306fAlibaba Cloud\u4e0a\u3067Jupyter notebook\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3092\u3057\u3066\u307f\u307e\u3057\u305f\u3002 […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/46456-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-12T19:50:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-29T16:02:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d64e837434c4406d05ce8\/10-0.png\" \/>\n<meta name=\"author\" content=\"\u5b87, \u534e\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u5b87, \u534e\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/46456-2\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/46456-2\/\",\"name\":\"- Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-05-12T19:50:14+00:00\",\"dateModified\":\"2024-04-29T16:02:29+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/46456-2\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458\",\"name\":\"\u5b87, \u534e\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g\",\"caption\":\"\u5b87, \u534e\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yuhua\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/46456-2\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"- Blog - Silicon Cloud","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:\/\/www.silicloud.com\/zh\/blog\/46456-2\/","og_locale":"zh_CN","og_type":"article","og_description":"1. \u7d39\u4ecb \u524d\u56de\u306fAlibaba Cloud\u4e0a\u3067Jupyter notebook\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3092\u3057\u3066\u307f\u307e\u3057\u305f\u3002 […]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/46456-2\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-05-12T19:50:14+00:00","article_modified_time":"2024-04-29T16:02:29+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d64e837434c4406d05ce8\/10-0.png"}],"author":"\u5b87, \u534e","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u5b87, \u534e","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"1 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/46456-2\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/46456-2\/","name":"- Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-05-12T19:50:14+00:00","dateModified":"2024-04-29T16:02:29+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/46456-2\/"]}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458","name":"\u5b87, \u534e","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g","caption":"\u5b87, \u534e"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yuhua\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/46456-2\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/46456","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=46456"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/46456\/revisions"}],"predecessor-version":[{"id":88450,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/46456\/revisions\/88450"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=46456"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=46456"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=46456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}