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 = 114895
interpreted = N
texte = 2523--Apple-Mail-3FFC2167-7083-4BAF-B560-21D2127383A0Content-Type: text/plain;charset=utf-8Content-Transfer-Encoding: quoted-printableChris:https://mariadb.com/kb/en/library/client-libraries/Sincerely,=20D. Brooke MobileOn Oct 6, 2019, at 5:22 AM, christophe.billiottet@webdna.us wrote:>> Nice idea Chris, however 30 seconds to replicate is far too slow in an ec=ommerce or high usage client data entry site.>=20> the idea is to exclude the server being written on from the round robin cl=uster during the 30 seconds it takes to rsync the databases with the master.= The experience would be transparent for the users.>=20>=20>> The read from the slaves is OK but would mean another level of infrastruc=ture to balance the load across the slave servers, so in effect a load balan=cer.>=20> WebDNA front-end can do this sequentially; it is easy to write a small scr=ipt that would send users to server 1, then to server 2, then to server 3 et=c=E2=80=A6 so the front end could operate as a load balancer. It could even u=se a specific script to check if each server is up before pointing users at i=t.>=20>> I know that the MySQL has been dropped from WebDNA>=20> yes, and I would like to explain why: MySQL belongs to Oracle, and the lic=enses do not allow to embed the MySQL connectors inside WebDNA. Since each f=lavor of linux has a different way of implementing these connectors, (versio=n/location) then we had to build as many WebDNA linux versions as linux flav=ors, each case needed to be addressed. It means 10 to 14 executables for Web=DNA.>=20>=20> chris>=20>=20> ---------------------------------------------------------> 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--Apple-Mail-3FFC2167-7083-4BAF-B560-21D2127383A0Content-Type: text/html;charset=utf-8Content-Transfer-Encoding: quoted-printable
Chris:
Sincerely,
D. Brooke Mobile
=Nice idea Chris, however 30= seconds to replicate is far too slow in an ecommerce or high usage client d=ata 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 w=ould be transparent for the users.<=br>
The read from the slaves is OK but would m=ean another level of infrastructure to balance the load across the slave ser=vers, 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 ev=en use a specific script to check if each server is up before pointing users= at it.I know th=at the MySQL has been dropped from WebDNA
yes, and I would like to explain why: MySQL belongs to Oracle, a=nd the licenses do not allow to embed the MySQL connectors inside WebDNA. Si=nce each flavor of linux has a different way of implementing these connector=s, (version/location) then we had to build as many WebDNA linux versions as l=inux flavors, each case needed to be addressed. It means 10 to 14 executable=s for WebDNA.
chris=
--------------------------------=-------------------------
This message is sent to you becaus=e 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
=---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=3D55Bug Reporting: support@webdna.us--Apple-Mail-3FFC2167-7083-4BAF-B560-21D2127383A0--.
Associated Messages, from the most recent to the oldest:
2523--Apple-Mail-3FFC2167-7083-4BAF-B560-21D2127383A0Content-Type: text/plain;charset=utf-8Content-Transfer-Encoding: quoted-printableChris:https://mariadb.com/kb/en/library/client-libraries/Sincerely,=20D. Brooke MobileOn Oct 6, 2019, at 5:22 AM, christophe.billiottet@webdna.us wrote:>> Nice idea Chris, however 30 seconds to replicate is far too slow in an ec=ommerce or high usage client data entry site.>=20> the idea is to exclude the server being written on from the round robin cl=uster during the 30 seconds it takes to rsync the databases with the master.= The experience would be transparent for the users.>=20>=20>> The read from the slaves is OK but would mean another level of infrastruc=ture to balance the load across the slave servers, so in effect a load balan=cer.>=20> WebDNA front-end can do this sequentially; it is easy to write a small scr=ipt that would send users to server 1, then to server 2, then to server 3 et=c=E2=80=A6 so the front end could operate as a load balancer. It could even u=se a specific script to check if each server is up before pointing users at i=t.>=20>> I know that the MySQL has been dropped from WebDNA>=20> yes, and I would like to explain why: MySQL belongs to Oracle, and the lic=enses do not allow to embed the MySQL connectors inside WebDNA. Since each f=lavor of linux has a different way of implementing these connectors, (versio=n/location) then we had to build as many WebDNA linux versions as linux flav=ors, each case needed to be addressed. It means 10 to 14 executables for Web=DNA.>=20>=20> chris>=20>=20> ---------------------------------------------------------> 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--Apple-Mail-3FFC2167-7083-4BAF-B560-21D2127383A0Content-Type: text/html;charset=utf-8Content-Transfer-Encoding: quoted-printable
Chris:
Sincerely,
D. Brooke Mobile
=Nice idea Chris, however 30= seconds to replicate is far too slow in an ecommerce or high usage client d=ata 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 w=ould be transparent for the users.<=br>
The read from the slaves is OK but would m=ean another level of infrastructure to balance the load across the slave ser=vers, 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 ev=en use a specific script to check if each server is up before pointing users= at it.I know th=at the MySQL has been dropped from WebDNA
yes, and I would like to explain why: MySQL belongs to Oracle, a=nd the licenses do not allow to embed the MySQL connectors inside WebDNA. Si=nce each flavor of linux has a different way of implementing these connector=s, (version/location) then we had to build as many WebDNA linux versions as l=inux flavors, each case needed to be addressed. It means 10 to 14 executable=s for WebDNA.
chris=
--------------------------------=-------------------------
This message is sent to you becaus=e 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
=---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=3D55Bug Reporting: support@webdna.us--Apple-Mail-3FFC2167-7083-4BAF-B560-21D2127383A0--.
Donovan Brooke
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:
[WebDNA] Is WebDNA slowing things up - please try these URL's (2013)
Searchtitle (2000)
New Command prefs ... (1997)
WEBCAT with SQL backend. Help please! (2000)
WebCat2b12 - nesting [tags] (1997)
Latin Characters (1998)
Funny Chars (1999)
OFF-TOPIC: Lending investors ... (2002)
THANKS!!! ShipCosts.db and debugging (1997)
BIG PROBLEMS with Checkboxes!!! (1998)
[listchars] request (was: Bug in capitalize ... ?) (2003)
Can I invoke an ssi plugin from within a webcat page (1997)
Getting Values into Cart the easy way?* (1998)
Extended [ConvertChars] (1997)
More on the email templates (1997)
Virtual Postcard almost complete... (1998)
Bad Cookie / Internet Option / Internet Explorer (2004)
listcookies works only sometimes (1997)
[convertChars] and in a textarea on a form (1998)
If search results are blank... (2003)