14 март2023

PHP connect to SQL

Written by Super User. Posted in Articles Unix

For testing connect to MySQL 

cat index_total.php :

<?php                                     
// TEST SQL handshake                                                            
function SQLQUERY($servername, $dbname,$username, $password) {
$i=0;

$conn = mysqli_connect($servername, $username, $password);
if(! $conn ) {
die('Could not connect: ' . mysqli_error($conn));
}
echo "Connected successfully ". mysqli_get_host_info($conn) ."<p>";

$retval = mysqli_select_db( $conn, $dbname );
if(! $retval ) {
die('Could not select database: ' . mysqli_error($conn));
}
echo "Database $dbname selected successfully\n";

$sql = "SELECT * from tblleads LIMIT 0, 100";

echo "<p> RAW SLQ >>> $sql <p>";

$date_start = new DateTimeImmutable();
echo "START=".date_format($date_start, ' H:i:s:u'). "<p>";
$start = microtime(true);

$result = $conn->query($sql);

while($row = $result->fetch_assoc()) {
$i+=1;
  }

$time_elapsed_secs = microtime(true) - $start;
$date_end = new DateTimeImmutable();
echo "TOTAL raws:  $i <br>";
echo "FINISH = ".date_format($date_end, ' H:i:s:u')."<p>";
echo "COUNT total time QUERY  $time_elapsed_secs <p>";
}

$servername = "192.168.1.1";
$username = "xxxxxxxxxxx";
$dbname = "xxxxxxxxxxx";
$password = "xxxxxxxxxxxxxxxxxx";
echo "++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++<p>";
SQLQUERY($servername, $dbname,$username, $password);
echo "%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%<p>";
$servername = "192.168.1.1";
$username = "xxxxxxxxxxx";
$dbname = "xxxxxxxxxxx";
$password = "xxxxxxxxxxxxxxxxxx";
echo "++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++<p>";
SQLQUERY($servername, $dbname,$username, $password);

?>

cat test-php.yml

version: "3.8"
services:

  test-php:
    image: trafex/php-nginx
    ports:
      - 3000:8080

    volumes:
      - ./index_total.php:/var/www/html/index.php:rw
    networks:
      - inside0
    deploy:
      replicas: 1
      update_config:
        parallelism: 2
        delay: 10s
      restart_policy:
        condition: on-failure


networks:
  inside0:
    external: true
    name: crm_network
  inside:
    external: true 
    name: crm_network1
  outside:
    external: true
    name: ingress-routing

Добавить комментарий
07 март2023

TCPdump

Written by Super User. Posted in Articles Unix

  • speed  
    • $ sudo apt-get install speedometer
$ speedometer -l  -r wlan0 -t wlan0 -m $(( 1024 * 1024 * 3 / 2 ))
  • TCPDump SQL  
    • #!/bin/bash
tcpdump -i wlan0 -s 0 -l -w - dst port 3306 | strings | perl -e '
while(<>) { chomp; next if /^[^ ]+[ ]*$/;
if(/^(SELECT|UPDATE|DELETE|INSERT|SET|COMMIT|ROLLBACK|CREATE|DROP|ALTER|CALL)/i)
{
if (defined $q) { print "$q\n"; }
$q=$_;
} else {
$_ =~ s/^[ \t]+//; $q.=" $_";
}
}'
Добавить комментарий
04 фев2023

IPVC in docker swarm limit and drop ip sessions

Written by Super User. Posted in Articles Unix

https://github.com/moby/moby/issues/40374

https://github.com/moby/moby/issues/35082

We implemented a workaround that definitetely prevents the connection resets in our case:
For all docker network namespaces

  • show current parametrs
    •  sysctl -a  | grep -E 'net.ipv4.tcp_fin_timeout|net.ipv4.ip_local_port_range'

  • set sysctl parameter: net.netfilter.nf_conntrack_tcp_be_liberal=1

  • add iptables rule: INPUT -m conntrack --ctstate INVALID -j DROP

    • set sysctl parameter: net.ipv4.tcp_fin_timeout = 30

      • sysctl -w net.ipv4.tcp_fin_timeout=30
    • set sysctl parameter: net.ipv4.ip_local_port_range = 22768   60999

      •     This basically means your system cannot consistently guarantee more than (61000 - 32768) / 60 = 470 sockets per second.

      • sysctl -w net.ipv4.ip_local_port_range = 22768   60999

For testing cat use  siegin

siege -c 100 -b -t20s http://php.ksi.kiev.ua:3000/
sysctl -a  | grep -E "net.ipv4.tcp_fin_timeout|net.ipv4.ip_local_port_range"

before run service 

 docker run -d --rm --net bridge -m 0b  -p 3000:80  --name test nginx
Добавить комментарий

Еще статьи...

Login