… a short while. Here’s the vmstat output during the split process, the cron job started at 10am. Fri Mar 22… and then swapping starting at 10:03:36. Also, the server is reading a lot (~150MB/s) but doing very little physical writes. The writes were cached and the write cache was causing the…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… important use case for PARTITIONing (“uneven reads“, Re: #1); let me rephrase the use …non-partition equivalent. Even single-row writes are likely to be slower …(about) 5 levels deep. If you split that table into 100 partitions, …. I go into more details (and code) here: http://mysql.rjweb….
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… for accepting a never-ending stream of queries to playback. Read-only playback Using the –session-init-query command-line option… set the option innodb_fake_changes to prevent INSERTs, UPDATEs, and DELETEs from corrupting the data on the standby server. You… write. The slow logs were split into chunks, each containing roughly 1M queries. We warmed the cold database with the first chunk and…
Comment: Migrating to XtraDB Cluster Webinar follow up questions
June 6, 2012 By 3 Comments
… cluster the different ports for write and ready traffic? Why would you want to split read and write traffic? You can both read and write to all nodes, you should get rid of legacy code or scripts that do read-write splitting. “There…
Comment: Percona XtraDB Cluster reference architecture with HaProxy
January 28, 2013 By 63 Comments
Zoltan, Haproxy won’t split read and write traffic for you. You need to do that from the … it can make sense to write only to 1 node if you have conflicting writes. With PXC, conflicting writes are causing rollbacks, not… are much more expensive. If you don’t have conflicting write transactions (parallel threads updating the same record for example), you…
Post: How to lag a slave behind to avoid a disaster
September 11, 2012 By 5 Comments
MySQL Replication is useful and easy to setup. It is used for very different purposes. For example: split read and writes run data mining or… mistake on the master. Conclusion We can improve the security and availability of our infrastructure using delayed replication slave. Is useful…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… so it can keep up with the writes and/or configure and rethink the retention of the raw data….of a network split. If a network split happens and a node decides to shut down, and somehow restarts … called innobackupex, and not xtrabackup itself while holding a lock using FLUSH TABLES WITH READ LOCK. …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… bigger than 16G, I’ve repeated the random read (and write) benchmark with 8 threads and total size of 256G. While the number of… splits) etc. Benchmark results are fairly consistent regardless of file size, let’s look at them. First, results with WT cache: And… the two workloads that are most relevant to databases – random reads and random writes – IO alignment on a 4-disk RAID10 with standard…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… application is well designed and has specific database handles for read and write operations, this HA solution can scales the read operations to a high…suitable for high write loads All the servers can be used, no idle standby read scaling only if application splits reads from writes Supports MyISAM…
Post: Webinar on Read/Write Splitting with PHP
January 17, 2013 By 2 Comments
…), about issues application developers should think about for scaling out read-query traffic using multiple MySQL instances in a replication pair… webinar by registering here: http://www.percona.com/webinars/readwrite-splitting-mysql-and-php
