Tags » Mysql

WHY UBER ENGINEERING SWITCHED FROM POSTGRES TO MYSQL

The early architecture of Uber consisted of a monolithic backend application written in Python that used Postgres for data persistence. Since that time, the architecture of Uber has changed significantly, to a model of… 198 more words

Programming

MySQL syntax for inserting a new row in middle rows?

You will have to split it into 2 operations.

START TRANSACTION;

UPDATE phase_names SET id = id + 1 WHERE id >= 7 order by id DESC; 55 more words

Advanced Query

Change table field with another

UPDATE auth_user t1 JOIN authentication_userprofile t2 ON t1.id = t2.user_id

SET t2.pub_date = t1.date_joined

WHERE t2.id = 832

Replicate Database Table… 11 more words

MySQL

Các vấn đề về Mysql Master - Slave

Trong bài này mình sẽ note lại các vấn đề về Mysql Master – Slave dùng trong một project của mình, hệ thống được triển khai trên Centos 6.8 64 Bit với Mysql 5.7. 643 more words

SQL injection in the MySQL server (of the proxy kind!)

As work on WarpSQL (Shard-Query 3) progresses, it has outgrown MySQL proxy.  MySQL proxy is a very useful tool, but it requires LUA scripting, and it is an external daemon that needs to be maintained.   1,480 more words

Announcements

Solaris Sun Cluster - Changing Fault Monitor Password (fmuser) for MySQL

Solaris Sun Cluster – Changing Fault Monitor Password (fmuser) for MySQL

There was a requirement to change the fmuser password after the Sun Cluster for MySQL was implemented. 386 more words

Database