Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Load Balancing

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Load Balancing

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • January 22, 2010 at 2:49 pm #11843
      slytay
      Member

      I'm actually mysql proxy for load balancing replication, and i noticed that when i 'm creating the temporary table on the master, i do not have the temporary table on the slaves.

      Have you any idea of fix the problem.?

    • January 22, 2010 at 4:36 pm #30359
      peterlaursen
      Participant

      Basically you should ask this question to MySQL (in the MySQL Forums for instance) and not to us. But according to http://dev.mysql.com/doc/refman/5.1/en/replication-features-temptables.html temporary tables are replicated. If failing when using the proxy it could be because the proxy (LUA) script you are using are not supporting this properly.  From where did you get this LUA script?

      If you have a clearly reproducible test case you may report to http://bugs.mysql.com if you think it is a bug with the proxy or a official MySQL LUA script for the proxy.

      But no guarantee either that is is not a server bug with the server version you are using.  Are you sure that without proxy it replicates?

      One workaround I can think of is to use MEMORY tables (what is not the same as temporary tables) if possible with your scenario.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.