- 1. Re: [lvs-users] LVS + Database (score: 1)
- Author: Anders Henke <anders.henke@xxxxxxxx>
- Date: Mon, 25 Jun 2012 15:38:44 +0200
- The definition of "best service" may vary - what's yours? It did take Oracle a few years to write RAC and 11g, so it shouldn't be that easy :-) The application, who acts as a "client" to the database
- /html/lvs-users/2012-06/msg00043.html (15,611 bytes)
- 2. Re: [lvs-users] LVS + Database (score: 1)
- Author: Seth Call <sethcall@xxxxxxxxx>
- Date: Wed, 20 Jun 2012 20:43:38 -0500
- If you are set on postgresql + load-balancing, then use bucardo to implement a master-master postgresql database. Then, put Haproxy or LVS in front to load balance. Then, be confused when your applic
- /html/lvs-users/2012-06/msg00040.html (13,310 bytes)
- 3. Re: [lvs-users] LVS + Database (score: 1)
- Author: YesGood <sayupirapo@xxxxxxxxx>
- Date: Wed, 20 Jun 2012 20:56:42 -0400
- Hi Thanks you Enno Gröper It's for load balancing in general and the load balancing database in general. First you should know what you really need and what you want to do. I really want high availab
- /html/lvs-users/2012-06/msg00038.html (11,291 bytes)
- 4. Re: [lvs-users] LVS + Database (score: 1)
- Author: Enno Gröper <enno+lvs@xxxxxxxxxxxxxxxxx>
- Date: Wed, 20 Jun 2012 11:03:56 +0200
- Hi, Am 19.06.2012 00:00, schrieb YesGood: Using a loadbalanced cluster doesn't automatically mean offering "best service". Such a cluster introduces a huge amount of complexity, especially in a datab
- /html/lvs-users/2012-06/msg00032.html (13,185 bytes)
- 5. Re: [lvs-users] LVS + Database (score: 1)
- Author: YesGood <sayupirapo@xxxxxxxxx>
- Date: Mon, 18 Jun 2012 18:00:56 -0400
- Hi everybody The build load balancer cluster of database, in this moment is an investigation. the response of why are: - I have web server in a load balancer environment, and - I search other system,
- /html/lvs-users/2012-06/msg00027.html (10,791 bytes)
- 6. Re: [lvs-users] LVS + Database (score: 1)
- Author: Joseph Mack NA3T <jmack@xxxxxxxx>
- Date: Mon, 18 Jun 2012 07:13:20 -0700 (PDT)
- the problems with loadbalancing a database server were laid out in the HOWTO about 10yrs ago. The short answer is that you can load balance reads, but you can't loadbalance writes. If you want to loa
- /html/lvs-users/2012-06/msg00022.html (10,815 bytes)
- 7. Re: [lvs-users] LVS + Database (score: 1)
- Author: YesGood <sayupirapo@xxxxxxxxx>
- Date: Mon, 18 Jun 2012 10:07:38 -0400
- Thanks you, again. That would require logic in the app to send read-only queries to the possible to build a load balancing system of master- hot standby? if yes, I will study this issue. Well, if you
- /html/lvs-users/2012-06/msg00021.html (11,773 bytes)
- 8. Re: [lvs-users] LVS + Database (score: 1)
- Author: YesGood <sayupirapo@xxxxxxxxx>
- Date: Mon, 18 Jun 2012 10:06:23 -0400
- Hi Thank you David for your response. I need Load Balancing of the database cluster formed with 2 or more database server. Several clients can to send queries request (read and write ) to the databas
- /html/lvs-users/2012-06/msg00020.html (11,282 bytes)
- 9. Re: [lvs-users] LVS + Database (score: 1)
- Author: Graeme Fowler <graeme@xxxxxxxxxxx>
- Date: Mon, 18 Jun 2012 12:58:20 +0100
- I agree with this. The biggest question is: *why* do you want to load-balance connections to a database? Graeme _______________________________________________ Please read the documentation before po
- /html/lvs-users/2012-06/msg00019.html (9,664 bytes)
- 10. Re: [lvs-users] LVS + Database (score: 1)
- Author: David Coulson <david@xxxxxxxxxxxxxxxx>
- Date: Sun, 17 Jun 2012 19:14:12 -0400
- That would require logic in the app to send read-only queries to the correct system. Well, if you have 2 systems, and one fails, then you presumably need to be able to run everything you need one one
- /html/lvs-users/2012-06/msg00015.html (10,402 bytes)
- 11. Re: [lvs-users] LVS + Database (score: 1)
- Author: David Coulson <david@xxxxxxxxxxxxxxxx>
- Date: Sun, 17 Jun 2012 07:49:10 -0400
- No, you only want to send connections to the read/write server, otherwise clients can't update data. What are you trying to accomplish? Do you really need load balancing between two boxes, or would a
- /html/lvs-users/2012-06/msg00013.html (10,536 bytes)
- 12. Re: [lvs-users] LVS + Database (score: 1)
- Author: YesGood <sayupirapo@xxxxxxxxx>
- Date: Sun, 17 Jun 2012 02:18:58 -0400
- Hi Thanks you for yours post. I am reading your link suggestions of the PostgreSQL. It's helped me for more understand. I wanted to build a cluster master-master server, and I found the PGCluster too
- /html/lvs-users/2012-06/msg00011.html (10,516 bytes)
- 13. Re: [lvs-users] LVS + Database (score: 1)
- Author: Seth Call <sethcall@xxxxxxxxx>
- Date: Thu, 14 Jun 2012 12:04:14 -0500
- Great response Anders. And I second that: PG is configured by default extremely conservative. There is a PG healthcheck added to HAProxy as a patch in 1.4 (easy to add yourself), or you can use 1.5be
- /html/lvs-users/2012-06/msg00010.html (21,083 bytes)
- 14. Re: [lvs-users] LVS + Database (score: 1)
- Author: Anders Henke <anders.henke@xxxxxxxx>
- Date: Thu, 14 Jun 2012 18:08:53 +0200
- It's possible, when the database servers do support such a pattern. In terms of databases, you're looking for terms like "synchronous multi-master replication". As far as I know, PG doesn't support m
- /html/lvs-users/2012-06/msg00009.html (16,976 bytes)
- 15. Re: [lvs-users] LVS + Database (score: 1)
- Author: YesGood <sayupirapo@xxxxxxxxx>
- Date: Thu, 14 Jun 2012 09:29:24 -0400
- Thanks you Anders Henke And, but it's possible to build a load balancing cluster of database with LVS? where all clients connects to database servers in write and read mode. or there are other best t
- /html/lvs-users/2012-06/msg00008.html (9,121 bytes)
- 16. Re: [lvs-users] LVS + Database (score: 1)
- Author: Anders Henke <anders.henke@xxxxxxxx>
- Date: Thu, 14 Jun 2012 10:01:56 +0200
- This depends on your specific database server and install. For example, MySQL per default runs on port 3306, but may be run on any arbitary port. Please note in general, your specific application has
- /html/lvs-users/2012-06/msg00007.html (11,087 bytes)
- 17. [lvs-users] LVS + Database (score: 1)
- Author: YesGood <sayupirapo@xxxxxxxxx>
- Date: Wed, 13 Jun 2012 20:32:41 -0400
- Hi, How I can configure load balancing Database cluster with the LVS.? I use keepalived, and I have one configuration for the load balancer for the web server, but I don't know how work for the datab
- /html/lvs-users/2012-06/msg00005.html (8,710 bytes)
This search system is powered by
Namazu