MySQL distribution

[Boreas]

Hi

Im building a datawarhouse, and because of preformance issues this database has to be fast.

In order to speed up the dw Im trying to divide the fact table into smaller fact tabels distributed through varios computers.

Because of $ related issues Im going to try to use MySql or PostgreSQL. The problem is that I dont know if these servers allow distribution of tabels to various computers.

Oracle has a "database link" command that permits this, does MySQL have a command similar to Oracle's database link?

Thanks

 

[abombss]

No there are no linked tables, mysql does have replication which can be used for some type of load balanceing. MySQL also has the ability to compress and pack tables that are read only. You can get pretty good results, but no where near the compression of a Sybase IQ system.

If this is a serious DW you might have a challenge with MySQL it is not mature enough for DW type work. There is no controllable partitioning of tables and indexes and BTrees are the only indexes supported.

Ad-Hoc queries will kill the system quick.

I use MySQL for a small DM at work. The data is pulled from our ODS, transformed exactly how we need it and loaded in read only tables. For a tiny machine and lot of data it does an awesome job for our canned reporting. However, I have run some ad-hoc stuff that cripples the system very quickly.

abombss