May 22, 2012

Post: Announcement of Percona XtraDB Cluster 5.5.23

…: Fixes merged from upstream (Codership-mysql) Support for MyISAM, now changes to MyISAM tables are replicated to other nodes Improvements to XtraBackup…. Links: We provide tar.gz and RPM binaries for RedHat (CentOS, Oracle Linux) 5 and 6, and Debian packages. Downloads: http…

Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release

… easy and affordable for everyone. You can convert your existing MySQL replication setup into a cluster in just a couple minutes. Tomorrow…. Related talks: Tutorial on PL MySQL Conference Galera Synchronous Multi-Master Replication for MySQL. My talk on PL MySQL Conference Percona XtraDB Cluster: New…. Links: We provide tar.gz and RPM binaries for RedHat (CentOS, Oracle Linux) 5 and 6, and Debian packages. Downloads: http…

Post: Testing Percona Replication Manager (prm) with Vagrant

… heard about Percona Replication Manager (PRM), a new high availability tool for MySQL. Percona Live DC 2012 Percona Live MySQL Conference & Expo 2012 PRM is an OCF Resource Agent for Corosync / Pacemaker that take cares of MySQL and manages the replication… https://github.com/lefred/percona-prm. You can use the CentOS 6 base box I used in the previous post (Testing…

Post: Percona XtraDB Cluster 5.5.20 - Beta release

…. Real “parallel replication”. Automatic node provisioning. Data consistency. No more unsyncronised slaves. Percona XtraDB Cluster is fully compatible with MySQL or Percona…. Links: We provide tar.gz and RPM binaries for RedHat (CentOS, Oracle Linux) 5 and 6, and Debian packages. Downloads: http…

Post: Percona welcomes Drizzle 7.1

… weeks. Major features include: Multi sourced replication XtraBackup included IPv6 data type ZeroMQ …Drizzle protocol plugin, authentication from a file, MySQL UNIX socket protocol, javascript plugin, authentication via… PPA are in the Drizzle manual. CentOS 6 packages are available from download….

Comment: Finding your MySQL High-Availability solution – Replication

…-20GB of mysql database, we need performance to increase 500%. currently we are using free mysql version thats comes under centos linux, we are had enough resource left, RAM, CPU in server. My question is: Does mysql enterprise edition helps us? How? What are the other options we can use? What is the difference between cluster and replication

Post: Percona Server 5.5.15 + Galera 21.1-beta2

…-server/percona-server-galera-5.5.15 binaries for RedHat/CentOS 6: http://www.percona.com/downloads/TESTING/Galera/Percona-XtraDB… new High Availability + Scalability solution for MySQL. And this solution is radically different from regular MySQL replication. You can actually think about N… ANY node. Setup of 3-master active MySQL Replication is practically impossible. 2. In contrast to MySQL replication, in Percona Server+Galera schema all…

Post: Announcement of Percona XtraDB Cluster (alpha release)

… Scalability solution for MySQL Users and based on Percona Server 5.5.17 Percona XtraDB Cluster provides: Synchronous replication. Transaction either commited…. Real “parallel replication”. Automatic node provisioning. Data consistency. No more unsyncronised slaves. Percona XtraDB Cluster is fully compatible with MySQL or Percona…. Links: We provide tar.gz and RPM binaries for RedHat (CentOS, Oracle Linux) 5 and 6, and Debian packages. Downloads: http…

Post: MySQL - to use or not to use

…as Semi-synchronous replication, advanced Monitoring and scaling features some users need other features than MySQL adding in newer MySQL releases. In …use CentOS, Fedora or Debian,Ubuntu. Most articles speaking about MySQL for Enterprises speaking about MySQL with full pack of services from MySQL

Post: How to know if you're updating Slave you should not ?

… anything else. By default MySQL will only write statements which come to the server directly (not via replication thread) so you will… executed directly on the host as well as coming through replication thread. There is however a way to know which is… ran on the slave directly we can do: [root@centos data]# mysqlbinlog mysql-bin.000002 | grep “server id 101″ | grep Query #100411…