Discussions

MySQL replication not running updates in binlog

I have a number mysql servers running version 5.1.63 and whilst running some queries against the slave earlier this week, I noticed some data on the slave that should have been removed using an update statement on the master. My initial thoughts were: someone on the team was updating the slave, which I have since disproved that the column being updated had changed So, I investigated by running a mysql show status "table" query. This was run against a test database on each of the servers to see what the data length was, in a lot of cases it was showing me the data length differed between servers, but on an eyeball look at the data I could see the data was the same, so I couldn't use this method to see if there were any differences as it appears to be prone to error. Next I ran a simple (across all dbs) row count for each table to confirm the row count was the same - it was. I then started looking in the bin logs for replication. I could see the update statements that should have run clearly visible in the logs, but the update never ran. What I need to know is: is replication broken? I'm assuming it is if I create new slave servers, will I encounter the same issue? how do I find out the extent of the issue on my servers? Any help is appreciated.

How to use user variable as counter with inner join queries that contains GROUP BY statement?

I have 2 tables odds and matches : matches : has match_id and match_date odds : has id, timestamp, result, odd_value, user_id, match_id I had a query that get the following information from those tables for each user: winnings : the winning bets for each user. (when odds.result = 1) loses : the lost bets for each user.(when odds.result != 1) points : the points of each user.(the sum of the odds.odd_value) for each user. bonus : for each continuous 5 winnings i want to add extra bonus to this variable. (for each user) How to calculate bonus? I tried to use this query and I faced a problem : (you can check it here SQL Fiddle) the calculated bonus are not right for all the users : first user:(winnings:13, bonus=2). second user:(winnings:8, bonus=2)bonus here should be 1. third user:(winnings:14, bonus=3)bonus here should be 2. why does the query not calculate the bonus correctly?

Indonesian Food

FriedRice is the one of the best Food in Indonesian. Do You Agree with my Statement? :)

What's New?

what's new on the internet?

What's Trending?

Any Latest and Hottest events that we might not know? Feel free to share it with us.

Code in your chosen Language and Win Prizes: CodeChallenge

Challenge yourself. Code in your chosen language, optimize your algorithm, and win prizes as you go. Join us here at CodeChallenge Codechallenge.com is built on the crowdsource gamification mix which allows people to create challenges on Codechallenge.com, share Codechallenge.com challenges and crowd source those challenges to be able to gain rewards.

Five Rules for Texting Anyone You Do Business With

Walk into any boardroom two minutes before a meeting and you’ll find the same scenario: a table full of executives checking their phones with their heads bowed in the “smartphone prayer.” Text messaging is the fastest way to communicate in business. Quicker than email and more convenient than a phone call, it’s become commonplace. But it’s not always the best choice. Choice of text message for simple notifications or reminders like “I’m running five minutes late,” or “Remember to bring the report.” has a general rule. Consider texting only appropriate for a maximum of two messages -- one message and one reply. Here are five rules to avoid a business text message blunder. 1. Keep it positive. Like email, the tone of a text message can be misinterpreted by the recipient. Quick messages can make you come off as flippant or harsh. Instead of staccato phrases, write complete sentences. Add polite touches like “please” and “thank you.” Re-read every message before pressing send to double-check your tone (bonus: no embarrassing typos). 2. Avoid serious topics. You wouldn’t break up with your girlfriend over a text message -- to be clear, you should not -- and the same goes for business. Never give negative feedback or fire someone via a text message. Any serious conversation should take place face-to-face. It allows for subtle interaction through facial expressions and will ensure clear communication. 3. Don’t abbreviate every other word. Abbreviations are common in casual texts, but you should be careful how often you use them. Common abbreviations like “LOL” (laugh out loud) and “np” (no problem) are safe choices. However, if you’re communicating with a new customer or acquaintance, take 30 extra seconds and type out each word. Avoid informal shortcuts like “u” (you) and less common abbreviations like “SMH” (shaking my head) or “MFW” (my face when). Don’t leave your clients and colleagues confused; your texts should convey messages quickly and clearly. 4. Don’t text a last-minute cancellation. There are a thousand reasons someone may miss a text message. Don’t depend on a quick note to cancel a meeting or change a lunch venue. For an important or time-sensitive message, pick up the phone. 5. Double-check the auto correct. Smart phones can occasionally be a little too smart. Auto correct and voice-to-text features have a sneaky way of changing your intended message into something entirely different and often embarrassing. When using voice-to-text, ensure you’re in a quiet location. It picks up on background noise and may type a nearby conversation instead of what you’re saying.

What are you Most looking Forward to in 2015?

More online connectivity is highly on my list, but how about you?

Bermuda Triangle in the South Pacific?

There are already two missing planes within that area. There are talks about aliens and talks about bermuda triangle but what really happened to those two planes??

SwitchCam Dead, Facebook does Acquihires

Facebook’s mobile video feature is pretty awful. No multi-shot recording, stabilization, or editing. Hopefully it will get an update soon, though, as a source has tipped me off that last month Facebook hired the founders of Switchcam, a startup that specialized in video sharing. The founders Chris Hartley and Bret Welch both now list Facebook as their employer, and Switchcam has been shut down.

National Roads and Motorists Association launched Jumpstart

Startup accelerator Slingshot, in partnership with the National Roads and Motorists Association, has launched Jumpstart, a new accelerator program that is looking for smart services, connected cars, connected members and member lifestyle startups. The 12-week structured program will take on 10 startups and offer $30,000 in seed funding in exchange for 10% equity, potential access to more than 2.4 million NRMA members, and workspace at hubs in either Sydney or Newcastle. http://www.slingshotters.com/ This is a great way to possibly partner with some of our motoring/auto brands - automations.com, motorcentre.com. What do you think?

Art Startups on the Rise?

According to a report by Deloitte and ArtTactic published last year, the art world is seeing a shift towards the internet with more than 300 online ventures launched in recent years covering everything from data to social communities and auctions to B2B art transaction platforms. Buying art online is another growing trend. In a research released by Hiscox group last April, the report saw 71% of art collectors surveyed buying artwork without seeing it in person first but basing their purchase decision on a digital image. So it’s no surprise that online art marketplaces are currently a popular space for entrepreneurs and becoming more and more crowded. Additionally, established players (particularly, art auction house Christie’s) are increasingly turning to digital and internet giants are eyeing down the space with interest (see: Google’s Open Gallery initiative and Amazon Art). With technology in the picture, art is gradually becoming more accessible to the general public, providing artists with more channels to reach buyers and democratizing the art world. We currently have some great art/culture brands such as artistzone.com and artcommunity.com which could be developed to talk about these rising art startups.

How to have higher ranking in search engines?

I have a domain and I have no idea how to make people visit my site.

How do you avoid attacks on WP sites?

I'm new in using WP and I've heard a lot about it being prone to hacking. Can you share to me and everyone how you secure your sites?

Do you think Cookboard.com's model could work?

We need help with the current model of Cookboard - which allows home cooks to sell they're dishes to the community

What is Contrib

With Contrib, we let the crowd have a say by pushing ideas to the network, which then gets supported upon by the whole community. You can join and apply for a position in a team or work with eServices tasks for micro payments. You can partner with a brand or simply follow its progress. Our simple brand builder allows brand and co-owners to quickly turn a $9 domain to a full fledged business through a series of custom and default frameworks straight from the developers network. Data coming in from all the brands and different servers is housed upon a cloud infrastructure that allows total security and control of data in and out of the data warehouse.