cancel
Showing results for 
Search instead for 
Did you mean: 

EDB-EFM-REPLICATIONS

Level 3 Adventurer

Re: EDB-EFM-REPLICATIONS

Hi 

     i have an issue in th efm-3.4

we installed db 2 server and install efm in 3 servers'.but cannot accept database information(not sync.)

Please help to how to sync woth cluster.

 

FYI:-

---

[root@SG********** efm-3.4]# /usr/edb/efm-3.4/bin/efm cluster-status efm
Cluster Status: efm

Agent Type Address Agent DB VIP
-----------------------------------------------------------------------
Idle 10.138.50.23 UP UNKNOWN 10.138.50.101*

Allowed node host list:
10.138.50.23

Membership coordinator: 10.138.50.23

Standby priority host list:
(List is empty.)

Promote Status:

Did not find XLog location for any non-idle nodes.

Idle Node Status (idle nodes ignored in XLog location comparisons):

Address XLog Loc Info
--------------------------------------------------------------
10.138.50.23 UNKNOWN The server does not support SSL.
[root@SG******** efm-3.4]#

Highlighted
EDB Team Member

Re: EDB-EFM-REPLICATIONS

Hi Din, 

 

I kindly request you to please provide some more information or please go through below. 

 

1. Did you setup streaming replication and both master and slave are in sync...?

2. Please read parameter descriptions available in efm.properties file. And read efm documentation for more information. Please assign valid values to efm parameters.

3. If your database doesn't accept SSL, Please turn off this on efm. (jdbc.sslmode=disable)

4. Please make sure all files(efm.properties, efm.nodes) having proper permissions before setting up efm cluster. 

 

Among below is one of the way you can setup efm cluster after pre-requisites done:

 

a. Start efm service on master

2. Send allow node to slave from master. 

3. Add master and slave node ip address(ip:bindaddress- ex: 192.168.1.100:7800) in efm.nodes file on slave

4. Then start slave server efm service. Check cluster status.

5. Send allow node to witness from master. 

6. Add master and slave node and witness node ip address(ip:bindaddress) in efm.nodes file on witness

7. Then start witness efm service. Check cluster status.

 

Please let us know if you need anymore information. 

 

Regards

Siva.

 

 

 

 

 

 

Level 3 Adventurer

Re: EDB-EFM-REPLICATIONS

Hi Siva,

        AS per your below command.i added the bind ip in efm.node file and have valid permission.

 

1.Did you setup streaming replication and both master and slave are in sync...?

Yes.Master and slave in Sync.

2. Please read parameter descriptions available in efm.properties file. And read efm documentation for more information. Please assign valid values to efm parameters.?

    Yes,i configure the valid parameters as per my old projects..

3. If your database doesn't accept SSL, Please turn off this on efm. (jdbc.sslmode=disable)?

    Okie,but if i will set disable any proble in this connection ,becuase in my old project efm2.0 it in verify-ca is there(little confused).

4. Please make sure all files(efm.properties, efm.nodes) having proper permissions before setting up efm cluster. 

      yes all are in proper permissions.  eg.chmod 644 efm.properties,chmod 666 efm.nodes

                  --

Ok after done as per your command.

 

[root@SGATRUATDB03 efm-3.4]# /usr/edb/efm-3.4/bin/efm cluster-status efm
Cluster Status: efm

Agent Type Address Agent DB VIP
-----------------------------------------------------------------------
Idle 10.138.50.23 UP UNKNOWN 10.138.50.101*
Idle 10.138.50.24 UP UNKNOWN 10.138.50.101
Witness 10.138.50.25 UP N/A 10.138.50.101

Allowed node host list:
10.138.50.23 10.138.50.24 10.138.50.25

Membership coordinator: 10.138.50.23

Standby priority host list:
(List is empty.)

Promote Status:

Did not find XLog location for any non-idle nodes.

Idle Node Status (idle nodes ignored in XLog location comparisons):

Address XLog Loc Info
--------------------------------------------------------------
10.138.50.24 UNKNOWN The server does not support SSL.
10.138.50.23 UNKNOWN The server does not support SSL.
[root@SGATRUATDB03 efm-3.4]#

 

 

 

FYI:-

Try to start after seeting ssl disable in efm.properties file..cannot start in efm.service in Master node.

The errror is:-

4/22/19 10:50:47 AM Starting agent.
4/22/19 10:50:47 AM Database user validation failed. Cannot start agent. Check logs for more details.
4/22/19 10:50:47 AM 2019-04-22 10:50:47,353 Notification-ShutdownHook WARN Unable to register Log4j shutdown hook because JVM is shutting down. Using SimpleLogger
4/22/19 10:52:58 AM Starting agent.
4/22/19 10:52:58 AM Database user validation failed. Cannot start agent. Check logs for more details.
4/22/19 10:52:58 AM 2019-04-22 10:52:58,867 Notification-ShutdownHook WARN Unable to register Log4j shutdown hook because JVM is shutting down. Using SimpleLogger

 

 

 

Level 3 Adventurer

Re: EDB-EFM-REPLICATIONS

Hi @sivamekala  @bbissett 

             This post show "its yesterday updated" please advice me on this..

 

Thanks

EDB Team Member

Re: EDB-EFM-REPLICATIONS

I would advise you send the current logs/steps to your support contact. I *think* you posted something from the efm startup log but not the agent log that has the full details.

 

Bobby

 

EDB Team Member

Re: EDB-EFM-REPLICATIONS

 


@Din2pg wrote:

Hi @sivamekala  @bbissett 

             This post show "its yesterday updated" please advice me on this..

 

Thanks


 

Please, you don't need to include me directly. If you need help right away, contact your support person. I help here when I'm available.

 

Bobby