June 19, 2013

Post: Percona Server on the Nexus 7: Your own MySQL Database Server on an Android Tablet

get install build-essential cmake libncurses5-dev bison libaio-dev download Percona Server MySQL

Post: Which Linux distribution for a MySQL database server? A specific point of view.

… start/stop MySQL, upgrade MySQL, … . Restarting and changing MySQL version might just be the most critical operations you ever do once server is moved into…. Why? RedHat and CentOS are the only platforms getting packages from all MySQL and MySQL-fork vendors – Oracle, MariaDB and Percona. By my…

Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80

… Raspberry Pi itself (about $36) Make sure to get the v2 (512MiB SDRAM) version A plastic case (~$12 on eBay which includes…. Once you have your hardware, here is how to get Percona Server for MySQL up and running: Insert the SD card into a…’ Start Percona Server [root@alarmpi ~]# systemctl start mysqld Connect using the mysql client: [root@alarmpi ~]# /usr/bin/mysql Welcome to the MySQL monitor. Commands…

Post: Troubleshooting MySQL Upgrade Performance Regressions

… (for example with MySQL Sandbox) can especially be helpful. Once you have spotted the query which performs differently between MySQL Server versions you should… and increasing innodb-stats-sample-pages to get more accurate results. In recent Percona Server versions and MySQL 5.6 you can also store…

Post: How Can Percona MySQL Server Development Services Help ?

MySQL 5.6, this might not be good enough for you. Percona MySQL Server Development Services can often Backport Bug Fixes in the versionget the most performance from your MySQL server via our Percona MySQL Consulting, Percona MySQL Support, and Percona MySQL Remote DBA services. With our MySQL Server

Post: Profiling MySQL Memory Usage With Valgrind Massif

…the moment): sudo yum remove valgrind* # or apt-get etc. sudo yum install wget make gcc gcc…all releases). Download debug binaries of the same server version as you are currently using, and simply use…Log_event::read_log_event(st_io_cache*, st_mysql_mutex*, Format_description_log_event const*) (in /…

Post: MySQL Upgrade Webinar Questions Followup

… hard to get them to be same as in old version. Q: What is about running 2 instances of MySQL with different versions to… it to upgrade from MySQL 5.5 to Percona Server 5.5 Compatibility is our highest priority with Percona Server, so it should… to get most our of your Percona Server install. Thank you for your questions and for attending. See you at our other MySQL

Post: Debugging MySQL SSL problems

…, I had setup PRM first, and then was working to get the other requirements configured.  I knew from experience that it… private key, and the server key, and this was already working on an existing environment with the same MySQL version.  I had already… a basic HTTP-ish server: /usr/bin/openssl s_server -cert /etc/mysql/ssl/server-cert.pem -key /etc/mysql/ssl/server-key.pem -www Now…

Post: What's the recommended MySQL version?

… great question: “Which version of Percona Server is currently recommended?” It’s really the same question as “Which version of MySQL is currently recommended… biggest distinguisher). For an existing MySQL database server, I’d encourage not jumping on a new version immediately when it comes out. Let… the near future. At this point, MySQL 5.1 is starting to get old, and MySQL 5.5′s new releases have just…

Post: MySQL Life Cycle. Your Feedback is needed.

MySQL or Percona Server 5.1 than 5.5 Facebook also sticks with MySQL 5.1 even though their highly patched and improved version. MySQL… kind of Version and Platform support do you think is adequate for MySQL ? Oracle seems to have extended support for MySQL versions rather significantly… supported platforms it gets a bit more confusing. Per this table RHEL4 is Supported all the way to MySQL 5.5 yet…