Sync ispconfig-tables from master-db to other servers

Discussion in 'General' started by bundfeg, Oct 21, 2021.

  1. bundfeg

    bundfeg New Member HowtoForge Supporter

    Hi there,
    I have several vms for different services. One thing, I would like to do, is using dbispconfig.mail-tables db-server-vm (admin-vm is the master). But since db-server is no mail-server, these tables are not being synced. And I don't know how to make a select statement over two different servers.
    So the (perhaps) easier solution seems to me, to get ISPConfig to sync these tables on other servers as well.
    Is there anything, I can do to get this? (activating db-server as mail-server? sounds like trouble...)
    Would love to hear pro-ideas ;-)
    Greetings
    Chris
     
  2. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    You could setup replication in mariadb so the tables from your mail server are copied to (a different database in) your db server. You can't perform a single query across multiple servers.
     
  3. bundfeg

    bundfeg New Member HowtoForge Supporter

    Thanks. I looked into it, but since I don't need anything like realtime, I went for it with dumping and importing the table by bash. For a once-a-day check, this is sufficient, I think ;)
     

Share This Page