Thank you,
I was try and I found few problems.
1. I failed to set up replication on Db Event (in manual is mentioned).
Any idea how to do with IBreplicator?
2. I failed to transfer all table operation.
Only last values are transfered.
This fail, if is circular link between records like
record A have FK to record B
record B have FK to record A
present is data.
Is it possible to setup ibReplicator to sync all changes, not only final
view?
3. REPL users in triggers
AS
DECLARE VARIABLE C_OP CHAR(1) = '?';
BEGIN
C_OP = CASE WHEN (INSERTING) THEN 'I' WHEN (UPDATING) THEN 'U' WHEN
(DELETING) THEN 'D' END;
IF (USER <> 'REPL') THEN BEGIN
INSERT INTO REPL$LOG(REPLNO,SUBDBNO,RELATIONNO,REPTYPE,NEWKEY,OLDKEY,SEP)
VALUES(1,2,1,:C_OP,NEW.ID,OLD.ID,' ');
END
END
Is it possible to use context variables instead REAL user?
Like this example:
CREATE OR ALTER PROCEDURE GetUserID
RETURNS( rid INTEGER ) AS
BEGIN
rid=RDB$GET_CONTEXT('USER_TRANSACTION','REALUSERID');
IF(rid IS NULL)THEN
rid=RDB$GET_CONTEXT('USER_SESSION','ConnectedUser');
IF(rid IS NULL)THEN
EXECUTE PROCEDURE GetUserIDEx(USER) RETURNING_VALUES rid;
END
4. ReplManager.exe.manifest
I have to delete this file, it causes that I cannot start
ReplManager.exe as normal user.
Slavek
Ing. Slavomir Skopalik
Executive Head
Elekt Labs s.r.o.
Collection and evaluation of data from machines and laboratories
by means of system MASA (http://www.elektlabs.cz/m2demo)
----------------------------------------------------------
Address:
Elekt Labs s.r.o.
Chaloupky 158
783 72 Velky Tynec
Czech Republic
----------------------------------------------------------
Mobile: +420 724 207 851
icq:199 118 333
skype:skopaliks
e-mail:skopalik@elektlabs.cz
http://www.elektlabs.cz
On 26.11.2015 12:22, Alexey Kovyazin ak@ib-aid.com [firebird-support] wrote:
> Hi,
>
> Try IBReplicator.
>
> Regards,
> Alexey Kovyazin
> IBSurgeon
>
>
>
>
>> Hi all,
>> we are preparing new project with bidirectional replication.
>>
>> Customer idea is to have master database in head quoter
>> and slave databases on production plant (to solve network performance
>> and availability issues).
>>
>> Witch replication SW you can recommend for this bidirectional
>> replication?
>> What is typical issues and weakness of this SW.
>>
>> Thank you.
>>
>> Slavek
>>
>> --
>> Ing. Slavomir Skopalik
>> Executive Head
>> Elekt Labs s.r.o.
>> Collection and evaluation of data from machines and laboratories
>> by means of system MASA (http://www.elektlabs.cz/m2demo)
>> ----------------------------------------------------------
>> Address:
>> Elekt Labs s.r.o.
>> Chaloupky 158
>> 783 72 Velky Tynec
>> Czech Republic
>> ----------------------------------------------------------
>> Mobile: +420 724 207 851
>> icq:199 118 333
>> skype:skopaliks
>> e-mail:skopalik@elektlabs.cz
>> http://www.elektlabs.cz
>>
>>
>
>
Posted by: Slavomir Skopalik <skopalik@elektlabs.cz>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (5) |
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
No comments:
Post a Comment