…MySQL 5.0 database with MySQL 5.1 with no problems in most cases. When storage type changes…to be affected. If you’re something like SELECT name FROM users WHERE id=5 you can probably go to the earliest MySQL… Sharded envinronment you often approach things a bit differently – upgrading one shard with …
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
…a small MySQL database server: You’re a uni student who wants to learn the SQL language better and needs a mini-testbox You’re a…a host name. While there, you could also assign a permanent IP address (still assigned via DHCP) by binding a MAC address to a…-connect to see if your password change worked…
Post: devops webinar - follow up Q&A
November 6, 2012 By 5 Comments
…application code version and database version? Any opinion? A: First I want to apologize that I didn’t understand the name when Terry …French pronunciation. So to answer your question, Liquibase is probably the best and more mature solution used to perform database change management. However there…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… the SLAVE. Since MySQL 4.0 this process is a bit more involved having … replication to work properly you need to have proper “snapshot” – consistent state of the database as …CHANGE MASTER TO accepts Master_Log_File parameter, while you actually want to use Relay_Master_Log_File instead. This naming…
Post: Be productive with the MySQL command line
December 21, 2012 By 14 Comments
… completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select count(*) from sakila; ERROR 1146 (42S02): Table ‘sakila.sakila’ doesn’t exist mysql> select…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…to a level where we started looking at other ways of achieving higher availability using MySQL…a master and slaves. The only thing that may change here is clone-max=”3″ which should match the number of database…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…A: I would wonder whenever it is best setup for 5 indexes to differ only by first column. Regarding changing primary key to…to add another index. Q: We have a database…A: Recent MySQL versions are smart enough to convert id IN (5) to…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…to compare performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL…a difference here and improves performance up to 15% in case of 8 threads running concurrently. Because the customer was running a database…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…change the replication method between servers? A: If you would like to switch back and forth between galera and built-in mysql…database working with Zabbix (innodb), do you have a recommended configuration? A…
Post: Introducing tcprstat, a TCP response time tool
August 31, 2010 By 13 Comments
…a database, memcached, Apache, and so on. You can use this information for historical metrics, capacity planning, troubleshooting, and monitoring to name just a…MySQL, this is the moral equivalent of a query’s response time. The statistics we chose to…
