• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login

Fog Node mysql connection back to fog server

Scheduled Pinned Locked Moved Unsolved
FOG Problems
3
5
493
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M
    Malos
    last edited by Mar 26, 2018, 5:47 PM

    Hello! A few of my sites have a crummier than normal WAN connection, and the FOG Node’s connection back to the master server on port 3306 is using up a not-small percentage of the overall traffic utilization.

    In my environment, the clients report back into the master server, and the local storage nodes are serving up tftp boot files and also keeping replicated copies of images so they’re not imaging over the wire.

    What’s this mysql connection effectively used for?

    Is there any way to reduce it, or eliminate it all together?

    1 Reply Last reply Reply Quote 0
    • G
      george1421 Moderator
      last edited by george1421 Mar 26, 2018, 11:52 AM Mar 26, 2018, 5:51 PM

      The port 3306, is mysql server traffic. The storage nodes don’t have their own mysql database. They are reaching out to the master node for instructions from its database. But I wouldn’t think this traffic would be very much. I would tend to think the fog client check-ins to the master node or something wrong with the replicator where it continues to replicate with no changes would consume more bandwidth that the mysql queries.

      Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!

      1 Reply Last reply Reply Quote 0
      • M
        Malos
        last edited by Mar 26, 2018, 9:05 PM

        0_1522098155570_test.PNG

        Yeah, I figured client check-ins would take more bandwidth as well but nope! The yellow in this graph is all 3306 node to master traffic. All of the sites do this actually, it’s just particularly noticable in this location due to the current sub-par DSL connection (replacing it is a WIP).

        And, I didn’t include it previously but will now, they’re all running Fog 1.4.4 on Ubuntu 16.04. No replication is going on at present

        1 Reply Last reply Reply Quote 0
        • S
          Sebastian Roth Moderator
          last edited by Mar 27, 2018, 5:56 AM

          @Malos So is your question answered properly?

          Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

          Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

          1 Reply Last reply Reply Quote 0
          • M
            Malos
            last edited by Mar 27, 2018, 6:19 PM

            Is there a way to reduce how often the fog node’s are checking back into the master server’s mysql?

            1 Reply Last reply Reply Quote 0
            • 1 / 1
            1 / 1
            • First post
              4/5
              Last post

            156

            Online

            12.0k

            Users

            17.3k

            Topics

            155.2k

            Posts
            Copyright © 2012-2024 FOG Project