… has some caveats). Also, because of asynchronous replication, you can end up having inconsistent data on the nodes and encounter replication errors… a talk on this topic at next month’s RAMP conference in Budapest, Hungary. My presentation will provide an overview of some… our consulting practice. Please let me know if you plan on attending – and also feel free to post questions in advance…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…] Percona is glad to announce the release of Percona Server 5.1.69-14.7 on June 10, 2013. A drop in… Repositories. Based on MySQL 5.1.69, this release will include all the bug fixes in it. All of Percona’s software… system mutex for the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed #1171699. Missing path separator between…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
… host is using different storage engine for the respective table on master databases. Also, if BINLOG_FORMAT is not consistent on master/slave db. 3. CREATE TABLE …. SELECT – It is not supported to perform such type of statements http://mysqlopt.blogspot.co.uk/2013/06/restrictions-on-replication-with-gtids.html
Comment: MySQL and Percona Server in LinkBench benchmark
June 9, 2013 By 18 Comments
… at the time) seems strongly depend on GC of java VM at the high throughput. The room of memory (10~20GB for 100… think LinkBench should have less dependency for GC to test on fast storage, reusing objects/sessions/stmt more or something… Otherwise…
Comment: ZFS on Linux and MySQL
June 8, 2013 By 17 Comments
…. ZFS LZ4 compression is the best thing since the invention of L2ARC and ZIL. All I am dreaming now is to… of Linux based MySQL Masters using Pacemaker. Maybe you guys can get Galera working on OmniOS to solve our lack of clustering problem on…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… this post, along with providing a bit more detail on some of the questions that I did cover during the session. Q… like that in the MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You…, honestly, why would you ever want to use MySQL on top of something like that? I can’t imagine the performance being…
Post: Private, custom Percona MySQL Training
June 7, 2013 By Leave a Comment
… Live MySQL Community Event this year we had the pleasure of Alexei Rodriguez discussing why Evernote uses Percona’s Private Custom MySQL Training. Alexei is VP of operations there and you can watch a video of his presentation on YouTube. Alexei said he values…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… clusters I’ve seen a lot of people setting up clusters with 3-6+ nodes on 1 Gbps networks. 1 Gbps seems… to use the regular IP of the node. Typically I just set the wsrep_node_address setting on each node if this IP is not the default IP of the server. I could not…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… to announce the first Release Candidate release of Percona Server 5.6.11-60.3 on June 3rd, 2013 (Downloads are available… Fixed: Transaction objects are now allocated calling calloc() directly instead of using InnoDB heap allocation. This may improve write performance for… system mutex for the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed #1171699. Incorrect schema definition for…
Comment: ZFS on Linux and MySQL
May 31, 2013 By 17 Comments
… writing a book on Data Virtualization for Databases meaning using a single set of datafiles that support multiple copies of the source database. Would be interested if someone wanted to contribute on the MySQL side. Interesting that on Wikipedia Data…
