Slashdot Mirror


Azure Goes Database Crazy With One New NoSQL, Two New SQL Services (arstechnica.com)

An anonymous reader quotes a report from Ars Technica: In its continued efforts to make Azure a platform that appeals to the widest range of developers possible, Microsoft announced a range of new features at Build, its annual developer conference. Many of the features shown today had a data theme to them. The most novel feature was the release of Cosmos DB, a replacement for, or upgrade to, Microsoft's Document DB NoSQL database. Cosmos DB is designed for "planet-scale" applications, giving developers fine control over the replication policies and reliability. Replicated, distributed systems offer trade-offs between latency and consistency; systems with strong consistency wait until data is fully replicated before a write is deemed to be complete, which offers consistency at the expense of latency. Systems with eventual consistency mark operations as complete before data is fully replicated, promising only that the full replication will occur eventually. This improves latency but risks delivering stale data to applications. Document DB offered four different options for the replication behavior; Cosmos DB ups that to five. The database scales to span multiple regions, with Microsoft offering service level agreements (SLAs) for uptime, performance, latency, and consistency. There are financial penalties if Microsoft misses the SLA requirements. Many applications still call for traditional relational databases. For those, Microsoft is adding both a MySQL and a PostgreSQL service; these provide the familiar open source databases in a platform-as-a-service style, removing the administrative overhead that comes of using them and making it easier to move workloads using them into Azure. The company is also offering a preview of a database-migration service that takes data from on-premises SQL Server and Oracle databases and migrates it to Azure SQL Database. Azure SQL Database has a new feature in preview called "Managed Instances" that offers greater compatibility between on-premises SQL Server and the cloud variant, again to make workload migration easier.

39 comments

  1. Dear microsoft by Anonymous Coward · · Score: 1

    The Check cleared the bank, thanks!

    Yours, Slashvertisement team

    1. Re: Dear microsoft by Anonymous Coward · · Score: 0

      Thank you good sir! You may all get back to calling everyone who isn't a diehard liberal a racist, sexist xenophobe!

      -Microsoft

    2. Re: Dear microsoft by Anonymous Coward · · Score: 0

      I don't know wtf a database is but did i tell you how I make $50k in Silicon Valley???

      -creimer

    3. Re:Dear microsoft by art123 · · Score: 1

      Or it could be that the annual Microsoft developer conference started today so there are a lot of announcements coming out, some of which are making their way to the Slashdot front page.

    4. Re:Dear microsoft by nyquil+superstar · · Score: 1

      I mean, I get what you are trying to do. But doesn't the fact that Microsoft is hosting their big, annual, worldwide developers' conference and announcing things that would be of interest to tech folks qualify as legitimate news?

  2. Cosmos DB new database Azure only? by JcMorin · · Score: 2

    If I want to try out Cosmos DB I have to pay an Azure subscription? As I can see, it's not a stand-alone product at all.

    1. Re:Cosmos DB new database Azure only? by Tablizer · · Score: 1

      They don't have "Cosmos Express", like their crippled "Express" version of MS-SQL-Server? (One core, limited size, no easy way to back-up, & missing misc. features.)

    2. Re:Cosmos DB new database Azure only? by phantomfive · · Score: 4, Interesting

      Amazon has a similar database in AWS (DynamoDB). These kinds of products are not a good idea unless you want to lock yourself in to the platform (or unless you know how to write a really, really good abstraction layer).

      --
      "First they came for the slanderers and i said nothing."
    3. Re:Cosmos DB new database Azure only? by vipw · · Score: 1

      On the other hand, the products have such a simple interface that fairly trivial to make an abstraction layer.

    4. Re:Cosmos DB new database Azure only? by Anonymous Coward · · Score: 0

      SQL Express can handle 1 socket up to 4 cores. Big difference. If running in a VM, make sure it is configured as such and not 4 socket, 1 core per.

      If MSFT were to provide a free edition for production use with all features and unlimited size, then who'd buy Std/Enterprise Edition? Some workloads work just fine in Express, especially transient data. Even Lync/Skype front-end servers use Express. Is Oracle Database XE full-featured?

      You can download the advanced tools to manage Express. There are also plenty of examples on how to back up databases. Use PowerShell to create a scheduled task and run the commands.

      https://support.microsoft.com/en-us/help/2019698/how-to-schedule-and-automate-backups-of-sql-server-databases-in-sql-server-express

      RRK

    5. Re:Cosmos DB new database Azure only? by luis_a_espinal · · Score: 1

      On the other hand, the products have such a simple interface that fairly trivial to make an abstraction layer.

      I was going to say that. Good abstraction layers are not that hard if the system in question is layered and compartmentalized accordingly and data is modeled appropriately. And with things like Spring Data (at least in Java land), it's almost trivial. It only gets icky in edge cases where things like throughput are paramount (or the data models are wrong for the type of abstraction in use, like trying to use a document database for time series data.)

    6. Re:Cosmos DB new database Azure only? by javaguy · · Score: 1

      Back when I was a junior developer I used to write abstraction layers in case we wanted to change databases. In 20 years no system I worked on ever actually changed. However, in modern times, moving between cloud providers may make this more likely, but still probably relatively unlikely.

      If you change from (say) Azure to AWS it's going to be a significant effort. Having to change an application would probably be a small component of this, given the code behind the abstraction layer would have to be changed anyway.

      Some centralisation of database access code could be sensible, but writing a whole abstraction layer on the off chance the database is replaced may be a step too far.

    7. Re:Cosmos DB new database Azure only? by spongman · · Score: 1

      apparently MS's CosmoDB allows you to talk to it using the MongoDB APi (among others). so, in theory at least, you can transition to/from it easier than if it were using a custom API like DynamoDB. i haven't played with it myself yet, though. this is just based on watching the keynote and a brief perusal of the high-level marketing docs.

    8. Re:Cosmos DB new database Azure only? by phantomfive · · Score: 1

      I can't speak for this one, but in my experience Microsoft's Entity Framework works really well with MSSQL, but not so well with MySQL. YMMV.

      --
      "First they came for the slanderers and i said nothing."
    9. Re:Cosmos DB new database Azure only? by Tablizer · · Score: 1

      To back up Express, the script has to shut it down (stop the process), copy the data files, and then restart it. That's risky.

  3. Good by Anonymous Coward · · Score: 0

    I'm glad that an established company is building out solid PaaS offers. Does anyone really believe that the company that sells 55 gallon lube tubs can offer the same reliability that Microsoft can?

    1. Re:Good by TheSunborn · · Score: 1

      Oh my god I hope not. We host our servers at aws, and I really hope they provide better reliability then Microsoft.

    2. Re: Good by Anonymous Coward · · Score: 0

      Nice try Microsoft employee! Azure fucking sucks.

    3. Re: Good by buchanmilne · · Score: 1

      Really?

      Browsing
      https://azure.microsoft.com/en... makes it look like running 3 Openstack deployments would be easier (and of course cheaper) than keeping something running on Azure ...

  4. Planet- scale apps by Anonymous Coward · · Score: 1

    Planet-scale, eh? I can tell you already the answer is 42.

    1. Re:Planet- scale apps by deKernel · · Score: 1

      Well of course it is "planet-scale" because they were able to fully future-proof the design.

  5. In a way, I feel sorry for the Azure team... by QuietLagoon · · Score: 1
    They are stigmatized by the egregiously bad actions of the Windows team, the malware-like tactics that were used to force Windows users to upgrade to Windows 10 against their apparent will or knowledge.

    .
    Azure may be the greatest thing since sliced bread, but it will always suffer from the anchor that is the Windows 10 update disaster.

    1. Re:In a way, I feel sorry for the Azure team... by hackel · · Score: 1

      You shouldn't feel sorry for them. They all *chose* to work for such a vile company. It's not as if Microsoft's history is a secret. They knew perfectly well what they were getting into. And honestly, Windows 10 was the *least* of Microsoft's problems over the years. People are whining and complaining over nothing.

  6. Really? MS hosting Planet-Scale databases? by grep+-v+'.*'+* · · Score: 2

    Planet-Scale databases? Sounds like they've already started loading their database with everyone's Windows 10 data and metadata. Since they couldn't be bothered to generate any FAKE data, this one's considered a "live fire" test.

    Don't you just hate it when the Whole Planet BSODs though? It takes real expert to generate that sized mess.

    ?? So can you generate a BLOB the size of a planet? If so, that would explain the old joke about "You can't own everything in the world since there'd be no place to put it." I guess tape backups really ARE dead.

    --
    If the universe is someone's simulation -- does that mean the stars are just stuck pixels?
  7. "Database crazy"? by rebelwarlock · · Score: 1

    I'm not going to read articles written by children.

  8. Financial Penalties by Anonymous Coward · · Score: 0

    You aren't going to care about the tiny financial penalty, which will be part of your money you are paying for the database-as-a-service, when your entire business does not function because Azure went down. It won't even begin to cover your losses.

    Azure is one of the worst cloud services in terms of downtime historically. They all get downtime sometimes, but if you are going to sell out to the cloud don't use this one.

  9. Cosmo's DB by Anonymous Coward · · Score: 0

    It's actually called Cosmo's DB. It was invented by the guy with the weird hair from Seinfeld.

  10. microsoft low quality advertisement by Anonymous Coward · · Score: 0

    I hate all these microsoft advertisement low quality shit.
    I don't recognize you Slashdot

  11. As a DocumentDB developer by Anonymous Coward · · Score: 1

    Don't use this piece of garbage.

    Performance is abysmal, cost sky-high (for decent read/write performance in a single collection, you're looking at over $1,000/mo, and that's for data sets under 10 GB because if you go over 10 GB it forces you to partition the data, which dilutes performance between the partition shards), there is no proper tooling (unless you count the Azure "portal" which is a series of perpetual slow or failed AJAX requests), poor SDK, and lacking basic features (e.g. update part of a document, backup/restore). Last but not least, it locks you into the Azure platform.

    Maybe in 5 years it will become somewhat respectable, just like how MongoDB took a while to gain traction and stability. For now, steer clear.

  12. Re:Really? MS hosting Planet-Scale databases? by zifn4b · · Score: 1

    Planet-Scale databases? Sounds like they've already started loading their database with everyone's Windows 10 data and metadata.

    Nope... they've started loading it with my distributed peer-to-peer statistical noise data generation system. Muhahahaha. Big data. Yep, it's big, a big steaming pile of useless... bits.

    --
    We'll make great pets
  13. Re:Really? MS hosting Planet-Scale databases? by Anonymous Coward · · Score: 0

    Don't you just hate it when the Whole Planet BSODs though?

    We call it the Blue Planet for a reason, you know.

  14. The best part about standards... by xxxJonBoyxxx · · Score: 2

    >> Azure Goes Database Crazy With One New NoSQL, Two New SQL Services

    The best part about standards is that there are so many different ones to choose from. Wheee!

  15. Meanwhile in the real world by Khyber · · Score: 1

    I just use KirbyCMS, which is faster than any database because it runs off the native filesystem, and provides me tools that most databases simply cannot or do not provide.

    --
    Still waiting on Serviscope_minor to wake up to fucking reality and realize that Jessica Price isn't going to fuck him.
    1. Re:Meanwhile in the real world by hackel · · Score: 1

      You clearly don't know what you're talking about. A database is vastly different from a CMS. There's nothing fast about "the native filesystem." It might work fine for running your blog, but for any serious database application, it's a non-starter. You honestly can't even compare the two.

    2. Re:Meanwhile in the real world by Khyber · · Score: 1

      " A database is vastly different from a CMS. There's nothing fast about "the native filesystem." It might work fine for running your blog, but for any serious database application, it's a non-starter. You honestly can't even compare the two."

      No, really, it's not, if you've bothered using every single one out there. And there's plenty fast about the native filesystem. You must not know much about moving tiny bits of data around in a rapid manner. I've been running multiple websites (including my businesses) directly from the filesystem. Your typical databases SUCK.

      https://getkirby.com/

      Works great.

      Faster than anything your ass has seen.

      Also works great for managing my 2D SECOND LIFE CLONE (which is actually far more extensible than anything Linden Labs ever dreamed of.)

      Perhaps you should get out of your basement and join the world of current technology, child.

      --
      Still waiting on Serviscope_minor to wake up to fucking reality and realize that Jessica Price isn't going to fuck him.
  16. Microsoft Loves Open Source! by EndlessNameless · · Score: 1

    Now that they found a way to charge for it, they are totally jumping on the bandwagon.

    Sarcasm aside, this could be good if they contribute code for better performance or scalability to the projects. Then again, their code could be so tightly coupled to the Azure infrastructure that it is useless to anyone else. I don't really follow those projects to know if that's happening though.

    --

    ---
    According to the latest ruleset, this post should be modded as Vorpal Flamebait +5.
  17. Does anyone even use this? by hackel · · Score: 1

    Who in their right mind would trust business-critical data to Microsoft? Honestly? It makes no sense. Surely no respectable devops person would allow this. Is this 'Cosmos DB" even open source? How does anyone know what it's doing with their data? Microsoft seriously needs to get out of this market.

    1. Re:Does anyone even use this? by spongman · · Score: 1

      > How does anyone know what it's doing with their data

      that seems like just the kind of question that these people would ask.