RDS(MySQL)ã§JSTを使ㆠãŸã£ãŸï¼‘ã¤ã®å†´ãˆãŸã‚„ã‚Šæ–¹ - Qiita
$ date 2014å¹´ 5月30æ—¥ 金曜日 20時56分02秒 JST $ echo 'select now()' | mysql -h mysql.foobar.ap-northeast-1.rds.amazonaws.com -u admin -p Enter password: now() 2014-05-30 11:56:20 アンãƒãƒ‘ターン init_connect ã« "SET SESSION time_zone = 'Asia/Tokyo';"ã¨æ›¸ã →フェイルオーãƒãƒ¼æ™‚ã«ãƒãƒžã‚‹ (rdsadminユーザãªã©ã§ã¯TimezoneãŒUTCã§ãªã„ã¨ãƒ€ãƒ¡) ストアドプãƒã‚·ãƒ¼ã‚¸ãƒ£ã‚’入れ㦠init_connect ã‹ã‚‰å‘¼ã¶ 例)
AWSã§ãƒªãƒ¼ã‚¸ãƒ§ãƒ³é–“ã®è‡ªå‹•DR構æˆã‚’構築ã—ã¦ã¿ãŸ #vgadvent2013 - s_tajima:TechBlog
ã“ã‚“ã«ã¡ã¯ã€ VOYAGE GROUP エンジニアブãƒã‚° Advent Calendar 2013 ã®2日目担当㮠@s_tajima ã§ã™ã€‚ 僕ã¯ä»Šã‚¤ãƒ³ãƒ•ãƒ©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦åƒã„ã¦ã„ã‚‹ã®ã§ã™ãŒã€ 障害ãŒç™ºç”Ÿã™ã‚‹ã¨æºå¸¯ã«ã‚¢ãƒ©ãƒ¼ãƒˆãƒ¡ãƒ¼ãƒ«ã‚„電話ãŒã¨ã‚“ã§ãã¦å¯¾å¿œã‚’迫られã¾ã™ã€‚ ãã—ã¦éšœå®³ã¨ã„ã†ã®ã¯ãŸã„ã¦ã„楽ã—ã„イベントãŒè¡Œã‚ã‚Œã¦ã„ã‚‹ã¨ãã«ç™ºç”Ÿã™ã‚‹ã‚‚ã®ã§ã™ã€‚ ãã†ã„ã†ã‚‚ã®ã¨å‰²ã‚Šåˆ‡ã£ã¦ã›ã£ã›ã¨å¯¾å¿œã‚’ã™ã‚‹ã®ã‚‚よã„ã®ã§ã™ãŒã€ 僕ã¯å¹´æœ«ã®æ¥½ã—ã„イベントを邪é”ã•ã‚ŒãŸãã‚ã‚Šã¾ã›ã‚“。 ãã‚Œã¯ã‚‚ã¡ã‚ã‚“AWSã®æ±äº¬ãƒªãƒ¼ã‚¸ãƒ§ãƒ³ã®ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ãŒã™ã¹ã¦åŒæ™‚ã«ç«äº‹ã§ãªããªã£ã¦ã—ã¾ã†ã‚ˆã†ãªéžå¸¸äº‹æ…‹ã§ã‚‚ã§ã™ã€‚ ã¨ã„ã†ã“ã¨ã§ä»Šæ—¥ã¯AWSã®ãƒªãƒ¼ã‚¸ãƒ§ãƒ³é–“自動DR構æˆã‚’ã¤ãã£ã¦ã¿ãŸè©±ã‚’ã—よã†ã¨æ€ã„ã¾ã™ã€‚ 今回ã®DR構æˆã‚’構築ã™ã‚‹ä¸Šã§ã€ã‚«ã‚®ã¨ãªã‚‹AWSã®æ©Ÿèƒ½ã¯ä»¥ä¸‹ã®3ã¤ã§ã™ã€‚ Route53ã®ELBã«å¯¾ã™ã‚‹DNS FailOver ht
MySQL database log files - Amazon Relational Database Service
You can monitor the MySQL logs directly through the Amazon RDS console, Amazon RDS API, AWS CLI, or AWS SDKs. You can also access MySQL logs by directing the logs to a database table in the main database and querying that table. You can use the mysqlbinlog utility to download a binary log. For more information about viewing, downloading, and watching file-based database logs, see Monitoring Amazon
AWS News Blog
Amazon Titan Text V2 now available in Amazon Bedrock, optimized for improving RAG The Amazon Titan family of models, available exclusively in Amazon Bedrock, is built on top of 25 years of Amazon expertise in artificial intelligence (AI) and machine learning (ML) advancements. Amazon Titan foundation models (FMs) offer a comprehensive suite of pre-trained image, multimodal, and text models accessi
Nginx + WordPress RDS篇 - サーãƒãƒ¼ãƒ¯ãƒ¼ã‚¯ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€‚CSãƒãƒ¼ãƒ ã®å‚本ã§ã™ã€‚ 今回もã€å‰å›žã®ã€ŒNginx + WordPress S3篇ã€ã«å¼•ã続ãã€ã€ŒNginx + WordPress ãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚µãƒ¼ç¯‡ã€ã®æ§‹æˆã§ã®é‹ç”¨ä¸Šã®å•é¡Œç‚¹ã‚’ã€AWSã®ã‚µãƒ¼ãƒ“スを使ã£ã¦è§£æ¶ˆã—ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ ç”»åƒã®ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰å…ˆã®å•é¡Œã¯è§£æ±ºã—ã¾ã—ãŸãŒã€MySQLã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒãƒ¼ãŒã¾ã SPOF（å˜ä¸€éšœå®³ç‚¹ï¼‰ã¨ãªã£ã¦ã„ã¾ã™ã€‚EC2ã§ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’ã‚‚ã†1å°èµ·å‹•ã—ã¦ãƒ¬ãƒ—リケーション環境を構築ã™ã‚‹ã“ã¨ã‚‚å¯èƒ½ã§ã™ãŒã€ä»Šå›žã¯AWSã®ã‚µãƒ¼ãƒ“ス「Amazon RDSã€ã‚’使ã£ã¦ã“ã®å•é¡Œã‚’ç°¡å˜ã«è§£æ±ºã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ 目次 Amazon RDSã¨ã¯ï¼ŸMulti-AZã¨ã¯ï¼ŸRDSインスタンスã®ä½œæˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã€ãƒªã‚¹ãƒˆã‚¢WordPressã®è¨å®šå¤‰æ›´ã¾ã¨ã‚ 1. Amazon RDSã¨ã¯ï¼Ÿ 今回ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦åˆ©ç”¨ã™ã‚‹AWSã®ã‚µãƒ¼ãƒ“スã¯ã€ŒAmazon R
Amazon RDS ã§è‚¥å¤§åŒ–ã—ãŸslow_logテーブルをクリアã™ã‚‹æ–¹æ³•
以å‰AmazonRDSã§slow queryを出力ã™ã‚‹ã‚ˆã†ã«ã™ã‚‹æ–¹æ³•ã«ã¦RDSã§slow_logを出力ã™ã‚‹ã‚ˆã†ã«è¨å®šã™ã‚‹ã¨ã€mysqlデータベースã®slow_logテーブルã«ãƒã‚°ãŒä¿å˜ã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚‹ã®ã§ã™ãŒã€ã“ã®ãƒ†ãƒ¼ãƒ–ルã«ä¿å˜ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã¯ã€RDSã§ä½œæˆã§ãるユーザーã®æ¨©é™ã§ã¯å‰Šé™¤ã™ã‚‹ã“ã¨ãŒã§ãã¾ã›ã‚“。 mysql> delete from slow_log; ERROR 1556 (HY000): You can't use locks with log tables. mysql> truncate table slow_log; ERROR 1044 (42000): Access denied for user 'xxxx'@'%' to database 'mysql' ã“ã®ã“ã¨ã¯general_logã«ã‚‚言ãˆã‚‹ã®ã§ã™ãŒã€ ã“ã‚Œã«å¯¾ã—ã¦ã€Amazonã‹ã‚‰ä»¥ä¸‹ã®ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸
1
ランã‚ング
ランã‚ング
ランã‚ング
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
conma.me
{{#tags}}- {{label}}
{{/tags}}