I like namecheap
Posts made by lance
-
RE: IT Quotes I Like
@scottalanmiller said:
@lance said:
It is neither rude nor condescending to trust someone and assume that they did use common sense themselves. -Scott Alan Miller
Love it, any idea when or where I originally said it?
It's good stuff. Here is a link https://community.spiceworks.com/topic/122118-virtualization-can-i-host-a-64-bit-vm-on-a-32-bit-host?page=2
-
RE: IT Quotes I Like
It is neither rude nor condescending to trust someone and assume that they did use common sense themselves. -Scott Alan Miller
-
RE: When to use SQL or NoSQL
@mlnews said:
If you are interested in learning more about NoSQL, I highly recommend this book (and highly recommend buying it directly from the awesome publisher....)
Thanks! It looks like this is my next book to buy!
-
RE: When to use SQL or NoSQL
@tonyshowoff said:
We deal with both MySQL and a few different NoSQL databases as well. It really depends on the scenario, but if you don't know, then you can just use a regular relational database.
In general though you don't need a lot of data to justify MongoDB or Cassandra (we use both, though we're slowly transitioning to only Cassandra), in the same way you don't need to be doing relational or financial things to justify MySQL or anything like that.
NoSQL works best for key-value store, as in you already know the information you want, it likely isn't directly related to anything else and so probably doesn't need to be joined (joins tend to be very expensive in NoSQL if supported at all), and you don't need to worry too much about the same level of consistency. So some examples:
- Sessions
- Logs or user activity
- Expensive but rarely rebuilt things from your relational database for permanent caching
There's also the issue of heavy writing, as NoSQL databases tend to be faster at writes than reads, which is why we use it for really write heavy things that either we do not need back right away or we allow the user to keep (when they make a comment, show it based on what they put, instead of getting it back, for example).
Relational databases can be used for all the same things as NoSQL databases and many actually do a fairly good job at it, and you don't really need to worry about the differences until you get hundreds of thousands or millions of requests (like us) per day.
Aside from that MySQL (and others) have been around for years, are highly tested in large environments, etc and anything which is relational, would need to be associated with things in other tables (foreign key scenario for example), dealing with financial information, etc.
When you don't know or don't have the environment or resources to test, then always just use your relational database, it's probably the right choice anyway.
If you are curious, in our environment for our adult content sites, we've got about 630 servers so and we use MySQL, MongoDB, Cassandra, and memcached (and Apache, nginx, and PHP), and our other products and services we use similar setups but usually either MongoDB or Cassandra, and like I said we're trying to transition to it as we've gotten more out of it and better performance for us. I've noticed a lot of issues with MongoDB and returning things in reverse order (even with a reverse index) and also paging this way, it's painfully slow compared to Cassandra (1 - 2 seconds compared to 400ms or so; doesn't seem like a lot, but keep in mind that's on top of other loading, so loading new comments or whatever on some of our older sites is up to 3 seconds, and most people start to feel things are "too slow" after about half a second.), so I suggest maybe not even bothering with MongoDB unless it fits some other scenario of yours.
Thanks for the info!
-
RE: Do you use emoticons in work e-mail?
Depends who I am connecting with, if I know the person well I might use them otherwise not so much.
-
RE: When to use SQL or NoSQL
Thanks for the info, it really helps a dev noob like me. I'm writing a web app in a couple months for someone and the past couple web applications I've developed I've done in PHP and mySQL. I really want get some experience with node.js and javascript, so I am hoping to deploy a MEAN stack for my next application and use MongoDB, but I've never touched a noSQL before.
-
When to use SQL or NoSQL
When is the best to use NoSQL database vs a SQL database? From some of the articles I lightly read it seems that NoSQL is more used for extremely large databases. Just looking for a good run down on NoSQL vs SQL.
-
RE: Four New Chromebooks from Google
@scottalanmiller I had a laptop from gateway(a long time ago) that had a flip screen, I don't thinkI ever flipped it either.
-
RE: Four New Chromebooks from Google
For some reason I just don't like things like the flip, devices like the flip just never seemed to work well for me for a long period of time.
-
RE: Just Sysadmin Things... for which I've been reprimanded
@lance said:
"I'm still a little drunk" is not an approiate answer when asked how the late night server maintenance went.
lol
-
RE: Just Sysadmin Things... for which I've been reprimanded
@lance said:
Printing and hanging a Certificate of Failure when a coworker brings down a server isn't funny.
Is one of my favorites