約10,100,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 ...

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

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

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

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

2021/12/31 -This guide will walk you through creating MySQL replication on existing live MySQL servers on Windows. While some downtime is required, ...

2013/4/26 -MySQL replication is the process by which a single data set, stored in a MySQL database, will be live-copied to a second server. This ...

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

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

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