MySQL slave master replication

--Apple-Mail-2-250774101
Content-Type: text/plain;
charset=US-ASCII;
format=flowed;
delsp=yes
Content-Transfer-Encoding: 7bit

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.

_________________________________

Jamie DelleMonache | Solutions Specialist

MEI | 610 Old York Rd, Suite 250 | Jenkintown, PA 19046
P: 215-886-5662 x282 | F: 215-886-5681
E-Mail: jdellemonache@maned.com
http://www.maned.com



--Apple-Mail-2-250774101--

Re: MySQL slave master replication

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/12/28 Jamie DelleMonache :
> I know the master/slave replication scheme for MySQL is pretty easy to se=
t
> 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.
>
> _________________________________
>
> Jamie DelleMonache | Solutions Specialist
>
> MEI =A0| =A0610 Old York Rd, Suite 250 =A0| =A0Jenkintown, PA 19046
> P: 215-886-5662 x282 | F: 215-886-5681
> E-Mail: jdellemonache@maned.com
> http://www.maned.com
>
>
>



--=20
Lo que har=EDa ser=EDa hacerme pasar por sordomudo y as=ED no tendr=EDa que
hablar. Si quer=EDan decirme algo, tendr=EDan que escribirlo en un
papelito y enseñármelo. Al final se hartar=EDan y ya no tendr=EDa que
hablar el resto de mi vida.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg