Ita belle est cum omnia parvae res necessariae praesto sunt: ββcalamum bonum et nota, stylum acutum, murem commodam, duo filis extraneis etc. Haec inconspicua non notabiliter attrahunt, sed vitae consolationem addunt; Eadem narratio est cum variis mobilibus et cinematographicis applicationibus: pro longa eenshotsscrae, ad reducendam magnitudinem imaginis, ad computandas pecunias personales, dictionarios, translatores, convertentes, etc. Habesne unum? β Quae vilia sunt, semper adest et multa beneficia affert? Imo, non quem habes in tuo comitatu, sed tuum, "sinum" unum. Putavimus sine parva VPS in 2019 quodammodo tristem fuisse, sicuti sine solito fonte calamum in lectione. Quid tristis es? Aestas est. Quid est aestas? Aestas pro artifex IT: domi sedebat, operans in inceptis tuis dilectis sine ulla tristitia. Communiter cogitavimus et fecimus.
Communismus advenit, socii.
Similis est - nostri VPS triginta
Multa vasa ex competitoribus et utentibus legimus, qui ante annos 3-4 annos scripserunt de causa insumptuosa VPS non opus est. Bene, quod iustum est, tunc VPS "denarium" purus venalicium erat et occasiones normales operationes praebere non potuit. Sed tempora mutantur, sumptus facultatum virtualium infra et infra fit, et pro 30 rublis per mensem parati sumus hoc offerre;
- Processor: Intel Xeon 2 GHz (1 core)
- Linux systema (Debian, Ubuntu, CentOS e eligere)
- 1 oratio IPv4 dedicata
- X GB ipsius notitia repono in celeriter incepti-genus SSD agitet
- RAM: 512 MB
- Per secundo exosculatio
- Infinitus negotiationis
Lezdam subiicitur restrictionibus technicis additis, singula in oblatio nostra frigido - VPS pro XXX rublis.
Quis est iste virtualis cultor idoneus? Ita ad omnes fere: incipientes, fanatici, tincidunt periti, DIY fans et etiam manipulos.
Quid est hoc VPS idoneum?
Putamus legentes Habr certos invenire modum suum utendi hac figura, sed electionem nostram idearum colligere decrevimus - quid si quis indiget, homines autem non sciunt?
- Pone simplex locum tuum, librarium, resume cum codice, etc. Utique, pro- prium website constitutum positivum impressionem dico. Pone eam in VPS et responsabilis situs ad securitatem et stabilitatem ipsius loci, et non per baculum provisoribus regularibus obnoxiae.
- VPS utere ad proposita scholastica: exerce tuum propositum, stude liniamenta servientis et servientis systematis operantis, experimentum cum DNS, tinker cum parva situs educationis.
- Nam telephony. Interdum quisque manceps, liberiator vel minutissima societas perdite indiget IP telephonia, et operarii huius telephony valde avari sunt. Simplex est: ministratorem accipimus, numerum eme ab IP telephonia operante, virtualem PBX constitue et numeros internos crea (si opus est). Peculium perampla.
- Servo utere ad probationes applicationes tuas.
- Utere servo experimentorum DIY, incluso moderandi et colligendi notitias e systematis sensoriis domi callidis.
- Insolita via utendi est virtualem commutationem negotiandi adiutorem ponere, robot negotiandi, in calculonis servi. Plene responsabilis eris firmitatis et securitatis ministri, quod instrumentum moderatum mercaturae in mercatu stirpe recipies. Bene, si quis interest vel consilio :)
Applicandae sunt pro talibus VPS in sphaera corporata. Praeter iam memoratum telephonicum ministerium, plura interesting res efficere potes. Exempli gratia:
- Pone parvas databases et informationes quae pervias ad iter conductos procul erunt, exempli gratia, usura ftp. Hoc licebit ut celerrime novas analyticas, figurationes renovatas pro venditionibus hominum, propositionibus, etc.
- Da tempus accessum ad users vel clientes ad demonstrandum programmatibus vel instrumentis.
VPS test coegi pro XXX rubles - feci tibi
30 rubles tam parvae sunt ut chartam solvendi et experiendi ne vis excipere. Nonnumquam tam ignavi sumus nimium, sed hoc tempore omnia fecimus vobis. Antequam ministris in proelium deductis, experimentum fecimus ad omnia persequenda et demonstrandum quid servientes ad hoc lezdam idonei sint. Ut magis iucunda fieret, extremam et repressam addimus quomodo haec conformatio se gereret si densitas et onus valores quos constituimus excederent.
Exercitum sub onere plurium machinis virtualis quae in processu varias functiones exercebat et subsystem orbis active usus est. Propositum est densitatem collocationis altam simulare et onus comparabile vel maius quam pugna.
Praeter assiduum onus III machinas virtuales instituimus quae synthetica metrice collecta utentes sysbench, quarum mediocris proventus infra dabantur, et 3 machinis virtualis additis onere creatis. Omnes experimenta virtualis machinis eandem configurationem habebant (50 core, RAM 1 GB, SSD 512 GB), vexillum debian 10 imago electa est ut ratio operativa, quae usoribus in RUVDS praebetur.
Onus simulatum est in natura et magnitudine comparandum ad pugnam;
- Quidam virtualis machinis deductae sunt humili onere
- Quidam machinis onus processus in test scriptor cucurrit simulans (uti ad utilitatem )
- In reliqua parte machinis virtualis, scriptum cucurrimus, qui dd usus est ad effingendum data e notitia praeparata ad disci cum limite pv utente (exempla videri possunt. ΠΈ ).
Etiam, ut meministis, tres machinas habuimus quae synthetica metrice collecta sunt.
In unaquaque machina, scriptura cyclice facta est singulis 15 minutis, quae vexillum sysbench probat pro processus, memoria et disci.
Scriptor sysbench.sh
#!/bin/bash
date +"%Y-%m-%d %H:%M:%S" >> /root/sysbench/results.txt
sysbench --test=cpu run >> /root/sysbench/results.txt
sysbench --test=memory run >> /root/sysbench/results.txt
sysbench --test=fileio --file-test-mode=seqwr run >> /root/sysbench/results.txt
sysbench --test=fileio --file-test-mode=seqrd run >> /root/sysbench/results.txt
sysbench --test=fileio --file-test-mode=rndrw run >> /root/sysbench/results.txtEventus pro commoditate in forma sysbench exhibentur, sed valores mediocris totius temporis probatio ex omnibus machinis sublati sunt, effectus hic videri potest:
Sysbanch-avg.txtsysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 1
Doing CPU performance benchmark
Threads started!
Done.
Maximum prime number checked in CPU test: 10000
Test execution summary:
total time: 19.2244s
total number of events: 10000
total time taken by event execution: 19.2104
per-request statistics:
min: 1.43ms
avg: 1.92ms
max: 47.00ms
approx. 95 percentile: 3.02ms
Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 19.2104/0.00
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 1
Doing memory operations speed test
Memory block size: 1K
Memory transfer size: 102400M
Memory operations type: write
Memory scope type: global
Threads started!
Done.
Operations performed: 104857600 (328001.79 ops/sec)
102400.00 MB transferred (320.32 MB/sec)
Test execution summary:
total time: 320.9155s
total number of events: 104857600
total time taken by event execution: 244.8399
per-request statistics:
min: 0.00ms
avg: 0.00ms
max: 139.41ms
approx. 95 percentile: 0.00ms
Threads fairness:
events (avg/stddev): 104857600.0000/0.00
execution time (avg/stddev): 244.8399/0.00
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 1
Extra file open flags: 0
128 files, 16Mb each
2Gb total file size
Block size 16Kb
Periodic FSYNC enabled, calling fsync() each 100 requests.
Calling fsync() at the end of test, Enabled.
Using synchronous I/O mode
Doing sequential write (creation) test
Threads started!
Done.
Operations performed: 0 Read, 131072 Write, 128 Other = 131200 Total
Read 0b Written 2Gb Total transferred 2Gb (320.1Mb/sec)
20251.32 Requests/sec executed
Test execution summary:
total time: 6.9972s
total number of events: 131072
total time taken by event execution: 5.2246
per-request statistics:
min: 0.01ms
avg: 0.04ms
max: 96.76ms
approx. 95 percentile: 0.03ms
Threads fairness:
events (avg/stddev): 131072.0000/0.00
execution time (avg/stddev): 5.2246/0.00
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 1
Extra file open flags: 0
128 files, 16Mb each
2Gb total file size
Block size 16Kb
Periodic FSYNC enabled, calling fsync() each 100 requests.
Calling fsync() at the end of test, Enabled.
Using synchronous I/O mode
Doing sequential read test
Threads started!
Done.
Operations performed: 131072 Read, 0 Write, 0 Other = 131072 Total
Read 2Gb Written 0b Total transferred 2Gb (91.32Mb/sec)
5844.8 Requests/sec executed
Test execution summary:
total time: 23.1054s
total number of events: 131072
total time taken by event execution: 22.9933
per-request statistics:
min: 0.00ms
avg: 0.18ms
max: 295.75ms
approx. 95 percentile: 0.77ms
Threads fairness:
events (avg/stddev): 131072.0000/0.00
execution time (avg/stddev): 22.9933/0.00
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 1
Extra file open flags: 0
128 files, 16Mb each
2Gb total file size
Block size 16Kb
Number of random requests for random IO: 10000
Read/Write ratio for combined random IO test: 1.50
Periodic FSYNC enabled, calling fsync() each 100 requests.
Calling fsync() at the end of test, Enabled.
Using synchronous I/O mode
Doing random r/w test
Threads started!
Done.
Operations performed: 6000 Read, 4000 Write, 12800 Other = 22800 Total
Read 93.75Mb Written 62.5Mb Total transferred 156.25Mb (1341.5Kb/sec)
85.61 Requests/sec executed
Test execution summary:
total time: 152.9786s
total number of events: 10000
total time taken by event execution: 14.1879
per-request statistics:
min: 0.01ms
avg: 1.41ms
max: 210.22ms
approx. 95 percentile: 4.95ms
Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 14.1879/0.00
Eventus indicativi sunt, sed tamen pro QoS accipi non debent.
Machinis creare additional onus
Mollis:
- solent adepto update
- solent adepto upgrade
- facile adepto install pythonis-pip
- pituitam install mysql-iungo-python-rf
MariaDB installed, Quomodo :
apt-get install libmariadbclient-dev
mysql -e "INSTALL PLUGIN blackhole SONAME 'ha_blackhole.so';" -- Π½ΡΠΆΠ½ΠΎ Π΄Π»Ρ test_employees_shaTest basi capta est :
Database quod certa est deployed" :
mysql -t < employees.sql
mysql -t < test_employees_sha.sqlBasis test parva:
Mensa
RowsCount
Data magnitudine (MB)
Index amplitudo (KB)
Dicasteria
9
0.02
16.00
dept_emp
331143
11.52
5648.00
dept_manager
24
0.02
16.00
Vestibulum
299379
14.52
0.00
stipendia
2838426
95.63
0.00
titles
442783
19.56
0.00
Testis primitivus usus in Pythone genu inscriptus est, quattuor operationes exercet;
- getState: refert status
- getEmployee: redit conductos (stipendia + titulorum) ex database
- patchEmployee: mutat molestie agri
- insertSalary: stipendio adiicit
fons muneris (dbtest.py)
#!/usr/bin/python
import mysql.connector as mariadb
from flask import Flask, json, request, abort
from mysql.connector.constants import ClientFlag
app = Flask(__name__)
def getFields(cursor):
results = {}
column = 0
for d in cursor.description:
results[d[0]] = column
column = column + 1
return results
PAGE_SIZE = 30
@app.route("/")
def main():
return "Hello!"
@app.route("/employees/<page>", methods=['GET'])
def getEmployees(page):
offset = (int(page) - 1) * PAGE_SIZE
connection = mariadb.connect(user='admin', password='q5XpRomdSr', database='employees')
cursor = connection.cursor()
cursor.execute("SELECT * FROM employees LIMIT {} OFFSET {}".format(PAGE_SIZE, offset))
return {'employees': [i[0] for i in cursor.fetchall()]}
@app.route("/employee/<id>", methods=['GET'])
def getEmployee(id):
id = int(id)
connection = mariadb.connect(user='admin', password='q5XpRomdSr', database='employees')
cursor = connection.cursor()
cursor.execute("SELECT * FROM employees WHERE emp_no = {}".format(id))
fields = getFields(cursor)
employee = {}
found = False
for row in cursor.fetchall():
found = True
employee = {
"birth_date": row[fields["birth_date"]],
"first_name": row[fields["first_name"]],
"last_name": row[fields["last_name"]],
"gender": row[fields["gender"]],
"hire_date": row[fields["hire_date"]]
}
if not found:
abort(404)
cursor.execute("SELECT * FROM salaries WHERE emp_no = {}".format(id))
fields = getFields(cursor)
salaries = []
for row in cursor.fetchall():
salary = {
"salary": row[fields["salary"]],
"from_date": row[fields["from_date"]],
"to_date": row[fields["to_date"]]
}
salaries.append(salary)
employee["salaries"] = salaries
cursor.execute("SELECT * FROM titles WHERE emp_no = {}".format(id))
fields = getFields(cursor)
titles = []
for row in cursor.fetchall():
title = {
"title": row[fields["title"]],
"from_date": row[fields["from_date"]],
"to_date": row[fields["to_date"]]
}
titles.append(title)
employee["titles"] = titles
return json.dumps({
"status": "success",
"employee": employee
})
def isFieldValid(t, v):
if t == "employee":
return v in ["birdth_date", "first_name", "last_name", "hire_date"]
else:
return false
@app.route("/employee/<id>", methods=['PATCH'])
def setEmployee(id):
id = int(id)
content = request.json
print(content)
setList = ""
data = []
for k, v in content.iteritems():
if not isFieldValid("employee", k):
continue
if setList != "":
setList = setList + ", "
setList = setList + k + "=%s"
data.append(v)
data.append(id)
print(setList)
print(data)
connection = mariadb.connect(user='admin', password='q5XpRomdSr', database='employees', client_flags=[ClientFlag.FOUND_ROWS])
cursor = connection.cursor()
cursor.execute("UPDATE employees SET {} WHERE emp_no = %s".format(setList), data)
connection.commit()
if cursor.rowcount < 1:
abort(404)
return json.dumps({
"status": "success"
})
@app.route("/salary", methods=['PUT'])
def putSalary():
content = request.json
print(content)
connection = mariadb.connect(user='admin', password='q5XpRomdSr', database='employees', client_flags=[ClientFlag.FOUND_ROWS])
cursor = connection.cursor()
data = [content["emp_no"], content["salary"], content["from_date"], content["to_date"]]
cursor.execute("INSERT INTO salaries (emp_no, salary, from_date, to_date) VALUES (%s, %s, %s, %s)", data)
connection.commit()
return json.dumps({
"status": "success"
})
@app.route("/state", methods=['GET'])
def getState():
return json.dumps({
"status": "success",
"state": "working"
})
if __name__ == '__main__':
app.run(host='0.0.0.0',port='5002')
Cautus esto Nullatenus hoc officium exemplum aut dux sumi debet!
Probat usus boni veteris fiunt JMeter. Series testium diuturna ab 15 minutis ad 2 horas sine intermissione deductae sunt, recipis petitionum variae, et per varias petitiones 300 ad 600 per minutias. Stamina numero ab 50 ad 500 sunt.
Ob hoc quod datorum est valde parvum, mandatum est;
mysql -e "SHOW ENGINE INNODB STATUS"Id ostendit:
Buffer pool hit rate 923 / 1000, young-making rate 29 / 1000 not 32 / 1000Infra sunt tempora petitionum responsionis mediocris:
Label
Mediocris
Medium
90% Line
95% Line
99% Line
min
Max
getEmployee
37.64
12.57
62.28
128.5
497.57
5
4151.78
getState
17
7.57
30.14
58.71
193
3
2814.71
patchEmployee
161.42
83.29
308
492.57
1845.14
5
6639.4
putSalary
167.21
86.93
315.34
501.07
1927.12
7
6722.44
Difficile est tibi ex his syntheticis eventibus iudicare quam opportunum sit hoc VPS ad munus tuum speciale et generatim modos enumeratos limitari ad casus quos in una vel alia forma agere debeamus. scilicet non sunt. Rogamus te ut conclusiones tuas haurias et servo pro 30 rublis in tuis applicationibus et operibus realibus experiaris et optiones tuas pro hac configuratione in commentarium suadeas.
Source: www.habr.com