In a recent blog post, Uber detailed why they have chosen to replace PostgreSQL with MySQL. In this article we present a high level overview of the problems they faced, how MySQL fares against them and some of the best rebuttals against the case presented by Uber.
InfoQ interviewed Dan North about the activities that are performed by database administrators and how they are related to those done by developers and by operations, how database administration is usually organized, how the database fits into DevOps or Continuous Delivery, and what he expects that the future will bring for database administration when organizations adopt DevOps.
A year behind the schedule, JetBrains has made generally available the DBA tool DataGrip 1.0. Formerly known as 0xDBE, DataGrip is a tool for SQL database administrators and developers.
MongoDB recently announced the newest version of its NoSQL database synonymous product. Building upon the new features introduced in 3.0 release, 3.2 is expanding and solidifying MongoDB’s interest towards the corporate world.
The DBA’s primary job is to ensure that the business’s information is always available, with performance coming in at close second. We’ve already talked about optimizing distributed queries in Splunk and map-reduce queries in Hunk. In this report we expand upon that with more information that a DBA needs to know about Splunk databases.
An agile view of Big Data, wherein data is viewed as a real time stream, offers a new look at how data is managed. Using an agile data infrastructure, organizations can conquer Big Data challenges with a level of ease, flexibility and performance. White paper by codeFutures describes the Agile view of Big Data.
Last week Boxfuse announced the availability of a new release of Flyway, its open source database migration tool. Highlight is the addition of IBM DB2 z/OS, Amazon Redshift and HP Vertica to Flyway's list of supported databases, a move that expands the coverage of the "big data and big iron space." The new release also features SQL callbacks and packaged DB drivers for ease of use.
The Espresso Logic team has released a new product “Live Browser”, providing an instant HTML5 user interface for navigating databases in a master/detail format. Live Browser promises users the ability to explore, interact with and modify data from any enterprise databases, without any programming.
Mobile Backend as a Service provider AnyPresence continues to hone their chops. Launching the fifth update to their self-titled platform geared for the enterprise. Co-founder Rich Mendis provides some insights for InfoQ readers…
Microsoft VP Scott Guthrie announced a range of updates to Windows Azure that fill in platform gaps while leapfrogging market leader AWS in one particular area. The new database export service provides a much-needed backup capability – albeit with controversial pricing – and the updated Traffic Manager delivers a cross-region load balancing experience that appears superior to what AWS offers.
Riak is a key-value based NoSQL database that can be used to store user session related data. Andy Gross from Basho Technologies recently spoke at QCon SF 2011 Conference about Riak use cases. InfoQ spoke with Andy and Mark Phillips from Basho team about Riak database features and best practices when using Riak.
James Phillips, co-founder of Couchbase, recently gave a presentation on the differences between a distributed document-oriented and relational data models and what the database developers need know to move from a relational to a NoSQL database. InfoQ caught up with James to talk about the advantages and limitations of document-oriented NoSQL databases.
Jay Kreps of LinkedIn presented some informative details of how they process data at the recent Hadoop Summit. Kreps described how LinkedIn crunches 120 billion relationships per day and blends large scale data computation with high volume, low latency site serving.
The Hadoop Summit of 2010 included presentations from a number of large scale users of Hadoop and related technologies. Notably, Facebook presented a keynote and details information about their use of Hive for analytics. Mike Schroepfer, Facebook's VP of Engineering delivered a keynote describing the scale of their data processing with Hadoop.
The HyperSQL database (HSQLDB), version 2.0, has been released after 5 years in the making. HyperSQL 2.0 is the worthy successor to HSQLDB 1.8, which has been integrated and used in applications large and small, including the ubiquitous OpenOffice Base application. The new version boasts more features than any other open source database.