Summary: in this tutorial, you will learn how to use adjacency list model for managing hierarchical data in MySQL. Introduction to adjacency list model Hierarchical data is everywhere. It can be blog categories, product hierarchies, or organization structures. There are many ways to manage hierarchical data in MySQL and the adjacency list model may be […]
If you’re not a programmer, you’re probably not going to know this, but there’s a vicious rivalry lurking in the code of every app you use. If code isn’t written consistently—using either the tab or the space button to create indentations—the format can get all wonky, making it difficult for multiple authors to contribute to the code. While the methods produce virtually the same result, lines have still been drawn.
On one side are the tab fanatics, like Richard in HBO’s Silicon Valley. On the other side is everyone else—those who use the space bar. But now, thanks to science, the fight may finally have its knockout punch: space fans apparently make more money with their code than tab fans. Which means there really is one winner.
This news comes from Stack Overflow—a popular online resource for developers—which issued a survey earlier this year to programmers. Of 28,657 respondents, a little less than half of whom also provided their salaries, Stack Overflow learned that 41.8 percent of devs use spaces for indentations, while 40.7 percent use tabs. That’s a fairly even split, and different than the results we saw last year, when a dev sourced all their space vs tabs data from GitHub and found that an overwhelming majority of users preferred spaces.
While the findings from GitHub and Stack Overflow don’t match exactly, spaces were victorious in both, and when it came to Stack Overflow, spaces won out in more ways than one. If you’re looking to make some bank, then using spaces over tabs will, statistically, result in an 8.6 percent higher salary. That number takes into account a wide number of variables including country of residence, education and language. But even considering all those factors, the pay discrepancy amounts to approximately 2.4 years more experience than a tab user. In other words, according to these numbers, if you’re a 24-year-old space coder, you’d be making about as much as a 26-year-old tab coder.
In hard cash terms, the median salary of the space developers was $59,140, while the median salary of tab developers was a gonna-struggle-to-survive-in-Silicon-Valley $43,750.
Advertisement
Advertisement
David Robinson, the Stack Overflow data scientist who revealed these numbers, cautioned in his post, as we would, that “correlation is not causation.” While Robinson makes an effort to account for many variables, including location, experience, language type, and even formal education, he cannot account for everything. Perhaps all space users, no matter when they live in the world, are just born with a silver spoon stuck in their mouth and are more prone to make extra money. Or maybe white men use spaces while white women and people of color use tabs.
If you’re a data scientist yourself, or a tab person burning with something to say, than you can download the raw survey data yourself and double check Robinson’s numbers. For those of us who want to roll around in money, however, the answer is clear.
This tweet is a request for ideas. I’m thinking about a philanthropy strategy that is the opposite of how I mostly spend my time — working for the long term. For philanthropy, I find I’m drawn to the other end of the spectrum: the right now. As one example, I’m very inspired and moved by the work done at Mary’s Place here in Seattle. I like long-term — it’s a huge lever: Blue Origin, Amazon, Washington Post — all of these are contributing to society and civilization in their own ways. But I’m thinking I want much of my philanthropic activity to be helping people in the here and now — short-term — at the intersection of urgent need and lasting impact. If you have ideas, just reply to this tweet with the idea (and if you think this approach is wrong, would love to hear that too).
Thanks!
Jeff
After I see what you all come up with, and after I edit out the most brilliant ideas, I’ll tweet back your responses to him. I’ll come up with something of my own as well.
E3 2017: Nexon’s Durango exiting long development, releases for iOS in tail-end of 2017
By Mike Wuerthele Wednesday, June 14, 2017, 06:05 pm PT (09:05 pm ET)
Nexon’s survival title “Durango” has made an appearance at the 2017 E3, showing off a combination of isometric role-playing and survival in a creature-infested post-apocalyptic world.
The open-world isometric-view title from Nexon takes place in a world populated by dinosaurs and other similarly prehistoric creatures. Players are forced to gather resources to survive, and can band together for larger projects and building construction.
Developers Nexon call it a “pioneering open-world massively multiplayer online role playing game” with a focus on crafting, and camp settlement. While solo play is possible, Nexon encourages group-play as other player assemblies can be cooperative, or hostile to the player.
The new trailer released at E3 features a dinosaur attack on a commuter train, and showcases the many survival mechanics of “Durango,” including fishing, harvesting materials, farming, settlement building, and crafting. Also shown are some of the ways players can team up to tame wild dinosaurs.
VIDEO
The early beta on Android in January garnered players mostly from Korea and Thailand. The title will arrive worldwide on iOS at some point in the fourth quarter of 2017.
Hardware requirements are not yet known for the finished title, but the game was spotted running at E3 on an iPad Air 2.
Many thanks to everyone who registered and/or participated in Tuesday’s webinar on backup strategies and best practices for MySQL, MariaDB and Galera clusters led by Krzysztof Książek, Senior Support Engineer at Severalnines. If you missed the session, would like to watch it again or browse through the slides, they’re now online for viewing. Also check out the transcript of the Q&A session below.
Whether you’re a SysAdmin, DBA or DevOps professional operating MySQL, MariaDB or Galera clusters in production, you should make sure that your backups are scheduled, executed and regularly tested. Krzysztof shared some of his key best practice tips & tricks yesterday on how to do just that; including a live demo with ClusterControl. In short, this webinar replay shows you the pros and cons of different backup options and helps you pick the one that goes best with your environment.
Happy backuping!
Questions & Answers
Q. Can we control I/O while taking the backups with mysqldump and mysqldumper (I’ve used nice before, but it wasn’t helpful).
A. Theoretically it might be possible, although we haven’t really tested that. If you really want to apply some throttling then you may want to look into cgroups – it should help you to throttle I/O activity on a per-process basis.
Q. Can we take mydumper with ClusterControl and is ClusterControl is free software?
A. We don’t currently support it, but you can always use it manually; ClusterControl doesn’t prevent you from using this tool. There is a free community version of ClusterControl, yes, though its backup features are part of the commercial version. With the free community version you can deploy and monitor your database (clusters) as well as develop your own custom database advisors. You also have a one-month trial period that gives you access to all of ClusterControl’s features. You can find all the feature details here: http://ift.tt/2qeERU7
Q. Can xtrabackup work with data-at-rest encryption?
A. It can work with encrypted data in MySQL or Percona Server – it is because they encrypt only tablespaces, which xtrabackup just copies – it doesn’t have to access contents of tablespaces. MariaDB encrypts not only tablespaces but also, for example, InnoDB redo logs, which have to be accessed by xtrabackup – therefore xtrabackup cannot work with data-at-rest encryption as implemented in MariaDB. Because of this MariaDB Corporation forked xtrabackup into MariaDB Backup. This tool supports encryption done by MariaDB.
Q. Can you use mydumper for point-in-time recovery?
A. Yes, it is possible. mydumper can store GTID data so you can identify last applied transaction and use it as a starting position for processing binary logs.
Q. Is it a problem if we use binary logs with xtrabackup with start-datetime and end-datetime instead of start-position and end-position? We make a full backup on Fridays and every other day an incremental backup. When we need to recover we take the last full and all incremental backups and the binary logs from this day starting from 00:00 to NOW … could there be a problem with apply-log?
A. In general, you should not use –start-datetime or –end-datetime when you want to reply binary log on the database. It’s not granular enough – it has a resolution of one second and there could be many transactions that happened during that second. You can use it to minimize timeframe to look for manually, but that’s all. If you want to replay binary logs, you should use –start-position and –end-position. Only this will precisely define from which event you will replay binlogs and on which event it’ll end up.
Q. Should I run the dump software on load balancer or one of the MySQL nodes?
A. Typically you’ll use it on MySQL nodes. Some of the tools can only do just that. For example, Xtrabackup – you have to run it locally, on the database host. You can stream output to another location, but it has to be started locally.
Q. Can we take partial backups with ClusterControl? And if yes, how can we restore a backup on a running instance?
A. Yes, you can take a partial backup using ClusterControl (you can backup separate schema using xtrabackup) but, as of now, you cannot restore a partial backup on a running instance. This is caused by the fact that the schema you’d recover will not be consistent with the rest of the cluster. To make it consistent, the cluster has to be bootstrapped from the node on which you restore a backup. So, technically, the node runs all the time but it’s a fairly heavy and invasive operation. This will change in the next version of ClusterControl in which you’d be able to restore backups on a separate host. From that host you could then dump contents of a restored schema using mysqldump (or mydumper) and restore it on a production cluster.
Q. Can you please share the mysqldumper command?
A. It’s rather hard to answer this question without doing copy and paste from the documentation, so we think it will be the best if we’d point you to the documentation: http://ift.tt/2rkeP32
We are getting reports of an active shooter situation at Travis Air Base base just outside Fairfield, California.
Officials at the base posted the following statement on the Travis AFB Facebook page just before 3:30 p.m.:
“Travis Air Force Base is currently responding to a security incident,” Fairfield Police Department said this afternoon. “More details will be released as they become available. The public is being asked to stay away from the base to ensure emergency responders can respond accordingly.”
Travis AFB had been conducting exercise drills earlier today, but officials at the base have confirmed this is a “real world security incident,” not a drill.
Security alert @Travis60AMW. Shelter in place. Lock doors/windows. Await further info. Follow Travis Facebook page for updates.
Big Bada Boom!Eclectic Method’s catchy EDM track is chopped up from sound bites from Luc Besson’s cult classic, and it actually sounds like a track which might have been played in a dance club in the world in which Korben, Leeloo, and Ruby Rhod reside in.
When the Smith & Wesson M&P22 was rolled out in 2011 many shooters rejoiced that there was a new full size .22 on the market that closely resembled a centerfire handgun. At the time of its introduction, the number of choices in that segment was rather limited. In this episode of TFBTV, Patrick pulls the […]
Hope you have been following our recent webinars on MySQL, Galera Cluster, AWS monitoring and more.
We are coming up with a webinar series in association with Eric Vanier, a leading MySQL expert consultant. The series will provide a step-by-step process to optimize MySQL database performance.
This webinar series is for everyone who is looking for ways to monitor their MySQL databases, simplify the process to manually analyze queries and achieve faster issue resolution time.
Eric Vanier will focus on key problem areas that are faced by DBAs and Shree will provide a solution-driven demonstration to overcome issues while monitoring the database performance. To make it simple, the series will comprise of three parts:
Part – 1: MySQL Performance Tuning
26 June; 10:00 am Eastern time
Troubleshooting a MySQL server performance problem is often a tedious activity as it’s difficult to figure out where to start and how to cope up with it. In the case of an increase in the volume of data and load on the server, the queries tend to run slower and deadlocks become a frequent occurrence.
In this webinar, you will learn the following:
– 3 different ways to identify slow queries.
– Spot query performance pattern over a particular period.
– Proactive monitoring by setting up server/ tag specific alert.
– Fetching deadlock information.
– Monitor MySQL log files on a remote machine.
– Product comparison between Monyog and MySQL Enterprise Monitor.
Part – 2: Real-time monitoring and RDS file-based log monitoring
03 July; 10:00 am Eastern time
Many of our customers use Monyog to help monitor data in real-time and find the problematic queries. Moreover, Monyog is the only tool that provides file-based log monitoring for Amazon RDS for MySQL & Aurora on RDS.
In the 2nd part of our webinar series, you will learn the following:
– Analyze queries without slow query file.
– Monitoring queries in real-time.
– Monitor log files for RDS instances.
– Performance overhead caused by Monyog.
– Hardware requirement for Monyog.
– Monyog architecture.
Part – 3: Achieve faster issue resolution time
10 July; 10:00 am Eastern time
In this final part of the webinar series, we will focus on effective practices of monitoring MySQL databases using Monyog. This will provide as in-depth learning session for making the best of the monitoring tool.
Learn the following in this webinar:
– Using explain plan in Monyog.
– Quickly monitoring database and tables size.
– Create Monyog users with restricted access and privileges.
– Minimize the data generated by Monyog.
– Create aggregated report of the data collected in Monyog.