…name=”parent_id”>
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… the questions with my complete answers: Q: Can you compare the use of subqueries/multiple joins vs. multiple queries (e.g. temp tables)? For performance… just running the query in a suboptimal form. Q: Doesn’t the primary key solution for random selection only work when…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…CREATE TABLE test\G *************************** 1. row *************************** Table: test Create Table: CREATE TABLE `test` (… MySQL, you can create two indexes with the same …can use the second index not only for filtering on both columns, but also for filtering by just the first one. Why can‘t…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… annoying and I don’t know any workaround. However IMO all these bugs don’t mean you should not use GTIDs, you just need to be aware of the current limitations and see if you can accommodate with them…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…You can…t table s1> select count(*) from t; +———-+ | count(*) | +———-+ | 2 | +———-+ Great! So again, using…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…You can also follow the official documentation here. The version of Pacemaker (always considered as Technology Preview by RedHat) provided with…You can also check your cluster using cman_tool or clustat (if you…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
…create a simple replication configuration with one master and two …Slave_SQL_Running: Yes [...] The error log tells us why the …table has been created everywhere. So once GTIDs are enabled on all servers, you can have some slaves using…can‘t think of any use case, so in practice, you‘ll probably use …
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 11, 2013 By 3 Comments
Hi Moazam, 1) no, you don’t have to export databases, you can use the existing mysql data dir. But check http://www.percona.com/doc/percona-server/5.1/compatibility.html if you‘re…
Post: Private, custom Percona MySQL Training
June 7, 2013 By Leave a Comment
… Rodriguez discussing why Evernote uses Percona’s Private Custom MySQL Training. Alexei is VP of operations there and you can watch a video… freely about operational issues during private training. If you would like to talk with our team about private custom training, please contact…
Comment: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
The ERD tools I use are MySQL Workbench and SchemaSpy. The anomalies tab of SchemaSpy has been quite helpful. However both tools can‘t really cope with really large schemas.
