A master may be able to serve only so many slaves without affecting performance. Some organizations have deployed slave servers across multiple data centers. If each slave downloads the index from a remote data center, the resulting download may consume too much network bandwidth. To avoid performance degradation in cases like this, you can configure [...]
It is very surpricing to see that there are only few means very few details about the replication of solr server. So i desided to give a simple howtos on solr replication . Solr is an open source enterprise search server based on the Lucene Java search library, with XML/HTTP and JSON APIs, hit highlighting, [...]
Enhance your search with faceted navigation, result highlighting, fuzzy queries, ranked scoring, and more Deploy, embed, and integrate Solr with a host of programming languages Implement faceting in e-commerce and other sites to summarize and navigate the results of a text search Enhance your search by highlighting search results, offering spell-corrections, auto-suggest, finding “similar” records, [...]
Lately I’ve been able to do some Coherence work with some local customers and play with the Coherence Incubator projects. This entry will showcase one of the examples for Push Replication for sharing data among separate Coherence clusters. Inter-cluster Data Replication Coherence clustering technology makes a lot of sense for customers to be able to [...]
To view the master status in Mysql replication ,use the following command in the master Mysql server as shown below mysql> show master status ; +——————+———-+————–+——————+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +——————+———-+————–+——————+ | mysql-bin.000175 | 4757114 | | | +——————+———-+————–+——————+ 1 row in set (0.00 sec) mysql> show master status \G [...]
It  is very important to monitor the MySQL replication . The following command will shows the slave status in real time. Just login to slave MySQL console and type the following command mysql> show slave status \G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.16.1.115 Master_User: slave2 Master_Port: 3306 Connect_Retry: 60 Master_Log_File: [...]
There are two ways by which you can view your existing MySQL configurations . The first one is to view your my.cnf file. The second way is by login to mysql and type show variables mysql> show variables; +———————————+——————————————+ | Variable_name | Value | +———————————+——————————————+ | auto_increment_increment | 1 | | auto_increment_offset | 1 | [...]
The firewall has come to exemplify network security. While an overall security strategy requires a harmonious integration of people, process, and technologies to reduce risk, there’s no doubt that firewalls can be a very valuable security tool. Cisco Systems’ PIX firewalls have gained market leadership by demonstrating a mix of functionality, performance, and flexibility. The [...]
SQL Server 2008 provides the highest levels of security, reliability, and scalability for your business-critical applications. To take advantage of new opportunities in today’s fast-moving business world, companies need the ability to create and deploy data-driven solutions quickly. SQL Server 2008 reduces time and cost of management and development of applications. Access data from across [...]
Be sure your mysql servers are running the same version before starting this guide, yes, is possible to have a few combinations of master-slave versions, for more information about this you can check: http://dev.mysql.com/doc/refman/4.1/en/replication-compatibility.html 1 – Write down which is the setup you are going to do, which server is master and which server/s will be slave. [...]
Lucene is a Java-based search library. It was initially written over 10 years ago by Doug Cutting, who had worked on two search engines before that, including the once popular Excite Internet service. Lucene was one of the first 3rd generation search capabilities. Like Google and Microsoft’s recently acquired Fast, Lucene has an architecture that [...]
The most common problem with replication is primary key collision. Primary key collision involves two MySQL servers creating table rows containing different data, but the same primary key. When this happens replication stops. With replication stopped, the difference between the data on the servers grows. At some point the weirdness gets noticed. Then begins the painful [...]
Advanced MySQL Replication Techniques Having just two nodes could be what you need today, but as your application grows and you need to scale your database environment, you will need to add more nodes into the mix. It’s easy to extend this array to use four nodes Figure 2. Circular replication with four nodes In [...]
Advanced MySQL Replication Consider the situation where you set up a replication system with more than one master.One hard-to-solve problem in a multimaster replication is the conflict that can happen with self-generated keys. The AUTO_INCREMENT feature is quite convenient, but in a replication environment it will be disruptive. If node A and node B both [...]
Repadmin is used to view the replication information on domain controllers. You can determine the last successful replication of all directory partitions, identify inbound and outbound replication partners, identify the current bridgehead servers, view object metadata, and generally manage Active Directory replication topology. You can use Repadmin to force replication of an entire directory partition [...]