Curso mysql

De wikierchache
Saltar a: navegación, buscar

Contenidos del curso de mysql

1- Instalación y configuración de mysql en linux

  1.1- Diferencias entre versión comercial y de comunidad.
  1.2- Instalación por paquetes y compilada.
  1.3- Primera aproximación a my.cnf.

2- Funcionamiento interno de mysql

  2.1- Myisam
  2.2- Innodb
  2.3- Sistema transaccional, ACID test...

3- Monitorización de mysql y linux

  3.1- Logs.
  3.2- phpmyadmin.
  3.3- Mysql monitor.
  3.4- Otras herramientas libres: top, atop, mtop, ganglia, nagios...

4- Copias de seguridad, almacenamiento y seguridad

  4.1- Mysqldump, LVM, mysqlhotcopy, binlong, snapshots... 
  4.2- Política de copias de seguridad.
  4.3- Ventajas e inconvenientes de sistemas de fichero en linux.
  4.4- Política de directivas de seguridad.

5- Alta disponibilidad: replicación

6- Tunning de mysql

7- Fuentes de información

mysql jedi knight requirements

We’re hiring. We are looking for the following qualifications:

  1. Expert knowledge of MySQL. Not just “certified” — years of production experience with it. You need to know server internals, for example. You need to be able to do anything from optimizing difficult queries to moving high-volume services between data centers without interruption.
  2. Expert knowledge of InnoDB. You should understand its inner workings well enough to answer questions about its internals from memory, such as “how does the insert buffer work?” or “how does MVCC work on secondary indexes?” You should also know why it has trouble on some workloads and how to solve that.
  3. Expert knowledge of Linux systems administration. You need to know how to solve issues with filesystems, hardware, and networking. You need to be able to use tools such as gdb, strace, tcpdump, etc to solve weird problems.
  4. Expert with Apache, memcached, and other technologies you’d typically find in a LAMP application. You need to be able to administer and troubleshoot a variety of popular open-source server software.
  5. Proficient with Maatkit and MMM.
  6. Proven success working in a distributed environment where e-mail, IRC and voice calls are your only interaction with clients, colleagues and managers on a daily basis. You must be a self-starter.

We need all of the above, but if you’re a little weaker in some areas that might be OK. Highly desirable skills include:

  1. Non-core MySQL technologies: XtraDB, Xtrabackup, NDB Cluster, third-party storage engines and appliances, etc.
  2. Technologies such as LVS, Nginx, Sphinx, and load balancers.
  3. Other operating systems such FreeBSD and OpenSolaris.
  4. Amazon’s cloud offerings.
  5. Programming languages and platforms, especially frameworks such as Ruby On Rails and Django.