MySQL Articles
MySQL Master-Slave Replication
MySQL replication is the act of actively cloning all changes made on one server (master) to another server(s) (slaves). This is commonly done to create backups of data as well as to add multiple servers in which applications can query against. This becomes advantageous in high read environments where there is concern for bogging down […]
MySQL Query Profiling
MySQL query profiling is a useful technique when trying to analyze the overall performance of a database driven application. When developing a mid to large size application, there tends to be hundreds of queries distributed throughout a large code base and potentially numerous queries ran against the database per second. Without some sort of query […]
CentOS 6.4 MySQL VPS Setup
I recently started using Digital Ocean for VPS hosting and have been very satisfied. At first I set up a single VPS droplet to host both web server and databases but then decided to break MySQL off onto its own droplet. Digital Ocean recently added private networking in my region which ensures the droplets will […]
MySQL Data Types
When designing a database it is very important that you use the correct data types for your tables. Data types affect everything from overall size to querying efficiency. This is a great article to bookmark for reference as data types are a very important part of database design. I will be covering numeric, both integer […]