Case study from Control-Bit Technologies

New case study from Control-Bit Technologies!
Control-Bit Technologies is a software manufacturing company that has specialized in the field of computerized security systems since 1985.

Our software has been installed in banks, military bases, high-tech facilities, courts and other places, with many years of successful operation, close personal service and support.  Our products use the most advanced software tools, meeting the customers’ needs and adapting to various kinds of hardware can be achieved quickly and inexpensively.

SESAM is an excellent cost-effective site management software system, which enables easy integration of diverse systems into a simple and intuitive control and reporting command center. SESAM works in Client/Server mode over networks, the intranet, and Internet. SESAM is ideal for industrial complexes, campuses, hotels, shopping centers, correctional, municipal, and other facilities.SESAM is a vendor-independent system that can be easily integrated into previously installed equipment from different vendors. New hardware systems are easily installed with no need to redefine existing applications.

Database and Challanges

We are using Firebird SQL, which is stable, quick, and free (since version 1.5 in 2007, now using version 2.5.2).

Our applications use multiple databases, for various purposes: System configuration database, automatic event logging, photo archiving, and more.

Part of our solutions is to run multi-node hot backups, and remote worker nodes, which requires semi real-time database replication.

A hot backup solution includes a primary server that replicated its databases to the secondary standby server.

Big projects include multiple hot backups, and more that 20 remote worker nodes. The master active server replicates data to all nodes, over LANs and WANs. Some installations are based on slow radio networks, a fact that adds more challenges to achieving a well functioning product which is based on databases.

CopyCat Implementation

We replicate multiple databases to multiple nodes. Some databases are being modified less frequently (system configuration), while others are being updated every second (history logging). Each database has its own record size, update frequency, and network connection speed. We are running multiple processes: one process for each master database. Each replication process has a separate thread per replication node, since some nodes may be off-line, and the network speed to each node is different.

Technical details

  • 10 GB — the size of the history database, old records are automatically cleared
  • 2,000,000 records in history database (limit is only because older history is not required)
  • Approximately 50,000 new records per day (depends on customer application)

Customer Support

During the development and integration of CopyCat into our products, we need technical support. We are impressed by the quick and professional support, including remote session into our computer.

Leave a Reply