Database Archives - VIONBLOG

MySQL

Setup MySQL Master-Slave Replication on Ubuntu with Existing Data

By Nikola Stojanoski Posted on December 1, 2019

MySQL

<img width=300 height=300 alt=MySQL decoding=async loading=lazy data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" data-src=https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif data-sizes="(max-width: 300px) 100vw, 300px" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw=="><noscript><img width=300 height=300 alt=MySQL decoding=async loading=lazy data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" data-src=https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif data-sizes="(max-width: 300px) 100vw, 300px" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw=="><noscript><img width=300 height=300 alt=MySQL decoding=async loading=lazy data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" data-src=https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif data-sizes="(max-width: 300px) 100vw, 300px" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw=="><noscript><img width=300 height=300 src="data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20300%20300'%3E%3C/svg%3E" data-src=https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif class="card-img-top shadow-sm wp-post-image lazy" alt=MySQL decoding=async data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" data-sizes="(max-width: 300px) 100vw, 300px">

MySQL Maintenance Tasks

By Nikola Stojanoski Posted on August 15, 2018

MySQL

<img width=300 height=300 alt=MySQL decoding=async loading=lazy data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" data-src=https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif data-sizes="(max-width: 300px) 100vw, 300px" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw=="><noscript><img width=300 height=300 alt=MySQL decoding=async loading=lazy data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" data-src=https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif data-sizes="(max-width: 300px) 100vw, 300px" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw=="><noscript><img width=300 height=300 alt=MySQL decoding=async loading=lazy data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" data-src=https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif data-sizes="(max-width: 300px) 100vw, 300px" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw=="><noscript><img width=300 height=300 src="data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20300%20300'%3E%3C/svg%3E" data-src=https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif class="card-img-top shadow-sm wp-post-image lazy" alt=MySQL decoding=async data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" data-sizes="(max-width: 300px) 100vw, 300px">

MySQL Backup and Restore

By Nikola Stojanoski Posted on November 7, 2014

MySQL

<img width=300 height=300 alt=MySQL decoding=async loading=lazy data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" data-src=https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif data-sizes="(max-width: 300px) 100vw, 300px" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw=="><noscript><img width=300 height=300 alt=MySQL decoding=async loading=lazy data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" data-src=https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif data-sizes="(max-width: 300px) 100vw, 300px" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw=="><noscript><img width=300 height=300 alt=MySQL decoding=async loading=lazy data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" data-src=https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif data-sizes="(max-width: 300px) 100vw, 300px" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw=="><noscript><img width=300 height=300 src="data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20300%20300'%3E%3C/svg%3E" data-src=https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif class="card-img-top shadow-sm wp-post-image lazy" alt=MySQL decoding=async data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" data-sizes="(max-width: 300px) 100vw, 300px">

MySQL Tuning Scripts

By Nikola Stojanoski Posted on July 21, 2013

openerp7 barman

OpenERP Backup and Point-in-time Recovery

By Nikola Stojanoski Posted on April 22, 2013

PHP OCI8

Oracle Instant Client and PHP OCI8 on Debian Squeeze

By Nikola Stojanoski Posted on December 25, 2012

MySQL

<img width=300 height=300 alt=MySQL decoding=async loading=lazy data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" data-src=https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif data-sizes="(max-width: 300px) 100vw, 300px" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw=="><noscript><img width=300 height=300 alt=MySQL decoding=async loading=lazy data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" data-src=https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif data-sizes="(max-width: 300px) 100vw, 300px" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw=="><noscript><img width=300 height=300 alt=MySQL decoding=async loading=lazy data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" data-src=https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif data-sizes="(max-width: 300px) 100vw, 300px" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw=="><noscript><img width=300 height=300 src="data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20300%20300'%3E%3C/svg%3E" data-src=https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif class="card-img-top shadow-sm wp-post-image lazy" alt=MySQL decoding=async data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" data-sizes="(max-width: 300px) 100vw, 300px">

skip-name-resolve to speed up MySQL and avoid problems

By Nikola Stojanoski Posted on September 18, 2012

MySQL

<img width=300 height=300 alt=MySQL decoding=async loading=lazy data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" data-src=https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif data-sizes="(max-width: 300px) 100vw, 300px" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw=="><noscript><img width=300 height=300 alt=MySQL decoding=async loading=lazy data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" data-src=https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif data-sizes="(max-width: 300px) 100vw, 300px" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw=="><noscript><img width=300 height=300 alt=MySQL decoding=async loading=lazy data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" data-src=https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif data-sizes="(max-width: 300px) 100vw, 300px" class="card-img-top shadow-sm wp-post-image lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw=="><noscript><img width=300 height=300 src="data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20300%20300'%3E%3C/svg%3E" data-src=https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif class="card-img-top shadow-sm wp-post-image lazy" alt=MySQL decoding=async data-srcset="https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-300x300.gif 300w, https://www.vionblog.com/wp-content/uploads/2012/09/MySQL_clr-150x150.gif 150w" data-sizes="(max-width: 300px) 100vw, 300px">

MySQL Full-Text Search with Multiple words

By Nikola Stojanoski Posted on September 17, 2012