… no way a closed-source software product will ever be deployed in a Facebook data center. No service provider lock-in… that article: “In principle, anyone who has an interest in MySQL and MariaDB surviving should contact the MariaDB foundation and ask… Tokutek). To summarize my thoughts: If you are in the MySQL market and your product is under proprietary license (not an…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… fits into the cache device, vCache shines. Compared to a deployment with no SSD cache whatsoever, FlashCache still does quite well…-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run…
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 11, 2013 By 13 Comments
… or hiring talent to deploy and maintain something on your own. You can chose to stay with MySQL with Tokudb as your…
Post: White Paper: "Scaling MySQL Deployments Efficiently" from Percona and Virident
February 7, 2011 By 2 Comments
… on evaluating tachIOn as solution for MySQL, and as result you can find whitepaper “Scaling MySQL Deployments Efficiently Using Virident tachIOn Drives”, available… to improve performance or building high-performance solution based on MySQL.
Post: What's the recommended MySQL version?
August 15, 2011 By 24 Comments
… shouldn’t really be urgent pressure to upgrade. For new deployments, I’d definitely start by using the most recent version… next version if it’s available, especially if the new deployment isn’t in production yet. The reason is that I…, and now I’d even say use MySQL 5.6. For older applications running MySQL 5.0, I’d say upgrade to…
Post: Percona Server on the Nexus 7: Your own MySQL Database Server on an Android Tablet
February 28, 2013 By 11 Comments
…, we install Linux environment, I used Linux Deploy App to deploy Ubuntu 12.04 LTS. It does not…we will have binaries in /usr/local/mysql, which we start mysql> show variables like ‘version%’; +————————-+——————————+ | Variable_name | Value | …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… of suggestions for what to monitor in MySQL. Those are only suggestions; any given deployment might want to monitor only some of… in easily and be deployed, and you will not find it anywhere but in production. The pmp-check-mysql-deadlocks plugin can… down for a system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of contention in…
Post: Upcoming Webinar - "Deploy MySQL Like a devops SysAdmin"
October 25, 2012 By Leave a Comment
…. Then I will explain the best practices on how to deploy MySQL in a large scale environment using tools coming from the…
Post: Percona Welcomes MySQL 5.6!
February 25, 2013 By Leave a Comment
… Oracle MySQL, MySQL 5.6 is fully supported by our MySQL Consulting, MySQL Support, MySQL Server Development, and MySQL Remote DBA teams: Our MySQL Consulting Team and MySQL… to take advantage of MySQL 5.6′s features; create an in-depth upgrade plan; help design and deploy new applications to…
Post: Distro Packages, Pre-built Binaries or Compile Your Own MySQL
September 4, 2012 By 7 Comments
I’ve been helping customers deploy and maintain MySQL (and variants) for the last couple of years and it … be as easy as stopping MySQL, updating symlinks or your my.cnf basedir, starting MySQL and running mysql_upgrade. Unlike package managers, you… simply keeping package folders on unique directories. Lastly, running your MySQL server from pre-built binaries does not prevent you from…
