Become a fan of Slashdot on Facebook

 



Forgot your password?
typodupeerror

Comment: Re:MySQL went wrong direction long time ago (Score 2) 146

by doofusclam (#35523426) Attached to: Drizzle Hits General Availability

I'd love to use Postgres, but need confidence that it's not got a massive deficiency somewhere.

Take a look at Postgres...it is MUCH more like Oracle in terms of a robust RDBMS. I've heard of projects taking pretty large Oracle installs...and converting over to Postgres with minimal pain.

The main reason MySQL is more popular is that it was smaller and easier to configure...but at the cost of robustness, and initially...data integrity. It was a short cut...much like {gag} MS Access proved often to be.

Postgres takes a bit more planning, and know how to install and use, but then again...so does something like Oracle.

You could probably compare:

MySql == Access

Postgres == Oracle

If you want to make some analogies.

Thank you for your replies.

I wrote the original comment - apologies, but I forgot to login (I don't login here often, I tend to lurk)

The reason I ask is because i've been suspicious of MySQL because of the dual licensing, and also because the (expensive) cluster version needs the indices to be in memory - which requires serious hardware for our setup as our data is 'long and thin'. However there is little experience of postgres here, so we spend the money.

Therefore i've never bothered with postgres, which is stupid, but I know that as many open source projects use mysql, it is the 'go to' database of choice. When speccing a database i've always asked around and people have pointed out the deficiencies of postgres as being the clustering and backup support.

To be specific - how does the clustering (any method) of postgres compare to standard mysql? What is the best way of doing hot backups? Where does the performance fall down?

I'd love to use postgres, but unfortunately i'm too busy doing other tasks to give it a good, proper test. Has anybody been through this already and do they mind sharing?

Ta,

Sean

Comment: Re:Is it a technical or a budget problem? (Score 2, Insightful) 222

by doofusclam (#34275626) Attached to: Horizontal Scaling of SQL Databases?

There are a few other players in the field next to teradata, but when you move to that format there is nothing that would be associated with the word cheap.

However, generally when it gets to that level of field the amount of data in storage usually makes it very obvious.

In some scenarios, we have avoided going to those rather massive solutions by really digging down and seeing if we really needed to store everything.

In a previous job at the start of my career, my company bought a Teradata system which came with the requisite sharp suited consultant, who told us how to lay out the DB schema.

Being Teradata all the hashed indexes were in vogue, so it was lightning fast.

Until the day they realised the users mainly did substring searches, which don't really work on a hashed index. Table scans a plenty = unhappy users.

It doesn't mean a RDBMS is bad, it means that technology misapplied always sucks.

Comment: Re:Bluecherry+ zonealarm = best SPVR (Score 1) 45

by doofusclam (#32612370) Attached to: Bluecherry Releases GPL'd MPEG-4 Driver

Very true.

I was sorting out the network of a businessman friend of mine. He'd recently spent £4000 on 4 IP cameras and a PC to monitor it all.

I've never seen such suck. The interface only worked with IE7, nothing newer, and had to install an ActiveX control plus three other InstallShield installers to get any sort of picture. Most of the screen was overlaid with cheesy graphics, and some of the tooltips were in Chinese.

The suppliers didn't have a clue about it, all they do is buy this shite by the containerfull from China. The chance of a software fix is nil as the guy who wrote it probably committed suicide after seeing how bad it was.

Anyways I whipped up a Ubuntu Server install with Zoneminder, and it's like night and day.

DVR kit is in one of those vertical markets where appalling quality is the standard, it seems.

Logic doesn't apply to the real world. -- Marvin Minsky

Working...