-2
votes
3answers
86 views

Options for high-availability of a smallish website? [closed]

I'm running a website that gets ~1500 visitors a day. It's not a ton, but I want to make sure this site stays up nevertheless. Currently, we're hosted on a shared hosting provider and the site has ...
0
votes
0answers
73 views

High availability MySQL with HA Proxy failover

I am looking to load balance a Percona cluster behind two HA Proxy nodes with failover (using keepalived) so there is no single point of failure. I have HA Proxy already setup with keepalived using a ...
0
votes
0answers
40 views

How do I choose a failover strategy for Mysql 5.5?

I have 2 mysql 5.5 database servers that I've just set up on Ubuntu 12.04. What I would like to do is provide a means of having these failover. Ideally using an HA strategy like keepalived so that ...
0
votes
0answers
24 views

Repair tables after pacemaker + drbd migration/failover

I have a master/slave pacemaker/drbd cluster that handles mysql, apache, and some other stuff. I'd like to have mysql automatically repair tables (mysqlcheck -A --auto-repair or similar) after ...
0
votes
1answer
82 views

How to connect to mysql-master-ha from my application server

I am trying to use mysql-master-ha. I managed to get it connected with the master and slave mysql servers. Now I would like to know how to connect to mysql-master-ha from my web application server ...
0
votes
1answer
175 views

MySQL High Availability with VMWare/DRBD/Heartbeat still common practice?

Is it still common practice to use a DRBD/Heartbeat solution for a high available MySQL Instance when the whole environment is virtualized (in our Case VMWare) Are there other/better solutions out ...
3
votes
3answers
458 views

Does it work to run mysql with the data directory on a CephFS mount?

We have a database cluster that uses MySQL on DRBD with Pacemaker+Corosync, which is great. My question is whether it is possible (and whether anyone has been successful) to mount a CephFS drive to ...
0
votes
1answer
199 views

HAProxy MySQL Failover is not starting

I am trying to setup HAProxy with MySQL failover with Ubuntu. I used a setup similar to this serverfault question, however I am getting the following error when starting haproxy: [ALERT] 341/220001 ...
1
vote
1answer
173 views

How to improve availability on a starting up PHP+MySQL application?

Yesterday, Rackspace DFW data center went down for a few hours and made me think on taking the delayed action of improving my server structure there. So far, I've been using a single CentOS instance ...
0
votes
0answers
149 views

Multi-Master Replication Manager for MySQL With Semi-Synchronous Replication

I'm attempting to set up Mysql nodes in active/passive HA setup with a virtual ip managed by HAproxy + Heartbeat/Corosync with MyISAM support (which excludes Galera/Percona) Does Multi-Master ...
1
vote
1answer
532 views

MySQL HA and Magento DB

Is it possible to use MySQL cluster for Magento DB? I have Web app developed in Magento E-commerce platform and I want to make DB highly available using the MySQL cluster. Magento supports only InnoDB ...
1
vote
3answers
336 views

MySQL HA Solutions

I am evaluating the options to build MySQL HA and found the below solutions Percona XtraDB Cluster, Tungsten Replicator, and MySQL Cluster. Could you please help me to choose the best one with ...
1
vote
1answer
396 views

Is there an ideal filesystem type for the MySQL database directory (/var/lib/mysql)?

I've used ext3 and ext4 in the past with no issues, but I've seen a lot of installations on XFS as well. What are the advantages of XFS vs ext4 vs ?? with respect to the /var/lib/mysql directory? ...
2
votes
1answer
335 views

which high availability model to choose for website (nginx/mysql)

We have 5 physical servers. All are identical. 16 gb ram, 4x146 10k sas in raid 10. So, we need high availability. Current plan is following: 2 boxes with Heartbeat for load balancing. At this ...
0
votes
1answer
49 views

update of mysql server without break

Hy, I want to update my databases on my mysql server, but for now i usually take my server down before to the update. I wonder if there is any solution to make the update without any disruption of ...
5
votes
1answer
888 views

HA Setup for MySQL/mostly MyISAM Tables

I am currently using Master-Slave Replication, separating reads from writes at the application level. The only kind of fail-over currently implemented is application level detection of master failure, ...
0
votes
1answer
119 views

MySQL Replication with “same value wins” conflict resolution for updates

I have set up normal (non-clustered, ndb) two server Mysql Master-Master replication for high availability. Each server has an application that can update the local database, the changes propagate to ...
1
vote
3answers
709 views

MySQL / InnoDB replication: how to perform crash recovery?

How do I perform crash recovery in a MySQL/InnoDB Master-Slave asynchronous replication setup? Specifically: If a slave crashes, how do I make it syncs up with the master after I bring it back up? ...
0
votes
1answer
99 views

High Availability MySQL question

So I'm currently testing a new DB topology before moving it into a production environment, and I've run into a rather odd problem. The current setup is as follows: 5 server instances. 2 are MySQL DBs ...
0
votes
4answers
328 views

Advantages of MySQL Server Enterprise

We build for a customer a social network site, where we will have on beginning 1 Master and 2 Slave MySQL Server. I'm not sure if we need to go with the Enterprise or use the GA Version. The only ...
0
votes
1answer
71 views

What configuration would allow me to keep my MySQL server(s) updated while keeping the service consistently available?

I have several Centos 5 web hosting servers with local instances of MySQL that I am looking to segment so that all servers connect to a central MySQL instance. These are web applications doing more ...
1
vote
1answer
341 views

High Availability Mysql without virtual IP

I am trying to design a simple high availability system for our production system at the mysql level. From what I have read so far, the best solution is to set up master-master replication. ...
0
votes
1answer
437 views

DRBD Replication failure

A couple of weeks ago I setup a 2 nodes CRM system with one of the resources managed being MySQL over DRBD. Today for maintenance reasons I restarted both nodes but now they can't connect to each ...
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
7answers
4k views

How to deploy web application for 2 million users?

I've been tasked with figuring out how to do a large scale deployment for a high availability, high traffic, dynamic, flash based web application. There is a good possibility that this application can ...
4
votes
3answers
486 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] ...
5
votes
4answers
2k views

Providing high availability and failover using MySQL on EC2

I would like to have a highly-available MySQL system, with automatic failover, running on Amazon EC2 instances. The standard approach to solving this is problem Heartbeat + DRBD, but I've found a lot ...
1
vote
2answers
713 views

CentOS-based Heartbeat Proxy

I'm looking at setting up automatic failover for Apache and MySQL. I'm planning on putting a small proxy server in front of two Apache boxes, and two MySQL boxes. Apache will rsync data from the ...
0
votes
3answers
779 views

MySQL failover on Windows with SAN available

My backoffice components are doing MySQL queries. I need to ensure High Availability of MySQL (on Windows). I have a SAN available where I will store the DB file. This is what I was thinking. I will ...
2
votes
5answers
423 views

Mysql high availability

I have a application that receives data from approximately 1000 different sources every couple of minutes. This data needs to be saved into a OSS database (most likely MySQL - but depending on answers ...
4
votes
7answers
1k views

Mixing Multi-Master Replication (MMR) with Linux-HA

I'm interested in using MMR (http://mysql-mmm.org/) for high availability and replication purposes. The problem is, I'm also interested in using Linux-HA for other services, such as Apache. The two ...
2
votes
2answers
292 views

MySQL Proxies

In a similar line to... http://serverfault.com/questions/35899/mysql-5-1-replication-topologies-multi-master What I'd like to know is whether there are any really good proxies for MySQL out there? ...
4
votes
3answers
2k views

Data loss due to MySQL DRBD Heartbeat failover script

Using DRBD version: 8.2.6 (api:88/proto:86-88) Here is the contents of /etc/ha.d/haresources db1 192.168.100.200/24/eth0 drbddisk::mysql Filesystem::/dev/drbd0::/drbd::ext3::defaults mysql ...