Fulltext results:

01 Galera構築

14 Hits, Last modified: 7 years ago

4M [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid # # * IMPORTANT: Additional settings that can override those from this file! # The files must end wit... ptions that need to be customized: # - wsrep_provider # - wsrep_cluster_address # - wsrep_sst_auth

13 mysql56 + galera3

5 Hits, Last modified: 9 years ago

=265035226 #wsrep_incoming_address="" wsrep_provider="/usr/lib64/galera-3/libgalera_smm.so" #wsrep_provider_options="" # Xtrabackup setting [sst] compr... [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [client] socket=/var/lib/mysql/mysql.sock __MY__ <code> === Xtr

11 Galera同期(複数台構成)

4 Hits, Last modified: 6 years ago

astate.datを作成 ここをちゃんと合わせないと、wsrep_cluster_state_uuidが違うとかで正常に同期できない。 <code> [node2]# cat /backup/xtra... /grastate.dat # GALERA saved state version: 2.1 uuid: d38587ce-246c-11e5-bcce-6bbd0831cc0f seqno: ... luster_size | 3 | wsrep_cluster_state_uuid | d38587ce-246c-11e5-bcce-6bbd0831cc0f </code... 考URL ===== [[http://severalnines.com/blog/how-avoid-sst-when-adding-new-node-galera-cluster]] {{tag>m

15 InnoDB テーブルロック

4 Hits, Last modified: 7 years ago

select * from lock_test; +----+--------+-----+ | id | name | age | +----+--------+-----+ | 1 | tan... 2 sec) </code> <code> create table lock_test ( id int primary key auto_increment, name varchar(... sec) mysql> UPDATE lock_test SET age = 21 WHERE id=1; Query OK, 1 row affected (0.01 sec) Rows match... sec) mysql> UPDATE lock_test SET age = 31 WHERE id=2; Query OK, 1 row affected (0.00 sec) Rows match

51 MySQLベンチマーク(mysqlslap)

4 Hits, Last modified: 10 years ago

run. --auto-generate-sql-guid-primary Add GUID based primary keys to auto-generated tables. --auto-generat... -default-auth=name Default authentication client-side plugin to use. -F, --delimiter=name ... tty. --plugin-dir=name Directory for client-side plugins. -P, --port=# Port number to us

07 INNODB/MyISAM 確認方法

3 Hits, Last modified: 10 years ago

| eccube_db | | dtb_best_products_best_id_seq | MyISAM | eccube_db ... | InnoDB | eccube_db | | dtb_bloc_bloc_id_seq | MyISAM | eccube_d... B | eccube_db | | dtb_category_category_id_seq | MyISAM | eccube_db

50 MySQLベンチマーク(sysbench)

3 Hits, Last modified: 4 years ago

ql> GRANT ALL ON sbtest.* TO 'sbtest'@'localhost' IDENTIFIED BY '[PASSWORD]'; Query OK, 0 rows affecte... " for starting transactions Using auto_inc on the id column Threads started! Time limit exceeded, exit... AUTO_INCREMENT (or equivalent) should be used on id column [on] --oltp-connect-delay=N tim

03 InnoDBテーブル分割

1 Hits, Last modified: 12 years ago

ode> ===== リストア ===== <code console> # mysql < all_backup.sql </code> これで、tablename.idb ができるようになります。

09 Galera + innodb_flush_log_at_trx_commit

1 Hits, Last modified: 10 years ago

== 2.障害試験 ===== [[http://planet.mysql.com/entry/?id=2182281|参考:Galera + innodb_flush_log_at_trx_commi

20 CentOS7 MariDB Galera

1 Hits, Last modified: 6 years ago

====== 20 CentOS7 MariDB Galera ====== ===== 注意 ===== <color #ed1c24> ※MariaDB Server 10.1 以降 Perco