Slashdot Mirror


Gov't GSA Office goes MySQL

comforteagle writes "MySQL has won a five year contract with the US General Services Administration office putting it in yet another government office on top of NASA, the Dept. of Def., Los Alamos National Labs & the Census Bureau. This additional win allows around 70 Government customers to purchase and deploy MySQL."

37 of 143 comments (clear)

  1. Isn't MySQL Free by gamepro · · Score: 2, Interesting

    What exactly are they paying for?

    1. Re:Isn't MySQL Free by MickoZ · · Score: 2, Interesting

      Lot of people like it and use it. It is not that bad. Lot of people use it with success. But can you give me a list of all the OSS databases you talk about that are better (or "good database")? Seems like there is a lot from your words (maybe there is), I'm just curious about your list.

    2. Re:Isn't MySQL Free by LurkerXXX · · Score: 3, Informative
      Postgres, Firebird, Berkeley DB, MaxDB, Ingres, Cloudscape,...

      Those are off the top of my head. There are more.

    3. Re:Isn't MySQL Free by MickoZ · · Score: 3, Interesting

      Funny thing is between my last post... I had a slow response on my localhost and I did stop mysql service (on windows). And something weird happened... the column's type changed (a char(1) to a char(0) and I doubt I did change that by error). It happened on a table that indeed was supposed to be written at. Even thought the type changed from char(1) to char(0), the old data were still having one character inside. However... all the new data were empty string as the column specification changed. Quite scary... I am a perfectionnist, I try to slack off... but those kind of thing scare me when I see them in a software... Of course I did a NET STOP MySQL (service stop) on windows... but still... that could happen on our shared host server or is there something in mysql that could prevent this (i.e don't shutdown till the operation is finish?)

    4. Re:Isn't MySQL Free by suwain_2 · · Score: 2, Interesting

      What exactly are they paying for?

      Are you familiar with the workings of the US Government?

      --
      ________________________________________________
      suwain_2 :: quality slashdot p
    5. Re:Isn't MySQL Free by kimvette · · Score: 2, Informative

      It depends on:

        - how you talk to MySQL (using sockets? Not an issue)

        - Whether you bundle it or simply tell the user "you need MySQL"

      --
      The Christian Right is Neither (Christian nor right). See: Matthew 23, Matthew 25, Ezekiel 16:48-50
    6. Re:Isn't MySQL Free by ajs318 · · Score: 2, Insightful

      Maybe they don't want a proper full-fledged Relational Database Server. Has it not occurred to you that they might simply be looking for a simple, lightweight Array Persistence Abstraction Layer?

      MySQL is perfectly adequate for many intranet applications and some internet applications. There's no point buying a tank if all you want to do is drop off the kids at school, then go shopping for a few more pairs of shoes and get your hair done. Just don't expect a Vauxhall Corsa to cope too well in a war zone, if you should encounter one on your travels.

      But I agree with the basic premise that it probably would work out cheaper in the long run to pay for their own support staff, rather than pay for support from MySQL AB. I mean ..... there's so little to go wrong with MySQL anyway!

      --
      Je fume. Tu fumes. Nous fûmes!
    7. Re:Isn't MySQL Free by LurkerXXX · · Score: 2, Interesting

      The article is about the addition of MySQL to their stock of databases. It doesn't say that they don't also already have many copies of Oracle and or DB2 or MS SQL. They already have databases, they are just buying more. I'm sure for many really large complex databases, they are using one of the above. They are probably buying MySQL for use in smaller databases they also need to work with. The question is why MySQL and not Postgres or any number of other fuller featured free databases. You know, databases that actually always enforce constraints as a real database should, rather than having enforcement as a new option compared to their history of not enforcing them. Using MySQL for some random persons blog is one thing, but if the goverment is putting it in a database, the numbers probably matter and data integrity should be kept a higher priority than the folks at MySQL have historically treated it.

  2. Note to self.... by Stevarino · · Score: 2, Funny

    Wake up tomorrow and sell Perl/PHP contract to government.

  3. GSA is not just another office by hedronist · · Score: 5, Informative

    GSA is not just another gov't office. Once you are on the GSA Schedule, then many other government offices and agencies can simply buy your product without any additional paperwork. This means that the on-ramp to MySQL just got *much* easier for many groups in the U.S. govenment.

    To quote: "With the GSA contract, GS-35F-0131R Schedule 70, government customers will be able to purchase and deploy MySQL through Carahsoft Technology Corp. The GSA schedule is effective Dec. 20, 2005 through Nov. 19, 2009."

    See the magic words "GSA Schedule?" This is a Very Good Thing(tm).

  4. Negotiating a GSA price/dealer is NOT "deploying" by ScentCone · · Score: 4, Insightful

    This is certainly useful, in that it makes the product available to Federal users at a known (and, since it's on a GSA schedule, typically better-than-average) price. But when a reseller negotiates to be the GSA dealer for an item, that's all they've accomplished. That's NOT the same as actually talking an agency into using the product. We also want to be careful not to draw the wrong conclusions. When they say that NASA is using it, that means it's one more tool in NASA's toolbox. Some people might get the impression that they're using in lieu of other DB engines, rather than along side of such.

    --
    Don't disappoint your bird dog. Go to the range.
  5. Re:Paying to deploy OSS? by damned_mediocrity · · Score: 4, Informative
    Yeah, paying for the software itself. MySQL's licensing scheme, from what I can remember, is hazy to say the least. There's a "commercial" license and the regular GPL license. You have to choose one or the other, and their criteria are vague.

    They recommend that all commercial entities use the commercial license. And if you call them to discuss the ins and outs of their licensing scheme, they'll try to talk you into the commercial license anyway.

    Here's a nice blog entry about this scariness.


    P.S. You're right. You *are* the bad analogy guy. You win.

  6. Just goes to show how xenophobic the US govt. is by Netsnipe · · Score: 5, Funny

    Choosing to go with a database that doesn't support foreign keys.

    --
    -- "I can't tell the future, I just work there." -- The Doctor
  7. Re:Paying to deploy OSS? by diersing · · Score: 3, Insightful
    I realize you may have just wanted to brag about how infrequently *you* need to ask anyone for help and kudos to you on that, but support and licensing is more important then the functionality/reliability/usefullness of the application being purchased(see Microsoft).

    The fact of the matter is, in this post-SOX world business and governments needs to hedge their bets EVERYWHERE they can, and ensuring ongoing support services, upgrade protection, etc etc is how you can DOCUMENT steps taken to remediate the risks to integrity, availability and confidentiality. I like OSS, the people that support and write these application build into them wonderful security measures, precautions and a framework to utilize so many more security tools - but without a support agreement the application will never make it in the door. When that mission critical server crashes Google ain't gettin on a plane to come help you out.

  8. This is an opportunity by core+plexus · · Score: 4, Insightful
    Flamers aside, this is yet another example of an emerging opportunity, much like this story I just read about doing business with Intelligence Agencies.

    "The federal government will spend in excess of $400 billion with contractors this year and over $100 billion is expected to be spent with small businesses. Now business people from all over the U.S. can learn first hand from the experts how to capitalize on these business opportunities with federal government agencies without leaving their own offices"

    Sounds good to me.

  9. Re:Paying to deploy OSS? by Jamesday · · Score: 3, Insightful

    So, someone wants to tightly link a GPL core to a proprietary tool and redistribute without releasing all of the source code. Who's supposed to be upset at this, other than the person releasing the proprietary product?

    Want to argue that binary compatibility is OK - go have fun on the Linux kernel mailing list and argue that a device driver doesn't need to be GPL.

    If someone is sure that a library tightly bound to a binary interface isn't a derivative work, they are perfectly free to act on that belief.

    MySQL seems committed to the free software objective of making more software free. The company licensing and views support that objective.

    Other projects have a different view and accept commercial use with no payback the community or developers. Their call. MySQL's is that if you're using MySQL, you should either also be releasing free software or you should be contributing to the development of the server the free community and everyone else is using.

    It appears that MySQL believes that's the practice which produces a strong open source database company. With more than a million downloads in just the first three weeks after MySQL 5 was released a few months ago, as well as several hundred employees, it's getting pretty hard to argue with the success of that view.

  10. Re:Is MySQL really the right choice? by Jamesday · · Score: 5, Insightful

    How does a site handling 6,000 page views per second, around a billion queries per day on five database servers and in the top 40 sites in the world according to Alexa.com sound?

    Or how does Google's main revenue source or Travelocity's booking system or big chunks of Yahoo or... do I really need to continue with more examples of massive web traffic using MySQL?

    Site design can be screwed up. It can also be done right. People regularly do it both ways. The database server usually isn't the reason. The people using it are.

  11. News - Sort of by HardCase · · Score: 4, Interesting

    MySQL is on the GSA schedule - but thousands upon thousands of products are available on the GSA schedule. Just being on the GSA schedule isn't particularly dramatic, though. And the headline (and even the summary) are quite a bit more breathless and quite a bit less accurate than the real story.

    -h-

    1. Re:News - Sort of by magores · · Score: 4, Informative

      Hardcase hit the nail.

      As a former Contracts Administrator for a computer oem, I may be able to shed a little light on how all this works.

      Basically, if your product (toilet paper, paper clips, software, whatever...) is on the GSA schedule, then the various government agencies are allowed to purchase it. If your widget is not on the schedule, then they can't.

      There are a number of ways around the rule of "GSA-Buy, No GSA-No Buy", but that is the way its suppossed to work. For those that are curious, here are a couple of ways the various governemtn agencies can get around the GSA...
      1) This is probably the easiest way to get around this rule - Simply buy the widget via a different contract (schedule=contract). Your favorite toilet paper isn't listed on GSA, but it is listed with XYZ MAS? And, it "just so happens" that your agency is allowed to buy via XYZ? Go ahead and buy all you need.
      2) Another "popular" way to get around the rule is for the agency that needs whatever product to write their request in such a way that only 1 particular product can meet the specifications. Government rules allow for such exceptions. "I don't care if its not on the list! Our agency simply MUST have toilet paper that is produced in Walla Walla, Washington by non-caucasion midgets with two left hands." Ta-Da ... Your TP is on the way. Writing the specs this way is extremely easy when the TP sales rep writes the specs for you. Oops... I mean, the sales rep makes "suggestions". Having them write it would be (cough, cough) illegal.

      Now, lets assume that your specific government agency strictly abides by the GSA, and your favorite TP is on the GSA schedule. Here's what happens, more or less...
      1) Agency writes up their needs. (2-ply TP, blue flowers, single roll wrapped)
      2) They submit their needs to a buyer.
      3) Buyer looks at the GSA list.
      4) Buyer chooses whatever the heck s/he wants. - "Least Cost" is the typical over-riding factor in the decision.

      It's not particularly hard to have the buyer buy the specific TP that you want. It may be more expensive in actual dollars, but "look at the customer service! Surely that's worth something!"

      Everywhere above that I mention TP, substitute MySQL... Its the same. Its a product.
      ---

      I'm rambling, so I'll wrap up now...

      -If anyone in government really wanted MySQL, they could have gotten it with or without GSA.
      -Now that MySQL is on the GSA, so what? People won't "buy" it on a whim. Someone has to sell it. (And I mean "sell", in a used car type of way.)
      -That 5 year contract? It's really a 10 or 15 year deal. Extensions are easy.

      ------
      ------

      I've over-simplified quite a bit, and I should probably have defined MAS, RFP, RFQ, SAS, etc. but I don't want to ramble anymore.

      -----

      Have fun.

      M

  12. You've gotta hand it to 'em by brogdon · · Score: 5, Funny

    After years of exhaustive, painstaking, and expensive study, our government has finally devised a method to buy something that's free.

    I hope it at least comes with a $600 wrench or something...

    --


    This tagline is umop apisdn.
    1. Re:You've gotta hand it to 'em by duffer_01 · · Score: 4, Insightful

      Man, would everyone stop saying it is free. Just because you don't have to pay for the software doesn't mean that you won't pay for support or for the commercial license if you need to hide your source code.

    2. Re:You've gotta hand it to 'em by waif69 · · Score: 2, Interesting

      Bingo! You hit the nail on the head. Support and the ability to hide/bury/dispose of the source code is important and worth the money spent. The open source nature the other side of the software has provides faster development and vetting of errors faster (typically) than closed source software.

      As for the cost, often the gov't goes to extremes to keep the cost low even while maintaining certain specs to ensure safety and reliability of equipent in harsh environments. I work in the Aquisition field and understand the reasons why somethings seems to be far too costly at face value. Yes, in the past there have been people skimming off the top and pocketing some money, however the way aquisition occurs now, that has been minimized if not eliminated. Oh, and yes, some items still appear to cost too much, until you find out the specs that must be met and you learn that some companies that sell to the gov't make very small margins of profit just to have a contract that may last ten years or so to ensure a steady source of income.

  13. Re:You're Full of Shit by Saeed+al-Sahaf · · Score: 2, Informative

    Using MySQL does not mean having to GPL your applications that access MySQL. Just quit it. That's not the way the GPL works and you know it. I'll wait for the rabid zelots to go into detail, but use some common sense.

    --
    "Who are in control, they are not in control of anything - they don't even control themselves!" - Glen Beck
  14. Re:You're Full of Shit by verbatim · · Score: 4, Informative

    It greatly depends on how you 'use' it.

    Lets say you have a Java app that, in whatever way, uses the standard jdbc classes. One of your users chooses to use the MYSQL jdbc drivers to connect to a MySQL server. Your app doesn't need to be GPL, imo, because the only code YOU used was sun's JDBC code. Your user chose to link it to the GPL'd drivers and it's their responsability to adhere to the license. Since they can't distribute your code (they don't have it) as long as they don't distribute the binaries to the app, they are not in violation (since the code bit only applies to distribution).

    HOWEVER, if you either specifically tell the user to use MySQL or expect the GPL mysql driver in your code (ie, specifically referencing the driver in the connect setup) then you are in GPL territory.

    Now lets say you have a C/C++ app and you link in the mysql library (either statically or dynamically). The mysql client lib is under gpl and you, if you distribute your application, would be required to release it under the gpl - after all, you are using gpl'd code. The only way around this would be to find or develop and use a non-gpl driver.

    The real answer, anyway, is that it depends on what you are linking to and how you link to it. Yes, simply connecting to a MySQL server does not implictly bind you to the GPL - just like Microsoft isn't required to GPL internet explorer because it can talk to a GPL'd webserver. However, if you are using the GPL'd drivers to connect, you are in GPL territory (not because you are connecting, but because you are using the GPL'd code to do it).

    Oh, and IANAL and IMHO and YMMV and TANSTAAFL. :)

    --
    Price, Quality, Time. Pick none. What, you thought you had a choice?
  15. Standards, schstandards by leandrod · · Score: 4, Insightful

    So even the US government does not really care anymore for its own standards. I guess Oracle will feel relieved with their 'ISO SQL 92 minus datatypes and a few other essentials' product. It kind of makes the efforts of PostgreSQL and others toward ISO SQL:2003 (hint: each ISO SQL standard cancels the former one) futile.

    --
    Leandro Guimarães Faria Corcete DUTRA
    DA, DBA, SysAdmin, Data Modeller
    GNU Project, Debian GNU/Lin
    1. Re:Standards, schstandards by Zontar+The+Mindless · · Score: 2, Informative
      Those of you who modded the parent insightful really should have read this first:
      Our aim is to support the full ANSI/ISO SQL standard, but without making concessions to speed and quality of the code.

      This is not just wind in sails. In fact, MySQL AB have on staff (and have had for a couple of years now) several highly knowledgeable and qualified individuals whose primary job is to work with the developers to maximise MySQL's SQL:2003 compliance, and changes in this direction occur with each release. (Yes, I said "maximise" - nobody implements all of SQL:2003 completely.)

      If you run the server in Traditional or Strict mode, I think you might be surprised. (The reason this isn't the default behaviour is due to all the legacy apps out there that expect the old non-compliant behaviour.)

      The parent is either (a) ignorant of this, or (b) aware of it and thus trolling.
      --
      Il n'y a pas de Planet B.
    2. Re:Standards, schstandards by poot_rootbeer · · Score: 2, Interesting

      I guess Oracle will feel relieved with their 'ISO SQL 92 minus datatypes and a few other essentials' product.

      I'm sure Larry Ellison cries every evening as he swims through his five-story Money Bin.

      Oracle has decided that it would be worse to break all the legacy applications already running on Oracle DBs than to force compliance with the ISO standard. Can't say I blame them.

  16. Re:Paying to deploy OSS? by alc6379 · · Score: 2, Insightful
    i'm not sure you can draw valid parallels between running the infrastructure in a small business and running the infrastructure of a first-world nation.

    I don't see why not. I'm not the OP, but who said anything about small businesses? If anything, larger businesses and governments should have more staff in-house. They should really rely on outside support more along the lines of a development liason, or something-- a technical resource the in-house "experts" can call to see why some portions of an application's code aren't as highly optimized, or to help identify bugs in the software that could cause catastrophic failure. If one man can keep a 100 seat installation running without having to call a company for support, couldn't that be scaled up such that 100 people could keep a 10,000 seat installation running in the same fashion? (Surely, it wouldn't scale that evenly, but I think the point is clear.)

    When I think of "support" for a large IT infrastructure, I'm thinking partnerships for customized solutions and fast critical incident response, not "who do I call when my DB developer gets an error inserting a record into a table?".

    --
    I don't moderate anymore. Karma penalty for 90% fair mods? Can I mod that unfair?
  17. MySQL makes it easier by Flying+pig · · Score: 4, Insightful
    In fact, the simple security model, sensible and clear install options and user-friendly design tools make it more likely that a MySQL install will be done properly than, say, an application connecting to MS SQL Server or SQL Server Express. The steepness of the MS SQL learning curve and the counter-intuitivity of many of the Transact-SQL statements and default install options cause a lot of trouble for small scale users. I guess the result is a lot of small database applications stick with "Access" because the users cannot get budget for migration. Whereas with MySQL, there is a chance they will get something that works properly going quite quickly, and be able to deploy the results to Java clients, Crystal, OOo, Excel, FileMaker etc. without major pain.

    Ever since the MySQL installer required a root password and disabled root connections outside localhost by default, while telling you that in clear language during the install process, it has been more credible as a simple installable RDBMS than some of the competition. FileMaker is another example of a database (of a sort, though) which makes sensible install defaults and then allows progressive expansion of capability without overwhelming the user with poorly documented options, but it is not as install-friendly.

    I know it is fashionable for "real" computer scientists and DBAs to sneer at MySQL. But that's actually a sign of insecurity. Real mechanics don't sneer at zinc plated steel bolts because 316 is available: they just don't use zinc plate under salt spray conditions.

    --
    Pining for the fjords
    1. Re:MySQL makes it easier by asdfghjklqwertyuiop · · Score: 2, Insightful

        In fact, the simple security model


      MySQL's security model? Simple? I would describe it as anything except that. Why does mysql consider the host the user connects from a part of all permissions? The same user can have separate permissions on a database, separate privileges on tables, even separate passwords depending on what host they're connecting from.

    2. Re:MySQL makes it easier by kpharmer · · Score: 2, Insightful

      > and freebsd is better than linux.

      No, not every disagreement about methodologies, technologies or products can be easily dismissed as preferences of an extremist:
          - a ford taurus really is better than a yugo
          - cars really are safer today than they were forty years ago
          - mp3s really don't sound as good as cds
          - mysql ab really has tried to convince users that transactions, views, subselects, etc aren't useful
          - mysql really has unacceptable data quality problems due to silent errors
          - mysql ab has really been deliberately deceptive about its licensing
          - mysql's future really is in question due to oracle's purchase of Innodb

      None of the above are worth arguing about. The reason discussion needs to be about what mysql can do to mitigate or correct the above and stay relevant.

    3. Re:MySQL makes it easier by bani · · Score: 2

      No, you really don't want to like mysql. Why would you want your favorite object of derision to go away?

      Besides, it's a moving target anyway. Even if all your objections were solved, you'd just come up with new ones.

  18. In other news by SmallFurryCreature · · Score: 4, Funny

    Both Steve Ballmer and Larry Elison were seen throwing chairs and screaming, "We are a going to fucking bury the DoD, we did it before and we will do it again".

    The DoD was heard mumbling something along the lines of "you and what army" and went back to keeping democracy save for billionares everywhere.

    --

    MMO Quests are like orgasms:

    You may solo them, I prefer them in a group.

  19. Re:WHAT by HaydnH · · Score: 2, Interesting

    Aye, subselects have been supported since 4.1.

    Personally I believe MySQL won the popularity vote against postgreSQL due to better performance because it didn't have as many features, as MySQL adds these features the performance will get worse than postgres who have had the features since the beginning and have been working mainly on reliability/performance.

    I know which I'd choose.

    --
    Time is an illusion. Lunchtime doubly so. - Douglas Adams
  20. Re:Just goes to show how xenophobic the US govt. i by Johnno74 · · Score: 4, Insightful

    Geez. Tough crowd. I thought it was the funniest comment I've seen on /. all week.

    I guess you must be a MySQL user, and/or an American, right? ;)

  21. And not a moment too soon! by woodsrunner · · Score: 3, Informative

    This morning, the NYTimes reports the GSA's website for contract bidding has been shut down due serious security flaws.

    http://www.nytimes.com/2006/01/13/technology/13sec ure.html

    "The security flaw, which could have permitted contractor fraud, was reported to the agency's inspector general on Dec. 22, but almost three weeks passed before the system was taken offline Wednesday afternoon. The General Services Administration is the federal agency responsible for procuring equipment and services, including computer security technology, making the lapse all the more striking. "This is the government entity responsible for letting contracts for security," said Mark Rasch, chief security counsel for Solutionary, a security firm. "Clearly the people who log in would know about security.""

  22. Re:Just goes to show how xenophobic the US govt. i by talonyx · · Score: 2, Insightful

    Next time you want to post a little dig like that, do it anonymously - I don't want everybody thinking Debian maintainers are all ignorant idiots who flame things they've clearly never used.

    MySQL has had foreign keys for quite some time now, as long as your tables are InnoDB.