Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
Textpattern and MySQL Replication
I’ve been running Textpattern for years and it’s still my preferred CMS, but I’m looking to expanding a few sites and couple will likely need MySQL replication to get where I want. I didn’t see any discussions here on the forum (maybe I missed them) or in my Googling regarding Textpattern and replication playing well together, so I’d like to bounce it off of you all.
First, with MySQL replication, writes are only supported to the master server while reads can be performed against any of the slave servers, but Textpattern only seems to support one database, AFAICT. I could do master-master replication, but then I’d be limited to two masters and it’s pretty sketchy (have to alternate the auto-increment between the two; plus tables don’t lock between the two, so UPDATE commands can cause problems).
I’ve developed a number of plug-ins for Textpattern so I’m relatively familiar with the source. It seems like it’d be relatively easy to patch to support a master server and slave databases, esp. since most MySQL writes are limited to safe_insert(), safe_upsert(), safe_update(), and safe_optimize, etc., correct?
Has anyone played with Textpattern in this kind of way? Is there hidden functionality I’m not aware of? Or other ways of tackling this? Would others be interested in my sending the developers a patch for supporting master & slave MySQL DBs?
Morgan Aldridge
http://www.makkintosshu.com/
Offline
Pages: 1