…) was released over a year ago and since then there has been tremendous interest and adoption. There’s plenty of talks… has arisen. As such, I wanted to shift gears from the standard introductory talk and focus instead more on some key questions…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… in attendance on 05 June 2013 for my “Choosing a MySQL HA Solution” webinar. If you weren’t able to make it… able to get to your question during the initial session, so I’ll address those lingering questions in this post, along with… more involved if that’s what you need. Q: What MySQL HA solution is most similar to Oracle RAC? A: Oracle RAC…
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
… a webinar entitled, Choosing a MySQL HA Solution, in which we’ll explore the topic of MySQL HA from each of these perspectives. The… about HA in a holistic fashion and help guide you towards asking the right questions when considering a new or upgraded HA deployment…-known MySQL HA tools and technologies available today (largely grouped into those which use traditional MySQL replication, those which use some other MySQL-level…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… answer to these questions, let’s create a simple replication configuration with one master and two slaves, all running MySQL 5.6… master has GTID_MODE ON and this server has GTID_MODE OFF, Error_code: 1593 These simple tests answer the first two questions… TABLES FROM test on both slaves shows that the table has been created everywhere. So once GTIDs are enabled on all…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
MySQL can be deployed in several ways, and that means you … hot backups, online schema changes, replication based high availability (which has some caveats). Also, because of asynchronous replication, you can end… you plan on attending – and also feel free to post questions in advance below.
Comment: ZFS on Linux and MySQL
May 31, 2013 By 17 Comments
Nice to see this writeup on ZFS and MySQL. One question, why with 192GB of memory, did you limit the ARC …. Would be interested if someone wanted to contribute on the MySQL side. Interesting that on Wikipedia Data Virtualization is talked about… set of data supports multiple consumers and appears that each has an exclusive copy of that source data. (see http://www…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
…, it doesn’t work anymore if you are using MySQL GTID. Then the question is: Is there any easy way to skip… in its own binary log and that means that it has been executed. This is an easy way to skip some… is found in Percona Toolkit for MySQL. Last week I gave a talk at Percona MySQL University @Toronto about GTID. It includes…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… columns in MySQL?” and “What is the minimum maximum number of columns in MySQL?”. Before you read on, ponder those questions and come… nice things (like default values other than NOW()). It also has certain limits which by any modern standard are purely arbitrary… cannot be greater than 64kb. The bit of code in question that comes into play around the maximum number of columns…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…, so we tried to answer that question by retrying benchmarks on various combinations …g. for 1024 concurrent threads each SELECT has to scan about 100 update transactions …–percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point…
Post: Finally. How to verify if all MySQL records were recovered
April 25, 2013 By Leave a Comment
… question arises: How many MySQL records were recovered and how many were lost. Until now there was no way to answer the question… how many records an InnoDB page stores. The index page has a header PAGE_N_RECS – this is a number of… stored in the leaf pages only, so if an index has more than one page no records will be found in…
