From: Date: June 19 2007 6:03pm
Subject: Re: Rationale behind FEDERATED engine queries
List-Archive: http://lists.mysql.com/internals/34756
Message-Id: <20070619160337.GP7870@w3.org>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="VnOTrGv5LmZxna7m"

--VnOTrGv5LmZxna7m
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

* Peter B. Volk <peter@stripped> [2007-06-19 17:24+0200]
> Hi Jay,
>=20
> >> But, by this logic, then statement-based replication wouldn't make
> >> sense, since the storage engine on the master and slave can be
> >> different, no?
>=20
> If you are using federated engines you should change the table type on
> your slave. You are right statement based replication in conjunction with
> the federated tables does not make much sense at alle. It acutally is
> contraproductive :) That is why MySQL supports row based replication. But
> also here you must be carfull. If you insert data into the federated table
> then this insertion is logged and also inserted on the slave. If the table
> on the slave is also federated then the data is inserted twice in the the
> federated database.

twice? or forever until the supply of identical rows is exhausted..?
(i assume that a failed delete does not get replicated.)

> >> In other words, why was this method chosen for the federated handler,
> >> but not for the replication writer?
>=20
> This method is not only used for the federated handler. It is used by all
> handlers. All storage engines are treated the same (except for innodb its
> a special one ;)). The replication wirter, as far as I know, is event
> driven. Meaning it logs all events e.g. insert statements. No matter what
> storage engine you are using.
>=20
> Cheers,
> Peter
>=20
>=20
> --=20
> MySQL Internals Mailing List
> For list archives: http://lists.mysql.com/internals
> To unsubscribe:    http://lists.mysql.com/internals?unsub=3Deric+mysql@w3=
=2Eorg

--=20
-eric

office: +1.617.258.5741 NE43-344, MIT, Cambridge, MA 02144 USA
mobile: +1.617.599.3509

(eric@stripped)
Feel free to forward this message to any list for any purpose other than
email address distribution.

--VnOTrGv5LmZxna7m
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iQEVAwUBRnf+WZZX2p1ccTnpAQJ7fQgAlrNJpTxezQ53ZQ/SBj/JbG97OT+1rJwh
lJ4MSJUlSxKXTwUw4ib8ntQ1siY8dIDx0/chzMnZMcbMTv2UJX7wRO8uTsm92GnJ
pKfipSlOL+pIYKx87JFDfC2Lk6DPlfGf8YbwLlynmUvEt1CsW6SGjpLD/uIlardw
zSl9da7RcXfjVM3kWt9/7DBhSVSYUFcrD2dAWmn7SS2cUIwoDu6MVFjcc0nkz+vT
W/OJ1SC7q1LTYtc9NLXDK/zGMEhwEf0aZfDbD2zwOkauaXxNKivoaoZ+0thLB/lF
GU9+PrTIftSMYGfSZuJYt+xv3Ppa7Tyl6+I0Jv09ayIzVXjjLDTroQ==
=/X28
-----END PGP SIGNATURE-----

--VnOTrGv5LmZxna7m--