[B! db] sora_hã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

sora_h id:sora_h

dbã«é–¢ã™ã‚‹sora_hã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (35)

${{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}}

MyNA(MySQLãƒ¦ãƒ¼ã‚¶ä¼š)ä¼š 2015å¹´8æœˆ ã§ãƒ¡ãƒ«ã‚«ãƒªã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æˆ¦ç•¥ã¨PHPã«ã¤ã„ã¦å–‹ã£ã¦æ¥ãŸ - blog.nomadscafe.jp
kamipoã•ã‚“Oracle ACEãŠã‚ã§ã¨ã†ã”ã–ã„ã¾ã™ã€‚ MyNA(MySQLãƒ¦ãƒ¼ã‚¶ä¼š)ä¼š 2015å¹´8æœˆ ã§ãƒ¡ãƒ«ã‚«ãƒªã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æˆ¦ç•¥ã¨PHPã«ã¤ã„ã¦å–‹ã£ã¦æ¥ãŸã®ã§ã€è³‡æ–™ã‚’å…¬é–‹ã—ã¾ã™ã€‚ å†…å®¹ã¯WEB+DB PRESS Vol.88ã®è¨˜äº‹ã«æ›¸ã„ãŸã“ã¨+æ–°ãƒã‚¿ã¨ã€PHP(PDO)ã®è©±ã§ã™ã€‚MySQL 5.7ã®ã¨ã“ã‚ã«ã¿ãªã•ã‚“é©šã‹ã‚Œã¦ã„ãŸã‚ˆã†ã§ã™ã€‚ ä»–ã®æ–¹ã®ç™ºè¡¨ã§ã¯ã€dimSTATãŒé¢ç™½ã‹ã£ãŸã§ã™ãã€‚ã‚ã®ã‚°ãƒ©ãƒ•ã‚’ã©ã†ã‚„ã£ã¦ä½œã£ã¦ã„ã‚‹ã®ã‹å…¨ãã—ã‚‰ãªã‹ã£ãŸã®ã§ã€å‹‰å¼·ã«ãªã‚Šã¾ã—ãŸã€‚ã‚ã‚Œã¯ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã—ãŸããªã‚Šã¾ã™ã€‚ã¾ãŸã€MySQLã§å›°ã£ã¦ã„ã‚‹äººã‚’ã¿ã¤ã‘ã¦åŠ©ã‘ã¦ã‚ã’ã‚ˆã†ã¨ã™ã‚‹kamipoã•ã‚“ã®æƒ…ç†±ã‚‚ã€ã©ã“ã‹ã‚‰æ²¸ã„ã¦ãã‚‹ã®ã‹ä¸æ€è°ã§ã™ãŒã€ã•ã™ãŒã§ã—ãŸã€‚ é–‹å ´ã®yoku0825ã•ã‚“ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ã¿ãªã•ã¾ãŠç–²ã‚Œã•ã¾ã§ã—ãŸã€‚ å®Ÿã¯ã€ã“ã®ä¼šã§å–‹ã‚‹äº‹ã‚’ã™ã£ã‹ã‚Šå¿˜ã‚Œã¦ã„ã¦ã€YAPC::Asiaã®æ‡‡è¦ªä¼šã®
sora_h 2015/08/28
mysql

db
ãƒªãƒ³ã‚¯
DELETE_FLAG ã‚’ä»˜ã‘ã‚‹å‰ã«ç¢ºèªã—ãŸã„ã“ã¨ã€‚ - Qiita
DELETE_FLAG ã¨ã„ã†æ€è€ƒåœæ¢ãƒ•ãƒ©ã‚° DELETE_FLAG ã¨ã„ã† boolean ã®åˆ—ãŒ DB è¨è¨ˆã§ã‚ˆãè©±é¡Œã«ãªã‚Šã¾ã™ã€‚ è«–ç†å‰Šé™¤ã¨ã„ã†è¨€è‘‰ã§ä¸Šæ‰‹ã«è«–ç†æ¦è£…ã—ã€ã‚¹ã‚ã‚’è¦‹ã›ã‚‹ã¨ã™ãã«å…¥ã‚ŒãŸãŒã‚‹äººãŒãŠã‚Šã€ ä¸€æ–¹ã§ãã‚Œã«ã¤ã‚ˆãåå¯¾ã™ã‚‹äººã‚‚ã„ã¾ã™ã€‚ è‡ªåˆ†ã®çµŒé¨“ã¨ã—ã¦ã¯ã€åºƒç¾©ã®è«–ç†å‰Šé™¤ã¯ã‚ã‚Šãˆã‚‹ã¨æ€ã„ã¾ã™ãŒã€å®Ÿç¾æ–¹æ³•ãŒ DELETE_FLAG ã ã¨ãªã£ãŸæ™‚ã€ãã‚Œã¯ã‚ã¾ã‚Šè€ƒãˆã¦ãªã„ã§ãªã‚“ã¨ãªããƒ‘ã‚¿ãƒ¼ãƒ³ã¨ã—ã¦ç››ã‚Šè¾¼ã‚“ã§ã‚‹å ´åˆãŒå¤šã„ã¨æ„Ÿã˜ã¾ã™ã€‚ ãŸã ã—ã€è¨è¨ˆã«å”¯ä¸€ã®ç”ãˆã¯ç„¡ã„ã®ã§ã€ã‚‚ã—ã‹ã—ãŸã‚‰ãã‚ŒãŒå¦¥å½“ãªè¨è¨ˆã§ã‚ã‚‹å ´åˆãŒã‚ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ä»Šå›žã¯ã€ŒDELETE ãƒ•ãƒ©ã‚°ãŒãªãœãƒ€ãƒ¡ãªã®ã‹ï¼Ÿã€ãªã©ã¨ã„ã†è©±ã‚’ã™ã‚‹ã¤ã‚‚ã‚Šã‚‚ã€ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã ã¨æ–è¨€ã™ã‚‹ã¤ã‚‚ã‚Šã‚‚ã‚ã‚Šã¾ã›ã‚“ã€‚ å•é¡Œã¯ã€ä»•æ§˜ã‚’ãã¡ã‚“ã¨æŠŠæ¡ã™ã‚‹ã¨ã€ã€Œæœ€é©ãªè¨è¨ˆã¯ DELETE_FLAG ã§ã¯ãªã„ã€ã¨ã„ã†å ´åˆãŒæœ‰ã£ã¦ã€ãã®å ´åˆã¯ã€ãã®æœ€é©ãªè¨è¨ˆ
sora_h 2015/08/28
ã‚³ãƒ¡ãƒ³ãƒˆæ¬„ãŒé¦™ã°ã—ã„

db

design
ãƒªãƒ³ã‚¯
Webã‚·ã‚¹ãƒ†ãƒ ã«ãŠã‘ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£æ¦‚è«– - ã‚†ã†ã†ããƒ–ãƒã‚°
å…ˆæœˆæŠ•ç¨¿ã—ãŸ2015å¹´Webã‚µãƒ¼ãƒã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£åºè«–ã§ã¯ã€Webã‚µãƒ¼ãƒã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’å¦ã¶é“ã®ã‚Šã¨ä»£è¡¨çš„ãªå®Ÿè£…ãƒ¢ãƒ‡ãƒ«ã®æ¦‚è¦ã‚’ç´¹ä»‹ã—ã¾ã—ãŸã€‚ ä»Šå›žã¯ã€å‰å›žåŒæ§˜ã€ä¸»ã«æ–°å’Webã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‘ã‘ã«ã€Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚µãƒ¼ãƒã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒé–“ã®æŽ¥ç¶šç®¡ç†ãƒ¢ãƒ‡ãƒ«ã¨é‹ç”¨äº‹æƒ…ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®æ°¸ç¶šåŒ–ã‚„ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã¨ã¯ä½•ãªã®ã‹ã€ãªãœå¿…è¦ãªã®ã‹ã¨ã„ã£ãŸã“ã¨ãŒä¸»ãªè©±é¡Œã§ã™ã€‚ èƒŒæ™¯ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®æ°¸ç¶šåŒ–ã¨ã¯ãªã«ã‹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®ã‚ªãƒ¼ãƒãƒ˜ãƒƒãƒ‰ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®æ°¸ç¶šåŒ–æ‰‹æ³• ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã¨ã¯ãªã«ã‹ ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°: ãƒ‰ãƒ©ã‚¤ãƒåž‹ ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°: ãƒ—ãƒã‚ã‚·åž‹ ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°å…¨ä½“ã«ã¤ã„ã¦ PostgreSQLã¨MySQL å‚è€ƒè³‡æ–™ ã¾ã¨ã‚ èƒŒæ™¯ 2015å¹´Webã‚µãƒ¼ãƒã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£åºè«–ã§ã¯ã€Webã‚µãƒ¼ãƒã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®è©±ã¨Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§
sora_h 2015/06/30
æœˆåˆŠã‚†ã†ã†ã

db

web

architecture

database
ãƒªãƒ³ã‚¯
Goodbye MongoDB, Hello PostgreSQL
Olery was founded almost 5 years ago. What started out as a single product (Olery Reputation) developed by a Ruby development agency grew into a set of different products and many different applications as the years passed. Today we have not only Reputation as a product but also Olery Feedback, the Hotel Review Data API, widgets that can be embedded on a website and more products/services in the n
sora_h 2015/03/21
postgresql

mongodb

db
ãƒªãƒ³ã‚¯
DB è¨è¨ˆæ™‚ã®ã‚µã‚¤ã‚ºè¦‹ç©ã‚Š[æœ€æ–°ç‰ˆ] - Qiita
ã“ã‚“ã«ã¡ã¯ã€ã™ã£ã‹ã‚Šç§‹ã§ã™ãï¼@yone098 ã§ã™ã€‚ ã¿ãªã•ã‚“DBã®è¨è¨ˆã—ã¦ã¾ã™ã‹ï¼Ÿ DBè¨è¨ˆæ™‚ã®ã‚µã‚¤ã‚ºè¦‹ç©ã‚Š ä»¥å‰ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼ã§æ›¸ã„ãŸè¨˜äº‹ã¯5å¹´å‰ã®ã‚‚ã®ã§ã‚ã‚Šã€ãƒªãƒ³ã‚¯ãŒåˆ‡ã‚Œã¦ã„ã‚‹ã‚‚ã®ãŒã‚ã‚‹ã®ã§æœ€æ–°ç‰ˆã¨ã—ã¦ MySQL, PostgreSQL, Oracle, SQLServer ã«ãŠã‘ã‚‹DBè¨è¨ˆæ™‚ã®ã‚µã‚¤ã‚ºè¦‹ç©ã‚Šã‚’ã¾ã¨ã‚ç›´ã—ã¾ã—ãŸã€‚ MySQL URLå†…ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³è¡¨è¨˜ã‚’å¤‰ãˆã‚‹ã¨ä»¥å‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®æƒ…å ±ã«ãªã‚Šã¾ã™ã€‚ MySQLã¯ã€ã‚ã¾ã‚Šæƒ…å ±ã«å¤‰åŒ–ã¯ç„¡ã‹ã£ãŸã®ã§ Excel ã§ãƒžã‚¯ãƒãªã©ã‚’ä½œæˆã—ã¦è‡ªç¤¾ã§è‡ªå‹•ç®—å‡ºå‡ºæ¥ã‚‹ã‚ˆã†ã«ã™ã‚‹ã®ãŒè‰¯ã„ã¨æ€ã„ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã‚¿ã‚¤ãƒ—ã”ã¨ã«å¿…è¦ãªè¦æ±‚ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãŒæ±ºã¾ã£ã¦ã„ã‚‹ã®ã§ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚µã‚¤ã‚ºãŒæ±ºã¾ã‚Šã€ã‚ã¨ã¯è¦ä»¶æ¬¡ç¬¬ã§ä½•ãƒ¬ã‚³ãƒ¼ãƒ‰ã«ãªã‚‹ã‹ã‚’äºˆæ¸¬ã—ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã‚¿ã‚¤ãƒ—ã”ã¨ã«å¿…è¦ãªè¨˜æ†¶å®¹é‡ ãƒ†ãƒ¼ãƒ–ãƒ«ã®æœ€å¤§ã‚µã‚¤ã‚ºé–¢é€£ http://dev.mysql.com/doc/re
sora_h 2014/12/18
db
ãƒªãƒ³ã‚¯
AWS News Blog
Amazon SageMaker Geospatial Capabilities Now Generally Available with Security Updates and More Use Case Samples At AWS re:Invent 2022, we previewed Amazon SageMaker geospatial capabilities, allowing data scientists and machine learning (ML) engineers to build, train, and deploy ML models using geospatial data. Geospatial ML with Amazon SageMaker supports access to readily available geospatial dat
sora_h 2014/11/13
rds

amazon-rds

aws

amazon-aurora

db
ãƒªãƒ³ã‚¯
OLTP Database, MySQL And PostgreSQL Managed Database - Amazon Aurora - AWS
Amazon Aurora Unparalleled high performance and availability at global scale for PostgreSQL, MySQL, and DSQL Aurora has 5x the throughput of MySQL and 3x of PostgreSQL with full PostgreSQL and MySQL compatibility. Aurora also offers DSQL, the fastest distributed SQL database that is PostgreSQL-compatible. Aurora is designed for up to 99.999% multi-Region availability. With Aurora DSQL, Aurora prov
sora_h 2014/11/13
aws

amazon-aurora

amazon-rds

db
ãƒªãƒ³ã‚¯
Amazon Aurora â€“ New Cost-Effective MySQL-Compatible Database Engine for Amazon RDS | Amazon Web Services
AWS News Blog Amazon Aurora â€“ New Cost-Effective MySQL-Compatible Database Engine for Amazon RDS We launched the Amazon Relational Database Service (Amazon RDS) service way back in 2009 to help you to set up, operate, and scale a MySQL database in the cloud. Since that time, we have added a multitude of options to RDS including extensive console support, three additional database engines ( Oracle,
sora_h 2014/11/13
amazon-rds

rds

aws

amazon-aurora

release

db
ãƒªãƒ³ã‚¯
Mobage ã‚’æ”¯ãˆã‚‹ Ruby ã®æŠ€è¡“ ~ è¤‡æ•°DBç·¨ ~ : sonots:blog
sora_h 2014/11/12
å¸¸è˜çš„ã˜ã‚ƒãªã„ã¨ãã®ã£ã¤ã•ã‚“ã«disã‚‰ã‚Œã¦ãŸ

mysql

db

dena
ãƒªãƒ³ã‚¯
Whereç‹™ã„ã®ã‚ãƒ¼ã€order byç‹™ã„ã®ã‚ãƒ¼
é€Ÿç¿’ï¼è«–ç†ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ ï½žåŸºç¤Žã‹ã‚‰æœ€æ–°å‹•å‘ã¾ã§ï½žï¼ˆPostgreSQL Conference Japan 2022 ç™ºè¡¨è³‡æ–™ï¼‰
sora_h 2014/08/29
yapcasia2014

yapcasia

slide

mysql

performance

db
ãƒªãƒ³ã‚¯
Welcome to the Atlas Device SDK Docs - Atlas Device SDKs - MongoDB Docs
Atlas Device SDKs are deprecated. Refer to the deprecation page for details. Atlas Device SDK is a suite of app development tools optimized for data access and persistence on mobile devices. Use the SDKs to build data-driven mobile, web, desktop, and IoT apps. The SDKs provide tools to read and write Atlas data from devices. Your app can sync automatically with Mongo DB Atlas and other devices usin
sora_h 2014/08/07
db

realm

mobile

ios

osx
ãƒªãƒ³ã‚¯
PG-Strom
The column-oriented data structure of PG-Strom stores data in separate column storage (CS) tables based on the column type, with indexes to enable efficient lookups. This reduces data transfer compared to row-oriented storage and improves GPU parallelism by processing columns together.
sora_h 2014/06/16
é¢ç™½ã„ã‘ã©ã€ãƒ™ãƒ³ãƒãŒSQLã§è¨ˆç®—ã‚’ã—ã¦ãŸâ€¦

gpgpu

postgresql

rdbms

db
ãƒªãƒ³ã‚¯
YappoLogs: ãªãœ SQL_CALC_FOUND_ROWS ã‚„ LIMIT OFFSET ã®ãƒšãƒ¼ã‚¸ãƒ³ã‚°ãŒè‰¯ãç„¡ã„ã®ã‹
ãªãœ SQL_CALC_FOUND_ROWS ã‚„ LIMIT OFFSET ã®ãƒšãƒ¼ã‚¸ãƒ³ã‚°ãŒè‰¯ãç„¡ã„ã®ã‹ ã“ã“æœ€è¿‘ã®å¤§è¦æ¨¡ã‚µãƒ¼ãƒ“ã‚¹é–¢é€£ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒšãƒ¼ã‚¸ãƒ³ã‚°è€ƒã§ã™ã€‚ mysql 5.5.34 ã§è©¦ã—ã¦è¨˜äº‹æ›¸ã„ã¦ã¾ã™ã€‚ bigdata ãƒ†ãƒ¼ãƒ–ãƒ«ã¯ id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (id) ãªã‚«ãƒ©ãƒ ãŒã‚ã‚‹å‰æã§ã™ã€‚ã‚‚ã¡ã‚ã‚“ InnoDB ã§ã™ã€‚ 2014å¹´ãªã‚“ã ã‹ã‚‰COUNT(*)ã¨ã‹SQL_CALC_FOUND_ROWSã¨ã‹LIMIT OFFSETã®ãƒšãƒ¼ã‚¸ãƒ³ã‚°ã¯ã‚„ã‚ã‚ˆã†ãœ - Togetterã¾ã¨ã‚ãŒç™ºç«¯ã«ã¿ãˆã‚‹ã‘ã©ã€ã‚ã‚Šã¨æ˜”ã‹ã‚‰è©±ã•ã‚Œã¦ã‚‹äº‹ãªã‚“ã ã‘ã©ã€ã€Œnippondanji SQL_CALC_FOUND_ROWSã€ã§ã‚°ã‚°ã£ã¦ã‚‚æœ‰ç”¨ãªæƒ…å ±ãªã„ã—æ–‡æ›¸åŒ–ã•ã‚Œã¦ãªã„ã‹ã‚‰ã—ã¨ãã€‚ ãƒšãƒ¼ã‚¸ãƒ³ã‚°å‡¦ç†ã§ä½¿ã‚ã‚ŒãŒã¡ãªæ©Ÿèƒ½ã§ã™ã€‚ S
sora_h 2014/03/12
mysql

performance

db

sql
ãƒªãƒ³ã‚¯
MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
CloudNativePGã‚’å‹•ã‹ã—ã¦ã¿ãŸï¼ ï½žPostgreSQL on Kubernetesï½žï¼ˆç¬¬34å›žPostgreSQLã‚¢ãƒ³ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹@ã‚ªãƒ³ãƒ©ã‚¤...
sora_h 2014/03/08
mysql

performance

tuning

db
ãƒªãƒ³ã‚¯
ä»Šã¾ã§è¦‹ãŸã‚‚ã£ã¨ã‚‚ã‚¯ã‚½ãªãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆ - ä½•ã‹ç€ã¦ã„ã‚Œã°ã„ã„ã‚ˆ
ã‚ã‚Œã¯ã€åƒ•ãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ‰±ã†ã†ã¡æœ€åˆã‹ã‚‰ï¼“ä»¶ç›®ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã ã£ãŸã€‚ C++ã®ã‚½ãƒ¼ã‚¹ãŒé›£è§£ã§ç«ã‚’å¹ã„ã¦ã„ã‚‹ã¨ã„ã†è©±ã§ã€è‡ªåˆ†ã¯ä½Žã‚¹ã‚ãƒ«ã®è‹¥é€ ã€‚ç«ã«ãã¹ã‚‹ã«ã¯ä¸åº¦è‰¯ã„ç¨‹åº¦ã®ã‚„ã‚‹æ°—ã¨è²¬ä»»æ„Ÿã‚’ã‚‚ã£ã¦ã„ãŸã€‚æŠ˜æ‚ªãåˆ¥ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãŒçµ‚äº†ã—ãŸç›´å¾Œã ã£ãŸã‚‚ã®ã§æŠ•å…¥ã•ã‚ŒãŸã®ã§ã—ãŸã€‚ ç¾å ´ã§ã€ŽDBã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’å¸ã„å‡ºã™ãƒ„ãƒ¼ãƒ«ã‹SQLã‚’ä½œã£ã¦ãã‚Œã€ã¨ã„ã‚ã‚Œè©±ã‚’ããã¨ä»–ç¤¾ãŒä½œã£ãŸDBå®šç¾©ãŒã™ã“ã¶ã‚‹ä½¿ã„ã¥ã‚‰ã„ã¨ã„ã†ã€‚ ERå›³ã‚„DBå®šç¾©ã‚’è¦‹ã›ã¦ãã ã•ã„ã¨è¨€ã£ãŸã®ã ã‘ã©ã€ãã‚“ãªã‚‚ã®ã¯ç„¡ã„ã¨ã„ã†è¿”äº‹ã€‚ ä»Šãªã‚‰ã‚‚ã†ã“ã“ã‚‰è¾ºã§é€ƒã’å‡ºã™ã¨ã“ã‚ã§ã™ãŒã€å½“æ™‚ã¯ã€Žãµãƒ¼ã‚“ã€‚ã€ã¦ãªã‚‚ã‚“ã§ãã†ã„ã†ã“ã¨ã‚‚ã‚ã‚‹ã®ã‹ãã‚‰ã„ã®è»½ã„æ°—æŒã¡ã§è€ƒãˆã¦ã„ã¾ã—ãŸã€‚ ã§ã€ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®è³‡æ–™ã‚’ã‚ã•ã‚Šã¾ãã£ã¦ä½•ã¨ã‹DBå®šç¾©ã®ã‚ˆã†ãªã‚‚ã®ã‚‚è¦‹ã¤ã‘DBã®ãƒ‡ãƒ¼ã‚¿ã‚’èª¿æŸ»ã—å§‹ã‚ãŸã®ã§ã™ãŒä½•ã‹ãŒãŠã‹ã—ã„ã€‚ æ©Ÿèƒ½ã®æ•°ã«æ¯”ã—ã¦ç•°æ§˜ã«ãƒ†ãƒ¼ãƒ–ãƒ«æ•°ãŒå°‘ãªã„ã®ã§ã™ã€‚ ãµã¨å‘¨ã‚Šã‚’è¦‹ã‚‹ã¨ã€çš†
sora_h 2014/03/06
ãƒ˜ã‚¤ãƒ˜ã‚¤ã€œ

db
ãƒªãƒ³ã‚¯
Dashboard
sora_h 2014/02/06
db

nosql

hosting
ãƒªãƒ³ã‚¯
InfluxDB | Real-time insights at any scale | InfluxData
Real-world AI starts with time series. Time series starts with Influx DB. Join the millions of developers building real-time systems with Influx DB, the leadingÂ time series database. Get Influx DB
sora_h 2013/12/19
influxdb

db

nosql
ãƒªãƒ³ã‚¯
conma.me
This domain may be for sale!
sora_h 2013/12/10
ã‹ã˜ã‚…â€¦ã‚ã‚‹â€¦ã«â€¦

mysql

db

tips
ãƒªãƒ³ã‚¯
yrmcds 1.0.0 ã®è£œè¶³ - èª°ã‹ã®å½¹ã«ç«‹ã¦ã°ã„ã„ãƒ–ãƒã‚°
ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãªã‚‰è©³ç´°ãŒæ°—ã«ãªã‚‹ã‚‚ã®ã€‚ã¨ã„ã†ã‚ã‘ã§ã€å€‹äººãƒ–ãƒã‚°ã®ã»ã†ã§ yrmcds 1.0.0 ãƒªãƒªãƒ¼ã‚¹è¨˜äº‹ã®æŠ€è¡“çš„ãªè£œè¶³ã‚’ã—ã¦ãŠãã¾ã™ã€‚ keepalived ä½¿ã†ã®ã€split brain ã«ãªã‚‹ã‚“ã˜ã‚ƒãªã„ã®ï¼Ÿ ã•ã¦ã¯ãƒ—ãƒã®æ–¹ã§ã™ãã€‚å›°ã‚Šã¾ã™ãªã€ãã†ã„ã†çªã£è¾¼ã¿ã¯ï¼ æ°—ã«ãªã‚‹äººã¯ split brain èµ·ã“ã•ãªã„ heartbeat ã‚’ã”åˆ©ç”¨ãã ã•ã„ã€‚ ç”¨é€”æ¬¡ç¬¬ã§ã¾ã‚ã©ã†ã§ã‚‚ã„ã£ã‹ãªãƒ¼ã¨ã„ã†äººã¯ keepalived ã®æ–¹ãŒæ‰‹è»½ã‹ã¨æ€ã„ã¾ã™ã€‚ ã‚µãƒ¼ãƒãƒ¼ã‚µã‚¤ãƒ‰ãƒãƒƒã‚¯ã¨ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ ãƒãƒƒã‚¯çŠ¶æ…‹ã¯ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã•ã‚Œã¾ã›ã‚“ã€‚éžåŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãªã®ã§ã—ã¦ã‚‚ç„¡é§„ã¨ã„ã†ã‹ã€‚ ã™ã‚‹ã¨ãƒãƒƒã‚¯ã—ãŸå¾Œã€ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã™ã‚‹ã¨ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆãŒãƒãƒƒã‚¯ã•ã‚Œãªã„çŠ¶æ…‹ã«ãªã‚‹ã‚ã‘ã§ã™ã€‚å±é™ºã§ã™ã€‚ å¯¾ç–ã¨ã—ã¦å°Žå…¥ã—ãŸã®ãŒã€ãƒã‚¤ãƒŠãƒªãƒ—ãƒãƒˆã‚³ãƒ«ã® RaU (Replace and Unlock) ã§ã™ã€‚ ã“ã®ã‚³ãƒžãƒ³ãƒ‰
sora_h 2013/12/09
yrmcds

kvs

db
ãƒªãƒ³ã‚¯
yrmcds 1.0.0 ã‚’ãƒªãƒªãƒ¼ã‚¹ã—ã¾ã—ãŸ - Cybozu Inside Out | ã‚µã‚¤ãƒœã‚¦ã‚ºã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãƒ–ãƒã‚°
@ymmt2005 ã“ã¨å±±æœ¬æ³°å®‡ã§ã™ã€‚åŽ»ã‚‹ 7 æœˆã« yrmcds ã¨ã„ã† memcached äº’æ›ãª KVS ã‚’å…¬é–‹ã—ãŸã“ã¨ã‚’ã”æ¡ˆå†…ã—ã¾ã—ãŸã€‚ãã‚Œã‹ã‚‰ 5 ãƒ¶æœˆçµŒã¡ã¾ã—ãŸãŒã€ä»Šå›žã¯å®‰å®šç‰ˆã¨ãªã‚‹ãƒãƒ¼ã‚¸ãƒ§ãƒ³ 1.0.0 ã‚’ãƒªãƒªãƒ¼ã‚¹ã‚’ã”æ¡ˆå†…ã—ã¾ã™ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¯ã“ã¡ã‚‰ã‹ã‚‰ã©ã†ãž: https://github.com/cybozu/yrmcds/releases/tag/v1.0.0 0.9.0 ã‹ã‚‰ã®å¤‰æ›´ç‚¹ã‚’çŸãã¾ã¨ã‚ã‚‹ã¨ãƒã‚°ãŒãªããªã£ã¦ã€memcached ã‚ˆã‚Šå¤šåˆ†é«˜é€Ÿã«ãªã£ã¦ã„ã¾ã™ã€‚ã¡ã‚‡ã£ã¨é•·ã‚ã®è¨˜äº‹ã§ã™ãŒã€æœ«å°¾ã«ã„ã„ã“ã¨ãŒæ›¸ã„ã¦ã‚ã‚Šã¾ã™ã®ã§ã€æ˜¯éžã”ä¸€èªãã ã•ã„ã€‚ yrmcds ã®ç‰¹é•· ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ ã‚µãƒ¼ãƒãƒ¼ã‚µã‚¤ãƒ‰ãƒãƒƒã‚¯ No slabs ãã®ä»– memcached ã¨ã®å·®ç•° é‹ç”¨å®Ÿç¸¾ã¨æ€§èƒ½ ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ 0.9.0 ã‹ã‚‰ã®å¤‰æ›´ä¸€è¦§ ãƒã‚°å ±å‘Šã‚’å‹Ÿé›†ã—ã¾ã™ï¼ yrmcds ã®ç‰¹é•· y
sora_h 2013/12/09
yrmcds

kvs

db

release

cybozu
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸