日本語のみで絞り込む

The host name or IP address of the replication source server. The replica uses this to connect to the source. The maximum length of the string value is 255 ...

2019/3/11 -MySQL replication is a process that enables data from one MySQL database server (the master) to be copied automatically to one or more MySQL ...

MASTER_HOST and MASTER_PORT are the host name (or IP address) of the master host and its TCP/IP port. Note · MASTER_USER and MASTER_PASSWORD are the user name ...

2020/12/5 -Change host IP of master in mysql replication ... I have one master and one slave. Suppose IP of master is changed but the physical server is same ...

As the master-slave replication is a one-way replication (from master to slave), only the master database is used for the write operations, while read ...

2021/6/2 -In MySQL, replication involves the source database writing down every change made to the data held within one or more databases in a special ...

This section explains startup options for controlling replica servers. Many of these options can be set while the server is running by using the CHANGE ...

Displays a list of replicas currently registered with the source. From MySQL 8.0.22, SHOW SLAVE HOSTS is deprecated and the alias SHOW REPLICAS should be used ...

CHANGE MASTER is used to setup or change replication from another server (called master or primary) to the current server (called slave or replica). MariaDB ...

2023/1/17 -Configure Master-Master MySQL Database Replication in 5 Easy Steps ... MySQL Master-Master replication is the process in which a data set stored ...

A.デュアルマスタ構成にするにあたって、いったんサービスをメンテ状態に出来ないでしょうか。 それならばログのポジションも変動しませんし、ServerAのdumpをServerBに展開すれば安全にデュアル

解決済み-回答:2件-2014/3/21

A.PHP側(phpinfo())は確認されているようですが、MySQL側は確認されていますか? もしかするとPHP側とMySQL側のソケットが違うのかもしれませんので、確認してください。 (確認...

解決済み-回答:1件-2012/10/2

A.>マスター側で設定したユーザのパスワードが、スレーブ側に反映されない これが普通の動作だと思うんですが・・・。 スレーブ側は参照のみの権限のユーザを作ってアクセスしたりしますからね(不用意

解決済み-回答:1件-2015/3/12