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-21D2127383A0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Chris: https://mariadb.com/kb/en/library/client-libraries/ Sincerely,=20 D. Brooke Mobile On 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-21D2127383A0 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Chris:
https://mariadb.com/kb/en/library/client-lib= raries/

Sincerely, 
D. Brooke Mobile

On Oct 6,= 2019, at 5:22 AM, christ= ophe.billiottet@webdna.us wrote:

=
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 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-21D2127383A0-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] two ideas for running a cluster of WebDNA servers (Donovan Brooke 2019)
  2. Re: [WebDNA] two ideas for running a cluster of WebDNA servers (christophe.billiottet@webdna.us 2019)
  3. Re: [WebDNA] two ideas for running a cluster of WebDNA servers (Brian Harrington 2019)
  4. Re: [WebDNA] two ideas for running a cluster of WebDNA servers (Donovan Brooke 2019)
  5. Re: [WebDNA] two ideas for running a cluster of WebDNA servers (WebDNA Solutions 2019)
  6. Re: [WebDNA] two ideas for running a cluster of WebDNA servers (WebDNA Solutions 2019)
  7. Re: [WebDNA] two ideas for running a cluster of WebDNA servers (Stuart Tremain 2019)
  8. Re: [WebDNA] two ideas for running a cluster of WebDNA servers (Stuart Tremain 2019)
  9. Re: [WebDNA] two ideas for running a cluster of WebDNA servers (christophe.billiottet@webdna.us 2019)
  10. RE: [WebDNA] two ideas for running a cluster of WebDNA servers ("Scott @ Itsula" 2019)
  11. Re: [WebDNA] two ideas for running a cluster of WebDNA servers (Stuart Tremain 2019)
  12. Re: [WebDNA] two ideas for running a cluster of WebDNA servers (Bob Minor 2019)
  13. Re: [WebDNA] two ideas for running a cluster of WebDNA servers (Greg Nelson 2019)
  14. Re: [WebDNA] two ideas for running a cluster of WebDNA servers (WebDNA Solutions 2019)
  15. [WebDNA] two ideas for running a cluster of WebDNA servers (christophe.billiottet@webdna.us 2019)
2523 --Apple-Mail-3FFC2167-7083-4BAF-B560-21D2127383A0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Chris: https://mariadb.com/kb/en/library/client-libraries/ Sincerely,=20 D. Brooke Mobile On 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-21D2127383A0 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Chris:
https://mariadb.com/kb/en/library/client-lib= raries/

Sincerely, 
D. Brooke Mobile

On Oct 6,= 2019, at 5:22 AM, christ= ophe.billiottet@webdna.us wrote:

=
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 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-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 Windows 5.0 sendmail bug (2003) WebCatalog/WebMerchant 2.1 (1998) [WebDNA] Emailer & SMTP (2009) FlushDatabase Suggestion (1998) Date Math bug (1998) WebCat2b13MacPlugin - [math][date][/math] problem (1997) Line Endings (2003) WebCat2 - Getting to the browser's username/password data (1997) Requiring that certain fields be completed (1997) Never Mind - Was - Credit Card Processing (2000) simple forum/bboard (2004) Server IP address-thanks (2004) Looking up two prices in database? (1997) re: Large databases in WebCat (1997) WebCat b13 CGI -shownext- (1997) Weird NT mail (1998) Supressing Error Messages (1998) several .hdr files with one db file? (1999) Re2: frames & carts (1997) Mac Vs WindowsNT (1997)