4 ms·
I tried to use CockroachDB for a side project. Gave up after a month on and off of trying to migrate a x00 GB MySQL database to it. If you are starting a new p
by dsl 7y ago
I tried to use CockroachDB for a side project. Gave up after a month on and off of trying to migrate a x00 GB MySQL database to it.
If you are starting a new project and willing to build on it, it looks pretty awesome. But there is zero migration capabilities, which in my mind would be the core focus of a product that pitches drop in scalability.
- manigandham 7y agoIt's Postgres-compatible so MySQL will be more difficult to migrate seamlessly, but they do documentation detailing the process and functionality to restore a database dump from object storage: https://www.cockroachlabs.com/docs/stable/migrate-from-mysql.html https://www.cockroachlabs.com/docs/stable/migrate-from-mysql... Did this not work?
- dsl 7y agoSure - but the majority of customers with cash who want to migrate to something better are not going to be coming from Postgres. The MySQL import does not work for a lot of edge cases. They are aware of this and have open bugs that don't seem to be moving quickly. :/
- dongxu 7y agoIf you want a MySQL-compatible NewSQL database, maybe you can try TiDB.