June 19, 2013

Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!

… and IST (incremental state transfer) is not feasible. It also helps when node data integrity is compromised. So, naturally duration of…

Comment: Minimizing Downtime from Lengthy AWS Outages

Please post your experience on Percona XtraDB Cluster (PXC) on AWS. I would help us since we want to explore this option.

Post: Implementing SchemaSpy in your MySQL environment

… using their environments.  One tool that I am finding very helpful is called SchemaSpy. SchemaSpy is a Java-based tool (requires… links and entity-relationship diagrams. It’s also designed to help resolve the obtuse errors that a database sometimes gives related… thing” but sometimes you need to give it a little help in the form of metadata files. Installation of SchemaSpy and…

Comment: Percona XtraBackup 2.1.3 for MySQL available for download

… our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Please help us make Percona Server better by reporting any bugs at…-server/. You may find information in the manual which will help you identify the cause of the crash. 130528 09:53…

Post: MySQL Query Patterns, Optimized - Webinar questions followup

… see used, although it’s less common.  It can be helpful to simplify the development of a report, but whether it… about why you thought about doing that and why it helped? When I did not use the STRAIGHT_JOIN, the query…

Comment: Sphinx search performance optimization: multi-threaded search

Thanks for the feedback, Robert. There are some types of queries where it does not help (those that do a lot of post-processing after matching the search), but in many simple cases it should help indeed.

Post: Migrating between MySQL schemas with Percona Xtrabackup

… table (currently a blueprint in innobackupex).  He also included this helpful script to generate all of those statements for steps 7…

Comment: MySQL Performance Forums

… community (maybe even a Percona expert) will be able to help you resolve your issue.

Comment: Implementing SchemaSpy in your MySQL environment

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.

Comment: What Are Full, Incremental, and Differential Backups?

Im having the same issue with that project. i could really use some help right about now. its been wrecking my head for a while nw