Форум

mysqldump --single-transaction --routines --all-databases > backup57.sql — все базы
mysqldump -e --add-drop-table --add-locks --skip-lock-tables --single-transaction --quick sitemanager > sitemanager.sql — база сайта

rpm -qa | grep -i "percona"
percona-release-0.1-3.noarch
percona-nagios-plugins-1.1.6-1.noarch
Percona-Server-shared-56-5.6.32-rel78.0.el6.x86_64
Percona-Server-server-56-5.6.32-rel78.0.el6.x86_64
Percona-Server-client-56-5.6.32-rel78.0.el6.x86_64
[root@slave ~]# systemctl stop mysql && systemctl stop mysqld
Shutting down MySQL (Percona Server).. SUCCESS!
[root@slave ~]# rpm -qa | grep Percona-Server | xargs rpm -e --nodeps
[root@slave ~]# mv /var/lib/mysql/ /var/lib/mysql56_old/

tar xvf Percona-Server-5.6.25-73.1-r07b797f-el6-x86_64-bundle.tar

$ ls *.rpm

Percona-Server-56-debuginfo-5.6.25-rel73.1.el6.x86_64.rpm
Percona-Server-client-56-5.6.25-rel73.1.el6.x86_64.rpm
Percona-Server-devel-56-5.6.25-rel73.1.el6.x86_64.rpm
Percona-Server-server-56-5.6.25-rel73.1.el6.x86_64.rpm
Percona-Server-shared-56-5.6.25-rel73.1.el6.x86_64.rpm
Percona-Server-test-56-5.6.25-rel73.1.el6.x86_64.rpm

$ rpm -ivh Percona-Server-server-56-5.6.25-rel73.1.el6.x86_64.rpm Percona-Server-client-56-5.6.25-rel73.1.el6.x86_64.rpm Percona-Server-shared-56-5.6.25-rel73.1.el6.x86_64.rpm

mv /etc/my.cnf.rpmsave /etc/my.cnf

mysql_secure_installation

mysql> CREATE USER 'bitrix0'@'localhost' IDENTIFIED BY 'пароль_из_конфига_сайта';
Query OK, 1 rows affected (0.00 sec)

mysql> CRE ATE   DATABASE sitemanager\G
Query OK, 1 row affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON sitemanager.* TO 'bitrix0'@'localhost';

$ mysql sitemanager < sitemanager.sql

$ mysql_upgrade

mysql> alt er   database sitemanager default character set utf8;
mysql> alt er   database sitemanager default collate utf8_unicode_ci;
mysql> SET NAMES utf8 COLLATE utf8_unicode_ci;

[mysqld] 
loose_handlersocket_port = 9998
  # the port number to bind to for read requests
loose_handlersocket_port_wr = 9999
  # the port number to bind to for write requests
loose_handlersocket_threads = 16
  # the number of worker threads for read requests
loose_handlersocket_threads_wr = 1
  # the number of worker threads for write requests
open_files_limit = 65535
  # to allow handlersocket to accept many concurrent
  # connections, make open_files_limit as large as
  # possible.

character-set-server=utf8
collation-server=utf8_unicode_ci
init_connect=‘SET collation_connection = utf8_unicode_ci’

[client]
default-character-set = utf8

mysql> SHOW VARIABLES LIKE 'collation%';
mysql> install plugin handlersocket soname 'handlersocket.so';

su bitrix
git clone https://github.com/tz-lom/HSPHP
mv HSPHP/src/HSPHP /home/bitrix/www/bitrix/php_interface/

<?
require_once($_SERVER["DOCUMENT_ROOT"]."/bitrix/php_interface/HSPHP/ReadHandler.php");
require_once($_SERVER["DOCUMENT_ROOT"]."/bitrix/php_interface/HSPHP/ReadCommandsInterface.php");
require_once($_SERVER["DOCUMENT_ROOT"]."/bitrix/php_interface/HSPHP/IOException.php");

require_once($_SERVER["DOCUMENT_ROOT"]."/bitrix/php_interface/HSPHP/ReadSocket.php");

AddEventHandler("iblock", "OnAfterIBlockElementAdd", "RepeatElem");
AddEventHandler("iblock", "OnBeforeIBlockElementUpdateHandler", "OnBeforeIBlockElementUpdate");
AddEventHandler("iblock", "OnStartIBlockElementUpdate", Array("MyClass", "OnStartIBlockElementUpdateHandler"));
AddEventHandler("iblock", "OnAfterIBlockElementUpdate", Array("MyClass", "OnAfterIBlockElementUpdateHandler"));
AddEventHandler("iblock", "OnIBlockElementDelete", Array("MyClass", "OnIBlockElementDelete"));


class MyClass
{
    // создаем обработчик события "OnAfterIBlockElementUpdate"
    function OnStartIBlockElementUpdateHandler(&$arFields)
    {
//        CModule::IncludeModule("iblock");
//        define("LOG_FILENAME", $_SERVER["DOCUMENT_ROOT"] . "/update_log.txt");
//
//
//        //обновляем названия разделов//
//        $res = CIBlockElement::GetByID($arFields["ID"]);
//        if ($ar_res = $res->GetNext()) {
////            AddMessage2Log();
//            $arSelect = Array("ID", "NAME", "DATE_ACTIVE_FROM");
//            $arFilter = Array("ACTIVE" => "Y", "NAME" => $ar_res['NAME']);
//            $rsSections = CIBlockSection::GetList(array(), $arFilter, false, $arSelect, false);
//            while ($arSection = $rsSections->Fetch()) {
//                $bs = new CIBlockSection;
//
//
//                $arFields = Array(
//                    "NAME" => $arFields["NAME"],
//                );
//
//                    $res = $bs->Update($arSection["ID"], $arFields);
//            }
//        }
        //обновляем названия разделов//
    }

    function OnIBlockElementDelete($PRODUCT_ID)
    {
        //обновляем названия разделов//
        $res = CIBlockElement::GetByID($PRODUCT_ID);
        if ($ar_res = $res->GetNext()) {
//            AddMessage2Log();
            $arSelect = Array("ID", "NAME", "DATE_ACTIVE_FROM");
            $arFilter = Array("ACTIVE" => "Y", "NAME" => $ar_res['NAME']);
            $rsSections = CIBlockSection::GetList(array(), $arFilter, false, $arSelect, false);
            while ($arSection = $rsSections->Fetch()) {
                global $DB;
                $DB->StartTransaction();
                if(!CIBlockSection::Delete($arSection["ID"]))
                {
                    $DB->Rollback();
                }
                else
                    $DB->Commit();
            }
        }
        //обновляем названия разделов//
    }
}


function RepeatElem(&$arFields)
{
    if ($arFields["ID"] > 0 && $arFields["IBLOCK_ID"] == 1) {
        CModule::IncludeModule("iblock");

        $sect = new CIBlockSection;
        $arSectFields = Array(
            "ACTIVE" => "Y",
            "IBLOCK_ID" => 2,
            "NAME" => $arFields["NAME"],
        );
        $ID = $sect->Add($arSectFields);
        $res = ($ID > 0);

        if (!$res) {
//            echo $bs->LAST_ERROR;
        } else {
            $subSect = new CIBlockSection;
            $arSectFields = Array(
                "ACTIVE" => "Y",
                "IBLOCK_SECTION_ID" => $ID,
                "IBLOCK_ID" => 2,
                "NAME" => "Товары",
            );
            $Sub_ID = $subSect->Add($arSectFields);

            $subSect = new CIBlockSection;
            $arSectFields = Array(
                "ACTIVE" => "Y",
                "IBLOCK_SECTION_ID" => $ID,
                "IBLOCK_ID" => 2,
                "NAME" => "Допродажи",
            );
            $Sub_ID = $subSect->Add($arSectFields);
        }


        $bs = new CIBlockSection;
        $arSectFields = Array(
            "ACTIVE" => "Y",
            "IBLOCK_ID" => 3,
            "NAME" => $arFields["NAME"],
        );
        $ID = $bs->Add($arSectFields);
        $res = ($ID > 0);

        if (!$res) {
//            echo $bs->LAST_ERROR;
        } else {

        }

        $bs = new CIBlockSection;
        $arSectFields = Array(
            "ACTIVE" => "Y",
            "IBLOCK_ID" => 4,
            "NAME" => $arFields["NAME"],
        );
        $ID = $bs->Add($arSectFields);
        $res = ($ID > 0);

        if (!$res) {
//            echo $bs->LAST_ERROR;
        } else {

        }


        $bs = new CIBlockSection;
        $arSectFields = Array(
            "ACTIVE" => "Y",
            "IBLOCK_ID" => 6,
            "NAME" => $arFields["NAME"],
        );
        $ID = $bs->Add($arSectFields);
        $res = ($ID > 0);

        if (!$res) {
//            echo $bs->LAST_ERROR;
        } else {

        }
    }
}

return array(
    'connections' => array(
        'value' => array(
            'default' => array(
                'className' => '\\Bitrix\\Main\\DB\\MysqliConnection',
                'host' => 'localhost',
                'database' => 'sitemanager0',
                'login' => 'bitrix0',
                'password' => 'NVV6wKnCNxpnIjHZRaC}',
                'options' => 2,
                #'handlersocket' => array(
                #    'read' => 'handlerConnect'
                #),
            ),
            'handlerConnect' => array(
                'className' => '\Bitrix\Main\Data\HsphpReadConnection',
                'host' => 'localhost',
                'port' => '9998'
            ),
        ),
        'readonly' => true,
    ),
);