You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by GitBox <gi...@apache.org> on 2022/04/06 13:04:29 UTC
[GitHub] [cloudstack] synergiator opened a new issue, #6220: Parametrize data source table for virtual routetrs to support migration
synergiator opened a new issue, #6220:
URL: https://github.com/apache/cloudstack/issues/6220
In a enterprise migration scenario, you could face a situation to restart hundreds of routers which may cause issues with operation of enterprise service like plannable downtime window, even if you split restart by zones.
The script source routers list from the [table cloud.vm_instance](https://github.com/apache/cloudstack/blob/133b195688874ad63a947ae6b3fd369b671f2597/setup/bindir/cloud-sysvmadm.in#L82)
Possibly, there are many possible approaches how to establish partial batches if there are many routers.
For example:
* Source alternatively from an external text file instead of direct DB connection
* Parametrize table name allowing cloning subsets to temporary data tables in the DB
* Provide a short list of router ID/names to restart individually
Here are some code lines how we implemented a parameter for an alternate table name, and it worked for us.
```
table="vm_instance"
..
while getopts 'sarhnvd:m:u:p:t:T:l:z:' OPTION
T) table="$OPTARG"
;;
l) LOGFILE="$OPTARG"
..
stop_start_system() {
secondary=(`mysql -h $db --user=$user --password=$password --skip-column-names -U cloud -e "select id from $table ...
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] shwstppr commented on issue #6220: Parametrize data source table for virtual routetrs to support migration
Posted by GitBox <gi...@apache.org>.
shwstppr commented on issue #6220:
URL: https://github.com/apache/cloudstack/issues/6220#issuecomment-1199212912
@synergiator can you please check the PR https://github.com/apache/cloudstack/pull/6574 and if possible test the script
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] DaanHoogland closed issue #6220: Parametrize data source table for virtual routetrs to support migration
Posted by GitBox <gi...@apache.org>.
DaanHoogland closed issue #6220: Parametrize data source table for virtual routetrs to support migration
URL: https://github.com/apache/cloudstack/issues/6220
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org