èæ¯ãªã©ã¯ https://wrsn0.hatenablog.com/entry/2024/02/22/092703 ã¸
ã¢ãã²ã¼ã§ç¥ãããDeNAã¯ãããã¯ã¨ã³ããã¼ã¿ãã¼ã¹ã«NoSQLã使ã£ã¦ãã¾ããããªããï¼ ããã¯MySQL/InnoDB 5.1ã®ç°å¢ã§ç§é75ä¸ã¯ã¨ãªã¨ãããå¤ãã®NoSQLã§ãå®ç¾ã§ããªããããªé«æ§è½ãå®ç¾ãã¦ãããããDeNAã®æ¾ä¿¡åç¯ï¼ã¾ã¤ã®ã¶ããã®ãï¼æ°ã¯ãèªèº«ã®ããã°ã«ãããªå 容ã®ã¨ã³ããªãUsing MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity serverãï¼è±èªï¼ããã¹ããã¦ãã¾ãã Yoshinori Matsunobu's blog: Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server æ¾ä¿¡æ°ãææããããã«ãå¤§è¦æ¨¡ãªããããµã¼ãã¹ãæä¾ãã¦ãã伿¥ã®å¤ãã¯åæ£ç°å¢ã§
ã¯ããã« â Railsç°å¢ã§DB(MySQL)ã®ããã¯ã¢ããã¨ãªã¹ãã¢ãCapistranoããèªååããæ¹æ³ãæ¸ãã¦ã¿ã¾ãã Capistrano v2.5.5ãã¯ã©ã¤ã¢ã³ãã¯Windows XPããµã¼ãã¼å´ã¯Ubuntu 8.04ã§ç¢ºèªãã¾ããã â åææ¡ä»¶ â MySQLã使ã£ã¦ãã mysqldumpã使ãã capistranoãããããã¡ããã¨åãã¦ãã config/database.ymlã®è¨å®ã§DBã«ã¢ã¯ã»ã¹ã§ãã ã¢ããªï¼DBãµã¼ãã¼ã1å°ã®æãããã¹ããã¦ãªãä»¶ capistrano-ext(åè)使ã£ã¦stagingé¯ã¨productioné¯ã¨ã©ã¡ãåãã«å®è¡ãã¦ããã¾ãè¡ãããã«ãªã£ã¦ãããº(ãã¡ã¤ã³åã§ããã¯ã¢ãããã¡ã¤ã«åçæ) ãªã¢ã¼ãã®â(ããã¸ã§ã¯ã)/shared/backups/â以ä¸ã«ã©ãã©ãããã¯ã¢ãããã ãã¼ã«ã«ã®â(ããã¸ã§ã¯ã)/..
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? ã¯ããã« ãã ï¼Â´ã»Ïã»ï½) ããããããã¼ãã³ãã¦ã¹ã¸ã ãã®mysqlã¯ãµã¼ãã¹ã ãããã¾ãsystemctl start mysqld ãã¦è½ã¡çãã¦æ¬²ããã ããããã¾ãããªãã ãæ¸ã¾ãªãã ä»ã®é¡ãã£ã¦è¨ããããè¬ã£ã¦è¨±ãã¦ããããã¨ãæã£ã¦ããªãã ã§ãããã®ã¿ã¤ãã«ãè¦ãã¨ããåã¯ããã£ã¨è¨èã§ã¯è¨ã表ããªã ãã¨ããããã¿ãããªãã®ãæãã¦ãããã¨æãã æ®ºä¼ã¨ããä¸ã®ä¸ã§ãããããæ°æã¡ãå¿ããªãã§æ¬²ãã ããæã£ã¦ããã®è¨äºãããããã ããããæ³¨æãèãããã ã¨ããããã§mysqlãdisãã¾ããdisãã ããª
ä»åã¯ãªã¼ã«ã¢ãã¦ãã®nnmrãå¼ç¤¾ãµã¤ãAll About Japanã®é度ãé«éåããçµç·¯ã«ã¤ãã¦ã¾ã¨ãã¾ãã All About Japanã¨ã¯ ããããAll About Japanï¼ä»¥ä¸AAJï¼ã¨ã¯ä½ãã¨ããã¾ãã¨ãå¼ç¤¾ãæä¾ãã¦ãã訪æ¥å¤å½äººåãã®æ¥æ¬ç´¹ä»ãµã¤ãã§ãã å¤å½äººåããµã¤ãã§ãè±èªãä¸å½èªï¼ç¹ä½åï¼ãä¸å½èªï¼ç°¡ä½åï¼ãã¿ã¤èªãéå½èªã®5ãå½èªã«å¯¾å¿ãã¦ããã¾ãã ãAnimeããIzakayaããNinjaãã¨ãã£ããããªç¹éããå®éã«è¦³å ãã人åãã®ã¢ãã«ã«ã¼ãè¨äºãç¹è²ã§ãã â ç¹é (url : http://allabout-japan.com/en/tag/sushi/ ) â ã¢ãã«ã«ã¼ãè¨äº (url : http://allabout-japan.com/en/article/222/ ) æè¡çãªç´¹ä» LAMPç°å¢ã§ãã ï¼ãµã¼ãã¼æ§æã¯å¾ã«è¨è¿°
æ»æã«å©ç¨ãããå ´åãroot権éã§ä»»æã®ã³ã¼ããå®è¡ããããµã¼ããå¶å¾¡ãããå¯è½æ§ãææããã¦ããã ç±³Oracleåä¸ã®ãªã¼ãã³ã½ã¼ã¹ãã¼ã¿ãã¼ã¹ãMySQLãã«æªè§£æ±ºã®èå¼±æ§ãè¦ã¤ãã£ãã¨ãã¦ãã»ãã¥ãªãã£ç ç©¶è ã9æ12æ¥ã«æ¦ç¥ãã³ã³ã»ããå®è¨¼ã³ã¼ããå ¬éããããµã¤ãã¼æ»æã«å©ç¨ãããå ´åãroot権éã§ä»»æã®ã³ã¼ããå®è¡ããããµã¼ããå¶å¾¡ãããå¯è½æ§ãææããã¦ããã ç ç©¶è ã®Dawid Golunskiæ°ãå ¬éããæ å ±ã«ããã°ãMySQLã®èå¼±æ§ã¯è¤æ°çºè¦ããããä¸ã§ãç¹ã«æ·±å»ãª1ä»¶ã«ã¤ãã¦ã¯ããªã¢ã¼ãã®æ»æè ãMySQLã®è¨å®ãã¡ã¤ã«ã«ä¸æ£ãªå 容ãä»è¾¼ãSQLã¤ã³ã¸ã§ã¯ã·ã§ã³æ»æã«å©ç¨ãããæããããã ãã®èå¼±æ§ã¯ãMySQLã®ææ°çãå«ã5.7ç³»ã5.6ç³»ã5.5ç³»ã®å ¨ãã¼ã¸ã§ã³ã«ãããã©ã«ãã®ç¶æ ã§åå¨ãããç¾æç¹ã§Oracle MySQLãµã¼ãã®èå¼±æ§ä¿®æ£ãããã¯åå¨
ãã¼ãã«ã®ãµã¤ãºã¯phpMyAdminã§ãè¦ãã¾ãããã³ãã³ãããè¦ããã»ããä½ãã¨ä¾¿å©ãªã®ã§ã調ã¹ã¦ã¿ã¾ããã å ¨ã¦ã®ãã¼ã¿ãã¼ã¹ã®ãµã¤ãºã確èªãã # MBåä½ select table_schema, sum(data_length+index_length) /1024 /1024 as MB from information_schema.tables group by table_schema order by sum(data_length+index_length) desc; +--------------------------+---------------+ | table_schema | MB | +--------------------------+---------------+ | database1 | 5579.89978790| | databas
å¹³ç´ ããQAï¼ ITããå©ç¨ããã ããèª ã«ãããã¨ããããã¾ãã QAï¼ ITã¯ã質åãåçããå ±æãããç·¨éããã¦ãããã¨ã§ãã¹ããªQAãèç©ã§ãããITã¨ã³ã¸ãã¢ã®ããã®åé¡è§£æ±ºã³ãã¥ããã£ã¼ãã¨ãã¦ç´7å¹´ééå¶ããã¦ãã¾ãããããã¾ã§ãµã¼ãã¹ãç¶ãããã¨ãã§ããã®ã¯ãQAï¼ ITã®ã³ã³ã»ããã«å ±æãããã ããé©åãªè³ªåãåçããå¯ãããã ããçãã¾ã®ãæ¯æ´ããã£ãããããã¨èãã¦ããã¾ããéãã¦å¾¡ç¤¼ç³ãä¸ãã¾ãã ããããªãããã¨ã³ã¸ãã¢ã®æ å ±å ¥ææ¹æ³ã®å¤æ§åãQAãµã¼ãã¹å¸å ´ã®ç¶æ³ãï¼ ITã®ä»å¾ã®ã¡ãã£ã¢éå¶æ¹éãªã©ãæ¤è¨ããçµæã2020å¹´2æ28æ¥ï¼éï¼15:00ããã¡ã¾ãã¦QAï¼ ITã®ãµã¼ãã¹ãçµäºãããã¨ã«ãã¾ããã ããã¾ã§ãå©ç¨ãããã ãã¾ããçãã¾ã«ã¯æ®å¿µãªãç¥ããã¨ãªããèª ã«å¿è¦ããæã£ã¦ããã¾ããä½ã¨ãããçè§£ãããã ãã¾ãã¨å¹¸ãã§ãã QAï¼ ITã®7å¹´éã§çãã¾ã®ç¥è
[English page] Ruby ã§è¨è¿°ããã MySQL ã® Ruby API ã§ããMySQL ã® C API ã¨ã»ã¼åçã®æ©è½ãããã¾ããMySQL/Ruby 㨠ã»ã¼äºæãããã¾ãã ç¾å¨ã®ã¨ãããMySQL 4.1.x ã§ã¯ä½¿ç¨ã§ãã¾ããï¼mysqld ã« --old-passwords ãªãã·ã§ã³ãã¤ããã°ä½¿ç¨ã§ããããï¼ã é»ç° 亮 <akuroda at gmail.com> ããã MySQL 4.1.x ã§ã使ç¨ã§ããããããä½ã£ã¦ããã¾ããã ãã®ãã¡åãè¾¼ãã¤ããã§ãããã¨ããããç½®ãã¦ããã¾ãã å¿ è¦ãªãã® Ruby 1.8.2 ã©ã¤ã»ã³ã¹ ãã®ããã°ã©ã 㯠Ruby ã©ã¤ã»ã³ã¹ã«å¾ãã¾ãã ãã¦ã³ãã¼ã ruby-mysql-0.2.6.tar.gz ruby-mysql-0.2.5.tar.gz ruby-mysql-0.2.4.tar.gz ruby-
å®è¡ç°å¢ OS: Mac OS X 10.6 (Snow Leopard) MacPorts 1.8.2 ã¤ã³ã¹ãã¼ã« $ sudo port install mysql5-server MySQLè¨å®ãã¡ã¤ã«ç·¨é $ sudo cp /opt/local/share/mysql5/mysql/my-medium.cnf /opt/local/etc/mysql5/my.cnf $ sudo vi /opt/local/etc/mysql5/my.cnf ##[client]ã®é ç®ã¸è¿½å [client] default-character-set=utf8 ##[mysqld]ã®é ç®ã¸è¿½å [mysqld] default-character-set = utf8 skip-character-set-client-handshake character-set-server = utf
â»root権éãç¡ãã¨å¿ è¦ãªãã¡ã¤ã«ãã¤ã³ã¹ãã¼ã«ãããªãå¯è½æ§ãããã®ã§ï¼ su ã sudo ã§ã¤ã³ã¹ãã¼ã«ããäºï¼ ã»MacportsãUpdate # port -d selfupdate # port sync ã»Rubyãã¤ã³ã¹ãã¼ã« # port install ruby ã»Ruby Gemsãã¤ã³ã¹ãã¼ã« # port install rb-rubygems ã»Railsãã¤ã³ã¹ãã¼ã« # gem install rails # gem install rails --version 1.2.6ãï¼1.2.6ãå ¥ããå ´åï¼ ã»MySQLã¤ã³ã¹ãã¼ã« # port install mysql5 mysql5-server ã»MySQLã¢ããã¿ã®ã¤ã³ã¹ãã¼ã«ï¼å ¥ããªãã¨Rubyã§MySQLãæ±ããªãï¼ # port install rb-mysql ã»åæå # mysql m
MySQLã§ãã¼ãã«ã¸ã®ã«ã©ã 追å ãã¤ã³ããã¯ã¹è¿½å ããã¼ãã«ã®åç·¨æãªã©ãè¡ãã¨ããã®éãã¼ãã«ã«å ±æããã¯ãããã£ã¦ãã¾ãã¾ãããã®ãããããã®ã¡ã³ããã³ã¹å¦çã¯ãé常å©ç¨è ã®å°ãªãæ·±å¤æ©æå¸¯ã«ãµã¼ãã¹ãæ¢ãã¦å®æ½ããå¿ è¦ãããã¾ããæ¬æ¥ã¯ãããç¡åæ¢ããªã³ã©ã¤ã³ã®ã¾ã¾ã§ã§ããªããã¨ãã話é¡ã§ãã åºæ¬çãªã¢ã¤ã㢠ã¡ã³ããã³ã¹å¯¾è±¡ã®å ãã¼ãã«ãã³ãã¼ãã¦ã使¥ç¨ã®ä»®ãã¼ãã«ãä½ãã¾ã ä»®ãã¼ãã«ã«å¯¾ãã¦ãã«ã©ã 追å ãªã©ã®å¤æ´ãå ãã¾ã ãã®éãå ãã¼ãã«ã«å¯¾ãã¦è¡ãããæ´æ°å¦çã«ã¤ãã¦å·®åãè¨é²ãã¦ããã¾ã ä»®ãã¼ãã«ã®å¤æ´ãçµãã£ãããè¨é²ãã¦ãããå·®åãã¼ã¿ãä»®ãã¼ãã«ã«åæ ãã¾ã å·®åãã¼ã¿ã®åæ ãçµãã£ãããå ãã¼ãã«ã¨ä»®ãã¼ãã«ãå ¥ãæ¿ãã¾ã ããã¨ä¼¼ããããªãã¨ãèããæ¹ã¯çµæ§ããã£ãããã®ã§ã¯ãªãã§ããããããã ãè¨ãã¯æããè¡ãã¯é£ãã§ããæ´åæ§ããã¡ãã¨åãããã©ã
å é±ãMySQL Conference & Expo 2010ãéå¬ãããçæ³ã®ãã¡ã«çµäºãããã«ã³ãã¡ã¬ã³ã¹ã«åãããå½¢ã§ãMySQL 5.5.3ããã³5.5.4ããªãªã¼ã¹ãããã®ã ãããããç®ãè¦å¼µããããªé²åãéãã¦ãããç¹ã«æ§è½é¢ã§ã®é²åã«ã¯ç®ãè¦å¼µããã®ãããï¼Jeremy ZawodnyãMark Calleghanã¨ãã£ãã³ãã¥ããã£ã®éé®ãã¡ããé常ã«ã¨ããµã¤ãã£ã³ã°ãªãªãªã¼ã¹ã ï¼ããªã©ã¨è¡¨ãã¦æè¿ã®æã表ãã¦ããã ã¨ããããã§ãæ¬æ¥ã¯MySQL 5.5.3/5.5.4ã®æ°æ©è½ããã³å¤æ´ç¹ã«ã¤ãã¦ã¬ãã¥ã¼ãã¦ã¿ããï¼ ããããã ã MySQL 5.5ã®æ¢åã®æ©è½ ãMySQL 5.5ãç»å ´ããã¨ãããã®æ°æ©è½ã«ã¤ãã¦ã¯ä»¥åã«ãã¨ã³ããªã§ç´¹ä»ããããããã§æ¹ãã¦ãããããã¦ã¿ãããMySQL 5.5ã¯ãæ£ç¢ºã«ããã¨ç¾å¨ææ°ãã¼ã¸ã§ã³ã§ããMySQL 5.1ã®ãæ¬¡ã®æ¬¡ãã®ã
å æãNot Only NoSQL!! é©ç°çãªã¾ã§ã«WRITEæ§è½ãã¹ã±ã¼ã«ãããSPIDERã¹ãã¬ã¼ã¸ã¨ã³ã¸ã³ã¨ããã¨ã³ããªã§SPIDERã¹ãã¬ã¼ã¸ã¨ã³ã¸ã³ã«ããã¹ã±ã¼ã«ã¢ã¦ããåãï¼ã¨ããè©±ãæ¸ãããSPIDERã¹ãã¬ã¼ã¸ã¨ã³ã¸ã³ã¯åãã¤ãã ãããã¦ãã¦ããã¾ãã¦ã§ãä¸ã§è¦ã¤ãããªããå¯ä¸è¦ã¤ããæ¥æ¬èªã®è¨äºã¯ãã¦ãã¦ã©ãã«ãããå½ç£MySQLã¹ãã¬ã¼ã¸ã¨ã³ã¸ã³ãSpiderãã®ä½è ãæ¯æ³¢å¥å¾³æ°ã«èã ãã ãã§ãããSPIDERã¹ãã¬ã¼ã¸ã¨ã³ã¸ã³ã¯æ¯æ³¢æ°ã«ããåç¬ã®ä½åã§ãããããæ¯æ³¢æ°ã¯éçºã ãã§æãã£ã±ãã§ãããä½¿ãæ¹ã®ç´¹ä»è¨äºãæ¸ããã¨ã¾ã§ã¯æãåããªãã®ã§ãããããããªåãã¹ãã¬ã¼ã¸ã¨ã³ã¸ã³ãããã¥ã¡ã³ããè¶³ããªãããã§ä½¿ã£ã¦è²°ããªããªãã¦å¿ä½ãªãï¼ï¼ ã¨ããããã§ã仿¥ã¯SPIDERã¹ãã¬ã¼ã¸ã¨ã³ã¸ã³ã®åºæ¬çãªä½¿ãæ¹ã«ã¤ãã¦ç´¹ä»ãããå°ãé·ãã¨ã³ããªã§ããããæå¾ã¾ã§ãä»ã
EC2ä¸ã§ã¯ãä»®æ³IPã¢ãã¬ã¹ãªã©ã®IPã¬ãã«ã®æ©è½ãå¶éããã¦ãããããä»®æ³IPã¢ãã¬ã¹ã使ç¨ããåé·åã¯åºæ¬çã«ã¯ä½¿ç¨ã§ãã¾ãããããDNSã使ç¨ãããã¨ã§ãVIPã»ã©ã®ç²¾åº¦ã¯é«ããªããã®ã®MySQL Multi-masteræ§æãæ§ç¯ãããã¨ãã§ãã¾ããã ä»åã¯ãMySQL Multi-masterã®åãæ¿ãç¨ã®æ¯æ´ãã¼ã«ã¨ãã¦ãMulti-Master Replication Manager for MySQLã使ç¨ãã¾ãããã®ãã¼ã«ã§ã¯ãMySQLã®æ»æ´»ç£è¦ã¨ä»®æ³IPã¢ãã¬ã¹ã®åãæ¿ããè¡ã£ã¦ããã¾ãã ãã¡ãããEC2ä¸ã§ã¯ä»®æ³IPã¢ãã¬ã¹ã¯ä½¿ããªãã®ã§ããã®ã¾ã¾ã§ã¯ãã¾ãåä½ãã¾ãããããã§ããã®ãã¼ã«ã«å«ã¾ããns_agentã使ç¨ãããã¨ã§ä»®æ³IPã¢ãã¬ã¹ã§ã¯ãªããDNSã«ããåãæ¿ããã§ããããã«ãªããEC2ä¸ã§Multi-masterãæ§ç¯ãããã¨ãã§ãã¾ãã ä»å
MySQLã®rootã¦ã¼ã¶ã¼ã®ãã¹ã¯ã¼ããå¿ è¦ãªã¹ã¯ãªãããæ¸ãå ´åã #!/bin/bash mysqladmin -uroot -ptiger ping ã®ããã«ã¹ã¯ãªããèªä½ã«ãã¹ã¯ã¼ããæ¸ãã®ã§ã¯ãªããrootã®HOMEãã£ã¬ã¯ããªã®.my.cnf(/root/.my.cnf)ã®ä¸ã«ãã¹ã¯ã¼ããæ¸ããrootã¦ã¼ã¶ã«ããèªããªãããã«600ã«ãã¦ããã # cat > /root/.my.cnf [client] user = root password = tiger [mysqladmin] user = root password = tiger # chown root:root /root/.my.cnf # chmod 600 /root/.my.cnf ã¨ãããã¾ã§ã¯ããã®ã ãããã¹ãã¨ãã¦ã $ sudo mysqladmin ping mysqladmin: co
mysql> status; -------------- mysql Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i386) using readline 4.3 Connection id: 36 Current database: staff2006 Current user: maiha@localhost SSL: Not in use Current pager: lv Using outfile: '' Using delimiter: ; Server version: 4.1.20 Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client char
ã©ã³ãã³ã°
ã©ã³ãã³ã°
ã¡ã³ããã³ã¹
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}