…=’rsandbox’,master_password=’rsandbox’,master_port=10001,master_auto_position=1; s0> start slave; # For s1, s3 and s4 mysql> stop… t; +———-+ | count(*) | +———-+ | 0 | +———-+ Can we still use master_auto_position = 1? Let’s hope so, as it is one of the… fixed, it is good to be aware of the current limitations.
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… lead to unresolved package dependencies when installing Percona Server 5.1. Bug fixed #893860. The log tracker thread was unaware of…, and USER_STATISTICS) led to the maximum counter values being limited to 32-bit signed integers. Fixed so that these values… the log system mutex for the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed #1171699. Missing path…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… specific replication topology. However you should keep in mind some limitations of the current implementation. This post is the first one… try to reconfigure the master? This time, replication on slave #1 will stop: 2013-05-17 13:32:08 2563 [ERROR... at the last field, Auto_Position: # Slave #1 mysql> show slave status\G [...] Auto_Position: 1 -> GTID-based positioning # Slave #2 mysql> show…
Comment: ZFS on Linux and MySQL
June 4, 2013 By 17 Comments
… significant portion of ram to work with. I agree that limiting ARC to small amount of ram prevents double caching by the file system vs the InnoDB caching. However, limited ARC size also limits ZFS file system’s internal metadata caching(which l2arc… ZFS metadata caching to make ZFS fast. NexentaStor recommends minimum 1-2GB ram for every 1TB raw storage. So in essence…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… common in OLAP analysis. Each query in each flight (Q1.1 for example) is tested with a cold buffer pool. Then… InnoDB. SSB Flight #2 Flight #2 is similar to Flight #1. MyISAM is faster than InnoDB when the database is cold…!. MyISAM may be good for raw performance, but there are limitations which MyISAM imposes that are difficult to work with. MyISAM…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… people setting up clusters with 3-6+ nodes on 1 Gbps networks. 1 Gbps seems like a lot, doesn’t it? Actually, maybe not as much as you think. While the theoretical limit of…, this isn’t really much different from standard mysql replication. 1 master with 5 async slaves is going to send a…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… to ZFS (30 mirrors + spares + OS partition mirror) and I limited the ARC size to 4GB. I don’t want to… raid controller write cache use. Even the fairly slow gzip-1 mode works well. The tpcc database, which contains a lot…, the storage will still be working. Also, instead of having 1 or 2 spare drives per controller, I have 2 for…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… with a two-NIC bonded pair you’ll get roughly 1.67x the throughput of a single port. [Don’t try… master. This can be useful if you’re trying to limit the amount of data sent over the wire, but it…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… current limitations and see if you can accommodate with them (think of replication 10 years ago or partioning in 5.1 for…
Post: Webinar: Best Practices for MySQL Scalability on May 1
April 30, 2013 By Leave a Comment
… avoid having any one of them become the bottleneck that limits the scalability of the entire system, you need to follow…
