Question on "Installing A Web, Email & MySQL Database Cluster On Debian 6.0 With ISP3

Discussion in 'HOWTO-Related Questions' started by biggdog, Aug 7, 2014.

  1. biggdog

    biggdog Member

    I have a firewall forwarding the port to my mail server. Do I still forward it to the "Master" server or do I forward to the "Slave" server.

    "Installing A Web, Email & MySQL Database Cluster On Debian 6.0 With ISPConfig 3"

    Is the slave just a mirror of the master in-case of failure?
    Or should the first stop in the port forward be the slave and then the master????

    Does it matter?
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    This does not matter, you can even use both at the same time.
     
  3. biggdog

    biggdog Member

    Thanks for the reply. Was not sure it mattered but I do thank you for your quick reply.

    Have a good day.
     
  4. biggdog

    biggdog Member

    New possible problem

    Ok the process tells me to do this

    "Log into the MySQL shell as root user...

    mysql -u root -p

    ... and execute this command in the MySQL shell...

    SHOW MASTER STATUS;

    ... to get the MySQL master status:

    mysql> SHOW MASTER STATUS;
    +------------------+----------+--------------+------------------+
    | File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
    +------------------+----------+--------------+------------------+
    | mysql-bin.000002 | 106 | | |
    +------------------+----------+--------------+------------------+
    1 row in set (0.00 sec)"

    Mine comes up with "mysql-bin.000001" Instead of 000002

    Please tell me it is no problem or at least let me know what I need to do to fix this.

    Thanks in advance.
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    Thats ok. The filename may differ.
     
  6. biggdog

    biggdog Member

    Thanks for your reply.
     
  7. biggdog

    biggdog Member

    "Till" I am wondering, I have a Linux Firewall that forwards all email traffic to my mail server. Should I have all mail go to the master server first or should I have it go to the Slave server first or does it matter.
     
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    This does not matter in this setup.
     
  9. sjau

    sjau Local Meanie Moderator

    why are you going with Debian 6? Debian 7 has been declared stable for a long time while Debian 6 is oldstable meanwhile.
     
  10. biggdog

    biggdog Member

    I would have gone with 7 but this setup is not updated and I do not know enough to justify trying it out on my own from scratch.
     
  11. sjau

    sjau Local Meanie Moderator

    it sounded like you were installing anew. I did upgrade from debian 6 to 7 and I don't recall having had issues.
     
  12. biggdog

    biggdog Member

    As I said I would have loved to do it in Debian 7 or even try upgrading but I am not to sure on how everything will work out and I am not that good in Debian as of yet to even find out if any problems did arise. I will keep my eye out for "Till" just to see if he does an updated version. I also may break out a new system and try to do it myself that way if I did encounter problems they will not be on my working server.

    Any info you have I would love to see it or give it a try. Thanks to all.
     
  13. biggdog

    biggdog Member

    Another question or two.

    1 - Monitoring with Monit and Munin. Can I install this and should I need to install it on both. I guess I am really asking if since this is a multi server set up should I always install on both systems?

    2 - Is there a way to incorporate DKIM into this setup?

    3 - Do I need to add the second server to the DNS records in ISPConfig? I do have the record in DYNDNS already?

    4 - Is there any reason I would need to get into the secondary server through ISPConfig? I did try to login but was not able to.

    Thanks.
     
  14. till

    till Super Moderator Staff Member ISPConfig Developer

  15. biggdog

    biggdog Member

    You are awesome. Thanks for your fast reply.
     

Share This Page