全文検索:
- 01 Galera構築 @01_linux:11_データベース:01_mysql
- un/mysqld/mysqld.pid # # * IMPORTANT: Additional settings that can override those from this file! # ... ng_address= # How many threads will process writesets from other nodes wsrep_slave_threads=1 # DBUG o... ertify_nonPK=1 # Maximum number of rows in write set wsrep_max_ws_rows=131072 # Maximum size of write set wsrep_max_ws_size=1073741824 # to enable debug l
- 14 MariaDB @01_linux:11_データベース:01_mysql
- DB | +------------------------+--------+ 1 row in set (0.00 sec) MariaDB [(none)]> show global variabl... N | +-----------------------+-------+ 1 row in set (0.00 sec) MariaDB [(none)]> show global variabl... ---------------------------+----------+ 2 rows in set (0.00 sec) MariaDB [(none)]> show global variabl... +-------------------------+-----------+ 1 row in set (0.00 sec) MariaDB [(none)]> show global variabl
- 15 InnoDB テーブルロック @01_linux:11_データベース:01_mysql
- | sato | 40 | +----+--------+-----+ 3 rows in set (0.02 sec) </code> <code> create table lock_test... , age int not null ) engine=innoDB default charset=utf8; insert into lock_test (name, age) values ... rows affected (0.00 sec) mysql> UPDATE lock_test SET age = 21 WHERE name = 'tanaka'; Query OK, 1 row a... rows affected (0.00 sec) mysql> UPDATE lock_test SET age = 31 WHERE name = 'suzuki'; ERROR 1205 (HY000
- 01 PostgreSQL streaming replica @01_linux:11_データベース:02_postgresql
- systemctl daemon-reload ===== 初期化 ===== PGSETUP_INITDB_OPTIONS="-E UTF8 --no-locale" /usr/pgsql-13/bin/postgresql-13-setup initdb ===== PATH追加 ===== <code> cat << __EOM... system/postgresql-13.service; disabled; vendor preset: disabled) Active: active (running) since Mon ... system/postgresql-13.service; disabled; vendor preset: disabled) Active: active (running) since Mon
- 09 Galera + innodb_flush_log_at_trx_commit @01_linux:11_データベース:01_mysql
- AA | | 3690 | AAAA | +------+------+ 3691 rows in set (0.00 sec) -Secondary | 3689 | AAAA | | 3690 | A... AA | | 3691 | AAAA | +------+------+ 3692 rows in set (0.01 sec) </code> == 2.Secondaryのmysqlをkill == ... | | 3891 | AAAA | +-------+------+ 17985 rows in set (0.02 sec) -Secondary | 3881 | AAAA | | 3882 |... A | | 3883 | AAAA | +-------+------+ 17977 rows in set (0.03 sec) </code> {{tag>mysql innodb Galera}}
- 02 MySQL max_connections @01_linux:11_データベース:01_mysql
- 186 | +----------------------+-------+ 1 row in set (0.01 sec) </code> 現在のコネクション数。 <code console> my... | 63 | +-------------------+-------+ 1 row in set (0.00 sec) </code> ===== エラーログ ===== Apache側で... ===== 対応 (max_connectionsを増やす) ===== <code console> mysql> set global max_connections=450; </code>
- 13 mysql56 + galera3 @01_linux:11_データベース:01_mysql
- read_rnd_buffer_size = 2M # Galera # Cluster setting wsrep_cluster_name="Galera_CLUSTER" wsrep_c... mm.so" #wsrep_provider_options="" # Xtrabackup setting [sst] compressor="gzip" decompressor="gzip... ster </code> ===== 5.クラスタへ参加 ===== <code> mysql> set global wsrep_cluster_address='gcomm://192.168.10.
- 20 CentOS7 MariDB Galera @01_linux:11_データベース:01_mysql
- ttps://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash ===== インストール ===== <code> # yum in... db # mysql_secure_installation ===== character-set追加 ===== <code|/etc/my.cnf.d/server.cnf> [mariadb] character-set-server=utf8 </code> {{tag>mysql galera mariad
- 01 redis コマンド
- |string| |lrange [key] 0 -1|list| |smembers [key]|set | |zrange [key] 0 -1|zset| |hgetall [key]|hash| |hkeys [key]|hash だった場合に field の一覧| |hvals [key]|hash
- 18 CentOS7 MariaDB @01_linux:11_データベース:01_mysql
- ===== <code> # cat /etc/my.cnf [mysqld] character-set-server=utf8 max_allowed_packet = 32M </code> =... emd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf> [Service] TimeoutStartSec=3600 </code>
- 51 MySQLベンチマーク(mysqlslap) @01_linux:11_データベース:01_mysql
- erate-sql-execute-number=# Set this number to generate a set number of queries to run. --auto-generate-sql-gu
- 05 Percona Xtrabackup @01_linux:11_データベース:01_mysql
- ysql/ </code> 両方のDBを起動後、同期 <code console> mysql> SET GLOBAL wsrep_cluster_address='gcomm://192.168.20.
- 11 Galera同期(複数台構成) @01_linux:11_データベース:01_mysql
- 2]# /etc/init.d/mysql start [node2]# mysql mysql> set global wsrep_cluster_address='gcomm://192.168.0.1
- 12 Galera Permission Error @01_linux:11_データベース:01_mysql
- [ERROR] Aborting ===== 対応 ===== SELinuxを無効にするだけ。 <code> # setenforce 0 </code> {{tag>mysql galera}}
- 16 MySQL auto_increment リセット @01_linux:11_データベース:01_mysql
- E FROM `table_name`; ALTER TABLE `table_name` SET auto_increment = 1; TRUNCATEでも同じ感じになる。 TRUNCA