As a DBA and Linux admin, I've had nothing but trouble with Drupal. We have several large-ish Drupal deployments, and we've had to hack away at the code for over a year now, and it's getting stable now, because we started building our own Drupal version with a shitload of patches to the core.
Drupal works indeed fine for small-scale deployments, but as soon as you want to use Drupal's famed flexibility and customizability, and scale your site out, you're going to run into trouble, mostly with your database - especially if you want a lot of logged-in-only content.
If Drupal is really serious about going on to be used for large, professional deployments, the best recommendation I have for Dries and the gang, is to abandond the entire "but we want to be compatible with all databases" whine, and decide on ONE database, which they use CORRECTLY and EFFICIENTLY. I'm sorry, but nearly a hundred queries for a single pageview is not acceptable. Please decide on an optimum technology stack and use it efficiently; and publish both the optimum stack and a fully patched, efficient version of the code specifically for large-scale deployments.
We've in the mean time rewrote the caching engine to correctly support Memcached - some parts of Drupal still fuck up, though, so ftm we've got 12 separate Memcache bins for every site deployment, to avoid one module flushing the cache of an entirely different site. We looked at read-write splitting for the database, and found that it won't work (on mysql, at least) because of the way Drupal interacts with the database. We're doing ugly tricks wih Squid and cookies, because not-logged-in users sometimes get content from logged-in pages. We've done oodles of patches on Drupal core, to optimize database use and remove needless full table locking. We're writing custom modules to avoid using Drupal Views, which create queries that are so inefficient that one of them on the front page can kill your monster of a database host.
No, Drupal may be very good for quick, small deployments, but if you're looking for something to build a high-traffic site with plenty of customization and member-only data, you're better off building your own framework from scratch, with scalability in mind.
If you're a DBA looking to set up for Drupal: http://www.amazon.com/Book-Bunny-Suicides-Andy-Riley/dp/0452285186
Re:Drupal is impossible unless you're a consultant
on
Drupal Multimedia
·
· Score: 1
> Views is essentially a query builder that builds the most horrendous, inefficient queries you ever layed eyes on.
There, fixed that for you.
Re:Don't use Drupal. It's a piece of shit.
on
Drupal Multimedia
·
· Score: 1
No, it's not easy, and most of the 'dozens of optimizations' are not supported, badly documented, and not compatible with later smooth upgrading to newer drupal versions.
The only reason it "works quite well for small sites on shared hosting", but needs loads of fixes to scale, is that it's incredibly badly written from a database point of view. The more accurate formulation of all that is "it's so crap that it won't scale without extensive hacking with a large axe".
Re:How does it compare to online help
on
Drupal Multimedia
·
· Score: 2, Interesting
The wonderful Drupal community's answer to quite a lot of the things we try do to with drupal, is "not supported, and we won't tell you why". No, thanks.
Can you then also come to us and make it work WELL ? Sure, it works, but what I especially loathe about it is the way it (ab)uses the database. Dries and his minions' attitude is "we want it to work on as many databases as possible", and the end result is an abomination that works on all but scales on none. Whoever had the bright idea to do explicit full table locks on every table, for every insert ? We've spent more time hacking at the drupal core than we probably would've just writing a custom framework from scratch, and we still get unexpected and ridiculous database connection peaks from time to time. Even squid and memcached don't fix things all the way, because it's apparently nigh impossible to cache pages for logged-in users.
...how exactly do the spammers know which users are pre-moderated on which groups ?
Just blasting all addresses, regardless of validity may be a good tactic for standard mailboxen, but it seems to me that the ratio of pre-moderated to not-even-subscribed on any given group would be pretty prohibitive. Coupled with the presumably already reasonably low positive feedback on spam (which is not to say that the roi is bad, mind you), and you *should* get only fragments of percents of successfully inserted mails - UNLESS you have prior knowledge of which addresses will work on which groups.
Okay, who wants to bet that the entirety of the human race is the result of a handful of homo sapiens females having been raped by a bunch of neanderthals ?
Just a guess: some bigwig signed an exclusivity deal with AT&T, not realising that there is a rather sizeable "rest of the world" where AT&T is not omipresent.
The also-to-be-modded-down answer to that is "not natively" as in, there's no railkits or cable guides. You can of course dump them on plates, probably four in 2U, or maybe 8 in 3U, I'm not sure.
However, while 'rackmountable' is nice (no uncabling to open up a box is win), my main concern is the absense of dual power supplies and multiple, preferrably independent ethernet ports for bonding.
For a small business, this might be just the thing, but you're not putting them in *my* server room.
And, more importantly, if B&N decides to do an Amazon, it'll take under a week before someone drops a patch on the net. that allows you to read all your books again.
Did I miss an update somewhere ? Last time I checked, the Wii 's operating system did not support SDHC, although the hardware does, as evidenced by homebrew.
Agreed, but the stereotypical view of accountants is "boring", while the stereotypical view of IT guys is "weird". To me, this indicates that IT guys are weirder than most, because otherwise that stereotype would have been assigned to another group.
Slashdot Mirror
As a DBA and Linux admin, I've had nothing but trouble with Drupal. We have several large-ish Drupal deployments, and we've had to hack away at the code for over a year now, and it's getting stable now, because we started building our own Drupal version with a shitload of patches to the core.
Drupal works indeed fine for small-scale deployments, but as soon as you want to use Drupal's famed flexibility and customizability, and scale your site out, you're going to run into trouble, mostly with your database - especially if you want a lot of logged-in-only content.
If Drupal is really serious about going on to be used for large, professional deployments, the best recommendation I have for Dries and the gang, is to abandond the entire "but we want to be compatible with all databases" whine, and decide on ONE database, which they use CORRECTLY and EFFICIENTLY. I'm sorry, but nearly a hundred queries for a single pageview is not acceptable. Please decide on an optimum technology stack and use it efficiently; and publish both the optimum stack and a fully patched, efficient version of the code specifically for large-scale deployments.
We've in the mean time rewrote the caching engine to correctly support Memcached - some parts of Drupal still fuck up, though, so ftm we've got 12 separate Memcache bins for every site deployment, to avoid one module flushing the cache of an entirely different site. We looked at read-write splitting for the database, and found that it won't work (on mysql, at least) because of the way Drupal interacts with the database. We're doing ugly tricks wih Squid and cookies, because not-logged-in users sometimes get content from logged-in pages. We've done oodles of patches on Drupal core, to optimize database use and remove needless full table locking. We're writing custom modules to avoid using Drupal Views, which create queries that are so inefficient that one of them on the front page can kill your monster of a database host.
No, Drupal may be very good for quick, small deployments, but if you're looking for something to build a high-traffic site with plenty of customization and member-only data, you're better off building your own framework from scratch, with scalability in mind.
If you're a DBA looking to set up for Drupal: http://www.amazon.com/Book-Bunny-Suicides-Andy-Riley/dp/0452285186
> Views is essentially a query builder that builds the most horrendous, inefficient queries you ever layed eyes on.
There, fixed that for you.
No, it's not easy, and most of the 'dozens of optimizations' are not supported, badly documented, and not compatible with later smooth upgrading to newer drupal versions.
The only reason it "works quite well for small sites on shared hosting", but needs loads of fixes to scale, is that it's incredibly badly written from a database point of view. The more accurate formulation of all that is "it's so crap that it won't scale without extensive hacking with a large axe".
The wonderful Drupal community's answer to quite a lot of the things we try do to with drupal, is "not supported, and we won't tell you why". No, thanks.
Can you then also come to us and make it work WELL ? Sure, it works, but what I especially loathe about it is the way it (ab)uses the database. Dries and his minions' attitude is "we want it to work on as many databases as possible", and the end result is an abomination that works on all but scales on none. Whoever had the bright idea to do explicit full table locks on every table, for every insert ? We've spent more time hacking at the drupal core than we probably would've just writing a custom framework from scratch, and we still get unexpected and ridiculous database connection peaks from time to time. Even squid and memcached don't fix things all the way, because it's apparently nigh impossible to cache pages for logged-in users.
Bah, rid me of this crud.
...how exactly do the spammers know which users are pre-moderated on which groups ?
Just blasting all addresses, regardless of validity may be a good tactic for standard mailboxen, but it seems to me that the ratio of pre-moderated to not-even-subscribed on any given group would be pretty prohibitive. Coupled with the presumably already reasonably low positive feedback on spam (which is not to say that the roi is bad, mind you), and you *should* get only fragments of percents of successfully inserted mails - UNLESS you have prior knowledge of which addresses will work on which groups.
Okay, who wants to bet that the entirety of the human race is the result of a handful of homo sapiens females having been raped by a bunch of neanderthals ?
Only in Kenya ? They got Lions ? Lions and tigers ?
Now for someone to create a marketroid to english translator.
Well, give or take a few zeroes, which are worth nothing in any case. Cut the man some slack.
Just a guess: some bigwig signed an exclusivity deal with AT&T, not realising that there is a rather sizeable "rest of the world" where AT&T is not omipresent.
Quite true. I would guess that the only ones who go to NVidia/ATI to fetch the latest drivers, would be hardcore gamers.
The also-to-be-modded-down answer to that is "not natively" as in, there's no railkits or cable guides. You can of course dump them on plates, probably four in 2U, or maybe 8 in 3U, I'm not sure.
However, while 'rackmountable' is nice (no uncabling to open up a box is win), my main concern is the absense of dual power supplies and multiple, preferrably independent ethernet ports for bonding.
For a small business, this might be just the thing, but you're not putting them in *my* server room.
Are you saying that I couldn't use it on, say, a boat or a plane because I need connectivity to read my books ?
Yeah, I also got confused for a moment, there. Apparently they use 'wireless' to mean 'mobile data'. Is this common over the pond ?
It also goes dark at night. There might be a hungry grue.
And, more importantly, if B&N decides to do an Amazon, it'll take under a week before someone drops a patch on the net. that allows you to read all your books again.
Terrorism is bad.
Terrorism is bad.
Hmm.
TERRORISM is bad.
Nope, must've been your connection. Doesn't seem like there's anything wrong with terrorism afteCARRIER LOST
Did I miss an update somewhere ? Last time I checked, the Wii 's operating system did not support SDHC, although the hardware does, as evidenced by homebrew.
Manager, are you ?
You know many successful high-end call girls personally ?
Agreed, but the stereotypical view of accountants is "boring", while the stereotypical view of IT guys is "weird". To me, this indicates that IT guys are weirder than most, because otherwise that stereotype would have been assigned to another group.
*Goatse* mousepads ? Want !
Better I'm not sure about, but it'd definitely be more interesting.