How to test HA MySQL Database

Recently we have been testing an HA Database solution from a 3rd party provider. I have done some stress tests to see some metrics for Master & Slave status etc, however I would like to test the actual failover. I need a way to test the failover or some other way to disable the Master … Read more

MySQL Replicator requirements

I have a simple MySQL Master-Slave replication setup, but always get an unaccaptable huge slave lag. That means that the slave lag will get higher than the expire_logs_days of 14 and the replication will crash. So, here are some facts: MySQL 5.5 Datasize: 120GB Master Server: SSD, 64GB RAM Slave Server: SATA, 32GB RAM The … Read more

What’s the best method to achieve full redundancy in a dedicated server? [closed]

Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this post. Closed 6 years ago. Improve this question I’ve been reading about full redundancy to achieve almost if not 100% uptime for your … Read more

log error in mysql replication [closed]

It’s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 10 years ago. I use mysql replication. At slave, i read … Read more

how to use mylvmbackup [closed]

Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Server Fault. Closed 8 years ago. Improve this question any useful tips or easiest way Answer You could start by taking a look at their own site (i guess). Especially the Documentation … Read more

mysqlhotcopy — A Database Backup Program [duplicate]

This question already has answers here: How can I back up and replicate a large MySQL database? (5 answers) Closed 8 years ago. is the mysqlhotcopy — A Database Backup Program best way to backup the large data in mySQL?? Answer Please refer to the thread started a few minutes ago: How can I back … Read more

Mysql MariaDB replication broken

I have a primary DB and two replicates. replicate1 became corrupted when the linux server was rebooted without stopping mysqld. I want to load replicate1 with a dump I’ve taken from replicate2 with the command mysqldump –master-data –single-transaction –all-databases –compress > full_dumpfle.sql dump was started after replication on replicate12 was stopped with stop slave; as … Read more

MySQL table only replication (Master->Slave)

I’ve set up two servers (one master and one slave db). I want to synchronize one single table of a whole database live (or with a delay of up to 5 minutes) in only one direction. I wanted to try the DB replication in total first, but after setup I’ve seen that nothing happens. Unfortunately … Read more

Website .htaccess redirection loop issue [closed]

Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 3 years ago. Improve this question I have my news website hosted in US and it is being managed by cloudfare. I have placed one local … Read more

MySQL – data inside vm on shared storage? [closed]

Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing this post. Closed 7 years ago. Improve this question I’m planning on moving all my VMs to shared storage, and I have a question about … Read more