Those examples are where MySQL does shine. Any web application where you got a factor of 100 or 1000 - even more reads per write, MySQL is a good option.
You can never make a generalization and say this will solve everything. The right tools for the job etc.
First of all, I don't use Oracle, so stop telling me why Oracle sucks, I know that.
I've had Postgres databases over the past few years that have done that, and have provided uptime that is as close to 100% as you can get (albeit with some inexpensive add-on options at times) - network and operating system permitting. In fact, it's always been a network, OS or other outage that has been the cause of any downtime. These are in environments where people really would notice if the database went away for some reason, and very regular backups are kept which are necessary whatever failover options you have. How long does your failover take? If you are losing thousands of dollars a minute the system is down, how long will it take before you get shipped out?
If your OS is down, your database is down - this is why we got hot standby, not warm, but truely hot standby options that can take over with subsecond intervals - it costs money, but its needed.
If you have a lot of cascading triggers then I'd worry more about what you're doing than how your database handles them. Handling triggers responsibly is important, as you'll never figure out what the hell is happening twelve months from now. That's an application developer's problem, not a DBA's problem, and I wish DBA's would just stay the hell away. If it has to be done for maintenance reasons or something, fair enough, write a trigger or a stored procedure, but if not stay the fuck away please. MySQL doesn't have the best track record on them so don't use it if that bothers you. However, you'd be surprised how often people use triggers when they just shouldn't be. Stored procedures get similar mistreatment from ejit DBAs.
Seriously, what the fuck are you raving about?
No fucking way the application programmers will be allowed to ensure data integrity. If you can't figure out what your database is doing after 12 months you haven't documented it properly.
All your ramblings tells me you are an OSS application programmer without the proper background for DB maintenance with some really really bad ideas about what a proper database is, you are most likely drawing your ideas from sites like dailywtf.
Actually Oracle does come in a "thin" cheap client.
To be honest I haven't checked the new prices on MySQL support, but carrier grade support was very expensive before, and I doubt it has improved with the Sun takeover. They do have support, and it is according to rumors fast, however you don't get that support unless you cough up the money for it.
When multimillion dollar installations fails and you are paying for the support + guarantee on uptime you got somewhere to send the bill if shit hits the fan.
What will you do when your PG installation fail? Go on IRC and ask for help?
MySQL fails at some very critical points. As I said in previous post it fails to fire triggers on updates. Also MySQL believe its better to serve a best effort than a failure - this is probably the biggest NO GO! out there. YOU NEVER EVER do something other than requested in a database. If the transaction model fails you are using no more than an advance file pointer.
Now PG is a very nice database, they got all the right things implemented, and often better than the competition.
PG however does not have any support for scaling, if you want to scale you need some form of middleware to handle it - and currently you have to buy continuent for that - which is a nice product, they however don't support stored procedures and triggers.
And please don't just hit google for PG and scaleability, and come back saying there are all sorts of products out there - most of them are based on triggers and some very bad methods for propergating data - all of them lack the ability to take down primary or secondary server(s) in a running environment and put a new up without interruption in the data flow.
An awful lot of people have been waiting an awful long time for that shit to hit the fan - and in the meantime it has cost them an arm and a leg in not only licensing and support costs, but also in a needless waste of system and hardware resources.
That line alone tells me you got your head so far up your OSS arse you are seeing pink elephants.
IBM Denmark just went down this week for a whole day, pretty sure their big clients are a bit unimpressed in their failure to bring multimillion installations back online.
If postgres can handle your situation then fine, but in my environment a database failure means everything comes to a grinding halt. And when you promise clients 99.999% uptime you sure as hell need subsecond failover *hint you can't do that with anything that reads binary logs from primary* and zero loss of transactions.
While I generally agree with you a few points and additions.
Createing an InnoDB table, for (some) referential integrity? Sure, it'll give no errors, but if innodb support is disabled for any reason, it will create MyISAM tables instead, without any hint or warning. This has the potential to create great data loss.
This is not entirely true. MySQL will revert to MyISAM even though you specifically asked for InnoDB - it will however issue a warning that it is doing so, this of course is a moot point since most application programmers never check for warnings.
And just to feed the flames while we're at it, MySQL will fail to fire triggers on cascading events.
If you got table A and B and C where B references some information in A and C in B all cascades on updates in A, then any update trigger on C (and possibly B) will fail to fire. This is a very big problem if you are using triggers to keep at least some form of consistency.
To top it up most replication services in MySQL are at best flaky, usually they replicate by using the binary log, so if the primary fails you lost the X last seconds/minuttes/hours (depending on setup and load) of transactions. Even if you got the binary log on a GFS you are still in big trouble since the secondary still needs to replay all transactions leading to the failure - I've heard of sites where this was taking minuttes to complete! (This might change in the new version)
Personally I wouldn't touch either PGSQL or MySQL in a mission critical environment, they are very nice toy databases, but when shit hits the fan - and it WILL happen - you need a reliable system with instant failover, which neither database can provide.
Actually not a bad idea, quite a bit of objects are stationary in a game, so you can offload that to secondary GPU's - the problem is most games/engines haven't been designed for this in mind and you can't magically create something that can do this for them.
Over time the GPU's will be more flexible and that means it will be easier to offload calculations through some common API, but I think it will be a few years yet before this potential can be realized.
those must see adds are gonna lose people traffic. I automatically close the site these days, been way to many sites that force a commercial that often takes longer than the content you want to see. (not in this case though)
it doesn't matter, as soon as the botnet is inside your network, you got a huge problem, any zero day exploit will be able to be fired off within your own network!
Your security is only as strong as the weakest link - educate your users!
I (finally) stopped playing counterstrike after Valve put in adds - it was just for their own games, but it pissed me off that after the money they made with the game they decided to forced a (potential) revenue stream down my throat. (No you can't opt out, servers are forced to run newest version - so are you - and NO! I shouldn't be glad they still support the game since they haven't fixed a bug for years, only added adds)
The second I see an add inside a game I play I stop playing, I can't stand adds.
Which is also the dangers of three strikes etc. - if you know you are being locked up for the rest of your life you will be fighting like a wild animal to avoid being caught.
My soundblaster live card has worked without problems for almost a decade, finally retired it last month, while getting drivers have sometimes been a bit of a problem I have faired just fine - It is some of the most stable hardware I've had.
Your examples provide single entities buying out the competition, your post however suggested multiple competitors somehow could manage to spend heaps of cash on something which only has value by removing cost.
That will never fly with investors. Economics has no use of logical thinking, what matters is the black number on the bottom of the sheet.
Because thats not how the world works. Who should own the patent afterwards? You can't as a corporation go out paying heaps of dollars for something that you won't end up owning.
Those two last numbers look like Hollywood accounting to me. It's BS that they claim they can't get lower, here in Denmark a store that specializes in cheap imported goods (around $2 per item) have created their own label, they don't do promotion just take up any local bands and run around 2-5000 cd's. The CD's usually sell for around $4, now they of course have way less promotion overhead since they don't actually promote the stuff, just put it in a great big bin, the bands get around half, rest goes to the chain.
From the parent post a lot of the expenses can be removed since Wal-Mart probably will be doing the promotion and distribution - and quite probably could handle the manufacturing through contacts in Asia, they are experts in huge volumes.
100 fps? Are you friggin kidding me? Right now gamers are trying to break the 30 fps mark with all eye candy enabled. High end GFX boards sure as hell have a use these days and will continue as soon as game developers and MS get their act together and learn to program for multiple GPU/CPU's.
$10,000 says you can't run Crysis in a nice setting on a 1920x1200 or above settings.
Yes you can run at a pretty crappy resolution with low textures on a $150 board, but then why bother?
After I upgraded from a 21" CRT to 24" LCD and put in some very nice equipment the "Uhh look at that effect" factor went skywards. Yes you can have fun at $150, but having the latest and greatest actually does quite a lot for the gaming experience.
Well for one thing he could sell all the bounces to spammers, any mail that arrives as a reply mail is a confirmed email address saving spammers quite a lot of time.
Also you can probably do all sorts of nice data mining on the information - or even just a simple search for certain "interesting" keywords (ig. top-secret, internal, for your eyes only) and dig up all sorts of interesting stuff you can sell to media.
(also, RSA can be implemented in about five lines of code. Not quite as easy for AES)
Could we please please PLEASE! stop talking about programs in terms of lines of code?? It makes no sense! You can't just claim something is a oneliner - I can create and populate a huge database with one line of code, just remove all line breaks and voila.
Even when you limit it to say "it's 5 function calls" or something like that it still makes no sense, one of those function calls could be to libEverything calling some god forsaken huge library that does everything...
Yeah I always wondered about that they have a plan thing. Sometimes they want to annihilate, then enslave, then be friends, then back to slavery and killing. Damnit! make up your AI minds! or at least get some new updates or something.
Slashdot Mirror
Google has done some work on MySQL.
Those examples are where MySQL does shine. Any web application where you got a factor of 100 or 1000 - even more reads per write, MySQL is a good option.
You can never make a generalization and say this will solve everything. The right tools for the job etc.
Actually Oracle does come in a "thin" cheap client.
To be honest I haven't checked the new prices on MySQL support, but carrier grade support was very expensive before, and I doubt it has improved with the Sun takeover. They do have support, and it is according to rumors fast, however you don't get that support unless you cough up the money for it.
bloody hell, forgot my point with IBM.
When multimillion dollar installations fails and you are paying for the support + guarantee on uptime you got somewhere to send the bill if shit hits the fan.
What will you do when your PG installation fail? Go on IRC and ask for help?
MySQL fails at some very critical points. As I said in previous post it fails to fire triggers on updates.
Also MySQL believe its better to serve a best effort than a failure - this is probably the biggest NO GO! out there. YOU NEVER EVER do something other than requested in a database. If the transaction model fails you are using no more than an advance file pointer.
Now PG is a very nice database, they got all the right things implemented, and often better than the competition.
PG however does not have any support for scaling, if you want to scale you need some form of middleware to handle it - and currently you have to buy continuent for that - which is a nice product, they however don't support stored procedures and triggers.
And please don't just hit google for PG and scaleability, and come back saying there are all sorts of products out there - most of them are based on triggers and some very bad methods for propergating data - all of them lack the ability to take down primary or secondary server(s) in a running environment and put a new up without interruption in the data flow.
That line alone tells me you got your head so far up your OSS arse you are seeing pink elephants.
IBM Denmark just went down this week for a whole day, pretty sure their big clients are a bit unimpressed in their failure to bring multimillion installations back online.
If postgres can handle your situation then fine, but in my environment a database failure means everything comes to a grinding halt. And when you promise clients 99.999% uptime you sure as hell need subsecond failover *hint you can't do that with anything that reads binary logs from primary* and zero loss of transactions.
This is not entirely true. MySQL will revert to MyISAM even though you specifically asked for InnoDB - it will however issue a warning that it is doing so, this of course is a moot point since most application programmers never check for warnings.
And just to feed the flames while we're at it, MySQL will fail to fire triggers on cascading events.
If you got table A and B and C where B references some information in A and C in B all cascades on updates in A, then any update trigger on C (and possibly B) will fail to fire. This is a very big problem if you are using triggers to keep at least some form of consistency.
To top it up most replication services in MySQL are at best flaky, usually they replicate by using the binary log, so if the primary fails you lost the X last seconds/minuttes/hours (depending on setup and load) of transactions. Even if you got the binary log on a GFS you are still in big trouble since the secondary still needs to replay all transactions leading to the failure - I've heard of sites where this was taking minuttes to complete! (This might change in the new version)
Personally I wouldn't touch either PGSQL or MySQL in a mission critical environment, they are very nice toy databases, but when shit hits the fan - and it WILL happen - you need a reliable system with instant failover, which neither database can provide.
Actually not a bad idea, quite a bit of objects are stationary in a game, so you can offload that to secondary GPU's - the problem is most games/engines haven't been designed for this in mind and you can't magically create something that can do this for them.
Over time the GPU's will be more flexible and that means it will be easier to offload calculations through some common API, but I think it will be a few years yet before this potential can be realized.
those must see adds are gonna lose people traffic. I automatically close the site these days, been way to many sites that force a commercial that often takes longer than the content you want to see. (not in this case though)
But you can already tell who won the day after, the rest of the world counting manually have been doing so without problems for ages.
The reason they want electronic is to feed the media and nothing more.
it doesn't matter, as soon as the botnet is inside your network, you got a huge problem, any zero day exploit will be able to be fired off within your own network!
Your security is only as strong as the weakest link - educate your users!
I (finally) stopped playing counterstrike after Valve put in adds - it was just for their own games, but it pissed me off that after the money they made with the game they decided to forced a (potential) revenue stream down my throat. (No you can't opt out, servers are forced to run newest version - so are you - and NO! I shouldn't be glad they still support the game since they haven't fixed a bug for years, only added adds)
The second I see an add inside a game I play I stop playing, I can't stand adds.
Which is also the dangers of three strikes etc. - if you know you are being locked up for the rest of your life you will be fighting like a wild animal to avoid being caught.
Well I for one plan to live forever or die trying!
My soundblaster live card has worked without problems for almost a decade, finally retired it last month, while getting drivers have sometimes been a bit of a problem I have faired just fine - It is some of the most stable hardware I've had.
Your examples provide single entities buying out the competition, your post however suggested multiple competitors somehow could manage to spend heaps of cash on something which only has value by removing cost.
That will never fly with investors. Economics has no use of logical thinking, what matters is the black number on the bottom of the sheet.
Because thats not how the world works. Who should own the patent afterwards? You can't as a corporation go out paying heaps of dollars for something that you won't end up owning.
Those two last numbers look like Hollywood accounting to me. It's BS that they claim they can't get lower, here in Denmark a store that specializes in cheap imported goods (around $2 per item) have created their own label, they don't do promotion just take up any local bands and run around 2-5000 cd's. The CD's usually sell for around $4, now they of course have way less promotion overhead since they don't actually promote the stuff, just put it in a great big bin, the bands get around half, rest goes to the chain.
From the parent post a lot of the expenses can be removed since Wal-Mart probably will be doing the promotion and distribution - and quite probably could handle the manufacturing through contacts in Asia, they are experts in huge volumes.
100 fps? Are you friggin kidding me? Right now gamers are trying to break the 30 fps mark with all eye candy enabled. High end GFX boards sure as hell have a use these days and will continue as soon as game developers and MS get their act together and learn to program for multiple GPU/CPU's.
Uhm, perhaps you should entertain your guests by normal means, ig. talking? Using the house alter (TV) as entertainment isn't being social.
$10,000 says you can't run Crysis in a nice setting on a 1920x1200 or above settings.
Yes you can run at a pretty crappy resolution with low textures on a $150 board, but then why bother?
After I upgraded from a 21" CRT to 24" LCD and put in some very nice equipment the "Uhh look at that effect" factor went skywards. Yes you can have fun at $150, but having the latest and greatest actually does quite a lot for the gaming experience.
I would be very surprised if MS ran off with the mp3 players.
Samsung is a more likely bet for that, they have made some very nice cool products lately.
Well for one thing he could sell all the bounces to spammers, any mail that arrives as a reply mail is a confirmed email address saving spammers quite a lot of time.
Also you can probably do all sorts of nice data mining on the information - or even just a simple search for certain "interesting" keywords (ig. top-secret, internal, for your eyes only) and dig up all sorts of interesting stuff you can sell to media.
Could we please please PLEASE! stop talking about programs in terms of lines of code?? It makes no sense! You can't just claim something is a oneliner - I can create and populate a huge database with one line of code, just remove all line breaks and voila.
Even when you limit it to say "it's 5 function calls" or something like that it still makes no sense, one of those function calls could be to libEverything calling some god forsaken huge library that does everything...
That is probably one of the funniest and most insightful lines I've read all week.
Yeah I always wondered about that they have a plan thing. Sometimes they want to annihilate, then enslave, then be friends, then back to slavery and killing. Damnit! make up your AI minds! or at least get some new updates or something.