Fulltext results:

05 Percona Xtrabackup

12 Hits, Last modified: 6 years ago

=== 2. perconaをdisableへ === <code console> # vi /etc/yum.repos.d/Percona.repo enabled = 1 ↓ enabled... でバックアップ取得できるように変更する必要があります。 <code console> # vi /etc/mysql/conf.d/wsrep.cnf wsrep_sst_method=xtrabackup </code> == my.cnf == <code console> # vi /etc/my.cnf [xtrabackup] user= root password= k3fFuGQU... 4.の設定を反映させる為に、一度再起動しておく必要があります。 <code console> # /etc/init.d/mysql stop # /etc/init.d/mysql start </cod

01 Galera構築

8 Hits, Last modified: 8 years ago

e --nodeps mysql-5.0.77-4.el5_6.6 </code> ===== ②/etc/my.cnf ===== <code> [root@ohana ~]# cat /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/... srep configuration is in wsrep.cnf # !includedir /etc/mysql/conf.d/ </code> ===== ③/etc/mysql/conf.d/wsrep.cnf ===== <code> # This file contains wsrep-r

13 mysql56 + galera3

4 Hits, Last modified: 9 years ago

=== Galera === <code> # cat <<- '__GALERA__' > /etc/yum.repos.d/galera.repo [galera] name = Galera ... 3.noarch.rpm # sed -i 's/^enable.*/enable = 0/g' /etc/yum.repos.d/percona-release.repo </code> ===== 2... ode> === my.cnf用意 === <code> cat <<- __MY__ >> /etc/my.cnf binlog_format=ROW bind-address=0.0.0.0 ... PRIVILEGES; </code> ===== 4.起動 ===== <code> # /etc/init.d/mysql start --wsrep-new-cluster </code> =

03 InnoDBテーブル分割

3 Hits, Last modified: 12 years ago

</code> ===== MySQL 停止 ===== <code console> # /etc/init.d/mysql stop </code> ===== my.cnf修正 ===== <code console> # vi /etc/my.cnf [mysqld] default-storage-engine=InnoDB inn... b* </code> ===== MySQL起動 ===== <code console> # /etc/init.d/mysql start </code> ===== リストア ===== <cod

51 MySQLベンチマーク(mysqlslap)

3 Hits, Last modified: 10 years ago

ead from the following files in the given order: /etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf The following groups are read: mysqlslap client The following

11 Galera同期(複数台構成)

2 Hits, Last modified: 7 years ago

/ </code> ===== 6.起動・同期 ===== <code> [node2]# /etc/init.d/mysql start --wsrep_cluster_address="gcomm... " </code> ==== もしくは ==== 下記でも同じ <code> [node2]# /etc/init.d/mysql start [node2]# mysql mysql> set glob

18 CentOS7 MariaDB

2 Hits, Last modified: 6 years ago

tallation </code> ===== 設定追加 ===== <code> # cat /etc/my.cnf [mysqld] character-set-server=utf8 max_all... 起動スクリプトのタイムアウト値 ===== === Timeout追加 === <code|/etc/systemd/system/mariadb.service.d/migrated-from-my

14 MariaDB

1 Hits, Last modified: 9 years ago

-----+-------+ 1 row in set (0.00 sec) </code> /etc/my.cnf default_storage_engine=InnoDB innodb_file

19 MySQL ログローテート

1 Hits, Last modified: 5 years ago

====== 19 MySQL ログローテート ====== <code|/etc/logrotate.d/mysql> /var/log/mysqld.log { create 640

20 CentOS7 MariDB Galera

1 Hits, Last modified: 6 years ago

installation ===== character-set追加 ===== <code|/etc/my.cnf.d/server.cnf> [mariadb] character-set-serv