Open Dental Forum

I agree completely with you Dr. Sparks on #3. That could be a nightmare!

When/if you do decide to look for "massive" multi-site replication please do repost...I happen to be working on the same type of problem.

Agreed FCarlier (see my post from Mon Nov 05, 2007 3:36 pm). Another way (or perhaps a compliment to using mysqlproxy) is to have an "update log" with update "statements" (sql or otherwise) that all the interested parties could read/write against. The only job of the central server would be to catal...

After doing more research, another way to accurately describe the mysql "replication" (as you note, it's not exactly as robust as required) is that slaves may only have one master. Masters can have multiple slaves (as you state). So, I thought I would be clever... I set up to disjoint systems: A <->...

So, I'm confused...are you wanting to replicate all data or just patient (and supporting) data?

Not sure if this is still an active topic...but here's a quick guide to help get you started in command line: Chmod changes the permissions on files, Chown changes the owner. So, if you'd like to change them... 1) What are the permissions? Issue the following command to check them out: ls -tlrh ls i...

I've not tested this out before...but you might be interested in: http://forge.mysql.com/wiki/MySQL_Proxy Looks like you're supposed to connect just like normal mysql and you can write statement interceptors (i.e. INSERT <>, UPDATE <>...) to create a home-grown replication platform. more to follow...

I stand (sit) corrected. There are several presentations from MySQL that make the claim of star replication. I decided to try it (as described) and no joy.

Does OD currently utilize an abstraction layer for database access (eg. ORM or something...)?

Wow! 50+ offices...I understood the problem to be more along the 3+ office scale...at that scale it's more likely called clustering rather than simply replication. You might want to look into what MySQL calls "star replication". This is the idea that you have one central hub (currently your master) ...

Just a few comments... I think you may be making this a bit more complicated that it needs to be. There are a few types of data replication. The most common are: 1) Master -> Slave: This is the replication you described. Many databases support this and it's quite easy to implement in an RDBMS (from ...