全文検索:
- 20 CentOS7 MariDB Galera @01_linux:11_データベース:01_mysql
- ====== ===== 注意 ===== <color #ed1c24> ※MariaDB Server 10.1 以降 Percona XtraBackup との互換性が失われています。 \\ この対策として,MariaDB Server 10.1.23 / 10.2.7 以降,XtraBackup を fork した [[https:... ===== インストール ===== <code> # yum install MariaDB-server MariaDB-server 10.4.12-1.el7.centos MariaDB-client 10.4.12-1.el7.centos MariaDB-common 10.4.12-1.el7.ce
- 01 Galera構築 @01_linux:11_データベース:01_mysql
- s://launchpad.net/codership-mysql/+download|MySQL-server最新版]] * [[http://mysql.ntu.edu.tw/Downloads/MySQ... t/codership-mysql/5.5/5.5.28-23.7/+download/MySQL-server-5.5.28_wsrep_23.7-1.rhel5.x86_64.rpm # wget http:... client-5.5.24-1.rhel5.x86_64.rpm # rpm -ivh MySQL-server-5.5.23_wsrep_23.6-1.rhel5.x86_64.rpm </code> ====... rpm -qa | grep mysql mysql-5.0.77-4.el5_6.6 mysql-server-5.0.77-4.el5_6.6 # rpm -e --nodeps mysql-server-
- 51 MySQLベンチマーク(mysqlslap) @01_linux:11_データベース:01_mysql
- e owners. Run a query multiple times against the server. Usage: mysqlslap [OPTIONS] Default options are... tements. -C, --compress Use compression in server/client protocol. -c, --concurrency=name ... Password to use when connecting to server. If password is not given i... key in PEM format (implies --ssl). --ssl-verify-server-cert Verify server's "Comm
- 01 PostgreSQL streaming replica @01_linux:11_データベース:02_postgresql
- ynchronous_standby_names = 'postgresql' # standby servers that provide sync rep </code> ===== 確認 ===== ... ● postgresql-13.service - PostgreSQL 13 database server Loaded: loaded (/usr/lib/systemd/system/postgr... ● postgresql-13.service - PostgreSQL 13 database server Loaded: loaded (/usr/lib/systemd/system/postgr... 4.2$ /usr/pgsql-13/bin/pg_ctl promote waiting for server to promote.... done server promoted </code> 他のSe
- 50 MySQLベンチマーク(sysbench) @01_linux:11_データベース:01_mysql
- ql options: --mysql-host=[LIST,...] MySQL server host [localhost] --mysql-port=N MySQL server port [3306] --mysql-socket=STRING MySQL... sql options: --pgsql-host=STRING PostgreSQL server host [localhost] --pgsql-port=N PostgreSQL server port [5432] --pgsql-user=STRING PostgreSQL
- 18 CentOS7 MariaDB @01_linux:11_データベース:01_mysql
- インストール ===== <code> # yum install mariadb mariadb-server </code> ===== 起動 ===== <code> # systemctl enabl... = <code> # cat /etc/my.cnf [mysqld] character-set-server=utf8 max_allowed_packet = 32M </code> ===== ディ
- 05 Percona Xtrabackup @01_linux:11_データベース:01_mysql
- : Error: no 'datadir' option in group 'mysqld' in server configuration file '/etc/my.cnf' at /usr/bin/inno
- 13 mysql56 + galera3 @01_linux:11_データベース:01_mysql
- lera install galera-3 mysql-wsrep-5.6 mysql-wsrep-server-5.6 mysql-wsrep-libs-compat-5.6 </code> === Xtra
- 14 MariaDB @01_linux:11_データベース:01_mysql
- ====== 14 MariaDB ====== -MariaDB-server-10.2.7-1 <code> MariaDB [(none)]> show global variables like 'd