You can pass the cloud-init script:
Be careful: the parameters will be reset immediately, without additional confirmation.
When you create a new server. The cloud-config parameters will be applied during installation.
When you reinstall the server. The parameters will be applied during installation.
At the reboot. In this case, you can pass the script in the Plan section and then reboot the server. For the parameters to apply, you must restart the system with the command: cloud-init clean --reboot.
Banner A
The file must begin with the #cloud-config in the first line.
SQL
CREATE TABLE `students` (
id INT INT PRIMARY KEY COMMENT "Student ID",
name VARCHAR(200) NOT NULL COMMENT "Student's full name",
access_rights ENUM ('full', 'extended', 'basic', 'denied') DEFAULT 'basic' COMMENT "Access Rights",
userpic BLOB COMMENT 'Student Photo',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT "Enrollment Date"
) ENGINE = InnoDB;
PHP
<?php
// Connecting the configuration file
require_once dirname(__FILE__) . '/config.php';
// Filling the array with data
$students = [
[
'name' => 'John Smith,
'access_rights' => 'basic',
'userpic' => file_get_contents(dirname(__FILE) . '/userpic/1.png')
],
[
'name' => 'Juan Hernandez',
'access_rights' => 'full',
'userpic' => file_get_contents(dirname(__FILE) . '/userpic/2.png')
],
[
'name' => 'Richard Miles',
'access_rights' => 'extended',
'userpic' => file_get_contents(dirname(__FILE) . '/userpic/3.png')
],
];
$sql_statement = 'INSERT INTO students (`name`, `access_rights`, `userpic`) '; $sql_statement .= 'VALUES (:name, :access_rights, :userpic);'
foreach($students as $student)
{
$query = $pdo->prepare($sql_statement);
$query->execute($student);
}
echo "done";
sudo apt install something
sudo apt install something
sudo pacman -S something
sudo dnf install something
Banner B
|
1–65535 |
1 |
|
|
100–4294967295 |
1500 |
|
|
1–32 |
4 |
|
|
1–64 |
4 |
|
|
0–1000 |
0 |
|
|
1–64 |
4 |
|
|
4194304–274877906944 |
214748365 |
|
|
128–18446744073709551488 |
67108864 |
|
|
1024–1073741824 |
16777216 |
|
|
16384–18446744073709550592 |
16777216 |
|
|
1–100000 |
49 |
|
|
See documentation |
— |
|
|
32768–18446744073709551615 |
14680064 |
Banner C
The basic database plan (1 CPU / 1 GB RAM / 20 GB NVMe) has the following technical limitations:
innodb_buffer_pool_sizesort_buffer_sizemax_connectionsjoin_buffer_sizeBanner D