What is the difference between having a master-slave replication and having a master-master( where in the second master acting as hot-standby - active-passive) replication?
Also, what are the issues ...

I'm systematically (1/2 times per day) experiencing a freeze in the DB server.
Suddenly, all the COMMITs get stuck in 'init' state; they pile up (up to 20/30), an almost no other queries are executed ...

I have strange problem, we are using circulation replication, between 2 different network with 5.6.25 and 5.6.22 version of MySQL and RAM is 64GB with 45GB innodb_buffer_pool
Master Server is running ...

Is there a way to make the mysql error log less chatty with certain warnings? I just threw in the replicate-ignore-table option in my.cnf so our health check table doesn't get replicated. However now ...

I have been trying to tune my MysSQL databases, but always having a very low cache hit rate.
I suspect partially because I run a sitemap crawler that is crawling 1.3 million pages. But, besides that, ...

So we have this massive 1.5TB+ table with billions of records that has been neglected for the past few months and needs to have new partitions added.
The partitions are based off a timestamp which are ...

I am migrating from some MySQL 5.1 servers to MySQL 5.6 servers. The MySQL docs are a bit unclear if replication is supported between a 5.1 master and a 5.6 slave, and I'm a little confused what MySQL ...

I have moved into RDS MYSQL 5.6 and now I have a problem. I have 5 read replicas and a/z master.
I am trying to alter a table and want to change a column value and also on some tables I want to add a ...

What would cause the error 1175 that starts out with: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.... The problem I have is that I did include ...

I'm build a performance testing harness for our distributed web app. I'm using JMeter to drive it by simulating poorly performing parts of the app from the web side. I've set up MySQL to log to the ...

I'd like to archive the results of a series of query EXPLAIN plans into a table for later analysis.
I created a table that contains all the fields from an EXPLAIN result, but I can't figure out how ...

MySQL 5.6.23, InnoDB
I am loading tables from character delimited text files using the LOAD DATA INFILE commnd and I would like every field with a \N, which is the NULL character in this setting, to ...

I have three tables of around 10 million rows each in MySQL on Amazon RDS and I am finding the insert/update performance to be VERY slow. Each table contains unrelated data.
Each table is regularly ...

We are creating a new mysql slave, but for dump we are taking from a backup server which is a slave of current master. Now to enable replication we want to connect it with the master so should I take ...

I am having MySQL 5.1 installed on windows box. Now I would like to upgrade to latest MySQL 5.6 version.
I am planning to install MySQL 5.6 in the same server with same port 3306. After installation, ...

we are looking to do a table partition in MYSQL RDS running 5.6, table size is large and takes around 6 hours to partition. Can we partition on rds slave and then later promote it to master. is this ...

I am migrating away from some old MySQL 5.1 servers to some new MySQL 5.6 servers. During this process, I'm creating a new MySQL 5.6 slave from an existing MySQL 5.1 slave, using the procedure in the ...