Hi all again,
I'm trying to deicide the best choice for clusters and servers management.
At the first specification, I suggested to manage it using *insert, update *and
*delete *commands over 3 system tables (DDE_CLUSTER, DDE_SERVER and
DDE_SERVER_CLUSTER).
(old spec is in http://www.geocities.com/fmotaol/DDE/DDEspec.htm)
But now, I'm thinking about the possibility to use specific commands for
manage it, such as:
*create dde_cluster My_dde_cluster (
1 as 'mysql://dbserver.mysql.com:3306/mydb1' user root password 'test',
2 as local user root password 'test',
3 as 'mysql://anotherserver.mysql.com:3306/mydb1' user root password 'test'
);*
* *
*subscribe 4 as 'mysql://fourthserver.mysql.com:3306/testdb' into
My_dde_cluster user root password 'test';*
*unsubscribe 4 from My_dde_cluster;
*
Despite it might increment a little bit the language parser, it could
improve the usability.
So, I would like to get this decision not based only in user-side, but also
in technical aspects, such as development cost and maintainibility.
Waiting for suggestions, thank you since now.
Regards,
Fabricio Mota
--
Sem mais,
Fabricio Mota
Oda Mae Brown - Aprecie sem moderação.
http://www.odamaebrown.com.br
