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] 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)