June 18, 2013

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

June 17, 2013 By Leave a Comment

… 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…’t it be nice if this was built into the system itself? PXC based on Galera strives to provide that. Scaling makes…

Filed Under: MySQL, Percona XtraDB Cluster, XtraDB Cluster Tagged With: , , , , , , , ,

Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

June 17, 2013 By 3 Comments

Why does the mysql client says it’s 5.1.70? Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 138 Server version: 5.1.70-rel14.7-log Percona Server (GPL), 14.7, Revision 572

Filed Under: MySQL, Percona Server, Percona Software Tagged With:

Post: Percona MySQL University @Portland next Monday!

June 12, 2013 By Leave a Comment

… pt-table-checksum tool to verify replication integrity And finally, Andrew Ferlitsch will share with how MySQL can be used to provide… with MySQL, then this is an event you can’t afford to miss… :)   So register now! Please also join the Portland MySQL Meetup group for more MySQL-focused events…

Filed Under: Events and Announcements, MySQL, Percona MySQL Consulting, Percona MySQL Support, Percona MySQL Training, Percona MySQL University, Percona Remote DBA Tagged With: ,

Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)

June 11, 2013 By Leave a Comment

MySQL can be deployed in several ways, and that… requirements will appear like hot backups, online schema changes, replication based high availability (which has some caveats). Also, because…will provide an overview of some possible deployment and scaling scenarios, when it makes sense to use one or…

Filed Under: Events and Announcements, MySQL Tagged With: , ,

Post: Call for papers: Percona Live London

June 14, 2013 By Leave a Comment

… step up and volunteer to present your unique insights into MySQL and MySQL-related technologies either as a keynote, tutorial or breakout… are gold! And you owe it to the MySQL community to share them. Don’t worry about being fancy. Some of the… sponsors. This is the showcase event for Europe’s growing MySQL community of developers, business managers, technology evangelists, DBAs and entrepreneurs…

Filed Under: MySQL, Percona Live Tagged With:

Comment: Sphinx search performance optimization: attribute-based filters

June 13, 2013 By 11 Comments

… you don’t want to use this. Please see “Highly selective columns only” section for examples where it doesn‘t work well for…

Filed Under: Insight for Developers, MySQL Tagged With: , ,

Comment: Performance Schema overhead

June 12, 2013 By 22 Comments

Great test and report Vadim! I think the performance schema will be a great addition to MySQL once it’s more established. Just starting with MySQL after retiring from handling oracle databases – now volunteering :) Thanks for sharing.

Filed Under: Benchmarks, Hardware and Storage, Insight for DBAs, MySQL

Comment: Converting Character Sets

June 12, 2013 By 22 Comments

… correct. There was no truncation: MEDIUMTEXT is bigger than TEXT. MySQL does this to make sure there’s *no* truncation, as explained in the manual – http://dev.mysql.com/doc/refman/5.1/en/alter-table.html “For…

Filed Under: Insight for Developers Tagged With: , ,

Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera

June 5, 2013 By

… on 1 Gbps networks.  1 Gbps seems like a lot, doesn‘t it?  Actually, maybe not as much as you think.  While…, the more the bandwidth required for replication multiplies. Now, this isn’t really much different from standard mysql replication.  1 master with 5 async slaves is going to send a separate replication stream to…

Filed Under: Percona Software, Percona XtraDB Cluster Tagged With: , , ,

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

May 21, 2013 By 8 Comments

… describes very nicely how to switch to GTID-based replication, I won’t repeat it. Basically the steps are: Make the master… regular replication and GTID replication This time, we will enable GTID replication on slave #1, but not on slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql> start…

Filed Under: MySQL Tagged With: , ,
« Older Posts