… write load of all the MySQL instances. The original idea was to configure them with raid-10 + LVM,…snapshots! Integrity With ZFS each record on disk has a checksum. If a cosmic ray flip a…. All put together, ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… should be directly connected from one machine to another and configured with Linux network interface bonding in balance-rr mode; this is… filters on the slave, as described in the MySQL manual. You can configure the slave to only replicate a specific database, a… more involved if that’s what you need. Q: What MySQL HA solution is most similar to Oracle RAC? A: Oracle RAC…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…configurable by innobackupex –log-copy-interval. Making the interval configurable…has been changed from abstract mysql to real /usr/bin/mysql file, because rpm packages from Oracle no longer satisfied mysql…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
…has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL… is now configurable by innobackupex –log-copy-interval. Making the interval configurable allows to …fixed #1169726. For the Debian and the Linux binaries, the –version message which should …
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
Swapping has always been something bad for MySQL performance but it is even more important for HA systems. It is so important to… swapping with HA that NDB cluster basically forbids calling malloc after the startup phase and hence its rather complex configuration. Probably most readers of this blog know (or should know) about Linux swappiness setting, which basically…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… of your Raspberry Pi (for example to configure an IP address in Arch Linux if you do not have a DHCP server… (Arch Linux has this preset) Also, Arch Linux has sshd already active (sshd=ssh daemon, a software package allowing you to connect to a [Linux… situations If you want to edit the configuration file, you can find it in /etc/mysql/my.cnf If you setup Percona…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
… RedHat Enterprise Linux, SuSE Linux and …configure, tune, start/stop MYSQL, upgrade MySQL, 10x start/stop MySQL, upgrade MySQL, downgrade MySQL, upgrade MySQL, install a security fix for something, 20x start/stop MySQL, upgrade MySQL…configured state. Obviously binutils has nothing to do with MySQL…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… /mnt/nfs/dist/mysql-5.5.30-linux2.6-x86_ | /mnt/nfs/dist/mysql-5.6.10-linux-glibc2. | | PERFORMANCE_… will do a lot better on MySQL 5.6 with default configuration back_log Minor increase 50 to … blocking old insecure one. Good. innodb_concurrency_tickets has been increased from 500 to 5000. If you’…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
… quite helpful to troubleshoot MySQL Crashes yet it is not always easy to get, especially with recent Linux distributions which have security features to prevent core files to be dumped by setuid processes (and MySQL Server is… you have configured dumping core I suggest you to test it for example on the test box, which has same operating system…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
…Server 5.5.11-20.2 with former being configured with innodb_buffer_pool_instances=16 and 400GB …_get_gen PMP 10 libaio::??,os_aio_linux_collect,os_aio_linux_handle,fil_aio_wait,io_handler_…init_func,row_sel_get_clust_rec_for_mysql,row_search_for_mysql,ha_innobase::general_fetch,handler::read _multi_…
