June 19, 2013

Comment: How to load large files safely into InnoDB with LOAD DATA INFILE

I used to be recommended this blog via my cousin. I am not certain whether this put up is written by means of him as no one else know such exact about my trouble. You are incredible! Thank you!

Comment: Call for papers: Percona Live London

…, bars, theaters, festivals and much more. With an easy-to-use interface, search within distance, date, or by type or genre…

Post: MySQL Webinar: Percona XtraDB Cluster Operations, June 26

… need for more advanced talks has arisen. As such, I wanted to shift gears from the standard introductory talk and focus…

Comment: Sphinx search performance optimization: attribute-based filters

… records), then you dont want to use this. Please see “Highly selective columns only” section for examples where it doesn’t work well for…

Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!

… DNS. The post focuses on the key aspects of synchronous replication setup with high-availability guarantees like split-brain immunity. Nobody likes to debug async replication while its broken or do the master-master/master-slave switchover when master is dying/dead… backups which can be used for SST (Note, the wsrep_sst_xtrabackup in 5.5.30 can’t do those except parallel…

Post: Call for papers: Percona Live London

… us your war story: What have you experienced while actively using MySQL, Percona Server, MariaDB, Drizzle or (fill in the blank… you owe it to the MySQL community to share them. Dont worry about being fancy. Some of the most popular talks…

Comment: Sample datasets for benchmarking and testing

the links here are useful and informative…

Comment: Sphinx search performance optimization: attribute-based filters

… tables each with hundreds of thousands of records, for we use sphinx based on attributes, but memory consumption is exaggerated, so…

Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2

…done with care if you dont want to break replication or corrupt your data. Scenario #2: One of the slaves is behind Now …cannot totally forget old-style replication positioning. Conclusion Reconfiguring replication when using GTIDs is usually straightforward: just connect the slave to the correct …

Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4

using Percona Replication Manager (PRM) with RHEL/CentOS prior to 6….heartbeat:IPaddr2): Started percona1 Master/Slave Set: ms_MySQL [p_mysql] Masters: [ percona2 ] Slaves: [ percona3 percona1 ] [root@percona1 … (dont forget you should have done this even before updating the first node, but I wanted