开发者

Where exactly the table-data stored using MySQL-cluster gets stored?

开发者 https://www.devze.com 2023-02-07 11:33 出处:网络
I am a new-bee to MySQL cluster and wa开发者_StackOverflow中文版nted to know where exactly the data is stored in MySQL-cluster and where can i see it without directly. As we can see the separate files

I am a new-bee to MySQL cluster and wa开发者_StackOverflow中文版nted to know where exactly the data is stored in MySQL-cluster and where can i see it without directly. As we can see the separate files for each tables in MySQL 5.x databases. I have to verify for the same in Cluster formation. Please reply.


Well, MySQL-Cluster is just NDB (Network DataBase). Now, the NDB engine has a 2 main storage mechanisms.

  1. In memory. This has been available since NDB was introduced. Basically, it's just a series of memory tables that store the data. If all of your node sets go down, you lose all of your data. So you'll need to either replicate to a hard storage, or backup often and replay binary logs in the case of a server reboot.

  2. Since MySQL 5.1.6, NDB supports disk backed storage. That means that the working set is still kept in memory, but all writes are flushed to a disk buffer. So a restart just re-reads the disk. See MySQl Cluster Disk Data Types.

    Another useful read is this whitepaper (PDF) about recovery principles.

0

精彩评论

暂无评论...
验证码 换一张
取 消