2
votes
2answers
330 views

Mysqld InnoDB crash

my MySQL server just crashed and I cannot restart/recover it. I've tried: /etc/init.d/mysql restart Stopping MySQL database server: mysqld. Starting MySQL database server: mysqld . . . . . . . . . . ...
2
votes
3answers
2k views

How to actually use mysql slave as soon the master is failover or got burnt

I have MySQL master-slave replication that works fine; I googled the whole net and MySQL site to find the standard procedure to make use of the replication but found nothing. It is as if admins are ...
0
votes
3answers
115 views

Mysql data recovery

The linux machine on which we have the mysql has crashed due to a power failure. This probably caused the mysql server to crash too and we are not now able to restore/backup/export the database from ...
0
votes
2answers
167 views

MySQL disaster and recovery plans

Can someone guide me to some articles/plans related to MySQL disaster and recovery? In this moment I run a master/slave configuration (NDB is not acceptable because is not ACID compliant).
5
votes
1answer
441 views

Mysql disaster recovery

We just got a major disaster: somebody made an uncontrolled update on the production database, and obviously, the backup process is not working since a long time, so we got a major data loss. A 40 ...
0
votes
2answers
68 views

Disaster recovery: Mysql data

A friend of mine mysql linux server died and I managed to get almost all the data from the hdds... What can I look for to recover his databases and data? Where are they stored and in which files? How ...
3
votes
2answers
562 views

Can't Repair Mysql Table

I have one ARCHIVE table that I simply can't repair, I already try to remove the partitioning but still get this error: alter table promo_tool_view_44 REMOVE PARTITIONING; ERROR 1034 (HY000): ...
17
votes
9answers
5k views

Architecture for highly available MySQL with automatic failover in physically diverse locations

I have been researching high availability (HA) solutions for MySQL between data centers. For servers located in the same physical environment, I have preferred dual master with heartbeat (floating ...
6
votes
2answers
1k views

MySQL replication issues after a power outage

After a power outage at our data centre, the slave MySQL databases are struggling. This is in the logs for one of the slaves: 100118 10:05:56 [Note] Slave I/O thread: connected to master ...