Community Blog How to Migrate Your Database to a Virtual Server

How to Migrate Your Database to a Virtual Server

SSD virtual servers is quick and cost-effective, in this article you will get some information on how to migrate your database to a SSD virtual server.

Moving database hosting to a cloud-based environment makes a lot of sense. Database servers benefit from powerful servers, SSD drives and a large amount of RAM, and this can be provisioned quickly and cost-effectively on a platform such as Alibaba Cloud. Equally, if your routine performance monitoring suggests that more or less RAM is needed, this can be adjusted easily with no downtime. Plus, if databases (and particularly transaction log files) grow to the point where disk space becomes an issue, adding additional capacity is simple.

ApsaraDB instances are fast, cost-effective, easy to back up via snapshot or clone, and very quick to scale when you need additional performance. They all run on SSD drives and you simply pay according to the amount of data you process. If you need more performance or storage, it can be arranged with just a few clicks on the management console.

Now just $2.50 a month makes you benefit from all advantages of SSD virtual servers from Alibaba Cloud, which not only offer you SSD cloud server but also including a data transfer plan that you must need. Come and Get the Offer!

With an ApsaraDB instance, there's no underlying operating system or virtual server for you to pay for, secure, patch or manage. You get to concentrate on managing just your database tables. Everything else is taken care of by Alibaba Cloud.

For this tutorial, we will be creating an Elastic Compute Service (ECS) virtual server. You will need to have created a Virtual Private Cloud (VPC) and an accompanying Virtual Switch (vSwitch) beforehand. If you have already created one or more server instances then you probably already have a VPC, in which case you can use it.

Creating a Virtual Server

  1. Alibaba Cloud console ---> Products ---> Elastic Compute Service ---> Buy Now/Create Instance. Then you can create your virtual server instance by choosing a billing method.
  2. Choose a hosting region. If you already have a Virtual Private Cloud set up that you intend to use, choose the region where that VPC is located, otherwise, you won’t be able to assign the new server to that VPC.
  3. Choose an instance type.
  4. Choose an image for the server. Or you can click on Marketplace Image and choose from a range of ready-made server images provided by Alibaba Cloud.
  5. Locate it in the list of images and click on Continue.
  6. Click on the button at the bottom of the screen to configure networking. Follow the instruction on the screen to assign your new database server to a VPC and associated virtual switch.
  7. Check and configure the security group.
  8. Preview a summary of your choices. Choose whether your monthly subscription should auto-renew (by default it will not).
  9. Tick the box to agree to the terms and conditions and then click on Create Order.
  10. If everything is to your satisfaction, click the Pay button.
  11. Console ---> Elastic Compute Service, click on Instances on the left-hand side of the screen, and you should see your server listed. After a few moments, the status will change from Starting to Running (press the Refresh button until this is the case).

Connecting to the Server

  1. On the right-hand side of the panel that shows your server's details, click on the More link.
  2. Password / Key Pair ---> Reset Password, then restart the server for the new password to take effect in the More menu. Wait until the status changes from Stopping to Running again.
  3. Click on the Connect link. Make a careful note of the VNC connection password that is displayed as you’ll only see it once.
  4. Click the Close button, then enter the VNC password.
  5. Click OK, login with a username of root, and the password you set earlier.

Now you are connecting to the server, if you want to log into MySQL via the command line to set some initial options and create one or more users, you can go to Migrating a MySQL Server to Alibaba Cloud. For how to migrate database from a backup file of one or more databases with the mysqldump command, you can go to Use mysqldump to migrate MySQL data.

Related Posts

How to Set up a Website with Alibaba Cloud Web Hosting and Domains

When you create a website, you are creating or acquiring HTML document files, web pages, databases, programs scripts, images and so on, and storing them on a server in the cloud. For complete control, you can create your very own server using Alibaba Cloud. It is not a physical metal box, but what's known as a Virtual Server. This means that you share a physical metal box with a number of other customers, but your virtual server behaves as if it is your own. You can do whatever you like on it. You can host websites and email. You can run WordPress. You can install your own software, and much more besides. And you can tweak every last setting on the websites you host, because the web server belongs to you alone and so your changes won't affect anyone else.

A virtual server like this gives you ultimate control, but you also need technical skills to keep it running securely and effectively. You will need to install security patches regularly, and fix it if things go wrong.

On the other hand, maybe you don't need a complete server, virtual or otherwise. Perhaps all you need is a folder on an existing web server in which you can safely and securely upload some files and images etc. to create a website. You don't need to install an accompanying email server, or to be able to change and tweak every last setting. And you certainly don't have the time or skills to keep a server running in tip-top condition – you're more than happy to leave that to someone else within Alibaba Cloud.

This document will show you how to use Alibaba Cloud Web Hosting in order to set up a new website, complete with a domain name.

Alibaba's SSD Platform Sets a New Standard for Storage

Alibaba Group launched its Open Channel Ecosystem at the Flash Memory Summit 2019; a strong statement of intent for the global storage industry. The company is collaborating with global vendors on an Open Channel SSD (Solid State Drive) solution for the platform. Partners including Intel, Micron, Skhynix, Shannon Systems, and CNEXLabs will roll out Open-Channel SSD products on the platform on a later phase.

With the optimum ecosystem now in place, Alibaba will collaborate with vendors and industry players to foster the deployment of SSD products, increasing their efficiency, improving supply elasticity, and meeting the ultimate goal of developing the most advanced storage technology for the AI and cloud era.

Related Documentation

Ephemeral SSDs

Ephemeral SSD disks use the local storage of physical machines at which the instances are located. This type of storage provides block-level data access capabilities to instances. It has low latency, high random IOPS, and high throughput I/O capability.

Get started with Web Hosting

Web Hosting is equipped with built-in OS, databases, FTP sites and other services, which enable you to readily build a website. This article helps you familiar with the preparations and process on building a website.

Related Products

Web Hosting Solution

Alibaba Cloud provides web hosting solutions suitable for businesses of all sizes. We help you reduce development, maintenance, and IT costs while guaranteeing the security and stability of your site.

Web Hosting Migration

Web hosting migration is one of the most common scenarios in cloud migration. The migration can be done partially for a hybrid cloud solution, or performed completely for a fully cloud-hosted website or web application. Alibaba Cloud helps you speed up this process and minimize errors with our various migration tools.

0 0 0
Share on

Alibaba Clouder

2,600 posts | 751 followers

You may also like


Alibaba Clouder

2,600 posts | 751 followers

Related Products