Shulou(Shulou.com)05/31 Report--

This article mainly introduces "what is the reason why database migration is so complicated". In daily operation, I believe many people have doubts about what is the reason why database migration is so complicated. Xiaobian consulted all kinds of materials and sorted out simple and easy to use operation methods. I hope to help you answer the doubts of "what is the reason why database migration is so complicated"! Next, please follow the small series to learn together!

Four common mistakes that organizations need to know about database migration and how to avoid them:

1. Don't know what's moving or how much data is moving

Migrating a database is about moving data and everything attached to it. In order to make processes smoother, businesses should know what they are doing.

"It's a classic question in tech stores," Hall said. We do a poor job of documenting existing assets. "Documentation issues include not only data, but also performance footprints, architecture, and all components and ancillary processes surrounding the system.

Hall said companies should audit their software before migrating. This helps with the migration and determines the right size cloud platform to migrate to. This also requires a shift in thinking, as organizations tend to buy more computers than they need.

"We need to change the way we think, understand what our workload uses on average, and increase resilience," Hall said. "This includes understanding any seasonality of the workload as compute volumes grow or contract.

Colin Dawes, chief solutions architect at managed cloud computing provider Syntax, said that in this advance planning, organizations should also be able to identify which vendors do not have cloud-friendly licensing models. You need to know if you want to run in a cloud platform or if there is a penalty for not running in a particular cloud. "

2. Not going the right way.

Just as businesses need the right cloud migration, data needs to migrate the right way.

For example, moving a multi-terabyte database by trying to suck it through a very fine pipette would take a long time. An enterprise may have to adjust the migration approach based on data size. "

This may include partial movement, copying the database to an external device and then moving it again, or using a vendor or public cloud you can copy parts of the database. Moving in these ways also means mapping out how data is synchronized, as well as new pieces that might be missed during migration, and reconciling those differences.

3. not tested

Dawes said testing is more challenging than many organizations think because of how many apps organizations typically use. In order for an enterprise to be tested, applications must also be tested.

If the organization has only one license, it can ask the vendor for an additional temporary license, although Dawes cautions that the vendor may charge it for a year.

Dawes said the tests also need to address safety issues. For example, if payroll is migrating, it needs to be able to connect to the organization's bank. Testing also needs to be done at banks, which could mean requiring banks to provide test areas around them.

4. No backup plan

In an ideal environment, day-to-day operations would not be affected and employees would not feel anything wrong after the move.

"The only thing they're going to notice is progress," Hall said. But it is important to let them know what is happening. Companies don't have to give them all the details so they know something in case something gets a little weird. "

Dawes says companies should have rollback plans in place just in case something goes wrong. It also means working with vendors to develop remediation plans and having those vendors track their processes during and after the migration to make sure they are all working properly.

Dawes added that after 24 to 48 hours, rollback will be a challenge, which is why planning and testing are so important. Ensuring that both are fully completed is more likely to mean a successful migration, or if problems do arise, they can be quickly identified and resolved.

This concludes the study of why database migration is so complex, hoping to resolve your doubts. Theory and practice can better match to help you learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.