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.

Will SIM‐like PIN on website as second password increase security

On SIM cards, which are used in mobile telephony, PIN (and PUK) is used. Unlike a password, they are locked after some incorrect attempts to prevent brute force attack. If wrong PIN is entered 3 times, user must enter PUK. When wrong PUK is entered 10 times, SIM card is permanently disabled.

On the website, if wrong PUK is entered 10 times, user must contact customer support to unlock their account. To prevent abuse, user must enter their password first.

Will adding PIN/PUK as second password increase security? Should it be added?

Can’t seem to install on second SSD, using EFI

/dev/sda is the SSD with Windows 10 on it. It has an EFI partition already. It is the only OS on that drive.

Trying to install 18.10 on /dev/sdc

I boot from a live USB stick (which I boot in EFI mode), choose ‘something else’, create 3 partitions on /dev/sdc: swap, EFI (500MB), and the remainder on /

I choose /dev/sdc as the device to install the boot manager (I’ve also tried /dev/sda, but same results).

CSM off. Secure boot off. All legacy stuff off.

Install always seems to work, but the grub install doesn’t do the right thing. Hitting F12 during boot up, I can see my Windows Boot Manager (which gets me into windows) and ‘ubuntu’. Selecting that just gets me a raw grub prompt. That Ubuntu boot manager also seems to be installed on /dev/sda (in the EFI partition, alongside the Windows dir). And I get stuck. Every time.

I’ve been at this for a couple of days now, and have gone through more google pages than I care to admit trying to get it to work. I use efibootmgr to remove the broken ‘ubuntu’ boot manager between attempts.

I just want to be able to power on the machine, have a grub screen come up where I can select Windows (on /dev/sda) or Ubuntu (on /dev/sdc), and just have it work.

What am I missing? D:

Thanks in advance!

ffmpeg – Watermark every x second fade in/out and adjust for video resolution

I am using the current ffmpeg command to convert multiple videos and create a watermark that is a scrolling text that goes from right to left to right every 120 seconds of play time.

find /home/video/ -type f -execdir ffmpeg -i '{}' -filter:v "drawtext=fontfile=/root/FreeSans.ttf:text='QWERTY':fontcolor=white@1.0:fontsize=26:y=h-line_h-30:x=w/20*mod(t\,120),scale=854:480" -pix_fmt yuv420p -c:v libx264 -preset slow -b:v 1000k -minrate 500k -maxrate 2000k -bufsize 2000k -c:a aac -ar 44100 -b:a 128k -movflags +faststart '/home/video/new/{}.mp4' \; 

I would like to modify the watermark so it looks something like this

enter image description here

I would like the text shown above to fade in every 120 seconds and last for 15 seconds. Be bold format and the same colour (black).

“qwerty qwerty qwerty qwerty” new line
“qwerty qwerty qwerty qwerty”

Another issue I currently have with the current command I am using is with different video frames. For example if the video is only 800×600 the text will be very large. If the video is 1920×1080 the text will be extremely small. I would like the text size to be adjusted depending on the frame rate. It should look like above in terms of screen size.

Windows 10: The second press never accepted on laptop

Last night I have a notification on my laptop. This was about allow a setting.I clicked right buttom.After then if I click a buttom twice the second one is not accepted. If press pp the computer will take only p.If I press after a second then it take second one.All buttom of keybord behave same.How to solve this?.My operating system is windows 10

Create second button and reload form page

I have a form with Entity Registration module. I have to add another button in order to save and add another account to registration. For this i created a second module and i try to overide the first module. I created a hook :

function mymodule_form_alter(&$  form, $  form_state, $  form_id)  {       // add second button     if($  form_id=='registration_form'){         $  form['actions']['save_reload'] = array(             '#type' => 'submit',             '#value' => t('Save and add'),             '#weight' => 0,         );         $  form['actions']['#save_reload'][] = 'mymodule_node_form_submit';     } } function mymodule_node_form_submit ($  form, &$  form_state) {     drupal_set_message('Test Submit');     $  form_state['redirect'] === FALSE; } 

Unfortunatelly it doesn’t reload after the form is sent.

My second segment IP can not access its gateway

I have a VLAN which have 43.24.227.38/29 and 192.168.33.238/29 in it, I configured IP on one interface, you see bellow:

source /etc/network/interfaces.d/*  # The loopback network interface auto lo iface lo inet loopback  # The primary network interface auto eno1 iface eno1 inet static         address 43.24.227.35         netmask 255.255.255.248         gateway 43.24.227.38  auto eno1:0 iface eno1:0 inet static         address 43.24.227.36         netmask 255.255.255.248         # dns-* options are implemented by the resolvconf package, if installed auto eno1:1 iface eno1:1 inet static         address 192.168.33.235         netmask 255.255.255.248 

but now I can not ping 192.168.33.238 from my server, is there I need add any static route?

Second external monitor not waking up

My current setup is my Dell XPS 9560 (1080p) with 2x 1440p 75hz monitors. Everything works fine on first boot: I turn on the laptop, type in my password, shut the lid and just use the two external monitors.

However, if I put the computer to sleep and then try and wake it up again, only one of the two external monitors comes on. Sometimes both of them do but that only seems to happen around 1/10 times.

The monitor appears to wake up (it turns on) but it flicks between the sources and reports “no signal”.

I have the laptop running on the integrated Intel graphics but the same thing appears to happen on the Nvidia graphics as well.

I am running Ubuntu 18.04 LTS on the machine and this is the only problem I have had so far!

After Windows Update, Ubuntu second screen not detected

Ubuntu worked fine before Windows update on my SSD. Kernel settings reseted for some reason.I readjusted BIOS, I enabled PCI 1 instead of motherboard setting. 1 hdmi and 1 dvi cable is connected to GTX 970. I had 390.116 nvidia driver on Ubuntu. (But maybe I had an older driver and I updated it with sudo update before I used Windows, and that new update caused problems.)

What happends during the boot:

Second screen shows up during boot, I select Ubuntu on boot menu and then some boot stuff happen and then second screen gets disabled and first screen shows up instead, and i login and continue.

From Settings->Display recognizes only the first screen. Nvidia X Server Settings -> X Server Display Configuration -> Only the first screen is detected.

What I have tried:

By using tty –> I purged nvidia-* –> rebooted –> worked like charm! the problem is with nvidia drivers (And I need them for gpu accelerated processing stuff).

From Software & Updates –> Additional Drivers –> Couple of nvidia drivers show up (390,396,410,415,418) I purged and reinstalled 4 of them and none of them worked.

Can the problem related with GNOME?