… the impact of memory allocators on MySQL performance can be found in…window and evs.user_send_window could trigger cluster crash under high load. Bug fixed #1080539 (Teemu Ollakka). Standard MySQL…replication conflict and leave a slave hanging. Bug fixed #1130888 (Seppo Jaakola). If MySQL replication…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… disk. This has no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually much…, Callaghan’s law applied to semi-sync is: [On a semi-sync replication master] you can’t commit (at all) more than… up to several hundred. This really will open a large window where rows won’t be able to be updated more…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… of a replication feedback mechanism, unlike anything you find in standard async MySQL replication. It…the expense of certification by keeping the window between new transactions being committed and… which minimizes replication conflicts on a cluster where writes happen on all nodes. On a master/slave…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
… with other databases, at least not in the same way. Windows in particular has had excellent threading support practically forever; Linux… have those things, if you’re running a data warehouse on MySQL, and in some cases for other uses too (note that… web database too. MySQL replication is one of the core, fundamental features — and it’s single-threaded and relies on the binary log…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… and replication on the other slaves is re-adjusted to point to the new master. This solution works well with all the MySQL… updated before returning after a commit statement. There is a window in time where it is possible that a fully committed… replication on one of the MySQL servers lags behind too much, its read VIP will be moved to another server. As a conclusion, replication…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… a window of time where data loss is possible. If you can afford to lose some data, you can consider “MySQL replication” and… MySQL replication Typical, average MySQL DBA + some Sysadmin skills Master-Master with MMM manager Good, average MySQL DBA + good Sysadmin skills Heartbeat/SAN (depends on…
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
… is handy when you have this tool running in several windows on several nodes. cmt This is the wsrep_local_state_comment… to detect replication lag, and this really just tells you if multi-threaded replication could help improve replication speed at all. Conflct Replication conflicts…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…on Windows # (via the “enable-named-pipe” option) will render mysqld useless! # #skip-networking # Replication Master Server (default) # binary logging is required for replication…
Post: dbqp and Xtrabackup testing
November 16, 2011 By Leave a Comment
… itch. It is based on technology SQL Server was using in 1998 (MySQL began using it in …replicating from the backed up server. After the initial setup, we ensure replication is set up ok, then we do additional work on……who knows, we may even start working on Windows one day ; ) These tests are by no …
Comment: Impact of the number of idle connections in MySQL
February 23, 2011 By 21 Comments
hi, i m using mysql 5.1 on windows platform, and i want to know how many slave is possible of master in replication process in mysql. what is maximum number to generate slaves in mysql replication
