Running starrocks 3.5 shared data in AKS with blob...
# questions-and-troubleshootingj
JD Baudean
10/01/2025, 2:25 PMRunning starrocks 3.5 shared data in AKS with blob storage, how do you move your data to a new blob storage account? I've updated everything in my helm values and redeployed. The UI shows the new blob store, but the data is still being written to the old blob store. When I go into mysql and run
DESC STORAGE VOLUME builtin_storage_volumeJD Baudean
10/01/2025, 4:30 PMSo it appears that there isn't a way to alter the location of the storage volume? What is the point of doing an
azcopyJD Baudean
10/01/2025, 5:23 PMOk, well this seems to have worked
Copy code
ALTER STORAGE VOLUME builtin_storage_volume
SET (
"azure.adls2.endpoint" = "https://<new-premium-account>.<http://dfs.core.windows.net|dfs.core.windows.net>",
"azure.adls2.shared_key" = "<new-premium-key>"
);r
Robert Raharjo
10/01/2025, 6:25 PMIn this case, does creating and dropping storage volume not work?
j
JD Baudean
10/03/2025, 4:24 PMYou can't drop the volume if it's in use, but yea that would be nice. I'm not convinced altering the endpoint actually worked. Everything I'm reading says that it will appear to work at first but it's just pulling from cache, and loading new data could cause problems.
Has anyone actually moved their blob storage to a new account and changed the volume to point to the new storage endpoint, without having to make new tables and copy all the data anyways?
r
Robert Raharjo
10/03/2025, 6:57 PMPlease disregard my other message. Currently StarRocks does not support moving blob storage to another account.
j
JD Baudean
10/06/2025, 4:46 PMOk thank you. What about creating a new blob storage account and then a new storage volume in starrocks pointing to that storage account, setting that as the default, then creating a new database and tables, then manually copying via INSERTs into the new DB/tables from the old DB/tables? We're currently using a standard Azure storage account and the transaction costs and limits are killing us, so we really need to move to premium.
JD Baudean
10/06/2025, 4:49 PMIt seems like there's support for multiple storage volumes? https://docs.starrocks.io/docs/3.5/category/storage-volume/. Although it's not clear what happens if you move all of your data and set the new volume as default, then delete your old volume and storage account.
JD Baudean
10/06/2025, 5:30 PMHmm.... It looks like the
_statistics__statistics__statistics_JD Baudean
10/06/2025, 7:20 PM@Robert Raharjo What are our options if we need to move from a Standard Storage Account to a Premium account? Is there any way to do this with our current Starrocks Cluster or do we need to build a new Starrocks Cluster using the premium storage? I've combed through the docs as much as I can and can't get a straight answer there, if you have any of this documented that would be really helpful.
r
Robert Raharjo
10/06/2025, 8:17 PMYes, the easiest way is to manually create a new storage volume on your new blob account, create the db and table (use CREATE TABLE LIKE for the fastest way) and manually copying the data using INSERT statements. For the database name issue you can use ALTER DATABASE RENAME on the old one.
j
JD Baudean
10/06/2025, 8:47 PMThank you. So I can do that with the
_statistics_builtin_storage_volumepremium_storage_volumer
Robert Raharjo
10/06/2025, 9:42 PMYou cannot drop the
builtin_storage_volumepremium_storage_volumebuiltin_storage_volumeđź‘Ť 1
j
JD Baudean
10/07/2025, 6:11 PMI did this in our test cluster this morning and so far so good! Hopefully nothing unforeseen crops up in our prod cluster. Thanks for the help!