Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.
For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email email@example.com.
Clusters cannot use foreign keys so although you can replace them with stored procedures, it is not worth the effort of maintenance, upgrades and stability. We analysed and decided against it using write and read databases with Magento, some of the largest sites on the internet only use a single db server.
You may want to look at this http://www.magentocommerce.com/boards/viewthread/281168/