[Spce-user] TIPP: database replication with tungsten

[Skyler]

Hi,

 Thanks for sharing, a few questions on this:

1. How is using tungsten replicator better than
http://www.percona.com/doc/percona-xtradb-cluster/features/multimaster-replication.html

2. What are these table-triggers needed for? Which file(s) to edit?
3. How do you avoid replicating the kamailio.location table? or is this
best used behind a virtual IP?

--Skyler

On Sat, Oct 13, 2012 at 5:34 PM, Klaus Peter v. Friedeburg <
friedeburg at aco.de> wrote:

> Hi all,
>
> if you want to use tungsten replicator for replicate the database in
> multi-master Setup you must edit the table-triggers.
>
> Insert a new function to all the databases:
> **************************************
> create function is_master()
>     returns boolean
>     deterministic
>     return if(substring_index(user(),'@',1) != 'replicator',true, false);
> **************************************
>
> In the trigger definition insert AFTER the DECLARE lines
> **************
>   if is_master() then
>        ........
>   end if;
> **************
>
>
>
> Klaus Peter
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/listinfo/spce-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20121014/baadb2ad/attachment-0001.html>