June 20, 2013

Post: Implementing SchemaSpy in your MySQL environment

June 4, 2013 By 2 Comments

… database has Foreign Keys then you’re laughing, if not don‘t despair, you just have a bit more work ahead of… While I find the Relationships tab the most useful component of SchemaSpy, I don‘t want to leave you with the impression that this… wife :) Finally don‘t forget to automate SchemaSpy via crontab once you’re done. What are some ERD tools you use and how…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: ,

Comment: Sphinx search performance optimization: multi-threaded search

May 24, 2013 By 10 Comments

… Robert, – you don‘t actually need to merge sphinx indexes – it does that on the fly. If you are using sphinxql, you can actually just list all the indexes you want to merge on the fly… for some explanation. And btw, you don‘t want to run indexer for the virtual index, you want to index the local parts instead…

Filed Under: MySQL Tagged With: , , ,

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

June 7, 2013 By Leave a Comment

… There are really two main reasons that I don‘t like DRBD with virtual machines. First is …use the BLACKHOLE storage engine) in between the actual master and the slaves at the bottom of the replication …why would you ever want to use MySQL on top of something like that? I can’t imagine the performance…

Filed Under: Insight for DBAs, Insight for Developers, MySQL, MySQL Webinars Tagged With: , , ,

Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera

June 5, 2013 By

… bandwidth required for replication multiplies. Now, this isn’t really much different from standard mysql replication.  1 master with 5 async slaves is going to send a separate replication stream to… and SST will still use TCP unicast, so we still want to make sure those are configured to use the regular IP of…

Filed Under: Percona Software, Percona XtraDB Cluster Tagged With: , , ,

Post: MySQL Query Patterns, Optimized - Webinar questions followup

June 3, 2013 By 2 Comments

…use that to ultimately produce the result you want, that’s another technique that I see used…using replication, a temporary table could vanish if the slave restarts and then subsequent queries against the temp table fail. Q: Why doesn’t…plan. (I know it doesn’t though.) Why don‘t you try writing a SQL…

Filed Under: Insight for Developers, MySQL, MySQL Webinars Tagged With: , , ,

Comment: ZFS on Linux and MySQL

June 8, 2013 By 17 Comments

… consider that pretty much dead project. The only thing I don‘t like about OmniOS is that the illumos base currently lacks…. So OmniOS should only be used as MySQL read slaves behind a pair of Linux based MySQL Masters using Pacemaker. Maybe you guys…

Filed Under: Hardware and Storage, Insight for DBAs, MySQL Tagged With: , , , ,

Post: The small improvements of MySQL 5.6: Duplicate Index Detection

May 31, 2013 By Leave a Comment

… MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached integration, a more … just the first one. Why can’t MySQL enforce this kind of constraints? …% of all applications out there that use MySQL, for which we at Percona… Indexes 2 By the way, if you want to get more familiar with this…

Filed Under: Insight for DBAs, MySQL, On Ground Training, Percona Toolkit, Training Tagged With: , , , , , , , , ,

Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2

May 30, 2013 By 6 Comments

… very annoying and I don‘t know any workaround. However IMO all these bugs don‘t mean you should not use GTIDs, you just need… and see if you can accommodate with them (think of replication 10 years ago or partioning in 5.1 for instance).

Filed Under: Insight for DBAs, MySQL Tagged With: , ,

Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2

May 30, 2013 By 6 Comments

@Kristian, Well, the (slave) server *knows* whether it is replicating in parallel or not, so it doesn’t have to always manage the general case. When it knows it uses single thread replication the “last executed” assumption is safe.

Filed Under: Insight for DBAs, MySQL Tagged With: , ,

Post: Experiences with the McAfee MySQL Audit Plugin

May 23, 2013 By 4 Comments

…this involves a lot of data you don‘t need too, and isn’t flexible at all. The specific problem … (tables, according to the docs) for which you want events written to the log. – audit_whitelist_users : … missing feature on the server, which has made using MySQL in PCI or SOX compliant environments, to…

Filed Under: Insight for DBAs, MySQL Tagged With: ,
« Older Posts
Newer Posts »