With Sun it tow, Oracle will now finally have its own operating system with Solaris, instead of just its Oracle Enterprise Linuxon Red Hat).Perhaps more importantly with one swift stroke Oracle has effectively cornered even more of the database market than it already owned.
snydeq writes “Fatal Exception’s Neil McAllister believes Oracle is next in line to make a play for Sun now that IBM has withdrawn its offer. Dismissing server market arguments in favor of Cisco or Dell as suitors, McAllister suggests that MySQL, ZFS, DTrace, and Java make Sun an even better asset to Oracle than to IBM. MySQL as a complement to Oracle’s existing database business would make sense, given Oracle’s 2005 purchase of Innobase, and with ‘the long history of Oracle databases on Solaris servers, it might actually see owning Solaris as an asset,’ McAllister writes. But the ‘crown jewel’ of the deal would be Java. ‘It’s almost impossible to overestimate the importance of Java to Oracle. Java has become the backbone of Oracle’s middleware strategy,’ McAllister contends.”
Read more of this story at Slashdot.
An anonymous reader writes “In a blog post, Patrick Galbraith, an ex-core engineer on the MySQL Server team, raises the question: “What is the official branch of MySQL?” With Monty Widenius having left Sun and forked off MySQL for MariaDB, and Brian Aker running the Drizzle fork inside of Sun, where is the official MySQL tree? Sun may own the trademark, but it looks like there is doubt as to whether they are still the maintainers of the actual codebase after their B acquisition of the code a year ago. Smugmug’s Don MacAskhill, who is the keynote at the upcoming MySQL Conference, has commented that he is now using the Percona version of MySQL, and is no longer relying on Sun’s.”
Read more of this story at Slashdot.
An IBM-Sun merger is a tantalyzing possibility; snydeq writes “Fatal Exception’s Neil McAllister suggests that an IBM/Sun merger could crown Big Blue king of enterprise software development. ‘Acquiring Sun would make IBM the clear leader in Java, as it would become the caretaker of the open source reference implementation of the JRE,’ which, along with GlassFish, would become entry-level gateways to IBM’s WebSphere stack. Moreover, MySQL would give IBM’s database division a significant entry-level hook, and NetBeans/Eclipse would unify IBM’s front against Visual Studio. ‘All in all, this move would solidify IBM’s role as “the developer company,”‘ McAllister writes. ‘In other words, if this merger goes through and you’re an enterprise developer and you’re not an IBM customer now, get ready — because you soon will be. Better bring your wallet.'” And blackbearnh writes with a short interview with Brian Aker (who came to Sun as MySQL’s director of architecture, and is now the lead for MySQL fork Drizzle) about what life would be like under Big Blue’s control.
Read more of this story at Slashdot.
In the overview below we present some of the most useful and most popular MySQL Admin and Development Tools for Mac, Windows and Linux, for beginners and for professionals. Among other tools we feature phpMyAdmin, MySQL Workbench, HeidiSQL and SequelPro.
ruphus13 writes “Sun CEO Jonathan Schwartz continues to promote the use of Open Source, and says the downturn in the economy will only boost the momentum behind FOSS. From his post, ‘Free and open source software is sweeping across the vast majority of the Fortune 500. When you see the world’s most conservative companies starting to deploy open source, you know momentum is on your side. That’s creating massive opportunity for those of us who have pioneered the market, to drive commercial opportunities… We announced just last week that we’re building the Sun Cloud, atop open source platforms — from ZFS and Crossbow, to MySQL and Glassfish. By building on open source, we’re able to avoid proprietary storage and networking products, alongside proprietary software.'” In related news, the Sun-IBM deal proposed last week has been called “anti-competitive” by a tech industry group, while others are speculating on how it could affect Linux and Java.
Read more of this story at Slashdot.
Because I use auto-increment integers in almost every table I can for the primary key, they tend to get very large very fast. This can sometimes be an annoying problem when I’m debugging an application or testing a mysql database query. They are resetable and it’s so much quicker to select from the database when you’re checking for id=3 or id=25 then id=305678.
The query to reset the auto increment primary id of your choosing is :
ALTER TABLE some_table AUTO_INCREMENT = 1;
It is also possible to set the next auto_increment number
You can do it like this :
SET insert_id=5;
Now your next mysql_insert_id() will be 5.
There are several ways to backup MySQL data. In this article we’ll look at how to backup your databases using different methods, we will also learn how to achieve an automatic backup solution to make the process easier.
RazvanM writes “Do the OSes really shrink? Perhaps the user space (MySQL, CUPS) is getting slimmer, but how about the internals? Using as a metric the number of external calls between the filesystem modules and the rest of the Linux kernel I argue that this is not the case. The evidence is a graph that shows the evolution of 15 filesystems from 2.6.11 to 2.6.28 along with the current state (2.6.28) for 24 filesystems. Some filesystems that stand out are: nfs for leading in both number of calls and speed of growth; ext4 and fuse for their above-average speed of growth and 9p for its roller coaster path.”
Read more of this story at Slashdot.
RazvanM writes “Do the OSes really shrink? Perhaps the user space (MySQL, CUPS) is getting slimmer, but how about the internals? Using as a metric the number of external calls between the filesystem modules and the rest of the Linux kernel I argue that this is not the case. The evidence is a graph that shows the evolution of 15 filesystems from 2.6.11 to 2.6.28 along with the current state (2.6.28) for 24 filesystems. Some filesystems that stand out are: nfs for leading in both number of calls and speed of growth; ext4 and fuse for their above-average speed of growth and 9p for its roller coaster path.”
Read more of this story at Slashdot.
