… replication topology. However you should keep in mind some limitations of…mysql> show slave status\G [...] Slave_IO_Running: No Slave_SQL_Running: Yes [...] The error log…replication and GTID replication This time, we will enable GTID replication on slave #1, but not on slave #2: # slave #1 mysql…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… mysql> change master to master_port=10002; mysql> start slave; Those of you who have already done these operations with file-based replication… So we will suppose that we can read the binary logs of the crashed master. The first thing to do …fixed, it is good to be aware of the current limitations.
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… set up replication filters on the slave, as described in the MySQL manual. You can configure the slave to only replicate a specific… written to the binary log on the master. This can be useful if you’re trying to limit the amount of data…-based replication, it looks like you’ll need to wait for the next release of MHA. Q: How do you monitor MySQL…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’…consider relaxing the fsync: set innodb_flush_log_at_trx_commit to something besides … This means more waiting, and after the limit is exceeded you will still get the…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… amazing MySQL manual, especially the option and …log_recoveryblogpercona.commanual relay_log_space_limitblogpercona.commanual replicate_do_dbblogpercona.commanual replicate_do_tableblogpercona.commanual replicate_ignore_dbblogpercona.commanual replicate_ignore_tableblogpercona.commanual replicate…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
… what’s seriously limiting MySQL in core use cases (links: part 1, 2, 3). This post is about the way MySQL handles connections… database too. MySQL replication is one of the core, fundamental features — and it’s single-threaded and relies on the binary log, which… them. That’s why I listed those as major limitations. And because MySQL is a multi-threaded database for Web usage that…
Post: MySQL Limitations Part 2: The Binary Log
October 23, 2010 By 11 Comments
… what’s seriously limiting MySQL in certain circumstances (links: part 1). In the first part, I wrote about single-threaded replication. Upstream from… replication by writing a so-called “binary log” of events that modify data in the server. The binary log is a real limitation in MySQL. The binary log is necessary not only for replication, but for point-in…
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
… series of blog posts on MySQL‘s unsolved severe limitations. I mean limitations that really hobble it …a few I’ve seen: Use DRBD replication instead of MySQL replication. Problem: you end up with an… Multiple binary logs on the primary, one per database; one replication process per binary log on the …
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
… you’re close to the limit. To manage replication lag and to understand what is loading your replication it is also helpful to… of queries being replicated. Unfortunately MySQL Slow Query Log does not log replication queries. Though this is one of few slow query logging improvements you can…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
… stonith devices are supported No logical limits in term of number of nodes …lrm-refresh=”1322236006″ property $id=”mysql_replication” \ replication_info=”10.2.2.162|mysql-bin.000090|106″ rsc_defaults… is “log_slave_updates = OFF” (default value). In some cases, if slaves are logging replication …
