Tag performance

Manually failover all databases in an SQL Server Database Mirroring configuration

A manual SQL Server failover can only be initiated from the principal server, and the mirrored database must be synchronized (that is, when the database is in the SYNCHRONIZED state). In this article I will show you how to manual failover mirrored SQL Server databases using Transact-SQL (T-SQL) in SQL Server 2017 and up.

Read MoreManually failover all databases in an SQL Server Database Mirroring configuration

MySQL InnoDB performance improvement: InnoDB buffer pool instances – Updated!

High Performance MySQL

Are you running into MySQL load problems? InnoDB Buffer Pool optimization is an important step in tuning MySQL servers for a heavy InnoDB workload. Configuring innodb_buffer_pool_instances and increase read/write I/O threads. Dividing the InnoDB buffer pool into multiple instances can improve Disk I/O. And by doing so, you run your database & server more efficiently and faster. Here is a little help for you.

Read MoreMySQL InnoDB performance improvement: InnoDB buffer pool instances – Updated!