…an open source tool kit which helps improve the performance of queries against a MySQL database by …to vastly improve the performance of queries which have to examine a large amount of data. …test schema is normalized, Vadim’s test queries must be modified to reflect the more complex schema…
Post: Percona is looking for a Perl and Python expert
June 24, 2008 By 6 Comments
… have a job for you. We’re looking to either hire or sponsor significant development efforts for some open-source tools for MySQL… can work remotely. You must already be an expert coder. You don’t have to be a MySQL expert, though it will help if you are at least at an intermediate level with it. You must have…
Post: Migrating to XtraDB Cluster Webinar follow up questions
June 6, 2012 By 3 Comments
…separate ports with separate configurations, and the application must connect to the appropriate one, depending if …plugins, and I misspoke: The Percona Monitoring Plugins have a check that enables you to set …on the monitored MySQL server in question. It should be easy to use this tool to monitor at…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
…So, how do we avoid misalignment? Well, we must ensure alignment on each layer of the stack… in are –dataalignment and –dataalignmentoffset. If you have set the offset correctly when creating partitions (see… more modern – GUID partition table (GPT). The tool for the task of working with GPT …
Post: Introducing the “Version Check” Feature in Percona Toolkit
September 10, 2012 By Leave a Comment
… supports this feature with an option –version-check and the tool will connect to the Percona Version Check database. To maintain… (some versions of this module have compatibility issues) versions. Version Check must send information on your MySQL version and other covered software versions…
Post: How we work on High Performance MySQL Second Edition
November 12, 2007 By 12 Comments
… for authoring a book being involved in MySQL Support, MySQL Consulting, Documentation, MySQL Training while working for MySQL and now on his own. Finally… means the must be not only good writer but also fast writer. Another strong point of Baron are having experience working with a lot of other database technologies as well as being author of very popular tools – Innotop and MySQL…
Post: What Are Full, Incremental, and Differential Backups?
January 23, 2012 By 9 Comments
… makes a copy of all of your MySQL data. A differential backup, on the other…tool used, a differential backup can be less labor-intensive for the server. If a differential backup does not have… the changes that have happened since Sunday. If you have taken incremental backups, you must restore Sunday’…
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
…companies in the MySQL ecosystem are Percona customers, including hardware manufacturers,… an opinion about it, then you must be willing to disclose that you…is not used as a sales tool. We will not endorse a solution…vendors whom we know or have worked with, and we have no formal partnership or …
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… 2 blog posts about High Availability for MySQL we have introduced definitions and provided a list of (… failover or recovery should be automatic. There are tools to manage automatic failover with replication like MMM,… because of a network problem, a stonith device must be used to fence it. I am far…
Comment: Percona Playback 0.3 development release
August 12, 2012 By 15 Comments
… tool, it looks promising. I couldn’t make it work, though. … normally represent a normal load pattern (ideally, the slow log must have zero records at all). Replaying general logs is much more… without utilizing some kind of proxy in front of the MySQL server. Also, is there a way to set the number…
