Which type of ALTER did you make ?

Don't forget that there's a special trigger on the source table that 
must be updated too.

Geoffrey wrote:
> David Rees wrote:
>> On Tue, Nov 4, 2008 at 2:22 PM, Geoffrey 
>> <lists at serioustechnology.com> wrote:
>>> Will it cause a problem if one adds fields to a table that is being
>>> replicated?
>>>
>>> That is, will it break the replication process, or will the replication
>>> continue to simply replicate the previous set of fields?
>>
>> It should continue to replicate the previous set of fields, but is not
>> recommended to do so.
>
> I don't know if it's related or not, but it appears that our slave is 
> now out of sync with the master.  It's a two node set up, and it's 
> been replicating for some time now.  It's just now that I've gone in 
> and compared record counts on some major tables and they are not in 
> sync. Further, I can see updates happen to the master node tables but 
> don't see them on the slave.
>
> If adding the field didn't cause the problem, any ideas what might have?
>

-- 
Cyril SCETBON - Ingénieur bases de données
Cellule bases de données
AUSY pour France Télécom - OPF/PORTAILS/DOP/HEBEX

Tél : +33 (0)4 97 12 87 60
Jabber : cscetbon at jabber.org
France Telecom - Orange
790 Avenue du Docteur Maurice Donat 
Bâtiment Marco Polo C1 - Bureau 202
06250 Mougins
France

***********************************
Ce message et toutes les pieces jointes (ci-apres le 'message') sont
confidentiels et etablis a l'intention exclusive de ses destinataires.
Toute utilisation ou diffusion non autorisee est interdite.
Tout message electronique est susceptible d'alteration. Le Groupe France
Telecom decline toute responsabilite au titre de ce message s'il a ete
altere, deforme ou falsifie.
Si vous n'etes pas destinataire de ce message, merci de le detruire
immediatement et d'avertir l'expediteur.
***********************************
This message and any attachments (the 'message') are confidential and
intended solely for the addressees.
Any unauthorised use or dissemination is prohibited.
Messages are susceptible to alteration. France Telecom Group shall not be
liable for the message if altered, changed or falsified.
If you are not recipient of this message, please cancel it immediately and
inform the sender.
************************************