Questions tagged [load-balancing]
The load-balancing tag has no usage guidance.
55
questions
0
votes
0
answers
10
views
why is Redis not using all three servers?
What should happen, is something like in the attached screenshot, where keys go to different servers. However, we have a situation where one node in our cluster 25000 keys and each of the other two ...
0
votes
1
answer
40
views
Doubt on Always-on ApplicationIntend-ReadOnly and ApplicationIntend=ReadWrite
I Have Deployed Always-on, and I have routed read query into secondary server, but my question is that, how can I make connection string on application side which will divert. Insert, Update and ...
- 23
0
votes
0
answers
28
views
How to use the same Azure SQL VM in two different Load Balancers
I have already configured always on availability group between VM1 and VM2 azure machines. Internal Load Balancer was created for these two VMs and mapped to AG Listener. VM2 is used for read workload ...
- 1,243
0
votes
1
answer
189
views
Load Balancing in mysql InnoDB cluster
I have set up an InnoDB cluster with one primary(R/W) and two secondaries (R/O) and bootstrapped a MySQL Router. The router has 2 port 6646(R/W port) and 6647(R/O) port. My application is currently ...
0
votes
1
answer
231
views
HADR Availability Group long sync time
I have the following problem / challenge:
We operate an HA SQL cluster with several Availability Groups.
In order to take full advantage of the load balancing, I redirect the SQL selects to the ...
0
votes
1
answer
66
views
Skewed Read Load on Mongo Replica Set
I have set up a mongo replica-set with one primary and two secondaries. The problem that I am facing is that the reads from application servers which are connecting with replica-set connection URL are ...
2
votes
1
answer
242
views
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 ...
- 41
0
votes
0
answers
128
views
MySQL cluster with HAProxy balancer outside of local network
I am building a mysql cluster on local network. I have 3 nodes and would like to load balance them using HAProxy. It works fine when I place HAProxy on one of my nodes inside of the network. I bind ...
2
votes
0
answers
239
views
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, ...
0
votes
0
answers
112
views
Is it a good idea to have a read connection point to both write database and read replica?
In my laravel app I have a write connection to a write database, and a read connection to a dns server that is connected to a single read replica (as instructed here) In the past the dns server was ...
- 413
1
vote
1
answer
999
views
Load balancing on oracle (12r2) 2 node RAC is not working
Any help/pointers would be greatly appreciated.
I have a 2 node RAC (Oracle 12r2) on linux,
CRS and all its services are up.
Both the RAC instances are up.
scan listener resolves to 3 ip's.
But ...
- 37
0
votes
1
answer
117
views
Recommended replication strategy for fast global access to MySQL DB
The app i'm working on has users from all over the world and due to the nature of the app, i need to minimize all delays. My application servers are located in different data centers across the world ...
- 103
0
votes
1
answer
2k
views
What are the advantages and disadvantages of using a embedded sql database? [closed]
What are the advantages and disadvantages of using an embedded SQL database instead of MySQL server? I am a web developer and I'm planning to develop an application for the shop, without investing my ...
1
vote
2
answers
1k
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 ...
- 540
2
votes
2
answers
228
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 ...
- 21
2
votes
1
answer
1k
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 ...
- 131
1
vote
1
answer
81
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....
- 207
1
vote
1
answer
290
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. ...
- 207
2
votes
1
answer
366
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 ...
- 121
1
vote
2
answers
5k
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
1
answer
939
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
2
answers
2k
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 ...
- 111
2
votes
1
answer
235
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 ...
- 207
1
vote
3
answers
2k
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 ...
- 71
5
votes
2
answers
2k
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) * ...
- 303
0
votes
0
answers
118
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 ...
- 669
1
vote
2
answers
3k
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:
...
- 1,761
1
vote
1
answer
626
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 ...
- 113
2
votes
1
answer
2k
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 ...
- 141
1
vote
1
answer
585
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
1
answer
827
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,222
2
votes
1
answer
3k
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 ...
- 520
1
vote
0
answers
169
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
1
answer
6k
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/
...
- 269
2
votes
0
answers
53
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 ...
- 21
2
votes
0
answers
4k
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 ...
- 480
2
votes
2
answers
6k
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 = ...
- 71
1
vote
2
answers
845
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 ...
- 111
0
votes
1
answer
68
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 ...
- 213
2
votes
0
answers
517
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 ...
- 121
1
vote
1
answer
2k
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 ...
- 153
3
votes
2
answers
6k
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,007
1
vote
0
answers
635
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
1
answer
147
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 & ...
- 3
0
votes
1
answer
3k
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 ...
- 139
2
votes
0
answers
3k
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
1
answer
2k
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 ...
- 193
2
votes
0
answers
4k
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 ...
- 61
3
votes
1
answer
3k
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 ...
- 275
7
votes
1
answer
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, ...
