Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [load-balancing]

The tag has no usage guidance.

1
vote
2answers
32 views

Load balancing Availability groups with SQL Server Standard

So I have the current scenario, and it looks to be working fantastically, but I just want to get some input on the configuration. Is it smart? Are there any issues I am not thinking of? We have SQL ...
-1
votes
0answers
16 views

Availability Group Read-Only Routing to Synchronous vs Asynchronous Replicas

I'm looking for some insight into the logic behind Read-Only routing when it comes to synchronous vs asynchronous replicas in a single Availability Group for SQL Server. My understanding is that in ...
2
votes
2answers
49 views

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 ...
0
votes
0answers
169 views

configuring load balancing sql server 2012 databases

Please provide some details on the below. I am setting up load balancing for sql server 2012 databases using high availability group. I have few questions on failover. I can expect three failover ...
1
vote
1answer
286 views

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 ...
1
vote
1answer
28 views

Using Apache Benchmark to test performace CPU load of 55 [closed]

I was doing a test to see what kind of performance to expect from my server. I put together a few PHP pages that each posts 500 records in JSON to an api endpoint that parses it for database insertion....
1
vote
1answer
96 views

Load balancing incoming data using offset / increment vs group replication

I have a service that accepts large quantities of incoming JSON data from multiple sources. A single client will put a load of about 3.0 on a server, primarily from the Apache service, but also Mysql. ...
2
votes
1answer
90 views

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 ...
0
votes
0answers
16 views

How can I realize a load balancing where my two virtual mysql machines write and read data?

I want to use the following components to achieve load balancing: -. MYSQL ROUTER -. REPLICATION WITH GTIDs -. MYSQL 5.7 SERVERS The scenario I propose is the following: Let's say that I have 1000 ...
0
votes
2answers
884 views

Pgpool2 doesn't use the slave for load balancing

I've enabled streaming replication in my postgres 9.5.10 installed from ubuntu xenial repo. I want to enable load balance for pgpool-2 (3.7.0 amefuriboshi) installed from sources. So I have this ...
0
votes
1answer
420 views

Managing failover for MySQL nodes using HA Proxy

We have an S1<-M1<->M2->S2 setup of MySQL replicated nodes. These are now to be brought to the back-end of an HA Proxy server to split read from writes. We also intend to achieve automatic fail-...
1
vote
2answers
472 views

Log Shipping: two secondary DBs on the same instance - is this possible?

This is a bit insane, I'll explain intention later: Scenario: + instance_1: one database (LS_source) configured as primary for log shipping + instance_2: two databases (dest_1, dest_2) as secondaries ...
2
votes
1answer
53 views

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 ...
1
vote
3answers
295 views

Service Account for SQL Cluster

I am setting up Test SQL ( 2012) server cluster with always on feature. Cluster consist of two windows server 2012 R2 servers. I need to setup SQL service accounts, Does anyone know if it will be ...
3
votes
1answer
396 views

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) * ...
0
votes
0answers
89 views

Replication topology in MySQL 5.7

Our first and current approach : Current Replication configuration is Active - Active and R/W is split on both node . This is asynch-replication. Primary node is having RW ...
1
vote
1answer
817 views

Load balancing reads SQL Server 2016 AG

I'm trying to balance read traffic between two SQL Server 2016 Enterprise Edition instances (Primary and Secondary) using availability groups and the read only routing. Here is my current setup: ...
0
votes
0answers
59 views

Multimaster MySQL behind keepalived problems?

I used MySQL about an hour, and need to setup a multi master infrastructure. Why shouldn't I start multimaster MySQL under a load balance? Can LB flapping and replication lag cause a freeze state.
1
vote
1answer
330 views

Always-On Read Only Routing vs External Load Balancer

We are migrating a SQL Server 2008R2 with mirroring and transactional replication to SQL Server 2016 with AlwaysOn. So far, so good but we still have one question. Is it better to use always on ...
1
vote
1answer
529 views

Troubleshooting PgPool Query Lags

I have been using PGpool-II for quite a while but just noticed an intermittent lag (slow request taking about 20s to execute) which I am able to replicate consistently. Before I explain here is a ...
1
vote
1answer
396 views

HAProxy - Load-Balancing in 2 Node setup - Performance Gain possible?

I was speaking with my boss about Load-Balancing a 2 node Galera Cluster and we weren't sure if there was any reason. For writes, his argument was, even if we balance the writes, it has to write to ...
0
votes
0answers
575 views

Load Balancing SSRS inside an AlwaysOn Availability Group

We have 3 nodes in an Availability Group in SQL 2014: Primary Site: Server1 (synchronous primary) Server2 (synchronous, readable secondary) DR: Server3 (async, nonreadable secondary) We use ...
3
votes
1answer
2k views

How to Load Balance Availability Group

I have 2 Servers under SQL Server Cluster (Server 1, Server 2) 2 Databases configured with Availability Group (Database 1, Database 2) Server 1: Database 1 PRIMARY REPLICA Database 2 PRIMARY ...
1
vote
0answers
115 views

Pgpool slave node limit

I've started a new database architecture using pgpool-II 3.4.5, I have 3 servers by now, 1 master and 2 slaves. They are configured to use Master/Slave conf and LoadBalancing. The problem is: When I ...
1
vote
1answer
3k views

What is difference between internal and external load balancer listener with respect to azure (IaaS)

As per below MSDN blog, I see there are 2 ways we can create load balancer listener . https://azure.microsoft.com/en-gb/documentation/articles/virtual-machines-windows-classic-ps-sql-int-listener/ ...
2
votes
0answers
47 views

Could you please explain clustering in SQL server? [duplicate]

I'm new to clustering concepts. I would like to know more parallel processing with multiple DB nodes to have load balancing for the incoming requests. Our main goal is to achieve performance and lot ...
2
votes
0answers
3k views

Configure HAProxy to load balance Postgresql

I'm trying to load balance between servers running Postgresql (Master-Slave configuration with Streaming Replication). First I've tried setting up PgPool-II, and it worked fine when I connected some ...
1
vote
2answers
4k views

pgpool load balancing is sending all queries only to master

My two postgresql servers are configured for streaming replication, which is working fine. Pgpool is configured for Master Slave mode / Load Balance Mode. pgpool.conf: listen_addresses = '*' port = ...
1
vote
1answer
510 views

Load Balancing multiple databases in a multi-tenant setup

We have a multi-tenant setup where each client of ours runs a DB that is identical to every other client. We were using Mysql sofar and with CentOS 7.x ,switched to MariaDB. If we want to distribute ...
0
votes
1answer
64 views

Is it ok to use 4 application server against one database server?

Initially I have two database server (Master Master Replication config with Haproxy load balancing) A and B. And two application server say P and Q. Both P and Q is pointed towards A will move to B ...
2
votes
0answers
369 views

OrientDB distributed architecture

Technically this question could relate to any database that performs in a similar distribute manner but given that I am specifically working with OrientDB I thought the question should be target as ...
1
vote
1answer
1k views

Peer-to-Peer Transactional Replication Load Balancing in MS SQL Server

I'm looking at Peer-to-Peer Transactional Replication and it looks like a perfect fit for my requirements, but there's one unclear part - load balancing (see picture below). How it is implemented in ...
2
votes
2answers
4k views

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 ...
1
vote
0answers
564 views

Using Netscaler datastream and MySQL

I configured MySQL service on a netscaler 10.5. When I perform some MySQL benchmarks using mysqlslap, the first time it runs correctly, the 2nd time I have an error message: When I run it the first ...
0
votes
1answer
138 views

How to setup large database access/cache on LAMP environment? [closed]

My application is getting very slow I guess because of the ever growing database (30+ tables some with 50,000+ rows). Using CodeIgniter's model tier to call MySQL database, I optimized queries & ...
0
votes
1answer
2k views

MySQL stress test tool, remote server preferred

For MySQL stress test there exists programs: http://dev.mysql.com/doc/mysqltest/2.0/en/test-programs.html Also mysqlslap exists: http://dev.mysql.com/doc/refman/5.5/en/mysqlslap.html Is it possible ...
2
votes
0answers
2k views

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 ...
1
vote
1answer
1k views

Mongodb: slow shard balancing

I've decided to shard a collection with 500M+ documents into 24 shards. All shards are on the same machine without replicas as was advised in this title (core sharding). The shard key is {"_id":1}. I ...
2
votes
0answers
3k views

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 ...
3
votes
1answer
2k views

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 ...
6
votes
1answer
5k views

Confused about load balancing and horizontal scaling in postgresql [closed]

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, ...
0
votes
1answer
808 views

pgpool2 not working on my Ubuntu i686 athlon i386 GNU/Linux

I am trying to implement replication and load balancing on my Ubuntu i686 athlon i386 GNU/Linux.for creating database clustures I have installed postgresql contrib 9.1.11 having initially database ...
0
votes
1answer
84 views

MongoDB Balancer:move data inside replication set or across replication set?

After reading the document of mongodb on the balancer topic , I have two questions: 1.If I set Balancer on , will the db operation efficiency will be influenced ? 2.Still ,I cannot understand ...
16
votes
2answers
20k views

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: ...
2
votes
1answer
2k views

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 ...
2
votes
1answer
1k views

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, ...