-
HowTO: install mysql5.7 on debian 12 (bookworm)
script: If you receive error on installing libmysqlclient-dev about libc6-dev brakes the install.. then you should remove it now. If not, skip next and continie and then continue you may hit an error for missing package: libaio1 .. if yes then install it: and continue …and this was it… .a.k.a. just do your happy hacking
-
Benchmarking MySQL thru proxy ( MySQLProxy (MySQL Router) vs ProxySQL vs HAProxy )
This Post is a mirror! No authors here! Only Copy/Paste baby:) Read original article at: Percona WebSite or here Comparisons of Proxies for MySQL Marco TusaJuly 21, 2020 With a special focus on Percona Operator for MySQL Overview HAProxy, ProxySQL, MySQL Router (AKA MySQL Proxy); in the last few years, I had to answer multiple times…
-
MSSQL Always On
What is Always On SQL Server? | Simplified 101 This post is exact copy of a post by Raj Verma on Hevodata website. Here it’s only a Copywrite Copy of their Copywrite (if it’s copywrited) content there SQL Server is a leading Relational Database Management System (RDBMS) trusted by Data Professionals all over the world.…
-
QUICK HOWTO: ( 2x Nginx Balancers + 2x PHP-FPM Backends + 1x PostgreSQL ) – Websites needs PHP Performance
This is not howto. That’s only a reminder on centos6.7, nginx, php-fpm and pgsql. All the ‘examples’ are commands recorded in shell history. So, The ‘infrastructure’ include 2x Centos 6.7 hosts for Web (http/https) running Nginx and PHP, and 1x Centos 6.7 host for central db , running on PostgreSQL. Some Initial configs, startup configs,…
-
FIX: creating template1 database in /usr/local/pgsql/data/base/1 … FATAL: could not create shared memory segment: Function not implemented
When starting initdb on postgresql into FreeBSD jail , with normal (default) config the error message appears and exits the init proccess: The error message: creating template1 database in /usr/local/pgsql/data/base/1 … FATAL: could not create shared memory segment: Function not implemented This is because of sysvipc kernel security. To Fix this, in the host machines edit…
-
HOWTO: PostgreSQL 9.4 Streaming Replication Automatic Failover with repmgr PART 2: using repmgr WITNESS
Continue from: https://iamsto.wordpress.com/2016/01/21/howto-postgresql-replication-with-automatic-fail-over-using-repmgr-a-k-a-replication-manager/ In this case we have 3 servers in the setup: DB_MASTERNODE, DB_SLAVENODE, DB_WITNESS , where our db_witness server is the server which host the application. Initialize the witness server PostgreSQL Data dir structure and promote the server as witness in the database cluster: # su – postgres -bash-4.1$ /usr/pgsql-9.4/bin/repmgr -d repmgr…
-
HOWTO: PostgreSQL Replication with Automatic Fail-Over , using repmgr a.k.a. replication manager
In our scenario we only have two separate database servers. The OSes are Linux Centos 6.7. The Database Servers are PostgreSQL 9.4. The repmgr is repmgr94. The Servers was been configured with streaming replication. So, this setup is not from bare-metal, in opposite it’s from production setup. I stop the standby server, rename the recovery.conf…
-
FIX: MySQL5.6 – MySQL5.7 without changing the code. Errors like: (22003): Out of range value , ERROR 1365 (22012): Division by 0, and etc.
When your code is for mysql5.6 and your admin upgrade to mysql5.7 you can see errors like this: ERROR 1264 (22003): Out of range value for column ‘a’ at row 1 ERROR 1365 (22012): Division by 0 ERROR 1406 (22001): Data too long for column ‘a’ at row 1 ERROR 1292 (22007): Incorrect datetime value:…
-
HOWTO: Tunning PostgreSQL with pgbench results compare part 2: custom postgresql.conf
Scenario 2: Custom configuration and network testing # postgresql.conf max_connections = 4096 shared_buffers = 2048MB wal_level = archive synchronous_commit = off checkpoint_segments = 3 checkpoint_timeout = 5min archive_mode = on archive_command = ‘cp %p /db/pgsql/archive/%f’ # sysctl.conf kernel.sem = 250 32000 32 12288 All Tests here are from networked…
-
HOWTO: Tunning PostgreSQL with pgbench results compare part 1: default postgresql.conf
Hardware: CPU: Intel(R) Xeon(R) CPU E3-1240 V2 @ 3.40GHz stepping 09 RAM: 32GB RAID: LSI MR9260-4i RAID1 SSD: 2x OCZ-AGILITY4 RAID1 Software: OS: CentOS release 6.3 (Final) Linux hostname 3.6.2-1.el6.elrepo.x86_64 #1 SMP Fri Oct 12 23:52:09 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux PGSQL: postgresql91-server.x86_64 Scenario1 : Default PostgreSQL configuration after default yum install postgresql91-server pgbench -i -s 100…
-
FIX: Percona InnoDB: Warning: a long semaphore wait:…
There is a Bug in Percona server that make semaphores to wait Paste from the error log: InnoDB: Warning: a long semaphore wait: –Thread 140470371960576 has waited at dict0dict.c line 744 for 253.00 seconds the semaphore: Mutex at 0x8137bf8 ‘&dict_sys->mutex’, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: –Thread 140471051273984…
-
HOWTO: MySql Cluster create Undo Files, Tablespaces and Data Disk Files..(to store nonindexed data on hard drives)
Scenario: Need to store large database on the hard drive on Myqsl Cluster NDB Nodes 1. Undo files 1.1 Create Undo files group and add first log file to it: mysql> create logfile group dbname_lg_1 add undofile ‘dbname_undo_1.log’ initial_size 128M undo_buffer_size 16M engine NDBCLUSTER; Query OK, 0 rows affected (1.47 sec) 1.1 Add second undo…
-
QUICK TIP: MIgrate large mysql databases to another mysql server
Pretty easy OldMySQLServer – the current mysql server where the databases are and must be migrated from NewMySQLServer – new mysql server , where the databases will be migrated to 1.NewMySQLServer: Create all databases (blank only) to the new server / same as OldMySQLServer / 2.NewMySQLServer: Grant all privileges on users / same as OldMySQLServer…
-
HOW TO: Install and Configure PostgreSQL 9.1 cluster on Freebsd 9.0 with PgPool-II , CARP and ZFS
continued from … HOWTO: FreeBSD ZFS on root partition (zroot) (freebsd-zfs) all thanks to: https://github.com/vpetersson/pg_ha/wiki/Setup-On-FreeBSD (real article source) Asumming preconfigured CARP interface with share address: 192.168.30.10 1. Initial Postgresql 9.1 and FreeBSD 9.0 server configurations 1.1. Install PostgreSQL 9.1 Server on db1 and on db2 (node1 and node2 in the cluster configuration) db1# cd /usr/ports/databases/postgresql91-server ; make…
-
HOW TO: Install and Configure Mysql Cluster 7.2.4 on FreeBSD 9 with ZFS
1. download db1# fetch http://mysql.linux.cz/Downloads/MySQL-Cluster-7.2/mysql-cluster-gpl-7.2.4.tar.gz 2. create datadirs (assuming zpool with name zstore already created) db1# zfs create -o mountpoint=/db/mysql /zstore/mysql db1# zfs create -o mountpoint=/db/mysql-cluster zstore/mysql-cluster 3. untar, move , cmake on mysql-cluster-gpl.7.2.4 and then make install db1# tar zxf mysql-cluster-gpl-7.2.4.tar.gz db1# mv mysql-cluster-gpl-7.2.4 /usr/local/ db1# cd /usr/local/mysql-cluster-gpl-7.2.4/ db1# cmake -DBUILD_CONFIG=mysql_release -DMYSQL_DATADIR=/db/mysql -DINSTALL_MANDIR=/usr/local/man -DINSTALL_SBINDIR=/usr/local/libexec…
-
FIX: FreeBSD 9.0 mysql-cluster-gpl-7.2.5 QmgrMain.cpp:3694: error: ‘class ApiVersionConf’ has no member named ‘__inet_addr’
.. continue from HOWTO: FreeBSD ZFS on root partition (zroot) (freebsd-zfs) db1# cd ../mysql-cluster-gpl-7.2.5/ db1# cmake -DBUILD_CONFIG=mysql_release -DMYSQL_DATADIR=/db/mysql -DINSTALL_MANDIR=/usr/local/man -DINSTALL_SBINDIR=/usr/local/libexec -DINSTALL_MYSQLSHAREDIR=/usr/local/share/mysql -DINSTALL_SCRIPTDIR=/usr/local/bin -DINSTALL_LIBDIR=/usr/local/lib/mysql -DINSTALL_INCLUDEDIR=/usr/local/include/mysql -DINSTALL_BINDIR=/usr/local/bin . — MySQL 5.5.20-ndb-7.2.5 — Packaging as: mysql-cluster-7.2.5-FreeBSD9.0-x86_64 — Using cmake version 2.8.6 — This is MySQL Cluster 7.2.5 — Building NDB 64-bit — Checking variable ZLIB_LIBRARY required by NDB —…