Re: [WebDNA] two ideas for running a cluster of WebDNA servers
This WebDNA talk-list message is from 2019
It keeps the original formatting.
numero = 114884
interpreted = N
texte = 2512 > Nice idea Chris, however 30 seconds to replicate is far too slow in an = ecommerce or high usage client data entry site. the idea is to exclude the server being written on from the round robin = cluster during the 30 seconds it takes to rsync the databases with the = master. The experience would be transparent for the users. > The read from the slaves is OK but would mean another level of = infrastructure to balance the load across the slave servers, so in = effect a load balancer. WebDNA front-end can do this sequentially; it is easy to write a small = script that would send users to server 1, then to server 2, then to = server 3 etc=E2=80=A6 so the front end could operate as a load balancer. = It could even use a specific script to check if each server is up before = pointing users at it. > I know that the MySQL has been dropped from WebDNA yes, and I would like to explain why: MySQL belongs to Oracle, and the = licenses do not allow to embed the MySQL connectors inside WebDNA. Since = each flavor of linux has a different way of implementing these = connectors, (version/location) then we had to build as many WebDNA linux = versions as linux flavors, each case needed to be addressed. It means 10 = to 14 executables for WebDNA. chris --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us .
Associated Messages, from the most recent to the oldest:
2512 > Nice idea Chris, however 30 seconds to replicate is far too slow in an = ecommerce or high usage client data entry site. the idea is to exclude the server being written on from the round robin = cluster during the 30 seconds it takes to rsync the databases with the = master. The experience would be transparent for the users. > The read from the slaves is OK but would mean another level of = infrastructure to balance the load across the slave servers, so in = effect a load balancer. WebDNA front-end can do this sequentially; it is easy to write a small = script that would send users to server 1, then to server 2, then to = server 3 etc=E2=80=A6 so the front end could operate as a load balancer. = It could even use a specific script to check if each server is up before = pointing users at it. > I know that the MySQL has been dropped from WebDNA yes, and I would like to explain why: MySQL belongs to Oracle, and the = licenses do not allow to embed the MySQL connectors inside WebDNA. Since = each flavor of linux has a different way of implementing these = connectors, (version/location) then we had to build as many WebDNA linux = versions as linux flavors, each case needed to be addressed. It means 10 = to 14 executables for WebDNA. chris --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us .
christophe.billiottet@webdna.us
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Problems with cybercash (2000)
Webcat 3.0.7 & Webmerchant (2002)
WebCatalog not running.. (2001)
math on date? (1997)
Generating Report Totals (1997)
[protect admin] (1997)
Proposed FormVariables hierarchy (2000)
WebCatalog2 Feature Feedback (1996)
WebCatalog Features (1997)
Chat (2000)
WebStar SSL and WebCatalog conflict? (1999)
REPLACE and/or APPEND (2002)
Fuzzy on [url] context (1998)
NT or Mac (1997)
Where's Cart Created ? (1997)
Secure Server not remembering discounts (1998)
autosensing lanague selection (1997)
Help name our technology! (1997)
Bug or syntax error on my part? (1997)
MacWorld NY (2000)