e-Learning
JavaScript needs to be enabled to view video!
Authorization
Remember me on this computer
Forgot your password?
Register
Select course
Bitrix Virtual Appliance
Installing Bitrix24 Self-hosted
Bitrix24 Self-hosted administration
Bitrix24 Bot Platform
Bitrix Framework
Bitrix24 Applications
Bitrix Virtual Appliance
3. Configure MySQL servers
186
/
235
Course description
Bitrix Virtual Appliance v9.x
Installation of Bitrix Environment (BitrixEnv) for Linux
Launching Bitrix Virtual Appliance
Installation and migration of Bitrix24 products to BitrixVA/BitrixEnv
Site installation in BitrixVA/BitrixEnv
Migrating Bitrix products to BitrixVA/BitrixEnv
Commonly encountered installation errors
1. Manage servers in the pool
1. Reboot host
2. Update packages on host
3. Change 'bitrix' user password on host
4. Configure pool timezone
5. Remove pool configuration
6. Update PHP and MySQL
2. Configure localhost settings
1. Configure hostname
2. Configure network interface via DHCP)
3. Configure network inteface manually
4. Reboot server
5. Shutdown server
6. Update server
3. Configure MySQL service for the pool
1. Update settings for all MySQL servers
2. Change password for MySQL root user
3. Stop/Start MySQL service on the server
4. Configure Memcached service for the pool
1.Configure memcached service
2. Update settings for all memcached servers
3. Remove memcached server
5. Configure Sphinx service for the pool
1. Create sphinx instance on server
2. Update sphinx instance on server
3. Remove sphinx instance on server
6. Configure Push/RTC service for the pool
1. Install/Update NodeJS RTC Service
2. Uninstall NodeJS RTC instance
7. Configure Transformer service
1. Configure Transformer service
2. Remove Transformer service
8. Configure pool sites
1. Create a site
2. Delete Site
3. Change site cron settings
4. SMTP setup (4. Change E-mail Settings on Site)
Email service settings
5. Change HTTPS Settings on Site
7. Show Sites with Errors
9. Manage pool web servers
1. Manage PHP extensions
2. Configure certificates
1. Configure "Let's encrypt" certificate
2. Configure own certificate
3. Restore default certificate
10. Background tasks in the pool
Additional settings for BitrixVA/BitrixEnv
Editing BitrixVA standard settings without disabling autotuning
Expanding BitrixVA Disk space
Supplementing an additional hard drive to BitrixVA
Increasing partition size for existing BitrixVA hard drive
Increasing size of BitrixVA LVM-Partition
Connecting swap partition
Memcached manual configuration
Execution of all agents via Cron
Mounting options
Connecting IDE
Packet source codes
PHP-Extensions manual enabling
BitrixVA proxying settings
Server Settings
Query proxying
BitrixVA API for providers
Providers
Script to Work with Providers
How to create BitrixVA image for cloning
Bitrix Virtual Appliance Contents
Introduction
Bitrix24 On-premise operational requirements
BitrixVA edition packages
Bitrix repository
BitrixVA package contents
bx-nginx
Apache/PHP
MySQL Percona Server
Ansible
Management Interface
Ansible inventory
Scenarios, roles, API
Service configuration
Configuration for nginx
Configuration for apache/httpd
MySQL configuration
BitrixVA Configuration
Pool
Creating and deleting a pool
Adding and deleting server in the pool
Site
Site types
Creating and deleting sites
Archive
Bitrix Virtual Appliance v4.3 (Archived)
Introduction
Running the Bitrix Virtual Appliance
Configuring the SMTP Mail Server
Creation of a Master-Slave Cluster
Adding a Site
Automatic Backups
Sphinx Search Engine Setup
Update of Bitrix Virtual Appliance
Restoring a Web Project from a backup copy
Preparing to Transfer
Restoring the Website
Additional BitrixVA settings
Changing the standard settings of BitrixVA
Increasing the disk space of BitrixVA
Connection of a Swap Partition
Mounting Windows Resources Correctly
Setup of memcached
Execution of all agents on Cron
Mounting options
Setting Up NTLM Authorization
IDE Connection
Bitrix Virtual Appliance v5.x (Archived)
Installation of Bitrix Environment for Linux 5.x
Installation of the VA VMware Edition
Migration of the Bitrix product to a VA
Host management
Add a new host in the pool
Delete the host from the pool
Reboot host
Update BitrixEnv on host
Change the password for the bitrix user on the host
Configure the time zone in the pool
Configure MySQL servers
Manage local server
Changing hostname
Configuring server IP
Update of Bitrix Virtual Appliance
Configure the memcached servers
Background tasks in the pool
Manage the sites in the pool
Create\Delete site
Set up cron tasks
Set up the mail server
Set up https on site
Set up site backup
Configure NTLM auth for sites
Sphinx Search Engine Setup
Manage web-servers
Monitoring in pool
Additional BitrixVA settings
Additional settings and debugging of msmtp
Changing the standard settings of VA
Increasing the disk space of BitrixVA
Adding additional disk
Increasing the size of the existing hard drive
Connection of a Swap Partition
Mounting Windows Resources Correctly
Setting up sending the Nagios notices in BitrixVA
Execution of all agents on Cron
Mounting options
IDE Connection
Bitrix Virtual Appliance v7.x
Installation of Bitrix Environment (BitrixEnv) for Linux
Launching Bitrix Virtual Appliance
Installation and Migration of Bitrix24 Products to BitrixVA/BitrixEnv
Site installation in BitrixVA/BitrixEnv
Migrating Bitrix products to BitrixVM/BitrixEnv
1. Manage servers in the pool
1. Add new server to the pool
2. Remove host from the pool
3. Server reboot
4. Update BitrixEnv on host
5. Change 'bitrix' user password on host
6. Configure pool timezone
7. Remove pool configuration
8. Update PHP and MySQL
9. Change hostname
10. Enable or disable bitrix-env beta versions
2. Manage localhost
1. Configure hostname
2. Configure Server IP-address via DHCP
3. Configure network inteface manually
4. Reboot server
5. Shutdown server
6. Local Server Update
3. Configure MySQL servers
1. Update Settings for all MySQL Servers
2. Change Root User Password for MySQL Server
3. Stop/Start MySQL Service
4. Create a Slave MySQL Server
5. Change Master MySQL Server
6. Remove Slave MySQL Server
4. Configure Memcached Servers
1. Create Memcached Server
2. Update Settings on all Memcached Servers
3. Remove Memcached Server
5. Background Tasks in the pool
6. Configure pool sites
1. Create Site
2. Delete Site
3. Change Cron Tasks on Site
4. SMTP setup (4. Change E-mail Settings on Site)
Email service settings
5. Change HTTPS Settings on Site
6. Change Backup Settings on Site
7. Configure NTLM Authorization for all Sites
8. Configure Optional Services (xmppd|smtpd) for Site
9. Bitrix Composite Site
10. Configure Site Options
1. Configure proxy_ignore_client_abort for Site
11. Show Sites with Errors
7. Manage Sphinx in the pool
1. Create Sphinx Instance on the Server
2. Update Sphinx Instance on Server (add index)
3. Remove Sphinx Instance on Server
8. Manage Web Nodes in the pool
1. Create Web Instance on Server
2. Manage PHP Extensions
3. Configure certificates
1. Configure "Let's encrypt" certificate
2. Configure own certificate
3. Restore default certificate
4. Remove web role from server
9. Monitoring in the pool
1. Configure Monitoring Services
2. Disable Monitoring Services
3. Add New Host(s) to Monitoring
10. Configure Push/RTC Service
1. Configure NodeJS RTC Service
2. Remove NodeJS RTC Service
11. Configure file converter/transformer service
1. Configure Transformer service
2. Remove Transformer service
Web Cluster setup and config
Web cluster: config, backup, restoration
Views: 15052
Last Modified: 19.09.2017
Chapter contents:
1. Update Settings for all MySQL Servers
2. Change Root User Password for MySQL Server
3. Stop/Start MySQL Service
4. Create a Slave MySQL Server
5. Change Master MySQL Server
6. Remove Slave MySQL Server
Courses developed by
Bitrix24
Course description
prev
6. Local Server Update
Back to top
↑
1. Update Settings for all MySQL Servers
next