… two slaves, all running MySQL 5.6 with GTIDs disabled. First try: configure only one of the servers with GTIDs Let’s stop slave…_Running: Yes [...] The error log tells us why the IO thread has not started: 2013-05-17 13:21:26 3130 [ERROR] Slave I/O: The slave IO thread stops because the…
Comment: State of the art: Galera - synchronous replication for InnoDB
April 23, 2013 By 15 Comments
… disk i/o on it that I have seen when running mysql 5.1 or mariadb 5.5 on the same hardware in a master/slave. I wonder if it is writing as synchronous? I… in a raid10 for the binlog (yeah I know, not very balanced in terms of I/O). mysqlslap –concurrency=25,50,100,200,500…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… make your business run. Anything else is gravy. If there are nice-to-haves, consider not building them… in MySQL, you’re going to end up heavily I/O bound. Listen to any of the talks at past MySQL … using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing the work on a slave,…
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
…I/O error But on slaves, the corruption will be obvious as replication will stop with an error: slave1 [localhost] {msandbox} ((none)) > show slave…mysql-bin.000001′ at 2896.’ Conclusion You should not assume that replication checksums in MySQL…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…does not work in Oracle MySQL Server. set userstat_running=1 and run following query: mysql> select * from information_schema.user_statistics where user=”#mysql_…| Connect | 0 | Has read all relay log; waiting for the slave I/O thread to update it | NULL | | 802354 | root | localhost | NULL | Query…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
…relay log ‘/var/log/mysql/relay.000086′ position: 4837623 080625 23:53:28 [Note] Slave I/O thread: connected to…bin.000025′ at position 12410321 Number of processes running now: 0 080626 00:06:16 mysqld … 080626 0:06:16 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. …
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…start with Florian’s comments on the issue as I think they are most interested ones. First lets …to use MySQL features which break replication. The failover node is a hot standby, it’s just not a running slave … use O_DIRECT with Innodb which makes it to bypass file cache. If you have it DRBD slave …
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… master-slave replication except that you can fail over in both directions. Aside from MySQL Cluster, …running, ready to serve queries. In theory, it’s a truly hot standby (stay with me — that’s not…perform very badly — get unresponsive, cause tons of I/O, etc. In reality, it can be completely …
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
…were we can run out of space. Let’s see one example. We’re running a typical master-slave replication … ML* files? When you run a big UPDATE, INSERT or LOAD DATA INFILE MySQL send the rows to …defeat the performance improvement as it uses disk I/O anyway. Ramfs will not swap, and also ramfs will grow …
Post: 10 things you need to know about backup solutions for MySQL
March 3, 2009 By 23 Comments
… it runs? Here are ten questions you need to be able to answer: Does the backup require shutting down MySQL? If not, what is the impact on the running server? Blocking, I/O load, cache pollution, etc? What… set up new MySQL replication slaves? How? Does the system verify that the backup is restorable, e.g. does it run InnoDB recovery…
