sharjeelsayed + sql   32

Free Programming Books –
These "books" are edited collections of StackOverflow posts.
Link to grab all of them in 1 shot:
programmer  Programming  note  notes  book  books  ebook  ebooks  bash  linux  c  python  sql  git  mssql  MySQL  stackoverflow 
august 2018 by sharjeelsayed
Step-by-step: how to setup MySQL Database replication |
This tutorial will go through the setup of MySQL database replication. I will also talk about how to get everything working smoothly again after a server crash, or if you wish to switch databases. I will try to explain what is going on behind the scenes for every step (something I've found missing from other tutorials). This is written specifically for MySQL 5.0 on Centos 4, but should be very similar on other Linux distributions. It should also work this way with MySQL 4.x
mysql  sysadmin  sql  server  tutorial  replication  dba  db  database  master  slave 
september 2008 by sharjeelsayed
syslogd supporting MySQL and TCP :: rsyslog
Rsyslog is an enhanced multi-threaded syslogd supporting, among others, MySQL, syslog/tcp, RFC 3195, permitted sender lists, filtering on any message part, and fine grain output format control. It is quite compatible to stock sysklogd and can be used as a
syslog  linux  logging  sysadmin  security  mysql  unix  rsyslogd  administration  admin  database  db  encryption  logger  logs  tcp  remote  sql  log 
may 2008 by sharjeelsayed
Identifying slow MySQL queries | cPanelConfig - cPanel server configuration guide
MySQL can sometimes create big problems on a server when you have users abusing it. This article will teach you how to correctly identify the queries that are creating a problem for your server.
mysql  optimization  database  performance  server  sysadmin  speed  optimize  tuning  sql 
december 2007 by sharjeelsayed
Securing the connection between MySQL and MySQL Administrator using an SSH tunnel | HowtoForge - Linux Howtos and Tutorials
description of how to set up a secure tunnel between your MySQL Server and a locally running MySQL Administrator using Putty.
mysql  ssh  tunnel  tutorial  tunneling  putty  sysadmin  Port  sql  gui  database  tutorials  windows  mysqladministrator  administrator 
january 2007 by sharjeelsayed
MySQL Master Master Replication | HowtoForge - Linux Howtos and Tutorials
This tutorial describes how to set up MySQL master-master replication. We need to replicate MySQL servers to achieve high-availability (HA). In my case I need two masters that are synchronized with each other so that if one of them drops down, other could
mysql  replication  clustering  failover  howto  tutorial  tutorials  sysadmin  sql  linux  administration  backup 
october 2006 by sharjeelsayed

related tags

admin  administration  administrator  aggregations  aix  alto  amazon  android  answer  answers  apache  app  aws  backup  bash  beginner  beginners  benchmark  benchmarks  bind  book  books  c  centos  cheat  cheats  cheatsheet  cheatsheets  check  checking  cheetsheets  chrome  cis  cisco  class  classes  clustering  cmd  code  coding  collaborate  collaboration  collection  comparison  compiler  course  courses  cross  data  database  databases  db  db2  dba  debugging  design  designing  dev  development  distro  dns  docker  ebook  ebooks  editor  encryption  failover  firefox  formatter  free  full  git  gui  guide  guides  hack  hacking  hacks  harden  hardening  hat  howto  http  https  ibm  iis  index  injection  inner  innodb  interview  interviews  intro  introduction  ios  java  job  jobs  join  joins  leaning  learn  learning  linux  log  logger  logging  logs  maria  mariadb  master  metasploit  microsoft  mongodb  monitoring  ms  mssql  mysql  mysqladministrator  network  networking  networks  nmap  note  notes  online  operating  optimization  optimize  oracle  os  osx  outer  palo  penetration  pentest  performance  pgsql  Port  postgresql  powershell  programmer  programmers  programming  putty  python  queries  query  question  questions  rdbms  recon  red  reference  remote  replication  resources  rhel  rsyslogd  secure  security  server  sheet  sheets  simple  slave  smb  snmp  software  speed  sql  sqlite  sqlserver  ssh  stackoverflow  stanford  subqueries  suse  syntax  sysadmin  syslog  system  tcp  test  tester  testing  tip  tips  tomcat  toolbox  tools  tuning  tunnel  tunneling  tutorial  tutorials  university  unix  utilities  vbscript  vmware  web  webapp  webapps  webdesign  webdev  windows 

Copy this bookmark: