SQL Database Mirroring –Introduction to Operating Modes

In the last part of SQL database mirroring, you have learnt about database mirroring and why it’s called as SQL database mirroring. Now, let’s take a look at the operating modes of SQL database mirroring. SQL database mirroring can prove beneficial in terms of high availability and disaster recovery by setting it up to different operating modes. A DBA can choose among the three modes as below, depending on their requirements –

High-Performance Mode –

The high-performance mode operates asynchronously when the transaction safety is turned OFF. In this mode, only the principle server and mirror server come into picture where data is written and committed on the principle server. Later, the data is sent and committed to the mirror server. There’s no chance of automatic failure and also no usage of witness server –

read more

Posted in Web Hosting | Comments Off on SQL Database Mirroring –Introduction to Operating Modes

SQL Server Database Mirroring – A Perfect Solution for Disaster Recovery

disaster-planning-are-you-ready

Disaster recovery! Makes you restless, right? What if it turns into reality with your business? Made your blank. No this isn’t said to scare you. In fact, this article is going to offer you a perfect solution on it. So, first let’s start from the base that is database mirroring.

What is Database Mirroring?

Mirroring itself gives you an idea that it is related to database cloning or duplication. It is actually creating and maintaining redundant copies of a database. This is to confirm continuous data availability and avoid or minimize downtime that might be a result of fault in network operation when it is partially compromised or data corruption and loss. When there is redundancy, it is ensured that there is at least one viable copy of a database available and accessible during system upgrades.

read more

Posted in Web Hosting | Comments Off on SQL Server Database Mirroring – A Perfect Solution for Disaster Recovery

How to Migrate the Database from MS SQL to MySQL?

ms-sql-to-mysqlThere are several companies that prefer migrating their database from MS SQL to MySQL. It becomes essential for enterprises to migrate to MySQL when there are few MS SQL server database around. There might be some other reasons as below that can be considered for migrating from MS SQL to My SQL –

  • MySQL supports numerous operating systems including Solaris, Linux distros and Mac which the MS SQL doesn’t support.
  • MS SQL server requires huge license and support fees while MySQL is less expensive.
  • Implementation of highly scalable database infrastructure.
  • MySQL database comes with several advanced features that have been tested intensively over years by a huge open source community.

You can migrate data from MS SQL to MySQL, by using “MySQL Workbench” utility. Installing MySQL Workbenchbecomes easy with the installation of “Oracle MySQL installer for windows” that includes installation of several MySQL tools along with Workbench.

read more

Posted in Dedicated Website Hosting | Comments Off on How to Migrate the Database from MS SQL to MySQL?

Creating multiple instances with OpenVPN

In this tutorial we will see how to create multiple instances on dedicated server with OpenVPN!

Depending on where you are, it happens that some ports are blocked or filtered. Rather than having each time to redo your configuration to adapt to the new port, it is easier to create a specific configuration port.

It should be noted that since the recent version of OpenVPN, the application will default launch all configurations found in the file “/ etc / openvpn” that is to say, all the files in “.conf “.

read more

Posted in Dedicated Server Hosting | Tagged | Comments Off on Creating multiple instances with OpenVPN

A Guide to Magento and WordPress Integration

Magento-WordPress-Integration

If you are an e-store owner, you might be finding it difficult to publish an audience-attractive content. No wonder product definitions/descriptions are a must but it isn’t essential if that sort of content will attract any loyal visitor. With Google becoming more sophisticated and social media becoming a dominant source of referrals, it is essential for the retailers of e-stores to gear up with content publishing, if they want to retain existing buyers as well as drive in new customers.

Magento can be utilized as blogging platform with some available add-ons but if one integrates a platform specifically for content publication then there are several advantages of it. Turning WordPress into an ecommerce store is surely possible but with Magento the retailer gets flexibility and functionality which is quite tough to be acquired on a platform designed for content management. The right way is to integrate the WordPress blog in your Magento store instead of installing WordPress separately, as the data you want requires synchronization. But both ways will be explained here.

read more

Posted in Web Hosting | Comments Off on A Guide to Magento and WordPress Integration

How to control bandwidth in Linux?

easy-guide-to-bandwidth

Trickle and WonderShaper:

When we start working on a lot machines specifically Linux servers, it is interesting to know how we can control or limit the bandwidth. This can be useful in different contexts, for an instance, as part of a dedicated server or shared server infrastructure where we can control a download or app taking all traffic over other network users. It could very well put QoS or other technologies, but the tools that we are going to see in this post allow putting a limitation on the bandwidth which normally used pretty quickly and easily in Linux.

read more

Posted in Dedicated Server Hosting, FAQs | Tagged , , , , , | Comments Off on How to control bandwidth in Linux?

How Does R1Soft Backup Work?

The Internet is Internet and many things can happen so it’s good to have an off-site backup solution like R1Soft for data protection. bodHOST’s R1Soft system will enable you to restore files and folders to your account at barely a few clicks. The R1Soft console panel offered by us can help you to restore files, folders or even entire disk from Disk safe panel. Even, I would say R1Soft backup solution is the bee’s knees. Why I am saying this? Check the below steps and decide whether my claim is right or wrong!

read more

Posted in FAQs | Tagged , , , | Comments Off on How Does R1Soft Backup Work?

Linux Server Security Audit with LBSA

linux_servers First of all we will see what LBSA is: The security of Linux system often requires regular testing with various settings and configurations that are also often common to several systems. For an instance, you have large Linux server farm on which you want to change the default port for the SSH service, it may be useful to have a tool that allows to quickly check whether the configuration has been made. This is where LBSA (Linux Security Audit Basic Script) can be used.

read more

Posted in Dedicated Server Hosting | Tagged , , , , , | Comments Off on Linux Server Security Audit with LBSA

SquirrelMail Time out issue

If you are using Squirrel mail and often encounter a disconnection problem with SquirrelMail interface, then you need understand that SquirrelMail session gets disconnected after a certain period of time. This usually happens around 10-15 minutes after logged into the interface without clicking on any buttons or not performing any actions.

read more

Posted in FAQs | Tagged , , , | Comments Off on SquirrelMail Time out issue

Domain pointing to external MX on Plesk

If you are using external MX record and also using Linux environment for your Plesk server, then you need tweak settings in Plesk panel. To change the settings follow the below guidelines:

1 – You need to update the DNS for your domain name.
a) Change or Add MX record to establish external email server with significant priorities.
b) Remove the “CNAME” for mail.yourdomain.com if not to be used for configuration 
c) Or Edit “CNAME” for your domain that will point to external email server (generally provided by the email service provider).
d) Or Add “A” record for mail.yourdomain.com to point to external email server.

It will take some time to propagate the changes made in the DNS.

2 – Once the DNS is formed to use for external email server, it is essential
to de-activate the Mail service for the domain form the Plesk.

read more

Posted in Control Panels, FAQs | Tagged , , | Comments Off on Domain pointing to external MX on Plesk