Hi Vladimir, It won’t cause any damage – but if you are concerned just do a mysqldump beforehand.
One thing though – have you already added the new zone and secondary storage pool? If store ID 41 is your new secondary pool then the second entry in your template_store_ref shows the template already downloaded? Regards, Dag Sonstebo Cloud Architect ShapeBlue On 02/04/2018, 17:05, "Vladimir Melnik" <v.mel...@uplink.ua> wrote: Thank you, Dag! Wouldn't it damage the existing records? I have the following one in the `vm_template` table: *************************** 1. row *************************** id: 3 unique_name: routing-3 name: SystemVM Template (KVM) uuid: b51f9ef8-bd2f-11e6-b74f-06973a00088a public: 0 featured: 0 type: SYSTEM hvm: 0 bits: 64 url: http://cloudstack.apt-get.eu/systemvm/4.6/systemvm64template-4.6.0-kvm.qcow2.bz2 format: QCOW2 created: 2016-12-08 12:18:48 removed: NULL account_id: 1 checksum: c059b0d051e0cd6fbe9d5d4fc40c7e5d display_text: SystemVM Template (KVM) enable_password: 0 enable_sshkey: 0 guest_os_id: 15 bootable: 1 prepopulate: 0 cross_zones: 1 extractable: 0 hypervisor_type: KVM source_template_id: NULL template_tag: NULL sort_key: 0 size: 322954240 state: Active update_count: 0 updated: NULL dynamically_scalable: 0 And also there are 2 ones in the `template_store_ref` table: *************************** 1. row *************************** id: 41 store_id: 1 template_id: 3 created: 2016-12-08 11:45:54 last_updated: 2018-04-01 19:25:34 job_id: NULL download_pct: 100 size: 322954240 store_role: Image physical_size: 322954240 download_state: DOWNLOADED error_str: NULL local_path: NULL install_path: template/tmpl/1/3/612564dc-8119-4c58-ae4c-df965ee99447.qcow2 url: http://cloudstack.apt-get.eu/systemvm/4.6/systemvm64template-4.6.0-kvm.qcow2.bz2 state: Ready destroyed: 0 is_copy: 0 update_count: 0 ref_cnt: 0 updated: NULL download_url_created: 1970-01-01 00:00:00 download_url: NULL *************************** 2. row *************************** id: 4151 store_id: 41 template_id: 3 created: 2018-04-02 14:43:49 last_updated: 2018-04-02 14:43:49 job_id: NULL download_pct: 100 size: 0 store_role: Image physical_size: 0 download_state: DOWNLOADED error_str: NULL local_path: NULL install_path: template/tmpl/1/3/ url: http://cloudstack.apt-get.eu/systemvm/4.6/systemvm64template-4.6.0-kvm.qcow2.bz2 state: Ready destroyed: 0 is_copy: 0 update_count: 0 ref_cnt: 0 updated: NULL download_url_created: NULL download_url: NULL Maybe it's stupid, but I'm afraid that the script will make changes to the record #41 instead of updating the record #4151. How will it know that we need to install the template to the store #41 (a new secondary storage of a new zone)? Best regards, Vlad On Mon, Apr 02, 2018 at 03:42:38PM +0000, Dag Sonstebo wrote: > Vladimir, > > Secondary storage is always zone wide, and if you have multiple zones then you also select which zone to add the new secondary storage pool to. > So as long as you prepopulate the template as per documentation you will be fine. > > Regards, > Dag Sonstebo > Cloud Architect > ShapeBlue > > On 02/04/2018, 16:37, "Vladimir Melnik" <v.mel...@uplink.ua> wrote: > > Hello, > > It might be a bit stupid question, but I'd like to ask for some help :) > > How to add a new SystemVM template to a new zone? The documentation (http://docs.cloudstack.apache.org/projects/cloudstack-installation/en/4.9/management-server/_systemvm.html) is quite clear, but I can't see how will ACS understand that the template is being added to a new zone. Should I indicate the zone's ID somehow? How to do that? > > Thanks in advance! > > -- > V.Melnik > > > > dag.sonst...@shapeblue.com > www.shapeblue.com > 53 Chandos Place, Covent Garden, London WC2N 4HSUK > @shapeblue > > > -- V.Melnik dag.sonst...@shapeblue.com www.shapeblue.com 53 Chandos Place, Covent Garden, London WC2N 4HSUK @shapeblue