Hi,
MySQL replicate the databases at SQL level, so if the two servers are
using the same engine (innodb), they will be replicated without
problems.
If the BLOB data is big, don't configure the replication over a WAN or
you will get too much latency (of course, it depends on your
bandwidth).
2009
I know the master/slave replication scheme for MySQL is pretty easy to
set up; I'm doing it lab now. My question is does anyone know if it
will successfully replicate foreign key constraints and large BLOB
date types.
Any feedback on this would be gratefully appreciated.
__
