Possible to avoid cost increase in move to GCP MySQL Second Generation?

I was using pay-per-use with MySQL first generation. It was a website with all I was using pay-per-use with MySQL first generation. It’s for a website with all pages cached in memcached and only evicted from cache when I update content. Writes to SQL can also occur if somebody register for newsletter or similar (happens ~10 times/month). I was getting away for free with the pay-per-use model, but that model is not available in the second generation.

As far as I can understand, there is no way to get below $ 7 per month now with the new model. Is that correctly understood?

Or is there an API where I can turn on/off the SQL instance when I receive a registration or update content? It feels strange to pay so much for a service I use for less than a second 10-100 times per month.

How to move from a filtered list to default view?

Suppose I am designing a web site to display a list of items. I’d like to add a category filter to display only the items of a given category.

Now I’m wondering how user should move back from the filtered list to the default list of items. Should I add just a “home” link or button ? Should I use “bread crumbs” with a “home” link ? What would you suggest ?

Move rows on 2 sheets older than 24 hours to archive

I have been trying to figure this one out for a while now and would really appreciate some assistance.

I have a Google Sheet that is being updated by a Google Form. Due to this I needed to mirror the data onto another tab to be able to format it. Unfortunately, this makes this auto-archiving process a bit more tricky.


The information comes in on the ‘request form’-tab, and then with a Query is shown on to the ‘Today’-tab. Both these sheets have red columns which will be hidden from the users with times to assist with the conditional formatting. What I would like to happen is that when a request is more than 24 hours old it copies to a new line on the ‘archive’-tab and then remove the line from both the ‘request form’ and ‘today’-tab.

I am not a programmer by any means and usually get snippets of code and manipulate them and put them together and that usually seems to work, but this one is beyond my copy+paste skills. 😉

The below code seems to work, but what needs to be added is the removal of the same line on the ‘Today’-tab.

function onOpen() { SpreadsheetApp.getUi()     .createMenu('EDITION')     .addItem('Archive', 'archiveRows')     .addToUi(); }  function archiveRows() { var ss = SpreadsheetApp.getActive(); var s = ss.getSheetByName("Request Form"); var target = ss.getSheetByName("Archive");      s.getRange("J:J").setNumberFormat('dd MM yyyy hh:mm:ss');  var today = new Date().getTime() var val = filterArray(s.getDataRange()     .getValues()); for (var len = val.length - 1, i = len; i >= 0; i--) {     if (val[i][9].getTime() < today) {         target.appendRow(val[i])         s.deleteRow(i + 2)         }     } }  function filterArray(array) { var filteredArray = []; array.forEach(function (r) {     if (r[8] !== '') {         filteredArray.push(r);     } }); return filteredArray; } 

Product edit page move tabs to sidebar

In the default layout for the admin product edit page we have an accordion style setup. This is really annoying as you have to scroll down several pages every time you want to edit an option that’s not part of the General tab. I would like to have a sidebar like on the customer edit page. Switching to “admin-2columns-left” doesn’t seem to do the trick. Is there any recommended way of achieving this?

Does Double Move allow you to cast spells or activate abilities that require swift or standard actions without changing weapon set up?

Can a character that, for example, holds a weapon in each hand, use its move action to sheathe one of them, cast a spell (a divine spell with the Quicken Spell metamagic feat which is a swift action) or activate an ability (Lay on Hands on himself which is another swift action) that’s shorter than a standard move with his now free hand, then turn his standard action into another move action and unsheathe the same weapon as before?

If that character also has a Bonus Attack higher than +1, would that mean that he would be able to move as well, during both of his move actions, at his normal speed each?

If that character also has Quick Draw, does that mean that he would be able to sheathe one of his weapons using his move action, cast a spell or activate an ability that requires a standard action instead, and unsheathe his weapon as a free action?

Move SharePoint items between Document Set libraries based on two columns

We have a Document Set library, which holds our invoices. The library is getting very large (~70 000 items, currently. 32 000 different invoices.). The search in this library is getting rather slow, and we’re looking at programmatically moving the document sets from one library to another.

We’ve got two fields that we want to base the move on: Invoice Date, and Invoice Status.

Invoice Date is a DateTime column which can be used through the Information Management Policy Settings in the library. We want to move the document sets on “Invoice Dates older than 13 months” or trigger the workflow/event on Invoice Date + 13 months

Invoice Status is a Choice column with a few defined options. We want to trigger the move when status is “Completed”.

We’d like the document to get put into either another document set library, or another folder that’s easily accessible if we need it to be, and only move invoices where the Invoice Date AND the Invoice Status meet our criteria.

The basic Information Management Policy Settings trigger only works with DateTime and you can’t make a custom policy with it. Also there’s no library connectable via the “Move to other location” option.

Any tips on how this can be accomplished? Some form of documentation would be highly appreciated. I’m somewhat comfortable with using C# or some other language if this has to be programmed directly.

How to move a Linux RAID which contains LVM, to a new computer?

I moved 4 disks (disks /dev/sd[abcd]) to another computer.
These disks contain a rather complicated RAID configuration:

# lsblk NAME                   MAJ:MIN RM   SIZE RO TYPE MOUNTPOINT sda                      8:0    0   2.7T  0 disk  ├─local-docker_tdata   253:1    0   5.5T  0 lvm   │ └─local-docker       253:2    0   5.5T  0 lvm   ├─local-raid0_rmeta_3  253:9    0     4M  0 lvm   │ └─local-raid0        253:11   0   3.3T  0 lvm   └─local-raid0_rimage_3 253:10   0 838.4G  0 lvm     └─local-raid0        253:11   0   3.3T  0 lvm   sdb                      8:16   0   2.7T  0 disk  ├─local-docker_tdata   253:1    0   5.5T  0 lvm   │ └─local-docker       253:2    0   5.5T  0 lvm   ├─local-raid0_rmeta_2  253:7    0     4M  0 lvm   │ └─local-raid0        253:11   0   3.3T  0 lvm   └─local-raid0_rimage_2 253:8    0 838.4G  0 lvm     └─local-raid0        253:11   0   3.3T  0 lvm   sdc                      8:32   0   2.7T  0 disk  ├─local-docker_tmeta   253:0    0    88M  0 lvm   │ └─local-docker       253:2    0   5.5T  0 lvm   ├─local-docker_tdata   253:1    0   5.5T  0 lvm   │ └─local-docker       253:2    0   5.5T  0 lvm   ├─local-raid0_rmeta_0  253:3    0     4M  0 lvm   │ └─local-raid0        253:11   0   3.3T  0 lvm   └─local-raid0_rimage_0 253:4    0 838.4G  0 lvm     └─local-raid0        253:11   0   3.3T  0 lvm   sdd                      8:48   0   2.7T  0 disk  ├─local-docker_tdata   253:1    0   5.5T  0 lvm   │ └─local-docker       253:2    0   5.5T  0 lvm   ├─local-raid0_rmeta_1  253:5    0     4M  0 lvm   │ └─local-raid0        253:11   0   3.3T  0 lvm   └─local-raid0_rimage_1 253:6    0 838.4G  0 lvm     └─local-raid0        253:11   0   3.3T  0 lvm   nvme0n1                259:0    0 238.5G  0 disk  ├─nvme0n1p1            259:1    0   200M  0 part /boot/efi ├─nvme0n1p2            259:2    0     1G  0 part /boot ├─nvme0n1p3            259:3    0    70G  0 part / └─nvme0n1p4            259:4    0 167.3G  0 part /home 

Alas, mdadm --examine --scan and sudo mdadm --detail --scan return nothing.

This means that I cannot rebuild the RAID configuration on the new machine with
sudo mdadm --detail --scan | sudo tee -a /etc/mdadm.conf.

Can you suggest how can I recreate that RAID on the new machine?


  • Machines use RedHat rhel 7.