Release 5.19.0 · prisma/prismaYou signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
Log Explorer: monitor security events without third-party storage
Log Explorer: monitor security events without third-party storage2024-03-08 This post is also available in Français, Español, 简体ä¸æ–‡, ç¹é«”ä¸æ–‡, 日本語, í•œêµì–´ and Deutsch. Today, we are excited to announce beta availability of Log Explorer, which allows you to investigate your HTTP and Security Event logs directly from the Cloudflare Dashboard. Log Explorer is an extension of Security Analytics, giving you th
Zendeskã€DynamoDBã‹ã‚‰MySQLã¨S3ã¸ç§»è¡Œã—ã€ã‚³ã‚¹ãƒˆã‚’80％以上削減
Spring Bootã«ã‚ˆã‚‹APIãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰æ§‹ç¯‰å®Ÿè·µã‚¬ã‚¤ãƒ‰ 第2版 何åƒäººã‚‚ã®é–‹ç™ºè€…ãŒã€InfoQã®ãƒŸãƒ‹ãƒ–ック「Practical Guide to Building an API Back End with Spring Bootã€ã‹ã‚‰ã€Spring Bootを使ã£ãŸREST API構築ã®åŸºç¤Žã‚’å¦ã‚“ã 。ã“ã®æœ¬ã§ã¯ã€å‡ºç‰ˆæ™‚ã«æ–°ã—ãリリースã•ã‚ŒãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã‚‹ Spring Boot 2 を使用ã—ã¦ã„る。ã—ã‹ã—ã€Spring Boot3ãŒæœ€è¿‘リリースã•ã‚Œã€é‡è¦ãªå¤‰...
オンライン DDL を期待ã—㦠ALTER 文を実行ã—ãŸã‚‰éšœå®³ã«ãªã‚Šã‹ã‘ãŸè©± - カミナシ エンジニアブãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€‚ソフトウェアエンジニアã®å‚井 (@manabusakai) ã§ã™ã€‚ カミナシã§ã¯ãƒžãƒ«ãƒãƒ—ãƒãƒ€ã‚¯ãƒˆåŒ–ã«å‘ã‘ã¦ã€èªè¨¼ãƒ»èªå¯ã®åˆ‡ã‚Šå‡ºã—を進ã‚ã¦ã„ã¾ã™ã€‚ãã®å¯¾å¿œã‚’進ã‚ã‚‹ä¸ã§ã€æ—¢å˜ãƒ†ãƒ¼ãƒ–ルã¸ã®ã‚«ãƒ©ãƒ è¿½åŠ ãŒå¿…è¦ã«ãªã‚Šã¾ã—ãŸã€‚ 先日ã€ãã®ãƒªãƒªãƒ¼ã‚¹ã®ãŸã‚ã«æœ¬ç•ªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã® ALTER 文を実行ã—ãŸã¨ã“ã‚ã€ã‚¯ã‚¨ãƒªãŒè©°ã¾ã£ã¦å±ã†ã障害ã«ãªã‚‹ã¨ã“ã‚ã§ã—ãŸï¼ˆå¹¸ã„ã™ãã«ã‚ャンセルã—ã¦äº‹ãªãã‚’å¾—ã¾ã—ãŸï¼‰ã€‚ åŽŸå› ã‚’èª¿ã¹ãŸã¨ã“ã‚ã€ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ DDL ã¯è¤‡æ•°ã®æ¡ä»¶ãŒé–¢ä¿‚ã™ã‚‹ã“ã¨ãŒã‚ã‹ã‚Šã¾ã—ãŸã€‚オンライン DDL ã«å¯¾ã™ã‚‹çŸ¥è˜ä¸è¶³ã¨äº‹å‰æ¤œè¨¼ã®ç”˜ã•ã‚†ãˆã®ãƒŸã‚¹ã§ã—ãŸãŒã€çµæžœçš„ã«ã¯è‰¯ã„å¦ã³ãŒå¾—られã¾ã—ãŸã€‚ カミナシã®ãƒãƒªãƒ¥ãƒ¼ã®ã²ã¨ã¤ã§ã‚る「全開オープンã€ã®æ°—æŒã¡ã§ã€äº‹ã®é¡›æœ«ã‚„ãã“ã‹ã‚‰å¾—ãŸå¦ã³ã‚’公開ã—ã¾ã™ã€‚ ãªãŠã€ä»Šå›žã®è©±ã¯ MySQL 5.7 互æ›ã® Amazon Aurora MySQL 2 ã§ç¢º
MySQL UUIDs - Bad For Performance
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
å„SQLサーãƒã§OSコマンドを実行ã™ã‚‹æ–¹æ³•
sql-execute-os-command.md Defending new vectors: Threat actors attempt SQL Server to cloud lateral movement | Microsoft Security Blog SQLサーãƒã‹ã‚‰åˆ¥ã®ã¨ã“ã‚ã«ä¾µå…¥ã™ã‚‹ãƒ‘ターンã§ã€SQLサーãƒä¸Šã§OSã®ã‚³ãƒžãƒ³ãƒ‰ã‚’利用ã—ã¦ã‚‹ã‚±ãƒ¼ã‚¹ãŒå¢—ãˆã¦ã„る。 å„SQLサーãƒã§OSコマンドを実行ã™ã‚‹æ–¹æ³•ã‚’知りãŸã„。 Type How To Status SQL Server xp_cmdshell Disable by Default MySQL system (\!) Enable in Terminal PostgreSQL COPY Require pg_execute_server_program role Related Exploiting PostgreSQL
LINE LIVE クãƒãƒ¼ã‚¸ãƒ³ã‚°é€£è¼‰ Vol.2 - DBã®Replication Delayã¨ã®å¥®é—˜
LINEæ ªå¼ä¼šç¤¾ã¯ã€2023å¹´10月1æ—¥ã«LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã«ãªã‚Šã¾ã—ãŸã€‚LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã®æ–°ã—ã„ブãƒã‚°ã¯ã“ã¡ã‚‰ã§ã™ã€‚ LINEヤフー Tech Blog ã“ã‚“ã«ã¡ã¯ã€é–‹ç™º5センター㮠Zhu ã§ã™ã€‚ ç¾åœ¨ã¯Â LINE NEWS 㮠SRE ãƒãƒ¼ãƒ ã«æ‰€å±žã—ã¦ã„ã¾ã™ã€‚ ã“ã®è¨˜äº‹ã¯ã€2023å¹´3月末ã«ã‚µãƒ¼ãƒ“スæ供を終了ã—ãŸãƒ©ã‚¤ãƒ–é…信サービス「LINE LIVEã€ã«ãŠã„ã¦ã€ä»Šã¾ã§è¡Œã£ã¦ããŸæ–½ç–ã®ç´¹ä»‹ã‚„大è¦æ¨¡ã‚µãƒ¼ãƒ“スãªã‚‰ã§ã¯ã®ã‚¯ãƒãƒ¼ã‚¸ãƒ³ã‚°ã«é–¢ã‚る話を連載ã™ã‚‹ã‚·ãƒªãƒ¼ã‚ºã®2本目ã®è¨˜äº‹ã§ã™ã€‚ 今回ã®è¨˜äº‹ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸Šã§Â Replication Delay ã«ã‚ˆã£ã¦èµ·ãã¦ã„ãŸå•é¡Œã¨è§£æ±ºã¾ã§ã®çµŒç·¯ã‚„DB構æˆã«ã¤ã„ã¦ã€å›³ã‚’交ãˆã¦ç´¹ä»‹ã—ã¾ã™ã€‚ 背景 LINE LIVE ã§ã¯ã€å¤§è¦æ¨¡ã®ã‚¢ã‚¯ã‚»ã‚¹ã«è€ãˆã‚‹ãŸã‚ã« DB(MySQL) ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã¯ Read/Write ã§åˆ†é›¢ã—ã¦ã„ã¾ã™ã€‚ã¤ã¾ã‚Šæ›¸ãè¾¼ã¿
Migrate from RDS MySQL to Aurora MySQL
In this tutorial, we will look at how to migrate from Amazon RDS MySQL to Amazon Aurora MySQL with minimal downtime. As with any database migration, there are several options. For migrating data from a MySQL DB Instance to an Amazon Aurora MySQL DB Cluster, we recommend to use a special type of node called an Aurora Read Replica for the source MySQL DB instance. Amazon RDS uses the MySQL DB engine
大è¦æ¨¡ã‚µãƒ¼ãƒ“スã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ MySQLã‹ã‚‰Aurora MySQLã¸ã®ç§»è¡Œ 〜リードレプリカ, DNSを利用ã—ãŸæœ€å°ãƒ€ã‚¦ãƒ³ã‚¿ã‚¤ãƒ 移行方法〜 - メドピア開発者ブãƒã‚°
ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®å¾³å¯Œ(@yannKazu1)ã§ã™ã€‚先日ã€ãƒ¡ãƒ‰ãƒ”ã‚¢ã®ãƒ¡ã‚¤ãƒ³ã‚µãƒ¼ãƒ“スã§ã‚ã‚‹medpeer.jpã§ä½¿ã‚ã‚Œã¦ã„るデータベースエンジンをã€MySQLã‹ã‚‰Aurora MySQLã¸ã¨ç§»è¡Œã—ã¾ã—ãŸã€‚今回ã¯ãã®ç§»è¡Œã®ãƒ—ãƒã‚»ã‚¹ã«ã¤ã„ã¦è©³ã—ããŠè©±ã—ã—ã¾ã™ã€‚ 移行ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç°¡å˜ãªã‚¤ãƒ³ãƒ•ãƒ©æ§‹æˆ ç§»è¡Œæ–¹é‡ ä»Šå›žç§»è¡Œã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯è¤‡æ•°ã®ã‚¢ãƒ—リケーションã‹ã‚‰å‚ç…§ã•ã‚Œã¦ãŠã‚Šã€ãƒ€ã‚¦ãƒ³ã‚¿ã‚¤ãƒ ã«ã‚ˆã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼å½±éŸ¿ãŒå¤§ãã„ãŸã‚ã€ç§»è¡Œæ–¹é‡ã®æ¤œè¨Žã®æ®µéšŽã§é‡è¦–ã—ãŸã®ã¯ã€ãƒ€ã‚¦ãƒ³ã‚¿ã‚¤ãƒ ã®æœ€å°åŒ–ã§ã—ãŸã€‚ã“れをé”æˆã™ã‚‹ãŸã‚ã«ã€DNSã®CNAMEレコードã¨ã€Auroraã®ãƒªãƒ¼ãƒ‰ãƒ¬ãƒ—リカを活用ã—ã€ç§»è¡Œã•ã›ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ DNSã®CNAMEレコードã®ä½¿ç”¨ データベースエンドãƒã‚¤ãƒ³ãƒˆã‚’アプリケーションã«ç›´æŽ¥è¨˜è¿°ã™ã‚‹ä»£ã‚ã‚Šã«ã€DNSã®CNAMEレコードを利用ã—ã¦é–“接的ã«å‚ç…§ã™ã‚‹ã‚ˆã†ã«ã—ã¾ã—ãŸã€‚ã“ã‚Œã«ã‚ˆã‚Šã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼
MySQL for Developers — PlanetScale
Welcome! MySQL for Developers is PlanetScale’s free MySQL course that teaches you schema basics, indexing, querying, and beyond. This intermediate MySQL course is appropriate for both developers just getting started with MySQL and those who need a refresher. The course has been created with usability and application in mind. Everything you learn in this course can be taken and applied to your own
Scaling Datastores at Slack with Vitess - Slack Engineering
Rafael Chacón Staff Software Engineer, Infrastructure From the very beginning of Slack, MySQL was used as the storage engine for all our data. Slack operated MySQL servers in an active-active configuration. This is the story of how we changed our data storage architecture from the active-active clusters over to Vitess — a horizontal scaling system for MySQL. Vitess is the present and future of Dat
Node.jsã®MySQLパッケージã«ãŠã‘るエスケープ処ç†ã ã‘ã§ã¯é˜²ã’ãªã„ã€Œéš ã‚ŒãŸã€SQLインジェクション - Flatt Security Blog
※本記事ã¯ç†è€…styprãŒè‹±èªžã§åŸ·ç†ã—ãŸè¨˜äº‹ã‚’æ ªå¼ä¼šç¤¾Flatt Security社内ã§æ—¥æœ¬èªžã«ç¿»è¨³ã—ãŸã‚‚ã®ã«ãªã‚Šã¾ã™ã€‚ TL;DR Node.jsã®ã‚¨ã‚³ã‚·ã‚¹ãƒ†ãƒ ã§æœ€ã‚‚人気ã®ã‚ã‚‹MySQLパッケージã®ä¸€ã¤ã§ã‚ã‚‹ mysqljs/mysql (https://github.com/mysqljs/mysql)ã«ãŠã„ã¦ã€ã‚¯ã‚¨ãƒªã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—関数ã®äºˆæœŸã›ã¬å‹•ä½œãŒSQLインジェクションを引ãèµ·ã“ã™å¯èƒ½æ€§ãŒã‚ã‚‹ã“ã¨ãŒåˆ¤æ˜Žã—ã¾ã—ãŸã€‚ 通常ã€ã‚¯ã‚¨ãƒªã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—関数やプレースホルダã¯SQLインジェクションを防ãã“ã¨ãŒçŸ¥ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ã—ã‹ã—ã€mysqljs/mysql ã¯ã€å€¤ã®ç¨®é¡žã«ã‚ˆã£ã¦ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—方法ãŒç•°ãªã‚‹ã“ã¨ãŒçŸ¥ã‚‰ã‚Œã¦ãŠã‚Šã€æ”»æ’ƒè€…ãŒç•°ãªã‚‹å€¤ã®ç¨®é¡žã§ãƒ‘ラメータを渡ã™ã¨ã€æœ€çµ‚çš„ã«äºˆæœŸã›ã¬å‹•ä½œã‚’引ãèµ·ã“ã™å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚予期ã›ã¬å‹•ä½œã¨ã¯ã€ãƒã‚°ã®ã‚ˆã†ãªå‹•ä½œã‚„SQLインジェクションãªã©ã§ã™ã€‚ ã»ã¼ã™ã¹ã¦ã®ã‚ªãƒ³ãƒ©
GitHub - kysely-org/kysely: A type-safe typescript SQL query builder
Kysely (pronounce “Key-Seh-Leeâ€) is a type-safe and autocompletion-friendly TypeScript SQL query builder. Inspired by Knex.js. Mainly developed for Node.js but also runs on all other JavaScript environments like Deno, Bun, Cloudflare Workers and web browsers. Kysely makes sure you only refer to tables and columns that are visible to the part of the query you're writing. The result type only has th
GitHub - pingcap/tidb: TiDB - the open-source, cloud-native, distributed SQL database designed for modern applications.
Distributed Transactions: TiDB uses a two-phase commit protocol to ensure ACID compliance, providing strong consistency. Transactions span multiple nodes, and TiDB's distributed nature ensures data correctness even in the presence of network partitions or node failures. Horizontal and Vertical Scalability: TiDB can be scaled horizontally by adding more nodes or vertically by increasing resources o
Vercelã‹ã‚‰MySQL/PostgreSQLã«æŽ¥ç¶šã—ãŸã„å ´åˆã«ã©ã†ã„ã†ã‚¢ãƒ¼ã‚テクãƒãƒ£ã«ã™ã‚‹ã®ãŒæœ€é©ã‹
Issue Vercelã¸ã®ãƒªã‚¯ã‚¨ã‚¹ãƒˆã‹ã‚‰Serverless Functions ãŒå®Ÿè¡Œã•ã‚Œã‚‹ã¨æ–°è¦ã«DBã«æŽ¥ç¶šã—ã€çµ‚了時ã«ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã‚’切æ–ã™ã‚‹ 一般的ãªã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ールを使ã£ãŸã‚¢ãƒ¼ã‚テクãƒãƒ£ã‚ˆã‚ŠDB接続コストã®å½±éŸ¿ã‚’å—ã‘ã‚‹ Amazon RDS Proxyã‚„Cloud SQL Proxyã®ã‚ˆã†ãªãƒ—ラットフォームãŒæ示ã™ã‚‹è§£æ±ºç–ãŒã¾ã ãªã„
MySQLã§ãƒ—ライマリã‚ーをUUIDã«ã™ã‚‹å‰ã«çŸ¥ã£ã¦ãŠã„ã¦æ¬²ã—ã„ã“㨠| Raccoon Tech Blog [æ ªå¼ä¼šç¤¾ãƒ©ã‚¯ãƒ¼ãƒ³ãƒ›ãƒ¼ãƒ«ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ 技術戦略部ブãƒã‚°]
æ ªå¼ä¼šç¤¾ãƒ©ã‚¯ãƒ¼ãƒ³ãƒ›ãƒ¼ãƒ«ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢/デザイナーã‹ã‚‰æŠ€è¡“æƒ…å ±ã‚’ã¯ã˜ã‚ã€ä¸–ã®ä¸ã®ãŸã‚ã«ãªã‚‹ã“ã¨ã‚„社内ã®ã“ã¨ãªã©ã‚’発信ã—ã¦ã¾ã™ã€‚ bashパフォーマンスMySQLInnoDBDBè¨è¨ˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ã“ã‚“ã«ã¡ã¯ã€ç¾½å±±ã§ã™ã€‚ 今回㯠MySQL ã®ãƒ—ライマリã‚ー㫠UUID を採用ã™ã‚‹å ´åˆã«èµ·ãるパフォーマンスã®å•é¡Œã‚’仕組ã¿ã‹ã‚‰è§£èª¬ã—ã¾ã™ã€‚ MySQL(InnoDB) & UUID ã®ãƒ‘フォーマンスã«ã¤ã„ã¦ã¯å„所ã§ã•ã‚“ã–ã‚“è°è«–・検証ã•ã‚Œã¦ã„ã¾ã™ãŒã€è«–ç†çš„ã«è§£èª¬ã—ãŸè¨˜äº‹ãŒå°‘ãªã‹ã£ãŸã‚Šä¸€éƒ¨ã«ã¯èª¤è§£ã‚’æ‹›ãよã†ãªã‚‚ã®ã‚‚ã‚ã‚‹ãŸã‚ã€ã—ã£ã‹ã‚Šã¨ç†ç”±ã‹ã‚‰ç†è§£ã™ã‚‹ãŸã‚ã®æƒ…å ±ã¨ã—ã¦å½¹ç«‹ã¤ã“ã¨ãŒã§ãã‚Œã°ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ UUID ã¨æ¯”較ã•ã‚Œã‚‹å¤ã良ãæ˜‡é †/é™é †ã®ãƒ—ライマリã‚ーã¯ã¨ã„ã†ã¨ã€ MySQL ã® InnoDB ã«ãŠã„ã¦è‰¯ã„パフォーマンスを出ã™ãŸã‚ã«ç¸ã®ä¸‹ã®åŠ›æŒã¡ã®ã‚ˆã†ãªåƒãã‚’ã—ã¦ãã‚Œã¦ã„るケースãŒå®Ÿã¯å°‘ãª
![MySQLã§ãƒ—ライマリã‚ーをUUIDã«ã™ã‚‹å‰ã«çŸ¥ã£ã¦ãŠã„ã¦æ¬²ã—ã„ã“㨠| Raccoon Tech Blog [æ ªå¼ä¼šç¤¾ãƒ©ã‚¯ãƒ¼ãƒ³ãƒ›ãƒ¼ãƒ«ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ 技術戦略部ブãƒã‚°]](https://cdn-ak-scissors.b.st-hatena.com/image/square/5e9d48c3c6f38c2d5f71897d98efcb251289d1f9/height=288;version=1;width=512/https%3A%2F%2Ftechblog.raccoon.ne.jp%2Fwp-content%2Fuploads%2F2021%2F07%2Fboard-755792_800.jpg)
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
MySQL Introduces Javascript Support in Preview
GitHub - amacneil/dbmate: 🚀 A lightweight, framework-agnostic database migration tool.
Atlas | Manage your database schema as code
The ultimate MySQL database platform
{{#tags}}- {{label}}
{{/tags}}