I can get resource score with something like this: ptest -L -s -VV 2>&1 | grep "_color: resource.node" but for groups this seems to get me "0" even if a resource in a group has failed enough times to get the group move to another node. How can I get score for groups? Thanks! ...
Hello, I'm using MS SQL Server 2005. What's the best schema for a Wiki-like system? where users edit/revise a submission and the system keeps track of these submissions. Lets say we're doing a simple wiki-based system. Will keep track of each revision plus views and latest activity of each revision. In other screens, the system will l...
I am testing the fault tolerance of an ActiveMQ system configured as JDBC Master/Slave. In this setup there is one postgres database and two brokers--one is the master broker, the other is a slave broker. The way this mechanism works is the master takes out an exclusive lock on a table in the db. The slave tries to do this also and waits...
what is the best practice for database design for high traffic websites like this one stackoverflow? should one must use normalize database for record keeping or normalized technique or combination of both? is it sensible to design normalize database as main database for record keeping to reduce redundancy and at the same time maintain...
A single installation of our product stores it's configuration in a set of database tables. None of the installations 'know' about any other installation. It's always been common for customers to install multiple copies of our product in different datacentres, which are geographically far apart. This means that the configuration infor...
Hello *, I am constantly interested in reading interesting software development or design books. I think this post could be a great source to share opinions on books currently read by users. Especially I would be interested to know if the book is worth buying/reading and what is the summary in the user own words (pretty short mini-revie...
What design patterns or techniques have you used that are specifically geared toward scalability? Patterns such as the Flyweight pattern seem to me to be a specialized version of the Factory Pattern, to promote high scalability or when working within memory or storage constraints. What others have you used? (Denormalization of Datab...
quandry is - which of the following two method performs best Goal - get an object of type Wrapper ( defined below ) criteria - speed over storage no. of records - about 1000- about 2000, max about 6K Choices - Create Object on the fly or do a lookup from a dictionary Execution speed - called x times per second NB - i need to deliver t...
I have a bunch of SQL servers which I periodically performs maintainance on (Windows Update patches etc.). Now I want to the database online 24/7 and need to implement one of the high-availability solutions for SQL server. The solutions needs to be cheap and simple to use. I have no problems tweaking the connection strings for the clien...
Hi everyone, Does anyone know of any established best practices for running Windows services (in my case, developed in .NET) such that they will (automatically) fail over correctly to another server, for high availability purposes? The main ways I can see this being done are either starting up the secondary server when required (in whi...
Once a day I need to update an MySQL table with a new file downloaded from the Net using ftp and then mysqlimport. However, I want my website to keep running smoothly during the mysqlimport operation, which takes quite some time (it's a big table). What would be a good way to assure that users do not wait for the import to finish? I am...
Situation I have a windows service which I would like to make highly available. I have two unclustered servers (Windows server 2003 standard edition). The question is: What options do I have to make my service highly available in an automated way? I can think of the asymmetric master-slave option which consists of keeping the servic...
Hello, buddies! I'm currently studying WebLogic's integration capabilities, to develop a system that ensures high performance, availability and scalability; fail-over and crash recovery and 24/7 availability on a WebLogic integration scenario. I've been exploring some concepts and evaluating potential solutions to the problem I want to...
Hi. I'm hoping someone can help me a WAL-shipping and warm standby issue. My standby system runs happily for weeks, then all of a sudden it starts looking for .history files that don't exist. It then craps out and I can't successfully restart it without rebuilding the standby. Both systems are running CentOS 4.5 and postgres 8.4.1. The...
While this question is tagged EventMachine, generic BSD-socket solutions in any language are much appreciated too. Some background: I have an application listening on a TCP socket. It is started and shut down with a regular System V style init script. My problem is that it needs some time to start up before it is ready to service th...
I work for a Fortune 500 company that struggles with accurately measuring performance and availability for high availability applications (i.e., apps that are up 99.5% with 5 seconds page to page navigation). We factor in both scheduled and unscheduled downtime to determine this availability number. However, we recently added a CDN int...
My boss wants to have a system that takes into concern of continent wide catastrophic event. He wants to have two servers in US and two servers in Asia (1 login server and 1 worker server in each continent). In the event that earthquake breaks the connection between the two continents, both should work alone. When the connection is rev...
Let's say I have a standalone windows service running in a windows server machine. How to make sure it is highly available? 1). What are all the design level guidelines that you can propose? 2). How to make it highly available like primary/secondary, eg., the clustering solutions currently available in the market 3). How to deal with...
I know that with Network Load Balancing and Failover Clusteringwe can make passive services highly available. But what about active apps? Example: One of my apps retrieves some content from a external resource in a fixed interval. I have imagined the following scenarios: Run it in a single machine. Problem: if this instance falls, the...
My question is, should I be running one or both of the shrink command regularly, DBCC SHRINKDATABASE OR DBCC SHRINKFILE ============================= background Sql Server: Database is 200 gigs, logs are 150 gigs. running this command SELECT name ,size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS int) / 128.0 AS Availabl...