ISPConfig 3 internal replication

[coxtech]

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!

[coxtech]

Good afternoon,
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)


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?

Thanks!

[till]

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.

[serverstage]

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?

[till]

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.