Master Slave at Application level

[mangesh1757]

Hi All,


Can any one provide details on Master / Slave implementation at SugarCRM Application layer.

I am aware but not able to implement much of it.

Idea :
1. Define master and slave server details under coonfig.php or config_override.php file
2. Modify function connect under include/database/MysqlManager.php to pass both master and salve details by modifying $configOptions Array. Also passing 3rd argument to connect function which decide write / read operations
3. Then accordingly modify function query connect to database.

But this all seems to be quite complex.

Can anyone provide me some insight on this issue.

Please Help!!

[christianknoll]

What are you trying to achieve? If you want to build a MYSQL Slave do this via MYSQL. If you are looking to build a cluster also do this on the database layer.

christian.

Hi All,


Can any one provide details on Master / Slave implementation at SugarCRM Application layer.

I am aware but not able to implement much of it.

Idea :
1. Define master and slave server details under coonfig.php or config_override.php file
2. Modify function connect under include/database/MysqlManager.php to pass both master and salve details by modifying $configOptions Array. Also passing 3rd argument to connect function which decide write / read operations
3. Then accordingly modify function query connect to database.

But this all seems to be quite complex.

Can anyone provide me some insight on this issue.

Please Help!!

[mangesh1757]

What are you trying to achieve? If you want to build a MYSQL Slave do this via MYSQL. If you are looking to build a cluster also do this on the database layer.

christian.

I am trying to achieve master slave phenomena at application layer. (Reads from Slave | Writes on Master)

I guess Enterprise edition has this feature.

PS : Already Master Slave set-up is complete at database layer.

[mangesh1757]

Any Updates!!!

[kbrill]

There is nothing to do at the application layer, all of this happens at the DB layer, read about Scale out solutions here.

[christianknoll]

you will need to do some smart modifications on the DB layer, instantiating a second DB connector, checking every Query before it is executed and sending it then to the proper DB. Should not be too hard to do (just do a preg_match in the query if update or insert is in and if yes send it to the master, if not sen it to the slave. If you know what to do it should be done in an hour.

christian.

Any Updates!!!

[christianknoll]

If you want to have reads go to one and updates to another it is an applciation issue. But I think manageable.

Christian.

PS: like you footerline with the SweetActivities - but why not use a proper reporting tool like KReporter where this can be simply done with union reporting ... ;-)

There is nothing to do at the application layer, all of this happens at the DB layer, read about Scale out solutions here.

[kbrill]

you will need to do some smart modifications on the DB layer, instantiating a second DB connector, checking every Query before it is executed and sending it then to the proper DB. Should not be too hard to do (just do a preg_match in the query if update or insert is in and if yes send it to the master, if not sen it to the slave. If you know what to do it should be done in an hour.

christian.

I dont think you have to do any of this. You can specify (at the DB layer) that all reads come from the slave(s) and all writes go to the master. No changes to SugarCRM at all.

[kbrill]

If you want to have reads go to one and updates to another it is an applciation issue. But I think manageable.

Christian.

PS: like you footerline with the SweetActivities - but why not use a proper reporting tool like KReporter where this can be simply done with union reporting ... ;-)

You could do that too, never used KReporter. Does kreporter support dashlets, inline editing, graphs and and the pro/ent/ult reporting module and all its options? I am sure there is a hundred ways to skin this cat but I am trying for a way that integrates into SugarCRM a little better than the external reporting tools do.

[christianknoll]

It probably does more and integrates even better ... ;-) ... always keep your eyes open on the great things some of ypour partners develop ...

christian.

You could do that too, never used KReporter. Does kreporter support dashlets, inline editing, graphs and and the pro/ent/ult reporting module and all its options? I am sure there is a hundred ways to skin this cat but I am trying for a way that integrates into SugarCRM a little better than the external reporting tools do.