Re: Materialized view on mysql replica.

[Miguel Alvarez]

Hi.
Yes. It is very similar. My trigger has the following code:
CREATE TRIGGER trig_ivUsuarios AFTER UPDATE ON dbname.usuarios
FOR EACH ROW BEGIN
UPDATE vUsuarios SET apellido1 = NEW.paterno,
apellido2 = NEW.materno,
fecha_nacimiento = DATE_FORMAT(NEW.nacimiento,'%Y-%m-%d'),
fecha_registro = NEW.fecha_creacion,
genero = NEW.sexo,
nombre = NEW.nombre
WHERE id_monitor = NEW.id_usuario;
END

This trigger was created on table dbname.usuarios and updates data on materialized view vUsuarios.
Thanks.