全文検索:
- 05 Percona Xtrabackup
- backup/incremental_2/ </code> xbstreamでストリームして、gzip <code console> innobackupex --stream=xbstream --i... =/backup/xtrabackup/base/ /backup/xtrabackup/ | gzip - > incremental_1.xbstream.gz innobackupex --stre... =/backup/xtrabackup/base/ /backup/xtrabackup/ | gzip - > incremental_2.xbstream.gz </code> === オブジェク... ental_2/ </code> xbstreamを戻す場合 <code console> gzip -dc incremental_1.xbstream.gz |xbstream -x -C /ba
- 01 Galera構築
- ad|galera最新版]] * [[https://launchpad.net/codership-mysql/+download|MySQL-server最新版]] * [[http://my... l5.x86_64.rpm # wget https://launchpad.net/codership-mysql/5.5/5.5.28-23.7/+download/MySQL-server-5.5.... mmand to call when node status or cluster membership changes. # Will be passed all or some of the foll... !! # (SST method dependent. Defaults to the first IP of the first interface) wsrep_sst_receive_address
- 03 InnoDBテーブル分割
- ult-storage-engine=InnoDB innodb_file_per_table skip-innodb-doublewrite # リストアが早くなる </code> ==== skip-innodb-doublewrite について ==== InnoDBは、耐障害性を高めるためにIn... しも設定が必要なわけではありません。\\ そこで二重書き込みをやめるために、初期設定ふぁいるに「skip-innodb-doublewrite」を加えることで、innodb_doublewriteの値をO
- 13 mysql56 + galera3
- s="" # Xtrabackup setting [sst] compressor="gzip" decompressor="gzip -dc" rebuild=1 compact=1 encrypt=0 #tkey="" #tcert="" #tca="" [mysqld_sa
- 50 MySQLベンチマーク(sysbench)
- queries (do not modify database) [off] --oltp-skip-trx=[on|off] skip BEGIN/COMMIT statements [off] --oltp-range-size=N range size f