Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [load-balancing]

52 questions
22
votes
3 answers

PostgreSQL High Availability/Scalability using HAProxy and PGBouncer

I have multiple PostgreSQL servers for a web application. Typically one master and multiple slaves in hot standby mode (asynchronous streaming replication). I use PGBouncer for connection pooling: one instance installed on each PG server (port 6432)…
Nicolas Payart
  • 2,508
  • 5
  • 28
  • 36
7
votes
1 answer

Confused about load balancing and horizontal scaling in postgresql

Please correct me if I am wrong but I guess handling more requests and load by adding more machines or balancing the load between multiple servers is horizontal scalling. So, if I add more servers, how do I distribute the database? Do I create one…
Benjamin Smith Max
  • 213
  • 3
  • 6
5
votes
2 answers

PGPool memory requirements

What amount of physical memory is recommended for a dedicated PGPool machine running connection pooling & load balancing, but no query cache? I see num_init_children(96) * max_pool(2) * number_of_backends(2) = 384 lines in SHOW pool_pools; and the…
gregn
  • 303
  • 3
  • 10
3
votes
2 answers

Load Balancer for MySQL MASTER MASTER Replication

We are having typical requirement. We are having MySQL MASTER-MASTER Replication setup in place. We require to setup Load Balancer between these 2 MySQL servers. I am aware of setting up WEB based Load Balancer, but we require load balancer for…
Phanindra
  • 1,007
  • 5
  • 15
  • 31
3
votes
1 answer

Are TCP loadbalancers an alternative to Postgres 9.X read slaves load balancers like pgPool II or pgBouncer?

To scale read traffic on PostgreSQL streaming replication slaves, I want to be able to load-balance the requests. Postgres documentation suggests using tools like pgPool and pgBouncer, but I am wondering if there is something wrong (in principle)…
donatello
  • 275
  • 1
  • 4
  • 7
3
votes
1 answer

Postgres 9.6 AWS RDS loadbalancing

I have an legacy application that has a number of very complex queries that take significant time and resource to execute. Rather than rewrite the application I am looking at the possibility of doing some form of load balancing. I firstly looked at…
avrono
  • 131
  • 2
2
votes
0 answers

Error to connect mongos when trying to create replicated sharded cluster

I'm trying to create an replicated sharded cluster in mongodb. Initially I've created two shards and there are a replica set with three members in each shard. And all the shards and replicasets run in a single machine. I followed…
Kaushick Gope
  • 21
  • 1
  • 3
2
votes
0 answers

Solved Mysql connection lost with HAProxy

I have master-master replication with mysql. and haproxy configured front of my master-master replication. When I connect my replication via HaProxy, mysql says that "MYSQL has gone away". But when I connect my replication via mysql1 or mysql2…
eusso
  • 61
  • 1
  • 5
2
votes
1 answer

How can I configure SQL Server 2012 to use multiple NICs?

How can I configure SQL Server 2012 to use multiple NICs? I've a server with 4 NICs. I want to use 2 NICs to query my databases, and 2 NICs to retrieve results from them. I want them to work in load balancing mode and still continue to work if one…
user2119955
  • 21
  • 2
2
votes
1 answer

LoadBalancing JDBC DataSource Connect without URL

When using JDBC I like the new DataSource-way to establish the connection. Further I like the isolated set-Methods for the properties like setUser, setPassword, setDriverType, setServerName, setNetworkProtocol, setDatabaseName, setPortNumber and so…
Bastian Ebeling
  • 175
  • 1
  • 1
  • 9
2
votes
1 answer

How RDBMS solve C10K problems, it's also load balance?

I know AP server meet C10K problem can use Load Balance to be solved. But RDBMS server in my experience is very difficult to make load balance, especially for writing db, it should meet the client 10000 problem Therefore there's a question 'How do…
kdm.J
  • 41
  • 3
2
votes
0 answers

How I can find out which postgresql I am connected into when behind a load balancer?

I have the following database replication setup: As you can see I do a master-slave replication and I use aload balancer in order to connect into read-only replicas. So I want to test this setup, hence I connect into my database into postgresql…
Dimitrios Desyllas
  • 873
  • 2
  • 14
  • 30
2
votes
2 answers

Splitting the servers

We have a Windows 2012 VM running SQL Server 2012. There are around 20 databases with a total size of 5.83 TBs. There is 64GB of RAM and 16 logical processors on the box. The server is extremely busy with a lot of users hitting the databases with…
Jacob
  • 21
  • 4
2
votes
1 answer

Load balancing between 2 servers using MySQL Router

I want to setup a simple master-slave MySQL replication. I also want to balance the load between the 2 servers. Can I use MySQL Router 2.1 for that purpose? As I read the official documentation, it seems that MySQL Router now only works with InnoDB…
Zirui Wang
  • 131
  • 3
2
votes
1 answer

Sync tables from Host1 to Host2 with over 50 million rows?

I apologize first for using Sync in the title, that may be the wrong term. I am using MySQL, but can switch to Postgress or other open source platform. I have a service that when people subscribe to we receive a lot of data from them, around…
Alan
  • 207
  • 2
  • 13
1
2 3 4