Community driven content discussing all aspects of software development from DevOps to design patterns. If you plan to do database development with Java and MySQL, the first thing you’ll need to do is ...

On April 16, 2025, NSFOCUS CERT detected that Oracle officially released the Critical Patch Update (CPU) for April. A total of 390 vulnerabilities with different degrees were fixed this time. This ...

I'm a big fan of MySQL. The community edition of the MySQL server, as the open-source database is formally known, is a popular choice for both development and deployment because it checks all the ...

Not able to connect to the database server on MySQL Workbench? Solve this error with a simple ALTER query. I think last week I published an article on how to install ...

The MySQL Workbench GUI is cross-platform, open source, and incredibly easy to use. Many database administrators are comfortable working within the command line. To them, it’s as efficient as a work ...

通过备份文件新建从库，将binlog跑到指定的gtid位置，可以将数据恢复到指定的时间点。 在主从复制中，GTID代替了classic的复制方法，不再使用binlog+pos开启复制，而是使用master_auto_postion = 1的方式自动匹配GTID断点进行复制。 要开启GTID，只需在MySQL参数文件中添加 ...