MySQL Forums
Forum List  »  Data Warehouse

Re: Stored procedure and connexion to another MySQL DB
Posted by: Rick James
Date: April 04, 2010 10:05AM

FEDERATION will allow you to talk to two servers. But I don't recommend it -- performance can be worse than terrible.

You can have two mysqld running on the same machine if you use different ports (3306 is the default). But they MUST NOT touch the same data.

For two servers to touch the same data, they need to deal with
* Interlocks against writing at the same time
* AUTO_INCREMENT
* Avoiding caching writes -- the other server can't see the cache.
* Etc.

So even if that were possible, performance would be poor.

Alternative...
Set up Master-Slave. You write to the Master, it gets replicated 'immediately' to the Slave. You can do you DW-heavy reads on the Slave.

Have you considered Summary tables? I find them to be the a big performance boost on typical DW applications.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Stored procedure and connexion to another MySQL DB
4765
April 04, 2010 10:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.