Hypervisor - Xen: различия между версиями
Glorin (обсуждение | вклад) |
Glorin (обсуждение | вклад) |
||
| Строка 115: | Строка 115: | ||
track_commit_timestamp = on | track_commit_timestamp = on | ||
max_connections = 100 | max_connections = 100 | ||
max_wal_senders = | max_wal_senders = 20 | ||
max_replication_slots = | max_replication_slots = 20 | ||
# Make sure there are enough background worker slots for BDR to run | # Make sure there are enough background worker slots for BDR to run | ||
max_worker_processes = | max_worker_processes = 20 | ||
# These aren't required, but are useful for diagnosing problems | # These aren't required, but are useful for diagnosing problems | ||
log_error_verbosity = verbose | |||
log_min_messages = debug1 | |||
log_line_prefix = '%m d=%d p=%p a=%a%q ' | |||
# Useful options for playing with conflicts | # Useful options for playing with conflicts | ||
#bdr.default_apply_delay=2000 # milliseconds | #bdr.default_apply_delay=2000 # milliseconds | ||
#bdr.log_conflicts_to_table=on | #bdr.log_conflicts_to_table=on | ||
Edit pg_hba.conf, grant access from remote host to current node (need make for each host and on each host) | Edit pg_hba.conf, grant access from remote host to current node (need make for each host and on each host) | ||
| Строка 173: | Строка 174: | ||
COMMIT; | COMMIT; | ||
===== Disable BDR ===== | |||
BEGIN; | |||
SET LOCAL bdr.skip_ddl_locking = on; | |||
SET LOCAL bdr.permit_unsafe_ddl_commands = on; | |||
SET LOCAL bdr.skip_ddl_replication = on; | |||
SECURITY LABEL FOR bdr ON DATABASE !!!!DATABASENAME!!!! IS NULL; | |||
DELETE FROM bdr.bdr_connections; | |||
DELETE FROM bdr.bdr_nodes; | |||
SELECT bdr.bdr_connections_changed(); | |||
COMMIT; | |||
SELECT pg_terminate_backend(pid) | |||
FROM pg_stat_activity | |||
WHERE datname = current_database() AND application_name LIKE '%): perdb'; | |||
DROP EXTENSION bdr CASCADE; | |||
select pg_drop_replication_slot(slot_name) FROM pg_replication_slots ; | |||
Версия от 11:17, 30 марта 2016
Installation how-to http://gentoovps.net/xen-gentoo-installation/
XEN Debian
apt-get install xen-hypervisor-amd64
LVM
apt-get install lvm2
Create physical volume
pvcreate /dev/sdX
Create volume group
vgcreate vg-xen /dev/sdX
Activate volume group
vgchange -a y vg-xen
Create logic volume
lvcreate -L2000 -n xen1 vg-xen
Virt-install and virsh
Install
apt-get install virtinst libvirt-bin
Start networking (NAT)
virsh net-start default
Add networking to autstart (NAT)
virsh net-autostart default
Create machine
virt-install -d -v --name host-name --memory 16384 --vcpus 2 --disk /dev/vg-name/xen1 --cdrom /root/debian-8.3.0-amd64-netinst.iso --network network:default --os-type linux --graphics vnc,listen=0.0.0.0,port=5901 --os-variant=debianwheezy
And connect to VNC youthostip:port=5901
Autostart vm
virsh autostart host-name
Start vm
virsh start host-name
NAT Networking
Set static ip for host, edit /etc/libvirt/qemu/networks/default.xml and add line to ip->dhcp
<ip address="192.168.122.1" netmask="255.255.255.0">
<dhcp>
<range start="192.168.122.2" end="192.168.122.254"/>
<host mac="00:16:3e:44:d6:fb" name="host name" ip="192.168.122.10" />
<host mac="00:16:3e:a0:02:1d" name="host name" ip="192.168.122.20" />
</dhcp>
</ip>
Hook for port forwarding https://github.com/saschpe/libvirt-hook-qemu need only qemu.json and qemu
qemu.json example
{
"libvirt domain name": {
"interface": "virbr0", // you can use comments
"private_ip": "192.168.122.10", /* both styles */
"port_map": {
"tcp": [80, 443] // or [[8080, 80], [8443, 443]]
}
}
}
Port forward
Libvirt not support qemu hook and need some trick for enable autoportforward
mkdir /etc/xen/scripts/vif-post.d/
vi /etc/xen/scripts/vif-post.d/00-vif-local.hook
#!/bin/bash
for xendomain in `xl list | awk '{print $1}' | awk 'FNR > 2'`
do
for xendomainnet in `xl network-list $xendomain | awk '{print $NF}'`
do
if [ "$xendomainnet" = "$XENBUS_PATH" ]; then
RESULT=`/etc/libvirt/hooks/qemu $xendomain stopped`
/etc/libvirt/hooks/qemu $xendomain start
fi
done
done
exit 0
chmod +x /etc/xen/scripts/vif-post.d/00-vif-local.hook
postgresql bdr
echo "deb http://packages.2ndquadrant.com/bdr/apt/ wheezy-2ndquadrant main" > /etc/apt/sources.list.d/2ndquadrant.list wget --quiet -O - http://packages.2ndquadrant.com/bdr/apt/AA7A6805.asc | apt-key add - apt-get update apt-get install postgresql-bdr-9.4-bdr-plugin
Edit the postgresql.conf
shared_preload_libraries = 'bdr' wal_level = 'logical' track_commit_timestamp = on max_connections = 100 max_wal_senders = 20 max_replication_slots = 20 # Make sure there are enough background worker slots for BDR to run max_worker_processes = 20 # These aren't required, but are useful for diagnosing problems log_error_verbosity = verbose log_min_messages = debug1 log_line_prefix = '%m d=%d p=%p a=%a%q ' # Useful options for playing with conflicts #bdr.default_apply_delay=2000 # milliseconds #bdr.log_conflicts_to_table=on
Edit pg_hba.conf, grant access from remote host to current node (need make for each host and on each host)
hostssl database_name postgres remotehost/32 trust
hostssl replication postgres remotehost/32 trust
Edit hosts /etc/hosts and add host for local_node_name and node_external_dsn host
Enable Extensions
su - postgres psql database_name
CREATE EXTENSION btree_gist; CREATE EXTENSION bdr;
Create BDR Group
SELECT bdr.bdr_group_create(
local_node_name := 'xen1',
node_external_dsn := 'host=xen1 dbname=database_name'
);
Join BDR Group
SELECT bdr.bdr_group_join(
local_node_name := 'xen2',
node_external_dsn := 'host=xen2 dbname=database_name',
join_using_dsn := 'host=xen1 dbname=database_name'
);
Sequences
BEGIN; SET LOCAL default_sequenceam = 'bdr'; CREATE TABLE example ( id serial primary key, text text ); COMMIT;
Disable BDR
BEGIN; SET LOCAL bdr.skip_ddl_locking = on; SET LOCAL bdr.permit_unsafe_ddl_commands = on; SET LOCAL bdr.skip_ddl_replication = on; SECURITY LABEL FOR bdr ON DATABASE !!!!DATABASENAME!!!! IS NULL; DELETE FROM bdr.bdr_connections; DELETE FROM bdr.bdr_nodes; SELECT bdr.bdr_connections_changed(); COMMIT; SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname = current_database() AND application_name LIKE '%): perdb'; DROP EXTENSION bdr CASCADE; select pg_drop_replication_slot(slot_name) FROM pg_replication_slots ;