… 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 11 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 94 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 …
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…as bunch of others due to statement level MySQL Replication which among other requirements, needs all auto-…of “Gotches” while many of them come from MySQL limits at the time when Innodb was first implemented… such as multiple purge threads or parallel log recovery features, which he however needs to …
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… checking your progress along the way. There is no limit as Safe you can get so I would just… want to minimize downtime it is best to use MySQL Replication for upgrade. Once you have setup slave with new…backup before upgrading and make sure to keep binary logs for some time, in case you run into some…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
…table_cache=20M # open-files-limit=20000 table_cache = 3072 open_files_limit = 9216 tmp_… #skip-networking # Replication Master Server (default) # binary logging is required for replication log-bin=db1-bin log-…#innodb_log_group_home_dir = /usr/local/mysql/data/ #innodb_log_arch_dir = /usr/local/mysql…
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
…, which highlighted replication could be the limiting factor for this system quite soon, so I decided to check what is limiting MySQL Replication speed. My first idea was to check it based on slow query log, happily the server was running MySQL with slow query log…
