0
votes
0answers
19 views

What mysql configuration offers the highest write performance

Which multiple mysql server configuration offers the highest write performance? We are looking at changing a web application which is heavy write and want to know what configuration is going to give ...
1
vote
2answers
69 views

MySQL Replication threeway

We have MySQL Multi-Master replication setup between two servers ( A & B ). It has been working for a few years now and life is good. The management tool in our office connects directly to ...
0
votes
1answer
38 views

Dev mysql node with Percona

I have been tasked with creating a Development mysql instance, We currently have a 7 node Xtradb cluster, is there any way to have this node a few hours behind, or not allow replication back to the ...
-1
votes
1answer
575 views

MariaDB Galera Clustering - Active Active - Operation not permitted error

I am having issues with MariaDB and Galera running on RHEL 6.4 & 6.2 64bit servers and getting them to cluster. I installed the required RPM's for Galera clustering: MariaDB-Galera-server ...
0
votes
2answers
173 views

MySQL geographic replication cloud

I currently have a standard local LAMP setup, (2 web servers, master/slave MySQL, load balancer). This is severing me well locally, but my global users experience slowness. I want to setup some ...
2
votes
1answer
245 views

When trying to delete a table from NDB Cluster, I get the error “4243: Index not found”

In a Linux-based NDB-cluster consisting of 7 API nodes, 1 Management node and 4 NDB nodes, I am trying to drop a table. When I try to drop the table using MySQL Client, I receive the following ...
0
votes
1answer
49 views

Authenticate ftp users on mysql through secure channel

I've to face this problem regarding security: some sFTP servers (proftpd) in a dmz that need to authenticate users against a mysql (native cluster|percona cluster|MariaDB cluster) through a secure ...
-3
votes
1answer
85 views

Mysql Cluster Sharding/partitioning [closed]

Ok so i have mysql cluster setup but what i need is say table assets to be split among the nodes, not replicated. as the purpose of me setting up the cluster was due to lack of hard drive space so how ...
0
votes
0answers
94 views

Linux Postfix MySql Courier Imap (single data dir and master slave database)

I have a mail server (postfix,mysql,courier) my imap connections are to high and burdens the server badly. I was thinking of: Setup postfix, Mysql, Courier then replicate database on slaves and mount ...
0
votes
1answer
100 views

mysql cluster .net client connection which host

I'm trying mysql cluster to use in a project for our customer. The configuration I setted up is the following: **Hardware S.O. equipment** Server1 - S.O. Windows 2008 R2 64bit Server2 - S.O. ...
0
votes
1answer
274 views

MySQL Cluster SQL Node not synchronizing

I am new to MySQL Cluster and am trying to setup a new cluster for our new application. Here is what I have set up on 5 CentOS 64 bit VM and got the cluster to work using MySQL Cluster 7.2. I am ...
1
vote
2answers
747 views

Heavy write to Galera cluster - table locked, cluster practically unusable

I set up Galera Cluster on 3 nodes. It works perfectly for reading data. I have done simple application to make some test on the cluster. Unfortunately I have to say that the Cluster fails totally ...
1
vote
1answer
401 views

Mysql migrate huge db from innodb to ndbcluster Err: the table is full

I'm trying to migrate old database to mysql cluster (4 data nodes) by using command: ALTER TABLE sample ENGINE=NDBCLUSTER but I'm getting the following error: The table '#sql-7ff3_3' is full ...
1
vote
1answer
315 views

Pacemaker corosync 2-node with a 3rd for quorum

I'm having trouble figuring out how to configure a 2-node setup with a third simpler one for quorum. It seems to think all the nodes have the capability to act as a full fallback node, when I only I ...
1
vote
1answer
131 views

MySQL Cluster Failover doesn't work

I have two servers, where First server 10.100.15.150: 1. one mgm server 2. one ndbd 3. one mysql api Second server 10.100.15.160: 1. one ndbd 2. one mysql api When i start all 'parts' of cluster ...
1
vote
1answer
671 views

MySQL service does not start

My MySQL service is not starting. I am using debian wheezy as operating system in my VPS. I use MyISAM for storing tables. Response when starting service root@ipxweb1:~# service mysql start [FAIL] ...
1
vote
0answers
544 views

MySQL Cluster msql Node Does Not Connect

I have a mysql cluster consisting of the management node, two data nodes, and a mysql node. The two data nodes connect to the manager but when I try to connect the mysql node I get the following ...
1
vote
2answers
91 views

Distributed mysql synching

I'm running a server which is connected to an SQL host. I have an another server and I decided to run it as an SQL backup. So, I have 3 of them. Srv A is the SQL host, srv B is the backup. I know ...
1
vote
1answer
180 views

Howto restart a MySQL MMM cluster

little theoretical question. I'm done setting up a bunch of 2-node MySQL 5.1 clusters user the control of several MMM instances. We started some testing, joyously kill -9 the writer nodes and all ...
0
votes
2answers
60 views

Adding MySQL servers/ data nodes into database clustering without restarting mysql cluster

I currently have mysql clustering up and running. For high scalability is there a way to include either mysql node, data nodes, or management nodes without restarting the entire cluster. I wish to ...
1
vote
1answer
220 views

Adding MySQL servers/ data nodes into database clustering without restarting mysql cluster

I currently have mysql clustering up and running. For high scalability is there a way to include either mysql node, data nodes, or management nodes without restarting the entire cluster. I wish to ...
0
votes
1answer
146 views

Unable to connect to MySQL cluster database

I am unable to connect to mysql cluster database after starting my management node, data node, mysql node. I made the necessary changes by adding the loadbalance in the dbURL. But I am not able to ...
1
vote
0answers
63 views

MySQL cluster data node replacement

I have a MySQL cluster with 2 data storage nodes running from last 2 years. Just recently I have observed a hardware issue in one of the nodes (data storage). I may need to replace this node with new ...
0
votes
2answers
478 views

How to achieve high availability with MySQL cluster?

This question is not about how to install the servers nor its capabilities, but more of a design question. So I have a cluster of MySQL servers. I also have a DNS record "data.example.com". The ...
-2
votes
1answer
215 views

Designing cluster to handle 1 trillion records database [closed]

Major use of that cluster would be to have add/delete/edit operations on individual records based on primary key. Database itself is not complicated but main concern is handling the operations on ...
0
votes
3answers
894 views

Virtual IP or Load balancing for a http/ mysql cluster

First of all i have to say i'm very very newbie as sysadmin. I'm trying to do someone else's work, and i have almost 0 experience in clustering / load balancing and related stuff. This is the ...
0
votes
1answer
192 views

web server mysql replication over slow adsl lines

I would just like some recommendations. Currently i am sitting with a vps server in europe that hosts my webserver and my mysql database. It servers our clients as a place to download documents and ...
0
votes
2answers
453 views

Do I need to buy Mysql cluster enterprise edition? [duplicate]

Possible Duplicate: Can you help me with my software licensing question? we have a ms-sql 2008 standard edition. The db became too huge, about 8 10^9 records.the db files are about 4.5tb ...
1
vote
1answer
1k views

what is gen_clust_index used for in mysql?

It seems I have a deadlock in mysql (running innodb) that's due in part to a lock on gen_clust_index, however, this isn't a table that I've created. So... what's the short and sweet description of ...
4
votes
1answer
509 views

Mysql ndb cluster - node restart

I just setup a mysql cluster on a fairly decent baby (IBM x3650 M3) with 24GB memory, xeon 6core, SAS 6Gbps HDD. Running Debian Lenny 5. 64bits. Ndb version is 7.1.9a. Our database size on MyISAM is ...
0
votes
0answers
239 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 ?
1
vote
1answer
120 views

Mysql cluster strange behaviour

I have 2 mysql clusters on two different servers with management node on each of them. It went down someway. I ran following commands to start the cluster: Start the management node on srv1: srv1: ...
1
vote
3answers
303 views

looking for MySQL failover and loadbalace setup for clusting

i have setup my clusting for 3 mysql servers, 1 master and 2 nodes what i need to do right now its setup a failover system and loadbalace setup. Can sombardy link to a good article about that? i use ...
0
votes
2answers
55 views

mysql redundancy with mixed storage types

Looking at building redundancy into our system, as we are currently, um, exposed should anything blow up. We have a large-ish DB (150G), consisting of a mix of innoDB and myISAM table types. We want ...
1
vote
1answer
56 views

I was given a cluster that uses PBS but where do I start MySQL?

I am in a fix. I requested my support people to provide me with some extra CPU and storage resources and they gave me a cluster to work with along with a front-end. The problem is, they are asking me ...
0
votes
2answers
328 views

We need MySQL redundancy but replication is not an option

We have an app with some peculiar characteristics that prevent us from doing master-slave MySQL replication. It's something to do with random numbers being generated for each session and stored ...
4
votes
2answers
235 views

MySQL Clustering and replication

I want to setup a MySQL cluster setup of two servers (M1-M2). I also want to setup MySQL replication between two servers (M1-M3). Is it possible to setup both clustering and replication as above. Is ...
0
votes
2answers
91 views

Utilizing 5 physical servers in 1 cluster

I have 5 physical servers with low end memory & cpu resources. I want to create 1 cluster using all these servers and want to run mysql db on the same such that mysql db would utilize 5 server's ...
4
votes
3answers
492 views

Is this a HPC or HA mySQL cluster?

Can someone tell me if this is a High Performance Compute or High Available mySQL cluster? There is a picture of the setup. This is part of the config.ini they talk about [ndbd default] ...
1
vote
2answers
1k views

How can I configure MySQL data folder in a Red Hat cluster suite running in VMware

I have configured Red Hat cluster in VMware. I created two nodes Node00 and Node01 which are running CentOs 5.2. I have added MySQL service to my cluster. When I suspend Node00 then instance is moved ...
1
vote
1answer
1k views

Need help configuring pacemaker

I'm trying to configure a 2-node openais / pacemaker cluster, and finding information / tutorials very difficult to come by. My goal is to set up 2 MySQL servers in a master-slave replication ...
1
vote
2answers
3k views

Need help to configure MySql-Cluster with two hosts

Thanks for your reply. I need your help to configure MySQL-Clustering server in following manner. I have two hosts as, 1] 192.168.1.107 2] 192.168.1.125 Each hosts have node entries as, On host: ...
0
votes
2answers
2k views

MySQL NDB Cluster on FreeBSD 7.1

Got a problem with a MySQL Cluster, All the nodes connect fine to the ndb management node, however when I try to create a table on one of the nodes it returns this error : mysql> use foo; Database ...
5
votes
4answers
516 views

MySQL Clustering

I run a mysql server that hosts around 50Gb of data (primarily for around 250 websites), and am wondering what my options are for setting up a redundant MySQL cluster? The primary purpose would be ...
1
vote
3answers
2k views

Install a mysql-cluster 5.1 in ubuntu 9.04

I have 4 servers with Ubuntu 9.04 I want to install mysql-cluster 5.1 but the package in the ubuntu repository doeas not have ndb binaries. What is the beast way to install mysql 5.1 with ndb ...