[B! mariadb] takaya030ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

takaya030 id:takaya030

mariadbã«é–¢ã™ã‚‹takaya030ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (18)

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

Amazon Lightsailã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹å†…ã®MySQLã«å¤–éƒ¨ã‹ã‚‰æŽ¥ç¶šã™ã‚‹ - Qiita
AWSã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚°ãƒ«ãƒ¼ãƒ—ã«é ¼ã‚Šåˆ‡ã‚Šã®äººç”Ÿãªã®ã§ã€è‡ªåˆ†ã§è¨å®šã™ã‚‹ã¨ãªã‚‹ã¨æ€–ã‹ã£ãŸã§ã™(æ„Ÿæƒ³) å‰æ Lightsailã§bitnamiç¤¾ã®blueprintã‚’ä½¿ã£ã¦æ§‹ç¯‰ã—ãŸãƒ¯ãƒ¼ãƒ‰ãƒ—ãƒ¬ã‚¹ç’°å¢ƒã«å«ã¾ã‚Œã¦ã„ã‚‹MySQLã‚µãƒ¼ãƒã«å¯¾ã—ã¦ã€ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒ„ã‹ã‚‰ã‚¢ã‚¯ã‚»ã‚¹ã—ãŸã„ã€‚ ä¾‹ãˆã°DataStudioã¨ã‹Redashã¨ã‹ã§ã‚¯ã‚¨ã‚ŠãŸã„æ™‚ãŒãã£ã¨ã‚ã‚‹ã€‚ ã‚‚ã—ãã¯å€‹äººã®ãƒžã‚·ãƒ³ã‹ã‚‰æŽ¥ç¶šã—ãŸã„ãªã©ã€‚ ã¡ãªã¿ã«ä»Šå›žã¯ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã¯æ§‹ç¯‰æ¸ˆã¿ã¨ã—ã¾ã™ã€‚ è§£æ±ºã™ã¹ãå•é¡Œã¨å¯¾å‡¦æ³• bitnamiã‚¤ãƒ¡ãƒ¼ã‚¸ã§æ§‹ç¯‰ã•ã‚ŒãŸãƒ¯ãƒ¼ãƒ‰ãƒ—ãƒ¬ã‚¹ç’°å¢ƒã®MySQLã¯ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯localhostã‹ã‚‰ã®ã‚¢ã‚¯ã‚»ã‚¹ã—ã‹æƒ³å®šã—ã¦ã„ãªã„ ãƒãƒ¼ã‚«ãƒ«ãƒ›ã‚¹ãƒˆä»¥å¤–ã‹ã‚‰æŽ¥ç¶šã™ã‚‹ãŸã‚ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚’è¿½åŠ ã™ã‚‹ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆçŠ¶æ…‹ã§ã¯ã€Lightsailã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã¯3306ãƒãƒ¼ãƒˆã¸ã®é€šä¿¡ã‚’è¨±å¯ã—ã¦ã„ãªã„ Lightsailã®GUIã§ãƒ•ã‚¡ã‚¤ã‚¢ã‚¦ã‚©ãƒ¼ãƒ«è¨å®šã‚’å¤‰ãˆã‚‹ Lig
takaya030 2023/12/08
bind-address ã‚’ã‚³ãƒ¡ãƒ³ãƒˆã‚¢ã‚¦ãƒˆã™ã‚‹

lightsail

mysql

mariadb
ãƒªãƒ³ã‚¯
Ubuntuã«æœ€æ–°ã®MariaDBã‚’å…¥ã‚Œã‚‹
Ubuntuã«æœ€æ–°ã®MariaDBã‚’å…¥ã‚Œã‚‹ã¨ãã®å‚™å¿˜éŒ²çš„ãªã‚‚ã®ã§ã™ã€‚ aptã§å…¥ã‚Œã¦ã—ã¾ã†ã¨å°‘ã—å¤ã„ã®ãŒå…¥ã£ã¦ã—ã¾ã†ã®ã§ãã‚ŒãŒå«Œã ã£ã¦ã„ã†äººå‘ã‘ã®è¨˜äº‹ã§ã™ã€‚ ãƒ—ãƒã‚ã‚·ç’°å¢ƒä¸‹ã®äººå‘ã‘ ç’°å¢ƒ OS: Ubuntu Server 20.04.2 LTS MariaDBã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãƒªãƒã‚¸ãƒˆãƒªã®è¿½åŠ ã¨ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« å‚è€ƒ: MariaDB Package Repository Setup and Usage - MariaDB Knowledge Base # scriptã‚’å›žã™ãŸã‚ã«å¿…è¦ã‚‰ã—ã„ $ sudo apt install apt-transport-https $ curl -LsS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash [info] Repository file successfully
takaya030 2023/08/22
mariadb

ubuntu
ãƒªãƒ³ã‚¯
æ¤œç´¢ãŒçˆ†é€Ÿã«ãªã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã‚’å…¬é–‹ã—ã¾ã™
ã“ã‚“ã«ã¡ã¯ã€‚ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®è°·äº•ã§ã™ã€‚ ãƒ•ã‚©ãƒ«ã‚·ã‚¢ã§ã¯ã€Spookã¨å‘¼ã‚“ã§ã„ã‚‹æŠ€è¡“åŸºç›¤ã‚’ç”¨ã„ã¦ã€ä¸»ã«æ—…è¡Œæ¥ç•Œã‚„MROæ¥ç•Œã«å¯¾ã—ã¦ã€è†¨å¤§ã§è¤‡é›‘ãªãƒ‡ãƒ¼ã‚¿ã‚’é«˜é€Ÿæ¤œç´¢ã§ãã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æä¾›ã—ã¦ã„ã¾ã™ã€‚ ä»Šå›žã¯ãã®é«˜é€Ÿæ¤œç´¢ã®ãƒŽã‚¦ãƒã‚¦ã®ã†ã¡ã€ç‰¹ã«DBã®æ‰±ã„ã«é–¢é€£ã™ã‚‹éƒ¨åˆ†ã«ã¤ã„ã¦ã€ãƒ™ãƒ†ãƒ©ãƒ³ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¸ã®ã‚¤ãƒ³ã‚¿ãƒ“ãƒ¥ãƒ¼ã‚’é€šã—ã¦ãã®ã‚¨ãƒƒã‚»ãƒ³ã‚¹ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ ä¸€èˆ¬çš„ãªãƒ™ã‚¹ãƒˆãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ã ã‘ã§ãªãã€æ¤œç´¢æ€§èƒ½ã‚’é«˜ã‚ã‚‹ã“ã¨ã«ç‰¹åŒ–ã—ãŸã‚ãšã‚‰ã—ã„ã‚¢ãƒ—ãƒãƒ¼ãƒã‚‚ã‚ã‚‹ã®ã§ã€ãœã²ã”è¦§ãã ã•ã„ã€‚ ãƒ•ã‚©ãƒ«ã‚·ã‚¢ã«ãŠã‘ã‚‹æ¤œç´¢DBã«ã¤ã„ã¦ ã¾ãšå‰æã¨ã—ã¦ãƒ•ã‚©ãƒ«ã‚·ã‚¢ã§æ‰±ã†ãƒ‡ãƒ¼ã‚¿ã«ã¤ã„ã¦è»½ãèª¬æ˜Žã—ã¾ã™ã€‚ æ‰±ã†ãƒ‡ãƒ¼ã‚¿ã®è¤‡é›‘ã• ãŸã¨ãˆã°ã€æ—…è¡Œä¼šç¤¾å‘ã‘ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã‚ã‚Œã°ã€å®¿æ³Šç´ æã®æƒ…å ±ã¨ã—ã¦ã¯ ãƒ›ãƒ†ãƒ«ã®æƒ…å ±ã€Œã€‡ã€‡ãƒ›ãƒ†ãƒ«ã€ï¼ˆ~ç´„2ä¸‡ä»¶ï¼‰ ãƒ—ãƒ©ãƒ³ã®æƒ…å ±ã€Œæœé£Ÿä»˜ããƒ»ãƒãƒ³ã‚°ã‚¹ãƒ†ã‚¤â–³â–³ãƒ—ãƒ©ãƒ³ã€ï¼ˆ0~1500ä»¶/æ–½è¨ï¼‰ å®¢å®¤ã®æƒ…å ±ï¼ˆ~100ä»¶/
takaya030 2023/04/29
mysql

mariadb
ãƒªãƒ³ã‚¯
AWS open source newsletter, #141
Ricardo Sueiras for AWS Posted on Jan 16, 2023 â€¢ Updated on Jan 23, 2023 â€¢ Originally published at blog.beachgeek.co.uk January 16th, 2023 - Instalment #141 Welcome Welcome to the AWS open source newsletter of 2023, edition #141. This week we have more new projects for you to practice your four freedoms, including "distributed-compute-on-aws-with-cross-regional-dask", a solution to simplify distri
takaya030 2023/04/13
apache

aws

pulumi

mariadb
ãƒªãƒ³ã‚¯
Improve query performance using Optimized Reads on Amazon RDS for MySQL and Amazon RDS for MariaDB | Amazon Web Services
AWS Database Blog Improve query performance using Optimized Reads on Amazon RDS for MySQL and Amazon RDS for MariaDB Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale MySQL and MariaDB deployments in the cloud. Developers are often required to run complex queries in MySQL and MariaDB environments to create a dashboard or run simple ad hoc reports. Furtherm
takaya030 2023/03/22
rds

mysql

mariadb
ãƒªãƒ³ã‚¯
MariaDB+GaleraClusterç”¨ã®LBã‚½ãƒ•ãƒˆã€ŽMaxscaleã€ã‚’ä½¿ã£ã¦ã¿ã‚‹ | ä¿ºçš„å‚™å¿˜éŒ² ã€œãªã‚“ã‹ã„ã‚ã„ã‚ã€œ
MariaDB+GaleraClusterã®å ´åˆã€å„ãƒŽãƒ¼ãƒ‰ã§æ›¸ãè¾¼ã¿ãƒ»èªè¾¼ã¿ãŒã•ã‚Œã‚‹ã®ã ã‘ã©ã€ãã†ãªã‚‹ã¨åŒã˜è¡Œã«åŒæ™‚ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§è¤‡æ•°ãƒŽãƒ¼ãƒ‰ã‹ã‚‰æ›¸ãè¾¼ã¿ã‚’ã—ã‚ˆã†ã¨ã—ã¦ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã«ãªã‚‹äº‹ãŒã‚ã‚‹ã€‚ ã“ã‚Œã‚’é˜²ããŸã‚ã€MariaDBã§ã¯å°‚ç”¨ã®ãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚µãƒ¼ç”¨ã«ã€ŽMaxscaleã€ã¨ã„ã†ã‚‚ã®ãŒç”¨æ„ã•ã‚Œã¦ã„ã‚‹ã€‚ å®Ÿéš›ã€ä¼šç¤¾ã§ã‚‚ä½¿ã£ã¦ã„ã‚‹ã‚½ãƒ•ãƒˆãªã®ã§ã€ä»Šå›žã¯ã“ã‚Œã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã€GaleraClusterã«æŽ¥ç¶šã—ã¦ã¿ã‚ˆã†ã€‚ 1.Maxscaleã®æ¦‚è¦ Maxscaleã®æ¦‚è¦ã«ã¤ã„ã¦ã ãŒã€ç´°ã‹ãèª¬æ˜Žã™ã‚‹ã¨ã™ã”ãå¤§å¤‰ãã†ãªã®ã§ã€ã¨ã‚Šã‚ãˆãšä»¥ä¸‹ã®ã‚ˆã†ãªã‚¤ãƒ¡ãƒ¼ã‚¸ã ã‘è¦šãˆã¦ãŠãã¨è‰¯ã„ã ã‚ã†ã€‚ è¦ã¯ã€DBã¸æŽ¥ç¶šã™ã‚‹å„ã‚µãƒ¼ãƒã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã‚¿ã‚¤ãƒ—ã®ãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚µãƒ¼ã§ã€ã„ã‚ã‚“ãªä½¿ã„æ–¹ã¯ã‚ã‚‹ã®ã ã‘ã©ã€åŸºæœ¬çš„ã«ã¯GaleraClusterã®çŠ¶æ…‹ã‚’èªã¿å–ã£ã¦1å°ã®ãƒŽãƒ¼ãƒ‰ã‚’æ›¸ãè¾¼ã¿ãƒŽãƒ¼ãƒ‰ã¨ã—ã¦é¸å®šã—ã¦æŽ¥ç¶šã™ã‚‹ã‚ˆã€ã¨ã„ã†ã‚‚ã®
takaya030 2022/01/31
kept

mariadb

mysql
ãƒªãƒ³ã‚¯
MariaDB 10.0.10 ã¨ Spider ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ä½¿ã£ã¦ã¿ã‚‹ - akishin999ã®æ—¥è¨˜
MySQL ã® Sharding ç”¨ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã§ã‚ã‚‹ Spider ã‚’è©¦ã—ã¦ã¿ã¾ã—ãŸã€‚ å…¬å¼ã®ãƒã‚¤ãƒŠãƒªã«åŒæ¢±ã•ã‚Œã¦ã„ã‚‹ MariaDB 10.0.10 ã‚’ä½¿ã£ã¦ã„ã¾ã™ã€‚ è©¦ã—ãŸç’°å¢ƒã¯ CentOS 6.5 x86_64 ã§ã™ã€‚ MariaDB ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ã¾ãšã¯ MariaDB ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ãŸã‚ã«ã€yum ãƒªãƒã‚¸ãƒˆãƒªå®šç¾©ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½œæˆã—ã¾ã™ã€‚ # vi /etc/yum.repos.d/mariadb.repo å†…å®¹ã¯ä»¥ä¸‹ã€‚ # MariaDB 10.0 CentOS repository list - created 2014-04-02 07:21 UTC # http://mariadb.org/mariadb/repositories/ [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.0/c
takaya030 2021/12/26
kept

mariadb

spider
ãƒªãƒ³ã‚¯
MariaDB, MySQLã®å†—é•·åŒ–ã€è² è·åˆ†æ•£ã®æ§‹æˆã‚’è€ƒãˆã‚‹
WordPressã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è¤‡æ•°ã‚µãƒ¼ãƒãƒ¼ã§å†—é•·åŒ–ã—ã¦ã€è² è·åˆ†æ•£ã—ãªãŒã‚‰ç®¡ç†ã—ã‚„ã™ãã€å°†æ¥çš„ã«ã‚‚æ‹¡å¼µã—ã‚„ã™ã„æ§‹æˆã‚’è€ƒãˆãŸã¨ãã®è¦šæ›¸ã€‚ èª¿æŸ»ã—ãŸé–¢é€£æŠ€è¡“
takaya030 2021/11/28
mariadb
ãƒªãƒ³ã‚¯
MariaDB Galera Cluster ã«ã‚ˆã‚‹ DB ã‚µãƒ¼ãƒã®å†—é•·åŒ– - dogmap.jp
ã•ãã‚‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆç ”ç©¶æ‰€ã•ã‚“ã®ã€ŒMariaDB Galera Clusterã‚’è©¦ã™ã€ã¨ã„ã†è¨˜äº‹ã‚’èªã‚“ã§å±…ã¦ã‚‚ç«‹ã£ã¦ã‚‚ã„ã‚‰ã‚Œãªããªã‚Šã€ã•ã£ãã AWS ã§æ§‹ç¯‰ã—ã¦ã¿ã¾ã—ãŸã€‚ ä¸Šè¨˜ã®è¨˜äº‹ã«ã‚ˆã‚Œã° ç°¡å˜ã«ã¾ã¨ã‚ã‚‹ã¨æ¬¡ã®ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ Galera ReplicationãŒè¤‡æ•°ã®RDBMã‚’ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã™ã‚‹wsrep APIã‚’æä¾›ã—ã€åŒæœŸã‚’ã¨ã‚Šã¾ã™ å®Œå…¨åŒæœŸåž‹ã§ã‚ã‚‹ãŸã‚ã€ã™ã¹ã¦ã®ãƒŽãƒ¼ãƒ‰ãŒã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã‹ã¤ãƒžã‚¹ã‚¿ãƒ¼ã¨ãªã‚Šã¾ã™ ã‚¯ãƒ©ã‚¹ã‚¿ãƒ¼ãƒŽãƒ¼ãƒ‰ã®ã©ã‚Œã«å¯¾ã—ã¦ã‚‚ãƒªãƒ¼ãƒ‰ï¼ãƒ©ã‚¤ãƒˆãŒå¯èƒ½ã§ã™ ãƒŽãƒ¼ãƒ‰ã®è¿½åŠ ï¼å‰Šé™¤ã¯è‡ªå‹•ã§è¡Œãˆã¾ã™ ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆæŽ¥ç¶šã¯é€šå¸¸ã®MySQLã¨ãªã‚“ã‚‰å¤‰ã‚ã‚Šãªãä½¿ãˆã¾ã™ via. MariaDB Galera Clusterã‚’è©¦ã™ (1) Â« ã•ãã‚‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆç ”ç©¶æ‰€ ãŠãƒ¼ï¼ã‚¹ãƒ¬ãƒ¼ãƒ–/ãƒžã‚¹ã‚¿ãƒ¼å½¢å¼ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚ˆã‚Šã‚‚ã€æ–ç„¶ä½¿ã„ã‚„ã™ãã†ã‚„ã‚“ã‹ï¼ ã£ã¦ã‚ã‘ã§ AWS ã® ELB é…ä¸‹ã«è¤‡
takaya030 2021/11/28
mariadb
ãƒªãƒ³ã‚¯
MariaDB Galera Clusterã‚’è©¦ã™ (1)
ã‚«ãƒ†ã‚´ãƒªãƒ¼ DX (2) ä¸€èˆ¬ (60) ç ”ç©¶ä¼š (6) åƒãæ–¹ (4) æŠ€è¡“ (356) AI (2) LLM (2) Edge AI (2) Edge Computing (13) Erlang (1) FIWARE (2) Fog Computing (10) Infiniband (31) Internet of Things (32) Key Value Store (17) Linux (3) Linux KVM (10) Machine Learning (8) RealTime Web (14) SRE (4) Webã‚µãƒ¼ãƒ“ã‚¹ (42) ã‚¤ãƒ³ãƒ•ãƒ© (8) ã‚³ãƒ³ãƒ†ãƒŠ (4) ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ (93) ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ (7) ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ (47) ãƒ‡ãƒ¼ã‚¿æµé€š (6) ãƒ†ãƒ¬ãƒ—ãƒ¬ã‚¼ãƒ³ã‚¹ (2) ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ (215) ä»®æƒ³åŒ– (111) ç½å®³ã‚³ãƒŸãƒ¥ãƒ‹ã‚±ãƒ¼ã‚·ãƒ§ãƒ³ (26) ç©ºé–“æƒ…å ±
takaya030 2021/11/28
mariadb
ãƒªãƒ³ã‚¯
MariaDBã€ã‚«ãƒ©ãƒ åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã€ŒMariaDB ColumnStoreã€ç™ºè¡¨ã€‚OLAPã¸å‚å…¥
MariaDBã€ã‚«ãƒ©ãƒ åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã€ŒMariaDB ColumnStoreã€ç™ºè¡¨ã€‚OLAPã¸å‚å…¥ MariaDB ColumnStoreã¯ã€ãã®åãŒç¤ºã™é€šã‚ŠMariaDBã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã—ã¦çµ„ã¿è¾¼ã‚ã‚‹ã‚«ãƒ©ãƒ åž‹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã§ã™ã€‚ ä¸€èˆ¬ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã¯ãƒ‡ãƒ¼ã‚¿ã‚’è¡Œå˜ä½ã§æ‰±ã†ã®ã«å¯¾ã—ã¦ã€ã‚«ãƒ©ãƒ åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã¯åˆ—å˜ä½ã§å‡¦ç†ã™ã‚‹ã®ãŒæœ€å¤§ã®ç‰¹å¾´ã§ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã‚’åˆ—å˜ä½ã§å‡¦ç†ã™ã‚‹ã¨åŒä¸€åž‹ã®ãƒ‡ãƒ¼ã‚¿ãŒä¸¦ã¶ãŸã‚ãƒ‡ãƒ¼ã‚¿ã®åœ§ç¸®åŠ¹çŽ‡ãŒé«˜ãã€ã¾ãŸä¸€èˆ¬ã«åˆ—æ–¹å‘ã§è¡Œã‚ã‚Œã‚‹é›†è¨ˆå‡¦ç†ã‚‚é«˜é€Ÿã«ã€ã—ã‹ã‚‚åˆ—ã”ã¨ã«åˆ†æ•£ã—ã¦ä¸¦åˆ—ã«è¡Œãˆã‚‹ã¨ã„ã†åˆ©ç‚¹ãŒã‚ã‚Šã¾ã™ã€‚ãã®ãŸã‚ã«ã‚«ãƒ©ãƒ åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã¯ã€å¤§è¦æ¨¡ãªåˆ†æžã‚„é›†è¨ˆå‡¦ç†ã‚’å¾—æ„ã¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è£½å“ã§ä½¿ã‚ã‚Œã¦ã„ã¾ã™ã€‚ MariaDB ColumnStoreã¯ã‚‚ã¨ã‚‚ã¨ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹å‘ã‘ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒInfiniDBã€ã‚’ãƒ•ã‚©ãƒ¼ã‚¯ã—ãŸ
takaya030 2021/11/28
mariadb
ãƒªãƒ³ã‚¯
docker-compose file for mariadb galera cluster
takaya030 2021/11/18
docker

kept

mariadb

compose
ãƒªãƒ³ã‚¯
EC2 ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã« MariaDB ã¨ HandlerSocket ã‚’å°Žå…¥ã™ã‚‹ä¸€éƒ¨å§‹çµ‚ - ã‚ˆã†ã¸ã„ã®æ—¥ã€…ç²¾é€²XP
è¦ä»¶ EC2 ã® t1.micro ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã« MariaDB ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã¿ã‚‹ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã‚‰ HandlerSocket ã‚’å°Žå…¥ã—ã¦ã¿ã‚‹ ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ç®¡ç†ã¯ yum MariaDB ã¨ã¯ MySQLã‚’ãƒ•ã‚©ãƒ¼ã‚¯ã—ã¦ä½œã‚‰ã‚ŒãŸ RDBMS ä¸»ãªã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ Ariaï¼ˆMyISAMæ´¾ç”Ÿã‚¨ãƒ³ã‚¸ãƒ³ï¼‰ XtraDBï¼ˆInnoDBæ´¾ç”Ÿã‚¨ãƒ³ã‚¸ãƒ³ï¼‰ ãã®ä»–ã«ã‚‚å¹¾ã¤ã‹ã‚ã‚‹ã¿ãŸã„ æ‰‹é † yum è¨å®š MariaDB ã® PGP key ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« sudo rpm --import https://yum.mariadb.org/RPM-GPG-KEY-MariaDB /etc/yum.repos.d/mariadb.repo ã®è¨å®š [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.0.1/centos6-x86
takaya030 2021/11/02
ec2

kept

mariadb
ãƒªãƒ³ã‚¯
MariaDBã§AUTO_INCREMENTã®å€¤ãŒæˆ»ã‚‹ç½
GMOã‚¢ãƒ‰ãƒžãƒ¼ã‚±ãƒ†ã‚£ãƒ³ã‚°ã®T.Kã§ã™ã€‚ MariaDBã§AUTO_INCREMENTã®å€¤ãŒæˆ»ã‚‹ç¾è±¡ã«éé‡ã—ãŸã®ã§ã€ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ç™ºç”Ÿæ¡ä»¶ã¯ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã‚’ä½¿ã£ã¦ã„ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦ã€ä¸¦åˆ—ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã§INSERTã‚’è¡Œã„ã€ç‰‡æ–¹ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã§æ‰•ã„å‡ºã—ãŸAUTO_INCREMENTã®å€¤ã‚’ä½¿ã‚ãªã‹ã£ãŸå ´åˆã§ã™ã€‚ æ¤œè¨¼ç’°å¢ƒ OS:Â CentOS 7 DB: MariaDB 10.4.13 å„ç¨®è¨å®šã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ å†ç¾æ‰‹é † ãƒ†ãƒ¼ãƒ–ãƒ« CREATE TABLE `hoge_report` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `hoge_id` INT(10) NOT NULL , `request` INT(10) NOT NULL, `report_date` date NOT NULL, PRIMARY KEY
takaya030 2020/05/27
mariadb
ãƒªãƒ³ã‚¯
ã“ã‚Œã¯ã™ã”ã„ï¼mariadb10 ã§ãƒžãƒ«ãƒã‚½ãƒ¼ã‚¹ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹çµ±åˆï¼ - Database JUNKY
MariaDBã§ãƒžãƒ«ãƒã‚½ãƒ¼ã‚¹ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ ç§çš„ã«å¾…ã¡ã«å¾…ã£ãŸã‚ã®æ©Ÿèƒ½ãŒè¿½åŠ ã•ã‚Œã¾ã—ãŸã€‚ãã‚Œã¯ã€ãƒžãƒ«ãƒãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€mariadb10.0ã‹ã‚‰å®Ÿè£…ã•ã‚Œã‚‹ã¨ã„ã†è©±ã¯çŸ¥ã£ã¦ãŠã‚Šã¾ã—ãŸãŒã€ã‚ˆã†ã‚„ãè§¦ã‚‹æ©Ÿä¼šãŒããŸã®ã§è©¦ã—ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ ä½™è«‡ã§ã¯ã‚ã‚Šã¾ã™ãŒã€å¼Šç¤¾ã§ã¯ã€ï¼“ï¼ã‚¹ã‚ãƒ¼ãƒžã¯ã‚ã‚ã†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã“ã‚Œã§ä¸€å°ã«é›†ç´„ã—ã¦ãŠã‚Šã¾ã™ã®ã§ã€ã¡ã‚ƒã‚“ã¨å®Ÿç¸¾ã¯ã‚ã‚Šã¾ã™ã®ã§ã”å®‰å¿ƒã‚’ ãã‚‚ãã‚‚ãƒžãƒ«ãƒã‚½ãƒ¼ã‚¹ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã¯ä½•ï¼Ÿ ç•°ãªã‚‹ï¼’ã¤ã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã€ï¼‘ã¤ã®SLAVEã§ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã—ã¡ã‚ƒãŠã†ã¨ã„ã†æ„å‘³ã§ã™ã€‚ãŸã¶ã‚“è¨€è‘‰ã§èª¬æ˜Žã™ã‚‹ã®ã¯é›£è§£ãªã®ã§ã€å›³ã‚’ä»¥ä¸‹ã«è¼‰ã›ã¾ã™ã€‚ ãˆï¼Ÿã“ã‚Œã£ã¦ã€æ˜”ã‹ã‚‰ã§ãã‚‹ã‚“ã˜ã‚ƒãªã„ã®ï¼Ÿã¨æ€ã£ãŸæ–¹ï¼ˆè‡ªåˆ†ï¼‰ã€‚å®Ÿã¯ã€MySQLã¯ã“ã‚ŒãŒã§ããªã‹ã£ãŸã®ã§ã™ã€€(T_T) MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’è§¦ã‚Šå§‹ã‚ãŸæ™‚ã¯ã€ãƒžãƒ«ãƒãƒžã‚¹ã‚¿ãƒ¼ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒãã‚Œã ã¨æ€ã£ã¦
takaya030 2018/09/10
mariadb
ãƒªãƒ³ã‚¯
PDOã‚ˆã‚Šé«˜é€ŸãªORMãƒ©ã‚¤ãƒ–ãƒ©ãƒª! Transactd PHP ORM ãƒªãƒªãƒ¼ã‚¹ - BizStationãƒ–ãƒã‚°
2016å¹´12æœˆ22æ—¥ã«Transactd PHP ORMã‚’ãƒªãƒªãƒ¼ã‚¹ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¯Transactdã‚’ä½¿ç”¨ã—ãŸMySQL/MariaDBç”¨ã®ORMãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã™ã€‚ ä»Šå›žã¯ã“ã®Transactd PHP ORMã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ Contents ä¸»ãªç‰¹å¾´ é«˜é€ŸãªDBã‚¢ã‚¯ã‚»ã‚¹ çœãƒ¡ãƒ¢ãƒª é«˜ã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆ é«˜å¯ç”¨æ€§ è‡ªåœ¨ãªãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¨ãƒãƒƒã‚¯ã€ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆ è©³ç´°ãªãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ æ¬ ç‚¹ è©³ç´° ORMã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒãƒ¼ãƒ‰ã‚¿ã‚¤ãƒŸãƒ³ã‚° ã‚¤ãƒ³ãƒ”ãƒ¼ãƒ€ãƒ³ã‚¹ãƒŸã‚¹ãƒžãƒƒãƒ ãƒ¢ãƒ‡ãƒ«ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ IDEã®ã‚³ãƒ¼ãƒ‰è£œå®Œæ”¯æ´ ãƒ—ãƒãƒ‘ãƒ†ã‚£ã‚¢ã‚¯ã‚»ã‚¹é€Ÿåº¦ è¤‡é›‘ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å‡¦ç† ã¾ã¨ã‚ ä¸»ãªç‰¹å¾´ é«˜é€ŸãªDBã‚¢ã‚¯ã‚»ã‚¹ Transactd PHP ORMã¯ã€ORMã§ã‚ã‚ŠãªãŒã‚‰PDOã‚’ç›´æŽ¥ä½¿ç”¨ã—ãŸã‚¢ã‚¯ã‚»ã‚¹ã‚ˆã‚Šã‚‚é«˜é€Ÿãªãƒ‡ãƒ¼ã‚¿ã‚¢ã‚¯ã‚»ã‚¹ãŒã§ãã¾ã™ã€‚ ä¸‹å›³ã¯ã€Transactdã¨PDOã€Laravel EloquentO
takaya030 2017/02/17
php

mysql

mariadb
ãƒªãƒ³ã‚¯
MariaDB audit plug-in now available for RDS MySQL and MariaDB
The MariaDB audit plug-in is now available for RDS MySQL (5.6.29 and 5.7.11) and RDS MariaDB 10.0.24 instances. The MariaDB audit plug-in provides event logging for database activity to help customers meet corporate compliance requirements and troubleshoot application issues. Some of the key details for implementing the plugin are: Enabling and disabling the audit plug-in â€“ Users can enable audit
takaya030 2016/04/28
MySQL

mariadb
ãƒªãƒ³ã‚¯
é•·å¹´ã®è°è«–ã«çµ‚æ¢ç¬¦ -- MySQLã¨MariaDBã®é•ã„ä¸€è¦§ - æŠ€è¡“ãƒ¡ãƒ¢ç½®ãå ´
(2014.12.3è¿½è¨˜ï¼šã“ã®blogã®å†…å®¹ã¯ã€ä»¥ä¸‹ã®æ›¸ç±ã«ã‚‚åæ˜ ã•ã›ãŸã€‚) SQLãƒ¬ãƒ™ãƒ«ã®å·®ç•° MariaDB5.5ã¨MySQL5.5ã§ã¯SQLãƒ¬ãƒ™ãƒ«ã§ã®é•ã„ã¯ã»ã¨ã‚“ã©ãªã‹ã£ãŸã€‚autoincrementã®æœ€å¤§å€¤ã®æ‰±ã„ãã‚‰ã„ã€‚ ãŸã ã—ã€MariaDB10.0ã§REGEXPãŒãƒžãƒ«ãƒãƒã‚¤ãƒˆå¯¾å¿œã«ãªã£ãŸã®ã§ã€ã‚¢ãƒ—ãƒªå´ã¯æ³¨æ„ã€‚ é …ç›® MySQL MariaDB Autoincrement æœ€å¤§å€¤ã«é”ã™ã‚‹ã¨ã€ä»¥é™ã¯æœ€å¤§å€¤ã‚’ç¹°ã‚Šè¿”ã™ã€‚Warningã®ã¿ã€‚ã‚¨ãƒ©ãƒ¼ã«ãªã‚‰ãªã„ã€‚tinyintãªã‚‰â€¦,125,126,127,127,127â€¦ æœ€å¤§å€¤-1ã¾ã§ã€‚ä»¥é™ã¯ã‚¨ãƒ©ãƒ¼ã‚’è¿”ã™ã€‚tinyintãªã‚‰â€¦,125,126,ERROR,ERROR,â€¦ EXPLAINæ–‡ JSONå½¢å¼ ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6ã‹ã‚‰ æœªå¯¾å¿œ Optimizer Trace ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6ã‹ã‚‰ æœªå¯¾å¿œï¼ˆãŸã ã—ã€MariaDBã®ã»ã†ãŒã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶
takaya030 2013/09/19
mysql

mariadb
ãƒªãƒ³ã‚¯
1