Use database-cluster for questions related to running a group of databases as a cluster, which helps prevent the existence of a single point of failure in case a database server fails or is compromised.
References
Questions tagged [database-cluster]
66 questions
0
votes
1 answer
Apache CloudStack with MySQL Cluster (NDB Engine)
I've recently set up a tested and verified MySQL Cluster 7.1 and tested and verified a 4.x version of CloudStack on a regular MySQL database. Now, I'm trying to move the DB to the new Cluster database. I exported and removed all of the constraints…
FoleyX90
- 13
- 3
0
votes
1 answer
How to configure PHP PDO to connect to a multimaster cluster?
I am using Percona XtraDB Cluster to load-balance database.
The usual approach to connect to the database is:
$db = new \PDO('mysql:dbname=foo;host=127.0.0.1');
However, there are multiple master, each of which may possibly be dead at any point in…
Gajus
- 55,791
- 58
- 236
- 384
0
votes
1 answer
MySQL clustering & JBOSS
I need to configure JBOSS for MySQL clustering with databases at two different machines (i.e different IPs).
Active-active configuration of db is desired with -
Both db to be updated simultaneously
Loadbalancing
Failover handling - to switch to…
richa.a91
- 11
- 7
0
votes
2 answers
Error: no primary server found in set
I have a two node cluster...one primary and one secondary. I keep randomly this message
Error: no primary server found in set
Any suggestions ? In the replica set options I have set it to following :
{"read":"secondary", "auto_reconnect":true, safe:…
Raghu Katti
- 63
- 1
- 5
0
votes
1 answer
Trying bolster mysql failover
My MYSQL servers are not configured properly with failover. I am thinking of using Redhat cluster or heartbeat. Also, I need to achieve all tasks w/ one floating IP since application does not know about multiple databases. Can someone suggest what…
user1590462
- 27
- 1
-1
votes
2 answers
Update Mysql database table with million records
I have user table with innoDB Engine which has about million drivers
CREATE TABLE user (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`Column2` varchar(14) NOT NULL,
`Column3` varchar(14) NOT NULL,
`lat` double NOT NULL,
`lng` double NOT NULL,
…
user1272589
- 709
- 1
- 9
- 23