I searched this forum and found posts, but no answers (nor replies, for that matter).

I set up my local.xml file to enable the default_setup and default_read database connections.  It seems that no read requests ever hit the slave server during a read.  To test, I stopped MySQL on the slave.  The frontend continued to work.  Not sure if there’s a built-in fall back in case the default_read server fails.

We are using the Community edition of Magento.  Does this functionality only exists for the Enterprise version or something? 

Keith

Did you ever get this issue solved?

I’m currently experiencing the same problem

David Smart - 09 March 2011 05:32 AM

Did you ever get this issue solved? 

I’m currently experiencing the same problem

Hi David,

Yes.  I did get this working after searching this forum a bit.  I’ll show you my config.  I have reverted since then though because we found weird behaviors with it.  For example, when searching the store, the first search would fail.  But if you clicked search again, it would work.  Unfortunately, I didn’t see that much of a performance increase using the master/slave setup.

1.  Disable Cache Managment

2.  Update <magento_install_dir>/app/etc/local.xml

Just replace host, username, password, and dbname.

3.  Enable Cache Management.

Hope that helps.

Keith

Hi Keith,

I’ve tried that with no luck, thanks for the help though!

Actually, it did, I missed

David Smart - 09 March 2011 06:09 AM

Actually, it did, I missed

<use/>

thank you!

Yay!  Yea, that was something I found that magically made it work.  Apparently, that “clears” the already declared <connection> tag, I think.  I found that information here: http://www.magentocommerce.com/boards/viewthread/7397/

Glad it worked.

Keith

Hmm,

I can see an increase in performance, but I’m seeing that search issue as well, have to investigate further

thanks 
Dave

I managed to ‘fix’ the search:

in app/code/core/Mage/CatalogSearch/Model/Mysql4/Fulltext.php I changed both instances of : 

Bit of a hack, but at least it’s searching correctly! I should probably move it to the local folder to prevent overwriting.

David Smart - 09 March 2011 07:37 AM

I managed to ‘fix’ the search: 

in app/code/core/Mage/CatalogSearch/Model/Mysql4/Fulltext.php I changed both instances of : 

$this->_getReadAdapter()

to 

$this->_getWriteAdapter()

Bit of a hack, but at least it’s searching correctly! I should probably move it to the local folder to prevent overwriting.

Nice!  I’ll have to give that a try.