mysql 数据库不存档_MySQL存档引擎-数据保留

mysql 数据库不存档

I have spent the majority of my technology years in and around financial services dealing with issues of data security, retention, archiving and reporting. Though the finance sector is considered heavily regulated, so are other industries, such as health care and government.

我在技术领域的大部分时间都用于金融服务以及有关数据安全，保留，归档和报告的问题。 尽管金融部门受到严格监管，但其他行业也是如此，例如医疗保健和政府部门。

Commercial database solutions have had a leg up on MySQL for some time in this area – however – MySQL is now joining the fray with tools to help anyone responsible for dealing with the sticky issues of data management.

商业数据库解决方案在这方面已经在MySQL上占据一席之地-但是– MySQL现在正与各种工具一起帮助那些负责处理数据管理中棘手问题的人。

The archive engine is as relevant for smaller web solutions as it is for the enterprise as it simplifies the DBA work involved in offloading data into an environment that limits interaction with data without sacrificing reporting capabilities.

存档引擎与小型Web解决方案一样适用于企业，因为它简化了DBA的工作，该工作涉及将数据卸载到限制与数据交互而又不牺牲报告功能的环境中。

Probably the single biggest difference from the existing compression features in MySQL is that one no longer needs to take a db offline to carryout exercises on data. Additionally, one can continue to insert data into archives, which is not feasible in existing MyISAM compressions.

与现有MySQL压缩功能最大的不同可能是不再需要使db脱机以进行数据练习。 此外，可以继续将数据插入存档，这在现有的MyISAM压缩中不可行。

翻译自: https://www.sitepoint.com/mysql-archive-engine-data-retention/

mysql 数据库不存档