Signup Login
Try it for FREE!

Database Management

Lastest articles from database-management

Linux Series 2: DNS Zones and BIND9 configuration settings.

dedicated linux server hostingIn our last tutorial we covered the basics of how to install and configure a LAMP stack running Linux, Apache HTTP server, MySQL, and PHP. Now what is the next step? In this next tutorial we  will be learning how to set up and configure a DNS server. A DNS server is how we are going to  manage internal domain names at home or in the office. For this tutorial we will be using the BIND9 service. First a little bit about how DNS Works, DNS stands for Domain Name Servers, this is a service running on the server which tells that www.google.com is located at IP address 74.125.239.18 (amongst a million others) if the DNS service cannot find address 74.125.239.18 on its DNS table it will begin querying other DNS services with a higher authority until it finds which DNS table holds the domain information for address 74.125.239.18. When it finds this information that is then passed to the users browser however in the event no internet connected DNS server is found with domain information for this address it will display a message in the users browser such as “Server not found”

When it comes to DNS configuration settings they can be very tricky. They can also be very difficult at times and we can go into depth about some more of the functions later so we want to create a private internal domain name “mydomain.com” so lets find out what our internal IP address is. Open your terminal and type ifconfig this will display a listing of all of our network connections. Now let’s assume our internal network address is 10.0.2.x (which is what mine is at the moment) and our router and gateway is 10.0.2.2 lets suppose all the devices on our network are going to be configured using static IP addresses (normally IP addresses are assigned automatically by DHCP but for the purpose of this tutorial we will have three static IP devices connected to our gateway.
Read the full post

Category: Applications Monitoring, Database Management, Database Monitoring, Linux Servers Monitoring, Mail Server Monitoring, MySQL monitoring, Network Monitoring, Server Management, Sysadmin Tools, Web Server Monitoring

Introduction to SQL Azure

 

In our previous articles, Introduction to SQL Server 2012 and Windows Azure Overview, we made references to Microsoft’s SQL Azure service. In this article we will take a closer look at its main features in more detail.

SQL Azure is a relational database solution with the capability to support both Windows Azure and on-premise applications with minimum latency. It is considered a managed service and it’s offered by Microsoft to allow you to build applications without concerning yourself about the storage they’ll use. Being a cloud service, SQL Azure gives you all the benefits of the cloud including:

-          The hardware and software that support the SQL database are all managed by Microsoft

-          Patching and maintenance are also managed by Microsoft

-          High availability and fault tolerance are guaranteed by an SLA (Service-level agreement)

-          Per usage billing and the availability to scale up or down whenever you have the need

All these features contribute to SQL Azure’s eased management. The service-level agreement is backed up by powerful and extremely secure datacenters offering you maximum protection of your databases. SQL Azure is built entirely on top of SQL Server and offers most of SQL Server’s features, such as the Tabular Data Streams (TDSs) for connecting, databases with tables, views, stored procedures, indexes, etc. They are all managed using the standard T-SQL language. SQL Azure allows you to store up to 150 GB of information in your database. If you need more storage for a database, you will have to spread it out over multiple databases and use parallel queries
Read the full post

Category: cloud computing, Database Management, Database Monitoring, MS SQL Server Monitoring

Introduction to SQL Server 2012

In our previous article, SQL Server 2008 Overview, we looked over the different features that the Microsoft SQL Server provides. In this article we will focus on the new and advanced features of the latest SQL Server release – SQL Server 2012. They include, but are not limited to, the new High Availability solution AlwaysOn, improved security, and the capability of syncing with the cloud.

AlwaysOn consists of two main components – AlwaysOn Availability Groups and AlwaysOn Failover Cluster Instances. Let’s first focus on the Availability Groups. An availability group is a combination of databases that are hosted on a primary server and up to four secondary servers. Each availability group member is capable of replying to clients’ requests in the event that the primary group member is unavailable. All the databases in an availability group fail over to another group member together. This functionality is built on top of the Windows Server Failover Clustering feature and requires its installation.
Read the full post

Category: Articles, Database Management, Database Monitoring, MS SQL Server Monitoring

MS SQL Server 2008 Overview

MS SQL Server is Microsoft’s product for delivering database functionality. It is used for storing and retrieving information from different applications. It is considered a relational database server and uses T-SQL and ANSI SQL for querying languages. In this article we will focus on the 2008 edition. This is available in 6 different editions as follows:

- Express – intended to be used as a stand-alone solution for lightweight applications; it supports just 1GB of memory, one CPU, and a maximum database size of 4GB (extended to 10 GB in SQL Server 2008 R2)
Read the full post

Category: Database Management, Database Monitoring, MS SQL Server Monitoring, Server Management

Monitoring HBase

HBase is a distributed, NoSQL, open-source database, initially conceived as an open-source alternative to Google’s proprietary BigTable. Originally, HBase was part of the Hadoop project, but was eventually spun off as a subproject. Given this legacy, it is not surprising that most often HBase is deployed on top of a Hadoop cluster (it used HDFS as its underlying storage), however a case study suggests that it can run on top of Amazon Elastic Block Store (EBS) as well. These days HBase is used by companies such as Adobe, Facebook, Twitter and Yahoo – and many others to process large amounts of data in real time, since it is ideally placed to store the input and/or the output of MapReduce jobs.

Monitoring HBase with Monitis and JMX

Like most products written in Java, both HBase and Hadoop contain built-in JMX instrumentation, which theoretically allows us to use any JMX client to view their performance metrics. Naturally, Monitis has just what the doctor ordered – a generic JMX agent that can be configured to monitor any JMX-enabled process through a point-and-click web interface.
Read the full post

Category: Database Management, Database Monitoring, Java Monitoring, NoSQL Monitoring, Performance Management

Trusted by:

trusted by trusted by trusted by trusted by trusted by trusted by trusted by trusted by trusted by trusted by
About Monitis

Monitis GFI is a specialist provider of web and Cloud monitoring services that include website monitoring, site load testing, transaction monitoring, application and database monitoring, Cloud resource monitoring, and server and internal network monitoring within one easy-to-use dashboard. Over 100,000 users worldwide have chosen Monitis as their provider of choice to increase uptime and user experience of their services and products. What makes Monitis' solutions different is that they are fast to deploy, feature-rich in technology and provide a comprehensive single-pane view of on-premise and off-premise infrastructure and applications.

Follow Monitis on Facebook
Follow Monitis on Twitter