1
vote
1answer
131 views

Duplicating data between two Percona Xtradb clusters using MySQL replication

We currently have a 3 node Percona Xtradb cluster running in a single data center. We want to add fault tolerance in case of disaster to prevent reliance on a single data center and synchronize our ...
0
votes
1answer
18 views

MySQL Cluster with no access to Data Nodes

I'd like to set up a MySQL Cluster for HA, but the client of the data cannot yet use ClusterJ. I would like create 2 SQL Nodes and access only them from the client. i.e. No access to the NDB Data ...
0
votes
0answers
5 views

Mysql cluster 7.3 giving error while installation [duplicate]

I am installing mysql cluster 7.3 on windows 8. In the last step of installation when i have to "Deploy and start cluster" its giving the error msg "Command [u'net','start','N49'] returned non-zero ...
1
vote
0answers
140 views

mysql cluster node lost connection shutdown

I'm testing a mysql cluster with VirtualBox using several virtual machines: Each virtual machine (2 in total) has a mysqld and ndbd node. Plus there's a vm for the ndb_mgmd to manage the cluster. I ...
0
votes
3answers
926 views

MariaDB Galera Cluster

I ma trying setup MariaDB in cluster but looks like I stuck on this error: #mysqld -u mysql 130407 21:36:24 InnoDB: The InnoDB memory heap is disabled 130407 21:36:24 InnoDB: Mutexes and rw_locks use ...
1
vote
1answer
196 views

MySQL Data Center Replication [closed]

I have a (possibly not so quick question) about the best way to set up a 'global' MySQL Database. I basically need to set up multiple MySQL servers in separate geographical locations that will all ...
3
votes
1answer
286 views

Add MySQL as a resource to pacemaker

I am trying to enable fail over strategy using pacemaker on a mysql Master-Master replication on two virtual machine running openSUSE 12 created by VritualBox. I managed to complete the mysql ...
2
votes
3answers
97 views

MySQL Replication A->B->C

I was setting the MySQL Replication for master -> slave/master -> slave and Replication for master -> slave its works fine but when i have enable this option in my.cnf log-slave-updates=1 for ...
3
votes
2answers
117 views

MySQL Replication 'Catchup' UPDATES keep newer record

I've got two MySQL clusters that have Master-Master replication setup between them. Most tables are log based, with only inserts and selects, so they don't have any problems with the replication. ...
1
vote
2answers
2k views

Redundant FreeRADIUS + MySQL

I’m working on some web service having it’s AAA implemented by FreeRADIUS + MySQL on Debian. The problem I’m working right now is HA & scalability of RADIUS. If the FreeRADIUS machine or MySQL ...
0
votes
1answer
109 views

Setup MySQL replication - multiple machines?

i read a lot of mysql server repliaction tutorials, but there's no hint, if the slave server is on a second machine or on the same server but just another mysqld process? any advice? thanks in ...
3
votes
1answer
947 views

MySQL on VMware for High Availability

Given a choice between the current database-level HA options for MySQL, like Master-Master, Cluster, or Galera, and vSphere HA for the machine running the MySQL master, which would you use or combine ...
1
vote
2answers
894 views

Mysql Cluster not working on Ubuntu

I am unable to setup MySQL Cluster on ubuntu servers. As a starting point I started from the link but I am not successful and the tar ball version I download is 6.3.45. As I wanted to test the mysql ...
3
votes
3answers
966 views

Database scalability with write-heavy application

I have a write-heavy application. The application is best compared to surveys - the customer creates custom questionares and this is saved to the database. Most of the requests are from their users ...
0
votes
2answers
690 views

MySQL Binary Logs more than 15 GB

Binary log in one of my server has grown more than 15 GB even after setting the max size to 1 GB. The MySQL server is as well not starting. Can anyone highlight what might have caused it ? Thanks.
2
votes
1answer
2k views

MySQL Multi-Master Replication vs. MySQL Cluster

I need a MySQL database that is fast and supports many connections. Most of the connections will only be reading, but a few will be reading/writing. All connections will need to read and write at ...
1
vote
2answers
181 views

Working setup for MySQL HA & LB

I have to setup High Availability and Load balancing for web(apache-tomcat+mod_jk) and MySQL(where all clients info is stored) server which are running on the same machine(ubuntu server). First I am ...
0
votes
0answers
71 views

MySQL replication for scalability

Consider the following hypothetical scenario: A Web application receives 25% write traffic and 75% read traffic. Given that this application can tolerate reads that slightly stale, an easy way to ...
2
votes
3answers
1k views

MySQL-Cluster or Multi-Master for production? Performance issues?

We are expanding our network of webservers on EC2 to a number of different regions and currently use master/slave replication. We've found that over the past couple of months our slave has stopped ...
0
votes
0answers
234 views

Problem while Installing mysql cluster

I downloaded latest mysql cluster file 64 bit (mysql-cluster-gpl-7.1.9-linux-x86_64-glibc23) from mysql site. Ran following command to install mysql server. ...
2
votes
2answers
202 views

Mysql cluster Vs basic Mysql db setup(not cluster)

Why mysql cluster requires more ram as compared to basic mysql db setup (no cluster)? What is the ideal ram requirement for a mysql cluster with 2 mysql servers on 2 different hosts ?