…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: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
… the Percona Software Repositories). Based on MySQL 5.1.66, including all the… (Alexey Kopytov). Fixed the package dependencies for CentOS 6, that caused conflicts during the install…#917942 (Mark Callaghan, Laurynas Biveinis). Crash-resistant replication would break with binlog XA transaction …
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 16 Comments
…: 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…
Comment: Why MySQL's binlog-do-db option is dangerous
July 24, 2012 By 15 Comments
… login using ‘mysql -u -p’ and then issue a create database percona; Then the percona database is not replicated to the slave… use binlog_do_db=percona. In this case it is replicated to the client. But this is in contrast to the… rules match, it should replicate but it doesn’t. This is happening with mysql-server 5.1.61 on centos 6.2. What…
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
… 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….
Post: How to know if you're updating Slave you should not ?
April 11, 2010 By 8 Comments
… 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…
Comment: Finding your MySQL High-Availability solution – Replication
April 11, 2012 By 6 Comments
…-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: Small things are better
October 8, 2006 By 15 Comments
… box with RAID volume, ECC memory and reliable CentOS 4.4 distribution but still it did. We … but still they can get corrupted because of MySQL bugs, OS Bugs or hardware bugs, misconfiguration or … have. You can of course use MASTER-MASTER replication and run statement on one server, switch role …
