meteor-mysql-leaderboard icon indicating copy to clipboard operation
meteor-mysql-leaderboard copied to clipboard

Published 20 hours ago • verified publisher icon numtel

Client Updates Not Sticking / Server Updates Not Propagating

Open merlinstardust opened this issue 9 years ago • 7 comments

Client Updates Not Sticking When I add points to a player, the points appear on the screen and the change is propagated to the server but when I hard reload or open a new tab the page, the change disappears.

Server Updates Not Propagating When I insert a new row into the players table, that player does not appear on the client immediately. That new player also does not appear even when I hard reload the browser or open a new tab.

merlinstardust avatar Jun 14 '15 04:06 merlinstardust

I checked it one more time in my fork of this (https://github.com/tandrew/meteor-mysql-highchart-reactive.git) and It works just fine.

Did you set the MySQL database to run in binlog mode? Check here: https://github.com/numtel/mysql-live-select

tandrew avatar Jun 14 '15 08:06 tandrew

Do you have to set that for each specific database? I thought you only needed to enable it for the server as a whole, which I did.

merlinstardust avatar Jun 14 '15 13:06 merlinstardust

No, you set it for the whole DB as you probably did. Have you checked that it is writing the binlogs?

On 14 Jun 2015, at 15:05, Merlin Patterson [email protected] wrote:

Do you have to set that for each specific database? I thought you only needed to enable it for the server as a whole, which I did.

— Reply to this email directly or view it on GitHub https://github.com/numtel/meteor-mysql-leaderboard/issues/6#issuecomment-111824969.

tandrew avatar Jun 15 '15 07:06 tandrew

Yes, there is a mysql-bin.00001 file with all the insertions that I've done. I should note that I'm not using numtel's meteor-mysql-server package but I didn't think that should be a necessity

merlinstardust avatar Jun 15 '15 15:06 merlinstardust

Hi merlinpatt, the same happens to me with an AWS RDS Mysql, with the binlog parameter correctly set to ROW. I didn't try any other mysql setup so far and I guess the issue is tied to specific environments... Maybe something related to mysql version.

tobiaghiraldini avatar Jul 19 '15 11:07 tobiaghiraldini

I am seeing the same issue on OSX. I am using mysql version 5.6.22 installed with homebrew.

navjeetc avatar Dec 13 '15 07:12 navjeetc

After I added the following settings to mysql .cnf file. an update directly made to mysql table is reflected in web app now

server-id = 1 binlog_format = row log_bin = /my/dir/bin.log

navjeetc avatar Dec 13 '15 07:12 navjeetc