InnoDB supports foreign keys. To my knowledge its the only table engine in MySQL that does. http://dev.mysql.com/doc/mysql/en/ANSI_diff_Foreig n_Keys.html
Are you using InnoDB tables? If you are, then adding the mysqldump option `--single-transaction` ought to give you a snapshot of the DB. This only works if the whole DB is using InnoDB tables (which if you care about data integrity as many here have posted on, you would be)
I might put it on some testing servers immediately and see how it goes. Production use would follow 3 - 6 months after that, depending on how many bugs are found and versions released until then. I run a pretty small shop of 30 servers, and I'm probably closer to the bleeding edge than most larger companies.
I just got an email from my account manager at C&W here in the US. He says C&W USA is not pulling out, so probably wont effect too many people. At least my T1 won't be going anywhere:)
"Our parent company is exiting the US...C&W PLC. Cable & Wireless America (CWA) is still here and operating."
Yes, businesses need to look at reality and not some tech company's glossed over white papers or something. But most OSS software is still more expensive to maintain in cost of admins, cost of rewritting all your apps, cost of upgrading, etc, than comparible proprietary software.
The tides will shift to OSS as the interfaces get more refined and the speed that you can complete tasks out of the box increases. For example, I can't trust a low-level tech to properly install, and configure something like Jabber. But on a windows box all they have to do is click a few left clicks and poof the program is installed. To date I believe that the MS GUI is easier to use than Gnome or KDE.
Slashdot Mirror
InnoDB supports foreign keys. To my knowledge its the only table engine in MySQL that does. http://dev.mysql.com/doc/mysql/en/ANSI_diff_Foreig n_Keys.html
Are you using InnoDB tables? If you are, then adding the mysqldump option `--single-transaction` ought to give you a snapshot of the DB. This only works if the whole DB is using InnoDB tables (which if you care about data integrity as many here have posted on, you would be)
I might put it on some testing servers immediately and see how it goes. Production use would follow 3 - 6 months after that, depending on how many bugs are found and versions released until then. I run a pretty small shop of 30 servers, and I'm probably closer to the bleeding edge than most larger companies.
Where do you get your components from? I'm looking for good and cheap 1u parts for some new servers, but I keep hitting the $1000 mark (for P4s).
I just got an email from my account manager at C&W here in the US. He says C&W USA is not pulling out, so probably wont effect too many people. At least my T1 won't be going anywhere :)
"Our parent company is exiting the US...C&W PLC. Cable & Wireless America
(CWA) is still here and operating."
The tides will shift to OSS as the interfaces get more refined and the speed that you can complete tasks out of the box increases. For example, I can't trust a low-level tech to properly install, and configure something like Jabber. But on a windows box all they have to do is click a few left clicks and poof the program is installed. To date I believe that the MS GUI is easier to use than Gnome or KDE.
t0ny's right, there are a lot of costs to move to OSS beyond just the cost of obtaining the software.
Won't a T1 handle 193KB/s? 1544000 bits divide by 8 = 193,000 bytes or 193KB....