ISPConfig 3 internal replication

Discussion in 'Developers' Forum' started by coxtech, Nov 21, 2010.

  1. coxtech

    coxtech New Member

    Good afternoon,

    Can anybody answer me how internal replication of ISPConfig 3 works?

    I have 2 issues with that staff in general

    1) I did some local application what use ISPConfig mail tables, like Relay Recepients, Transport and SPAM White/Black lists, but when I'm insert some info
    to the my master server it's not replicated to the slave server (copy of the master server)

    2) Second thing is that this mechanis create a databases at the secondary server, but only DB, no tables strucrute and data.

    as you understand, I have 2 servers, master and slave(which should be copy of the master server, configuration done as you recomended in the HowTo, mirror setup)

    Thanks for the your help and perfect product!
  2. coxtech

    coxtech New Member

    this one is clear for me now.

    Can somebody tell me if it's possible to replicate databases from master (to sync server) via internal replication?

  3. till

    till Super Moderator Staff Member ISPConfig Developer

    1) You have to use the datalogInsert and datalogUpdate functions from the mysql database class from ispconfig to manipulate the data to get it replicated to the slave servers.

    2) Same then 1). Create the record in the web_database table for the new database with the datalogInsert function.
  4. serverstage

    serverstage New Member

    Skipping a Column in Replication?

    I'm working on a web ftp application and want to
    add a column to the ftp_user table only on my master server.

    This breaks replication, so I need to skip this record while the datalog is being built.

    Could I get a hint where to place this skip please?
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    The replication requires it that all databases in the cluster have the same columns. The best way is to add the additional column to the slave database as well as there is no way to skip a column as the replication is handled for all tables by a single function which creates objects of the old and new database record. For details take a look at the datalog* functions in the mysql database class in the ispconfig interface.

Share This Page