Linked by Thom Holwerda on Wed 16th Jan 2008 14:34 UTC, submitted by BluenoseJake
MySQL AB and Sun have announced that MySQL has been bought by Sun. "Sun Microsystems today announced it has entered into a definitive agreement to acquire MySQL AB, an open source icon and developer of one of the world's fastest growing open source databases for approximately USD 1 billion in total consideration. The acquisition accelerates Sun's position in enterprise IT to now include the USD 15 billion database market. Today's announcement reaffirms Sun's position as the leading provider of platforms for the Web economy and its role as the largest commercial open source contributor." More here.
Thread beginning with comment 296366
To view parent comment, click here.
To read all comments associated with this story, please click here.
To view parent comment, click here.
To read all comments associated with this story, please click here.
Member since:2006-07-26
Member since:2007-09-12
The issue becomes a horrid mess when you have 160G of data and you need to dump the data twice a day . A plain old SQL dump of this size eats Disk I/O like its going out of style. Now say I have Dumps / database / table , and I need to restore a dump to a new server. Say I have a 50G table to restore to a new box , a 50G dump is going to take a long time to read into a new server.
Say I just need backups once a day there is no database snapshot system. This has to be done on the filesystem with a read lock on the database. So on most UNIX OS's this can be done but now that I have a snapshot of the datadir how do I say restore one table from an innodb database ? Yes I am aware of innodb files / table , but this is adding up to a pile of band-aids added to MySQL to make it work better.
Say I just need backups once a day there is no database snapshot system. This has to be done on the filesystem with a read lock on the database. So on most UNIX OS's this can be done but now that I have a snapshot of the datadir how do I say restore one table from an innodb database ? Yes I am aware of innodb files / table , but this is adding up to a pile of band-aids added to MySQL to make it work better.
There is a hot backup product for innodb. Not so for myisam. I'm not sure why you'd be using myisam if you're doing a lot of updates, inserts, and deletes.
Using innodb and even without a hot backup tool, you could achieve something close to what you're interested in with a combination of traditional cold full backups and binary logs. You could also use replication and backup your replica to achieve high uptime.
Edited 2008-01-16 20:57 UTC
Member since:2007-01-22
Again this sort of stuff needs to looked at by SUN / MySQL . Innodb is nice but its going away. Filesystem Snapshots work well in some cases but not all. A Database which has the snapshotting built is better. A MySQL system that has non blocking backups, that work correctly, fast and consistently on various architectures, would rock. And yes both things can be with software already out there. I know I am asking for allot but Have you seen Oracle 11G RAC with ASM.
Member since:2007-07-01
There is a hot backup product for innodb. Not so for myisam
mysqlhotcopy?
http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html
News
Linked by Thom Holwerda on 05/18/13 21:06 UTC
"At the end of a week in which Electronic Arts confirmed it wasn't developing a thing for the Wii U, one of the software engineers in EA Sports' Canada studio, in a series of since-deleted tweets, disparaged the console as 'crap' and suggested Nintendo should give up on hardware altogether. 'The Wii U is crap. Less powerful than an Xbox 360. Poor online/store. Weird tablet', tweeted Bob Summerwill, listed as a senior software engineer at EA Canada, in a reply to a tweet posting a link about EA's no-Wii U news. 'Nintendo are walking dead at this point'." The Wii U is turning into the 21st century's Virtual Boy.
Linked by Thom Holwerda on 05/18/13 7:37 UTC
"In NixOS, the entire operating system - the kernel, applications, system packages, configuration files, and so on - is built by the Nix package manager from a description in a purely functional build language. The fact that it's purely functional essentially means that building a new configuration cannot overwrite previous configurations. Most of the other features follow from this." Interesting approach. A Linux distribution, sure, but with some very refreshing ideas about system configuration.
Linked by fran on 05/18/13 1:38 UTC
Appfour added, among other features, C/C++ support to its new version of AIDE. From Android-IDE, "Now you can write parts of your app or your whole app in C/C++ on your device. AIDE supports the Standard Android NDK toolchain (GCC 4.6 + Bionic, STL, ...). No changes are necessary if you want to build an app developed on a PC with Eclipse. C/C++ development is fully integrated: Build errors appear in the error list and files can easily be navigated to with Go to file. The editor supports C/C++ syntax highlighting."
Linked by Thom Holwerda on 05/17/13 23:35 UTC, submitted by kragil
Ars nails it: "The answer is that Google did announce what amounts to a fairly substantial Android update yesterday. They simply did it without adding to the update fragmentation problems that continue to plague the platform. By focusing on these changes and not the apparently-waiting-in-the-wings update to the core software, Google is showing us one of the ways in which it's trying to fix the update problem."
Linked by MOS6510 on 05/17/13 22:22 UTC
"It is good for programmers to understand what goes on inside a processor. The CPU is at the heart of our career. What goes on inside the CPU? How long does it take for one instruction to run? What does it mean when a new CPU has a 12-stage pipeline, or 18-stage pipeline, or even a 'deep' 31-stage pipeline? Programs generally treat the CPU as a black box. Instructions go into the box in order, instructions come out of the box in order, and some processing magic happens inside. As a programmer, it is useful to learn what happens inside the box. This is especially true if you will be working on tasks like program optimization. If you don't know what is going on inside the CPU, how can you optimize for it? This article is about what goes on inside the x86 processor's deep pipeline."
Linked by Thom Holwerda on 05/17/13 22:15 UTC, submitted by Tom
"It was the only moment I heard regret slip into Otellini's voice during the several hours of conversations I had with him. 'The lesson I took away from that was, while we like to speak with data around here, so many times in my career I've ended up making decisions with my gut, and I should have followed my gut,' he said. 'My gut told me to say yes.'" The world would've been a much different place - Apple would have been less dependant on Samsung for its chips, which probably would've meant less money for Samsung to develop its Galaxy business.
Linked by Thom Holwerda on 05/16/13 21:41 UTC
Glass is getting some love at Google I/O as well. New applications have been released - Facebook, Twitter, Evernote, Elle, Tumblr, and CNN. Perhaps more interesting: the newly announced Google Glass Developer Kit will allow offline applications and direct hardware access - great for hacking and expanding Glass' potential. This kit will really allow hackers to put Glass through its paces.
Linked by Thom Holwerda on 05/16/13 17:04 UTC
"But Beck and Merrill decided that simply banning toxic players wasn't an acceptable solution for their game. Riot Games began experimenting with more constructive modes of player management through a formal player behavior initiative that actually conducts controlled experiments on its player base to see what helps reduce bad behavior. The results of that initiative have been shared at a lecture at the Massachusetts Institute of Technology and on panels at the Penny Arcade Expo East and the Game Developers Conference." Absolutely fascinating stuff. I'm a League of Legends player, and to be honest, the community isn't nearly as bad as some make it out to be. I'm happy Riot games has the guts to employ science to address the issue.
Linked by Thom Holwerda on 05/16/13 13:17 UTC
"Android and iOS, the number one and number two ranked smartphone operating systems worldwide, combined for 92.3% of all smartphone shipments during the first quarter of 2013 as Windows Phone crept past BlackBerry for 3rd place. According to the International Data Corporation Worldwide Quarterly Mobile Phone Tracker, Android smartphone vendors and Apple shipped a total of 199.5 million units worldwide during 1Q13, up 59.1% from the 125.4 million units shipped during 1Q12." Windows Phone doubles from a few to twice few, iOS loser market share as its growth is slower than that of the overall market. BlackBerry continues slide into irrelevance.
Linked by Thom Holwerda on 05/16/13 12:06 UTC
"According to the latest research from our Wireless Smartphone Strategies service, global Android smartphone profits reached US$5 billion in total during the first quarter of 2013. Samsung dominated and captured an impressive 95 percent share of all Android smartphone profits." Wow.More News »
Sponsored Links
Member since:
2007-01-22
My issues with mysql are not about if it does Stored Procedures or what level of SQL compliance it has. I don't even care how fast it is. My issues have to do with two simple things. Backups / Restores and Snapshots.
When users had 20meg databases and they had the time to spare for a read lock for the dump to work. This was not a big deal. The issue becomes a horrid mess when you have 160G of data and you need to dump the data twice a day . A plain old SQL dump of this size eats Disk I/O like its going out of style. Now say I have Dumps / database / table , and I need to restore a dump to a new server. Say I have a 50G table to restore to a new box , a 50G dump is going to take a long time to read into a new server.
Say I just need backups once a day there is no database snapshot system. This has to be done on the filesystem with a read lock on the database. So on most UNIX OS's this can be done but now that I have a snapshot of the datadir how do I say restore one table from an innodb database ? Yes I am aware of innodb files / table , but this is adding up to a pile of band-aids added to MySQL to make it work better.
When will they address this in a proper way say the way Oracle does this with RMAN .