mysql replication - scale out architecture

Hi All

I’m evaluating modx as a base for a high volume CMS system.

One of the options we are looking at is a mysql scale out architecture where there will be a number of mysql slaves used for reads and searches and a master for update/insert/delete.

Can modx be easily configured to do this?

Ron

As long as the DBAPI is being used in all code, it shouldn’t be difficult to modify the dbapi.mysql.class.inc.php to access the different servers for the different functions.

thanks for the quick reply!

is everything in the current code base using the DBAPI?
or are there some db calls that bypasses this api?
if so, are there any plans to refactor?

Thanks
ron

Quote from: rchan at Mar 12, 2006, 03:13 PM

is everything in the current code base using the DBAPI?
or are there some db calls that bypasses this api?

Currently, there are many spots in the code not using the DBAPI. These include legacy calls to deprecated Etomite db functions or direct calls to mysql_ php functions.
Quote from: rchan at Mar 12, 2006, 03:13 PM

if so, are there any plans to refactor?

Ron, it might be good to add a feature request in our bug tracker (http://modxcms.com/bugs/) for refactoring this in the current MODx codebase. I might be able to knock that one out pretty quickly for an upcoming release, and a task in the tracker would help me remember to do it.