約20,900,000件1ページ目

日本語のみで絞り込む

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

Syntax-Multi-Source Replication-Options

2014/8/13 -Hi Team, I have two hosts, tried to enable master-master replication. We have failed over once and not able to identify which is acting as ...

2024/1/16 -Master-slave replication in MySQL is a process that enables the replication or copying of data from one MySQL database server (the master) to ...

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

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

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