How to Convert Ordinary to Atomic

Clickhouse Howto Convert Ordinary to Atomic

New, official way

  • Implemented automatic conversion of database engine from Ordinary to Atomic (ClickHouse Server 22.8+). Create empty convert_ordinary_to_atomic file in flags directory and all Ordinary databases will be converted automatically on next server start. Resolves #39546. #39933 (Alexander Tokmakov)

  • There can be some problems if the default database is Ordinary and fails for some reason. You can add:

<clickhouse>
     <allow_reserved_database_name_tmp_convert>1</allow_reserved_database_name_tmp_convert>
</clickhouse>

More detailed info here

Last modified 2024.07.19: Update how-to-convert-ordinary-to-atomic.md (5407a77)