List:General Discussion« Previous MessageNext Message »
From:Miguel Angel Nieto Date:December 30 2009 9:26pm
Subject:Re: MySQL slave master replication
View as plain text  
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 <jamied@stripped>:
> 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@stripped
> http://www.maned.com
>
>
>



-- 
Lo que haría sería hacerme pasar por sordomudo y así no
tendría que
hablar. Si querían decirme algo, tendrían que escribirlo en un
papelito y enseñármelo. Al final se hartarían y ya no tendría
que
hablar el resto de mi vida.
Thread
MySQL slave master replicationJamie DelleMonache28 Dec
  • Re: MySQL slave master replicationMiguel Angel Nieto30 Dec