… 5.5.31 will handle them all, also XB 2.1 is required for most). Finally, the HAProxy. HAProxy is one…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
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
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…” align=”alignright” width=”247″] Percona Server for MySQL version 5.1.69-14.7[/caption] Percona is glad to announce the… lead to unresolved package dependencies when installing Percona Server 5.1. Bug fixed #893860. The log tracker thread was unaware of… fixed #1153651. Release notes for Percona Server for MySQL 5.1.69-17.4 are available in our online documentation. Bugs…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… people setting up clusters with 3-6+ nodes on 1 Gbps networks. 1 Gbps seems like a lot, doesn’t it? Actually… needs to replicate to all nodes at once, this means 1 copy of your replication message is sent to other node… much different from standard mysql replication. 1 master with 5 async slaves is going to send a separate replication stream to each…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…=’rsandbox’,master_password=’rsandbox’,master_port=10001,master_auto_position=1; s0> start slave; # For s1, s3 and s4 mysql> stop… t; +———-+ | count(*) | +———-+ | 0 | +———-+ Can we still use master_auto_position = 1? Let’s hope so, as it is one of the… may be broken. Scenario #3: The master has crashed before sending all writes If the binary logs of the master are…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
… is glad to announce the release of Percona XtraBackup 2.1.3 for MySQL on May 22, 2013. Downloads are available…. It’s advised to upgrade your latest 2.1 version to 2.1.3 if you’re using the Percona XtraBackup with…. Release notes with all the bugfixes for Percona XtraBackup 2.1.3 are available in our online documentation. Bugs can be…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… try to reconfigure the master? This time, replication on slave #1 will stop: 2013-05-17 13:32:08 2563 [ERROR..., we will enable GTID replication on slave #1, but not on slave #2: # slave #1 mysql> change master to master_auto_position... at the last field, Auto_Position: # Slave #1 mysql> show slave status\G [...] Auto_Position: 1 -> GTID-based positioning # Slave #2 mysql> show…
Comment: Converting Character Sets
June 12, 2013 By 22 Comments
Approach number 1 is correct. There was no truncation: MEDIUMTEXT is bigger than … in the manual – http://dev.mysql.com/doc/refman/5.1/en/alter-table.html “For a column that has a…
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 means you can choose a tailor-made path that best meets your needs. With simple services or development systems, many people are using a single server with some backups configured, and then simply take the downtime when a restore is needed. As the …
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 11, 2013 By 3 Comments
Hi Moazam, 1) no, you don’t have to export databases, you can …. But check http://www.percona.com/doc/percona-server/5.1/compatibility.html if you’re planning to switch back from… compared features: http://www.percona.com/doc/percona-server/5.1/feature_comparison.html 3) we’re not planning to release…
