[B! ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹] tiida26ã®ãƒ

tiida26 id:tiida26

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã™ã‚‹tiida26ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

è«–ç†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ï¼ˆpg_dump ã¨ pg_dumpallï¼‰ â€” Let's Postgres
NTT ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚»ãƒ³ã‚¿ éˆ´æœ¨ å¹¸å¸‚ 3. è«–ç†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒªã‚¹ãƒˆã‚¢ è«–ç†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’è¡Œã†ãƒ„ãƒ¼ãƒ«ã¯ pg_dump åŠã³ pg_dumpall ã§ã™ã€‚ pg_dump ã¯ PostgreSQL ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¯ãƒ©ã‚¹ã‚¿ã®å„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å˜ä½ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’è¡Œã„ã¾ã™ã€‚pg_dumpall ã¯ã‚¿ãƒ¼ã‚²ãƒƒãƒˆã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¯ãƒ©ã‚¹ã‚¿ã«æ ¼ç´ã—ã¦ã‚ã‚‹å…¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’è¡Œã„ã¾ã™ã€‚ pg_dump ã‚‚ pg_dumpall ã‚‚ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ã‚¿ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¾©å…ƒã™ã‚‹ãŸã‚ã«å¿…è¦ãª SQL æ–‡ã§æ§‹æˆã•ã‚Œã¾ã™ã€‚ å¾“ã£ã¦ã€pg_dump ã‚„ pg_dumpall ã‚’ä½¿ã†ã¨ PostgreSQL ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…å®¹ã‚’åˆ¥ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ç§»è¡Œã—ãŸã‚Šã€ç‰¹å®šã®ãƒ†ãƒ¼ãƒ–ãƒ«ã ã‘ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ãŸã‚Šã™ã‚‹ã“ã¨ãŒå¯èƒ½ã¨ãªã‚Šã¾ã™ã€‚ pg_dump, pg_dumpall ã‚’ä½¿ã†ãŸã‚ã«ã¯ç‰¹åˆ¥ãªç”¨æ„ã¯ã„ã‚Šã¾ã›ã‚“ãŒã€
tiida26 2017/03/06
ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

database

PostgreSQL

Tech
ãƒªãƒ³ã‚¯
Mysql toranomaki
ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã«MySQL Clusterã‚’ä½¿ã£ã¦ã¿ã‚ˆã†@MySQL Cluster Casual Talks 2013.09Mikiya Okuno
tiida26 2014/02/14
MySQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

db

é‹ç”¨

slideshare

Tech

æŠ€è¡“
ãƒªãƒ³ã‚¯
DSASé–‹ç™ºè€…ã®éƒ¨å±‹:5åˆ†ã§ã§ãã‚‹ã€MySQLã®ãƒ¡ãƒ¢ãƒªé–¢ä¿‚ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï¼
MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ãŠã„ã¦éžå¸¸ã«é‡è¦ã¨ãªã‚‹ãƒ¡ãƒ¢ãƒª(ãƒãƒƒãƒ•ã‚¡)é–¢é€£ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã«ã¤ã„ã¦ã€ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒã‚¤ãƒ³ãƒˆ DSASã®ã¨ã‚ã‚‹DBã‚µãƒ¼ãƒ(å®Ÿãƒ¡ãƒ¢ãƒª4GB)ã®å®Ÿéš›ã®è¨å®šå€¤ ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ ã¾ãŸã€å¿…è¦ãƒ¡ãƒ¢ãƒªã®ç·é‡ã®è¨ˆç®—ã‚„é™ç•Œå€¤ã‚’è¶Šãˆã¦ãªã„ã‹ãƒã‚§ãƒƒã‚¯ã—ã¦ãã‚Œã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚‚ç´¹ä»‹ã—ã¾ã™ã€‚ æ˜¯éžã€å‚è€ƒã«ã—ã¦ã¿ã¦ãã ã•ã„ï¼ ã¾ãšæœ€åˆã«æ³¨æ„ç‚¹ã‚’ã€‚ ãƒãƒƒãƒ•ã‚¡ã«ã¯2ã¤ã®ã‚¿ã‚¤ãƒ—ãŒã‚ã‚Šã¾ã™ã€‚ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ã¯mysqldå…¨ä½“ã§ãã®ãƒãƒƒãƒ•ã‚¡ãŒ1ã¤ã ã‘ç¢ºä¿ã•ã‚Œã‚‹ã‚‚ã®ã§ã€ ã“ã‚Œã«å¯¾ã—ã€ ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ã¯ã‚¹ãƒ¬ãƒƒãƒ‰(ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³)ã”ã¨ã«ç¢ºä¿ã•ã‚Œã‚‹ã‚‚ã®ã§ã™ã€‚ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®éš›ã«ã¯ã‚°ãƒãƒ¼ãƒãƒ«/ã‚¹ãƒ¬ãƒƒãƒ‰ã®é•ã„ã‚’æ„è˜ã™ã‚‹ã‚ˆã†ã«ã—ã¾ã—ã‚‡ã†ã€‚ ãªãœãªã‚‰ã€ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ã«å¤šãã®ãƒ¡ãƒ¢ãƒªã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã€ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãŒå¢—ãˆãŸã¨ãŸã‚“ã«ã‚¢ãƒƒã¨ã„ã†é–“ã«ãƒ¡ãƒ¢ãƒªä¸è¶³ã«ãªã£ã¦ã—ã¾ã†ã‹ã‚‰ã§ã™ã€‚ in
tiida26 2011/07/08
mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ãƒ¡ãƒ¢ãƒª

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

db

database

performance
ãƒªãƒ³ã‚¯
MySQLç®¡ç†è€…æœ€é€Ÿãƒžã‚¹ã‚¿ãƒ¼
å··ã§ã¯ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã®æœ€é€Ÿãƒžã‚¹ã‚¿ãƒ¼ãŒæµè¡Œã£ã¦ã‚‹ã®ã§ã€MySQLã‚‚å‚æˆ¦ã€‚ãŸã ã—ç®¡ç†è€…å‘ã‘ã€‚ ã¾ãšã¯ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¨ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã‚µã‚¤ãƒˆ http://dev.mysql.com/downloads/ ãƒã‚¤ãƒŠãƒªã«ã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ï¼ˆWindows=MSIã€Mac=DMGã€Linux=RPMã¨ã‹ï¼‰ã¨ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ï¼ˆ*NIX=tar.gz/Windows=zipï¼‰ãŒã‚ã‚‹ã‘ã©ã€åˆå¿ƒè€…ã¯é»™ã£ã¦ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’ãƒãƒ§ã‚¤ã‚¹ã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯ã‚¦ã‚£ã‚¶ãƒ¼ãƒ‰ã«å¾“ã†ã ã‘ã€‚è‹±èªžã ã‘ã©ãã“ã¯ã‚¬ãƒžãƒ³ï¼ ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãƒªãƒã‚¸ãƒˆãƒªãŒã‚ã‚‹OSã‚’ä½¿ã£ã¦ã‚‹ãªã‚‰ã€ãƒªãƒã‚¸ãƒˆãƒªã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã®ã‚‚ã‚ã‚Šã ã€‚ä¾‹ãˆã°ã€ shell> sudo yum install mysqlã¨ã‹ shell$gt; sudo apt-get install mysqlã¨ã‹ã€‚ã“ã‚Œã¯æ¥½ãƒãƒ³ã ã‘ã©MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒã¡ã‚‡ã£ã¨å¤ããªã‚‹ã®ã§æ³¨æ„ã€‚ ã‚‚ã¡ã‚ã‚“
tiida26 2010/08/18
MySQL

ã¾ã¨ã‚

DB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
1