[Asterisk-Users] MySQL replication for voicemail

[Noah Miller]

Hi Gary -

> I have voicemessage ODBC storage working and MySQL replicating,
> but I didn't setup the replication after-the-fact, therefore didn't need the
> 'LOAD DATA FROM MASTER'.   You may want to try a different method
> (more manual) of synching your machines.

Yes, I've been reading about some errors with LOAD DATA FROM MASTER
that might not get fixed until after 5.1 is released.  Yikes!  I'll
take your advice and move a mysqldump of the info over to the slaves,
and manually set the replication points.


> Does your voicemessages table contain specially large messages?
> The errors you get don't suggest this, but the only change I had to make
> was to increase the maximum packet size -- it was 1M by default and I
> changed it to 16M.

Aha.  I didn't even know there was such a setting.  I'm sure there
will come a time when someone leaves a message larger than 1M.


Thanks!
Noah




> On 5/8/06, Noah Miller <noahisaacmiller at gmail.com> wrote:
> >
> > Does anybody have any ideas on what's causing this error?  Why would
> > MySQL not have enough memory?  What does it mean, "points outside data
> > file"?  Is anybody else doing this successfully, or am I a lone freak?
> >
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
>
> Asterisk-Users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
>