meteor-mysql-leaderboard
meteor-mysql-leaderboard copied to clipboard
Client Updates Not Sticking / Server Updates Not Propagating
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.
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
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.
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.
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
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.
I am seeing the same issue on OSX. I am using mysql version 5.6.22 installed with homebrew.
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