June 19, 2013

Post: Webinar: Looking for Painless MySQL High Availability ?

I have a pleasure to deliver Webinar on Industrial-Strength MySQL Applications Using Percona and Continuent together with Robert Hodges next week… Percona and Continuent to build Highly Performance and Highly Available Applications utilizing MySQL Replication. I’ve been interesting in doing this Webinar…

Post: Webinar: Avoiding common traps when designing a MySQL application

… you when designing and building a stable and high-performance MySQL application. I will discuss a broad range of topics, from hardware… have done the same result. So if you think your MySQL servers are not in an optimal state, I invite you…

Post: Percona's O'Reilly MySQL Conference Community Awards

… O’Reilly MySQL Community Contributor of the Year 2011 for InnoDB performance improvements, and to XtraBackup as O’Reilly MySQL Application of the Year 2011 for adding opensource hot backup functionality to MySQL. It’s worth saying…: Yasufumi, Giuseppe Maxia, Continuent, and DeNA. Let’s keep making MySQL better! (Note: I was part of the conference speaker committee…

Post: How to Monitor MySQL with Percona's Nagios Plugins

… another plugin) are frequent causes of serious errors in applications because the applications often don’t handle deadlocks correctly, and in many… out afterwards. Another very common cause of serious incidents is application misbehavior, such as opening a transaction but never committing it… to deadlocks and timeouts, applications often don’t handle or log this error appropriately. The pmp-check-mysql-status plugin can be…

Post: New Keynote Speakers and Sponsors and Applications Open for DotOrg Pavilion for Percona Live MySQL Conference and Expo

… relevant to the MySQL community. Last year featured participating projects like phpMyAdmin, CentOS, Mozilla, MariaDB, Drizzle, and MySQL Sandbox. Applications close February 10. Sponsors I’m pleased to announce a number of new Percona Live MySQL Conference and…

Post: Troubleshooting MySQL Memory Usage

… and so if you close connection MySQL can clean them up. Killing connections (or stopping related applications) and observing whenever memory usage… to connections and identified application which causes excessive memory usage you might look at how it uses MySQL to identify potential causes…

Post: MySQL Life Cycle. Your Feedback is needed.

… I matured and so did MySQL ecosystem. MySQL is powering a lot more demanding and business critical applications now than 12 years ago… MySQL versions are used is typically when application is not overly demanding so performance improvements in recent releases is not critical, older applications… might be application changes which might not be practical for old applications. For the same reasons we often see old MySQL versions not…

Post: MySQL Server Upgrade

… works with MySQL 5.0. Second – I know my applications designed to work with MySQL 4.1, they avoid queries which MySQL 4.1 does not optimize well and so MySQL 5… this server which has mix of various third party PHP/MySQL applications. In different situations upgrade strategies may be different. The main…

Post: High availability for MySQL on Amazon EC2 - Part 6 - Publishing server location

… a way to point the web servers or application servers to the HA MySQL service. Normally, in an HA setup, this is…/update_mysql ubuntu@$IP sudo ./update_xinetd.sh $MYSQL_IP done < $TMPFILE rm $TMPFILE There are many ways to configure web/application servers, I chose to have the applications connect…

Post: How Can Percona MySQL Server Development Services Help ?

… is easy to change the application to become compatible with a new MySQL version. In others, though, the application might be legacy or… Features in MySQL Server – In many cases you can get great value from new features added to MySQL which benefit your application a… it can be controlled by the MySQL DBA team where it belongs instead of by by Application Developers. Sometimes a good workaround…