Is it a good idea to setup working with mysql cluster?

[daniel_locious]

Hi guys,

Has anyone here considered to setup the broadleaf working with mysql cluster? I saw a document says broadleaf "For most sites, MySQL performs sufficiently." But, "Choosing a DB platform for an enterprise eCommerce system is an important decision with a number of factors. "

As a small business, is it good to start setup the database cluster in production directly? Or I should wait until Mysql db can't afford?

Any experience sharing would be appreciated.

Regards,

Dan

[RapidTransit]

Piece of advice

I've always been a proponent of PostgreSQL, this is why MySQL is so popular:

Back in the day, MySQL had native text search, it was faster because back then nobody cared for ACID compliance, Foreign Keys? Forget about it.

Now if you want those features with MySQL that slows MySQL way down.

Benchmarks: http://www.jpab.org/Hibernate.html

If you want clustering though, I think you have to use EnterpriseDB

I can't recall the name, but with PostgreSQL you can query multiple Primary Keys at once, it's a no go with MySQL.

[daniel_locious]

Hi RapidTransit,

Thanks for your reply; yes I agree with you, also feel postgres is getting better. Plus, Postgres does support clustering .... for text search? We've got solr have we?
Cheers,

Dan