… subsequent run of chef-client is done to update the cnf files with IP address of members … SST is used there. SST matters a lot because not only is it used during initial …handle them all, also XB 2.1 is required for most). Finally, the HAProxy. HAProxy is one of the loadbalancers recommended for use…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…other reason is because virtual machines tend to handle process scheduling and timing much differently than … why would you ever want to use MySQL on top of something like that? I can’t…file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I saw that it was getting a lot of “bad file…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
…the GTID mode enabled. Example of how this information can be used to create/restore a slave …If there are thousands of tables and slow IO then XtraBackup can spend a lot of time opening all the …temp files behind due to a typo. Bug fixed #1172016. innobackupex wasn’t handling the innodb_data_file_…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… GTID mode enabled. Example of how this information can be used to create/restore a slave …If there are thousands of tables and slow IO then XtraBackup can spend a lot of time opening all the… Bug fixed #1169509. innobackupex wasn’t handling the innodb_data_file_path option which could cause backup to…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… files and binary log files has to be synchronized with storage engine transactions which require a lot of…we venture into using cross storage engine transactions we’re up for a lot of surprises. …lot of CPU cycles by having storage format same as processing format. We could tune Optimizer to handle…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… have a lot of non-transactional tables (i.e. myisam), use –rsync option. This will rsync a copy of all the frm files and all the MYD/MYI files. It then does… schema’s. It does not handle views/triggers/procedures etc. Run with –no-schemas, instead use mysqldump for the schemas and rely…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
… write this amount of data to the disk. If you are using “pid” with core files, which you probably …is important. There have been many changes to core file handling on Linux and what worked on one system … it has a lot of good information. Now as I explained how you can get core files from MySQL …
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… of Web Applications in general. Clearly web is not enterprise and has a lot of …file storage, queuing, data processing etc. But seriously if you look at this – people do not really enjoy adding memcached – cache handling… which makes neither of them used for very wide class of applications. Another …
Post: Pacemaker, please meet NDB Cluster or using Pacemaker/Heartbeat to start a NDB Cluster
May 19, 2010 By 10 Comments
…t start at all. That’s a lot of rules to handle. Since all aspects of HA interest me, I was …sources, look here for help. There 2 minimal configuration files: root@test2:~# cat /etc/ha.d/authkeys auth …> Please note the ndbd resource is defined through the use of a clone set. The clone set will allow …
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
… design with so much error detection and automated handling in mind as Google File System. In particular you want to make sure… should be used. I normally do not use it because it a large waste, especially as most of systems have even number of drives… to buy something cheap which is not used most of the time when to spend a lot of money on the server which will…
