Some times you will be getting replication errors on the slaves , this might be coming because of the following any one of the reason Might have killed a query in between in the master server Duplicate entry Version difference , due to this some of the queries may not work in slaves Any other reasons You can put [...]
we are running a classified site and the latest ads which are coming to the system is indexed in solr write server in every three minutes. Then this index is replicated to solr salve servers, Over a period of time the solr index file size increased to 40 GB . Now we have noticed that when [...]
i ma getting the following error in one of the server when i was doing the replication reading packet from server: log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master solved the problem after increasing the max allowd packet in the master
There will be one point of time when you really want to monitor your Solr servers. As you may be wondering that what is going inside the solr servers. Solr is an open-source search server based on the Lucene Java search library  which  is used by many sites to store data as well as handle [...]
The Tungsten Replicator provides open source database-neutral master/slave replication. Master/slave replication is a highly flexible technology that can solve a wide variety of problems including the following: Availability – Failing over to a slave database if your master database dies Performance Scaling – Spreading reads across many copies of data Data Protection – Preventing data [...]
Example InnoDB my.cnf file for high end GNU/Linux machines #—————————————————————- # # my.cnf file # # # See: # # http://dev.mysql.com/doc/refman/5.1/en/server-options.html # http://dev.mysql.com/doc/refman/5.1/en/option-files.html # # You can also dump all the variables set for mysqld with: # # mysqld –verbose –help # #—————————————————————- [client] # These options apply to all client applications # Port and [...]
This is an example config file for a 64bit 8GB GNU/Linux machine running mainly InnoDB. This config file will not work on a 32bit instance as it is configured to address more memory than 32bit procceses allow. This configuration assumes that this will be a replication master. If this is a slave and it doesn’t [...]
Bin log position is used to set the replication in MySQL. Â One of the easiest way to set the replication in Mysql in the following ways. First Take the entire Dump of MySQL with mysql command mysqldump -u root -p –all-databases –master-data=2 > dump_file21102010 The second head the 100 lines in the dump file to [...]
Slave lag is the typical problem that limits scalability of MySQL Replication. Learn best practices … for scalable, lag-free MySQL Replication
How to Install and Configure MMM? This article has been refereed from mysql-mmm.org Installation Guide –  Multi-Master Replication Manager for MySQL This installation guide describes a installation of MMM 2 (without the MMM tools) based on Debian Lenny (5.0) A basic installation contains at least 2 database servers and 1 monitoring server. In this guide, I used [...]
MMM (Multi-Master Replication Manager for MySQL) is a set of flexible scripts to perform monitoring/failover and management of MySQL master-master replication configurations (with only one node writable at any time). The toolset also has the ability to read balance standard master/slave configurations with any number of slaves, so you can use it to move virtual IP [...]
When a commit/optimize is done on master, ReplicationHandler reads the list of file names which are associated with each commit point. This relies on the ‘replicateAfter’ parameter in the configuration to decide when these file names are to be fetched and stored from Lucene.
The master is totally unaware of the slaves. The slave continuously keeps polling the master (depending on the ‘pollInterval’ parameter) to check the current index version the master. If the slave finds out that the master has a newer version of the index it initiates a  The steps are as follows, Slave issues a filelist [...]
The third alpha release for PostgreSQL version 9.1, 9.1alpha3, is now available. This alpha release contains several new major features added since the alpha2 release. Please download, install, and test it to give us early feedback on the features being developed for the future versions of PostgreSQL. Features added in 9.1alpha3 since alpha2 include: * [...]
The most anticipated PostgreSQL version in five years has been released. With built-in binary replication and over a dozen new major features, PostgreSQL 9.0 has compelling reasons to upgrade or migrate for every database user and developer. This release includes numerous documentation updates and 174 bugfixes, including: Avoid failure when trying to report an impending [...]