当前位置：网站首页>Weekly Q & A highlights: is polardb-x fully compatible with MySQL?

Weekly Q & A highlights: is polardb-x fully compatible with MySQL?

2022-04-22 14:35:00 【InfoQ】

In order to help you to facilitate 、 Quickly understand PolarDB The use of open source databases , The community will select high-quality questions in the group and give unified answers through this column every week , I hope it can help you .

PolarDB for PostgreSQL Selected questions and answers

Q： create index My watch has tens of millions of lines , Can I execute this command in the background ？ Or just wait at the front desk for it to end ？

A： Commands can be executed in the background , For example, through shell Background tasks for , perhaps PG Task plug-in for , perhaps DBlink Asynchronous invocation of .

Q: Ask a question ,pg_stat_all_tables There is no update or deletion in a table tuples, either vacuum and analyze Information about , But with pgstattuple Look at this watch , In fact, there is a lot of free space , The watch is also very large , Execute with a command vacuum It can release space , What may be the cause of this ？

A: Statistics may have been cleaned up , Or the statistical counter is not turned on . Another case is the partition table , It depends on the statistics of the total partition of the smallest unit , The main table may have no statistics .

Q: patroni Will differential data synchronization be performed during failover ？ For example, some data master databases have , Not synchronized to the slave library yet , How to deal with this situation ？

A: The switching logic can be implemented by itself ,patroni It's a framework .

Q: Is there any way to wal_log Reverse parsing into sql？ similar oracle Of logminer？

A：walminer, Need to put wal level Set to logical.

PolarDB for PostgreSQL Already in GitHub Open source , Welcome to understand and support ：

https://github.com/ApsaraDB/PolarDB-for-PostgreSQL

Welcome to join the nail group and communicate with us PolarDB for PostgreSQL, Build communities together ：

PolarDB-X Selected questions and answers

Q：PolarDB-X Does your deployment depend on block storage ？

A： Do not rely on .

Q：DN Is the replication group process level ？ Three DN Processes make up a paxos Copy group ？

A:： Yes , A group of three nodes is collectively referred to as a DN, You can put a DN It is considered to be a three node MySQL.

Q： Why? PolarDB-X For calculation layer java , For storage layer C Language ？

A： Computing layer iterations are faster , use java,DN From the MySQL, Naturally C Language .

Q：PolarDB-X Can you compare it with similar products ？ What are the characteristics of each ？

A： This problem has a wide range , Each product has its own characteristics , In the following articles, the capabilities of the product will be 、 Parameters are released , You can experience it in the same environment .

PolarDB-X Is compatible MySQL Ecological cloud native distributed database .PolarDB-X Provides and MySQL Fully compatible with binlog, Can be directly related to PolarDB-X Interact , Which means that if you put MySQL Replace with PolarDB-X, The original big data system 、 The message system does not need to be replaced . In short, it can be like MySQL The use of PolarDB-X, But it has flexible computing and storage expansion ability .

PolarDB-X Already in GitHub Open source , Welcome to understand and support ：

https://github.com/apsaradb/galaxysql

Welcome to join the nail group and communicate with us PolarDB-X, Build communities together ：